|
PRPENFSRC FILE
REFERENCED BY
PR160 PR180 PR229 PR04.1
UPDATED BY
PR197 PR29.1 PR529 PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNF-COMPANY Numeric 4 PR29.1 PR529
Element: Company Hr Identifies the AP company if the PR560 PR82.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PNF-EMPLOYEE Numeric 9 PR29.1 PR529
Element: Employee Contains the employee number. Each PR560 PR82.1
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.
PNF-PENS-SEQ-NBR Numeric 4 PR29.1 PR529
Element: Pens Seq Nbr PR560 PR82.1
PNF-FUNDING-SOURCE Alpha 6 PR29.1 PR529
Element: Funding Source PR560 PR82.1
PNF-FUND-AMOUNT Signed 11.2 PR29.1 PR529
Element: Fund Amount PR560 PR82.1
PNF-PAYMENT-DESC Alpha 15 (Lower Case) PR29.1 PR529
Element: Payment Desc PR560 PR82.1
PNF-EFFECT-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Element: Effective Date PR560 PR82.1
PNF-END-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Element: Ending Date The end date for this effort period. PR560 PR82.1
PNF-RETRO-PAYMENT Alpha 1 PR197 PR29.1
Element: Retro Payment " " = No PR529 PR560
N = No PR82.1 PR85.1
Y = Yes; open payment
P = Closed; retro payment
PRPENFSRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNFSET1 COMPANY PR160 PR180
EMPLOYEE PR197 PR229
PENS-SEQ-NBR PR29.1 PR529
FUNDING-SOURCE PR560 PR82.1
RETRO-PAYMENT PR85.1
PNFSET2 COMPANY PR04.1
FUNDING-SOURCE
RETRO-PAYMENT
EMPLOYEE
PENS-SEQ-NBR
PRPENFSRC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|