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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PNF-COMPANY PK
COMPANY		Numeric 4—PR29.1, PR529, PR560, PR582, PR82.1
#PNF-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
#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 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
PNFSET1
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR
  4. FUNDING-SOURCE
  5. RETRO-PAYMENT
PrimaryBN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR229 +12 more
PNFSET2
  1. COMPANY
  2. FUNDING-SOURCE
  3. RETRO-PAYMENT
  4. EMPLOYEE
  5. PENS-SEQ-NBR
PR04.1

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PNF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PNF-COMPANY→EMP-COMPANY
PNF-EMPLOYEE→EMP-EMPLOYEE
Pens PaymentPRPENPAYNot Required
PNF-COMPANY→PNP-COMPANY
PNF-EMPLOYEE→PNP-EMPLOYEE
PNF-EFFECT-DATE→PNP-EFFECT-DATE
PNF-PENS-SEQ-NBR→PNP-PENS-SEQ-NBR
PrfundsrcPRFUNDSRCNot RequiredValid 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)

Referenced by (12)