PRPENPAY – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PNP
Primary key
COMPANY, EMPLOYEE, EFFECT-DATE, PENS-SEQ-NBR
Fields
28
Updated by
6 programs
Referenced by
49 programs

PRPENPAY is a Lawson Payroll table (prefix PNP); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, EFFECT-DATE, PENS-SEQ-NBR (PNPSET1); alternate indexes: PNPSET2 and PNPSET3. It is related 1:1 to PRSYSTEM and EMPLOYEE and 1:M to PAYMASTR and PRCHECK. It is updated by PR29.1, PR300, PR529, PR560, PR582 and PR82.1 and referenced by BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 and 41 more. The table has 28 fields, 3 indexes and 4 documented relations.

About PRPENPAY

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the PNP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PNP-COMPANY PK
COMPANY		Numeric 4—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PENS-SEQ-NBR PK
PENS_SEQ_NBR		Numeric 4—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PENS-DIST-TYPE
PENS_DIST_TYPE		Numeric 2—
  • 01 Partial; Hardship
  • 02 Partial; Non-hardship
  • 03 Partial; Rollover to IRA
  • 04 Total; Non-rollover
  • 05 Total Rollover to IRA
  • 06 Total rollover to qual plan
  • 07 Periodic; > 10 years
  • 08 Periodic; < 10 years
  • 09 Periodic; < 10 years; Roll IRA
  • 10 Periodic; Tax not determined
  • 11 Periodic; W-2
  • 12 Lump sum payment; W-2
  • 13 Retro-payment
  • 14 Retro-payment; Rollover to IRA
  • 15 Loan issued
  • 16 Dividend
  • 17 Minimum distribution
  • 18 Excess deferrals
  • 19 Non-spousal death benefit
  • 20 Periodic non-res alien; 1042S
  • 21 Lump sum NRA; 1042S
  • 22 Periodic; 480.6
  • 23 Lump sum; 480.6
  • 24 Retro; W-2
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PENS-DIST-CODE
PENS_DIST_CODE		Alpha 1—
  • 1 Early distrib; No exception
  • 2 Early distrib; With exception
  • 3 Disability
  • 4 Death benefit
  • 5 Prohibited transaction
  • 6 Section 1035 exchange
  • 7 Normal distribution
  • 8 Excess contrib;Taxable curr yr
  • 9 PS 58 costs
  • A Qualified for 5/10yr averaging
  • D Exs cntrb;Txb in pri yr;Pri yr
  • E Excess annual addtns; Sec 415
  • G Direct rollover to IRA
  • H R-over to qual plan/tax sh ann
  • L Loan default
  • P Excess contrib;Txbl prior year
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PENS-DST-CODE2
PENS_DST_CODE2		Alpha 1—
  • A Qualified for 5/10yr averaging
  • D Exs cntrb;Txb in pri yr;Pri yr
  • G Direct rollover to IRA
  • H R-over to qual plan/tax sh ann
  • P Excess contrib;Txbl prior year
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-TAX-CATEGORY
TAX_CATEGORY		Numeric 2—
  • 00 Regular
  • 70 Periodic
  • 71 Non-periodic;Not elig rollover
  • 72 Eligible for rollover
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ADDL-FED-TAX
ADDL_FED_TAX		Signed 9.2—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PERC-TOT-DIST
PERC_TOT_DIST		Numeric 3—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-PAYABLE-TO
PAYABLE_TO		Alpha 38 (Lower Case)—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-FBO-NAME
FBO_NAME		Alpha 38 (Lower Case)—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-CITY
CITY		Alpha 58 (Lower Case)This field contains the city of the address.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-STATE
STATE		Alpha 2This field contains the two-character state code of the address.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.PR29.1, PR529, PR560, PR582, PR82.1
#PNP-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR29.1, PR529, PR560, PR582, PR82.1
#PNP-ROLLOVER-ACCT
ROLLOVER_ACCT		Alpha 17—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-MISCELLANEOUS
MISCELLANEOUS		Alpha 6—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-MISCELLANEOUS2
MISCELLANEOUS2		Alpha 6—PR29.1, PR529, PR560, PR582, PR82.1
#PNP-WIRE-IND
WIRE_IND		Numeric 1—
  • 1 Foreign
  • 2 Domestic
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-CA-EFT
CA_EFT		Alpha 1—
  • N No
  • Y Yes
PR29.1, PR529, PR560, PR582, PR82.1
#PNP-STATE-TAX-CAT
STATE_TAX_CAT		Numeric 2—
  • 00 Regular
  • 70 Periodic
  • 71 Non-periodic;Not elig rollover
  • 72 Eligible for rollover
  • 73 Premature distribution
—
#PNP-IAT-ACH
IAT_ACH		Alpha 1N YPR29.1, PR529, PR560, PR582, PR82.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PNPSET1
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. PENS-SEQ-NBR
PrimaryPR229, PR29.1, PR529, PR560, PR582, PR82.1
PNPSET2
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR ↓
BN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131 +22 more (list truncated in source)
PNPSET3
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE ↓
  4. PENS-SEQ-NBR
PR29.1, PR529

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPAYMASTRPRCHECKPRPENPAY

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PNP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PNP-COMPANY→EMP-COMPANY
PNP-EMPLOYEE→EMP-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
PaymastrPAYMASTR
PNP-COMPANY→PYM-COMPANY
PNP-EMPLOYEE→PYM-EMPLOYEE
PNP-PENS-SEQ-NBR→PYM-PENS-SEQ-NBR
—→PYM-CHECK-ID
PrcheckPRCHECK
PNP-COMPANY→PCH-COMPANY
PNP-EMPLOYEE→PCH-EMPLOYEE
PNP-PENS-SEQ-NBR→PCH-PENS-SEQ-NBR
—→PCH-CHECK-ID

Programs

Updated by (6)

Referenced by (49)