PRPENFSRC FILE
REFERENCED BY
PR195 PR197 PR229 PR82.1 PR85.1 PR04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNF-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
PNF-EMPLOYEE Numeric 9
Employee 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.
PNF-PENS-SEQ-NBR Numeric 4
Pens Seq Nbr
PNF-FUNDING-SOURCE Alpha 6
Funding Source
PNF-FUND-AMOUNT Signed 11.2
Fund Amount
PNF-PAYMENT-DESC Alpha 15 (Lower Case)
Payment Desc
PNF-EFFECT-DATE Numeric 8 (yyyymmdd)
Effective Date
PNF-END-DATE Numeric 8 (yyyymmdd)
Ending Date The ending date in a range of dates.
PRPENFSRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNFSET1 COMPANY PR195 PR197
EMPLOYEE PR229 PR82.1
PENS-SEQ-NBR PR85.1
FUNDING-SOURCE
PNFSET2 COMPANY PR04.1
FUNDING-SOURCE
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 PNF-DEPARTMENT != Spaces
PNF-COMPANY -> PFS-COMPANY
EMP-PROCESS-LEVEL -> PFS-PROCESS-LEVEL
EMP-DEPARTMENT -> PFS-DEPARTMENT
PNF-FUNDING-SOURCE -> PFS-FUNDING-SOURCE
|
