PRPENFSRC – No description in the Lawson data dictionary

System: Payroll (PR)
Prefix: PNF
Primary key: COMPANY, EMPLOYEE, PENS-SEQ-NBR, FUNDING-SOURCE, RETRO-PAYMENT
Fields: 9
Updated by: 9 programs
Referenced by: 12 programs

PRPENFSRC is a Lawson Payroll table (prefix PNF); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PENS-SEQ-NBR, FUNDING-SOURCE, RETRO-PAYMENT (PNFSET1); alternate indexes: PNFSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PRPENPAY and PRFUNDSRC. It is updated by PR195, PR197, PR29.1, PR300, PR529, PR560, PR582, PR82.1 and 1 more and referenced by BN66.1, PR04.1, PR140, PR160, PR180, PR189, PR229, PR80.1 and 4 more. The table has 9 fields, 2 indexes and 4 documented relations.

About PRPENFSRC

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the PNF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PNF-COMPANY` PK COMPANY	Numeric 4	—	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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
`PNF-PENS-SEQ-NBR` PK PENS_SEQ_NBR	Numeric 4	—	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-FUNDING-SOURCE` PK FUNDING_SOURCE	Alpha 6	—	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-FUND-AMOUNT` FUND_AMOUNT	Signed 11.2	—	PR29.1, PR529, PR560, PR582, PR82.1, PR85.1
`PNF-PAYMENT-DESC` PAYMENT_DESC	Alpha 15 (Lower Case)	—	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	—	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	PR29.1, PR529, PR560, PR582, PR82.1
`PNF-RETRO-PAYMENT` PK RETRO_PAYMENT	Alpha 1	" " = No `N` No `Y` Yes; open payment `P` Closed; retro payment	PR195, PR197, PR29.1, PR529, PR560, PR582, PR82.1, PR85.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PNFSET1`	`COMPANY`, `EMPLOYEE`, `PENS-SEQ-NBR`, `FUNDING-SOURCE`, `RETRO-PAYMENT`	Primary		BN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR229 +12 more
`PNFSET2`	`COMPANY`, `FUNDING-SOURCE`, `RETRO-PAYMENT`, `EMPLOYEE`, `PENS-SEQ-NBR`			PR04.1

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PNF-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required		`PNF-COMPANY` → `EMP-COMPANY`, `PNF-EMPLOYEE` → `EMP-EMPLOYEE`
Pens Payment	PRPENPAY	Not Required		`PNF-COMPANY` → `PNP-COMPANY`, `PNF-EMPLOYEE` → `PNP-EMPLOYEE`, `PNF-EFFECT-DATE` → `PNP-EFFECT-DATE`, `PNF-PENS-SEQ-NBR` → `PNP-PENS-SEQ-NBR`
Prfundsrc	PRFUNDSRC	Not Required	Valid When EMP-DEPARTMENT != Spaces	`PNF-COMPANY` → `PFS-COMPANY`, `EMP-PROCESS-LEVEL` → `PFS-PROCESS-LEVEL`, `EMP-DEPARTMENT` → `PFS-DEPARTMENT`, `PNF-FUNDING-SOURCE` → `PFS-FUNDING-SOURCE`

Programs

Updated by (9)

PR195 Accrual Program
PR197 Payroll Close
PR29.1 Pension Payment Maintenance
PR300 History Purge
PR529 Pension Payroll Conversion
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation

Referenced by (12)

BN66.1 Estimated Pay Calculation
PR04.1 Pension Funding Sources
PR140 Earnings and Deductions Calculation
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR229 Pension Participant Listing
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.4 Manual Payment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test