PRPENFSRCH FILE
UPDATED BY
PR560 PR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFH-COMPANY Numeric 4 PR560 PR82.1
Company The company number represents an
established company and is entered on
all function codes.
PFH-EMPLOYEE Numeric 9 PR560 PR82.1
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.
PFH-CHECK-ID Numeric 12 PR560 PR82.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PFH-PENS-SEQ-NBR Numeric 4 PR560 PR82.1
Pens Seq Nbr
PFH-FUNDING-SOURCE Alpha 6 PR560 PR82.1
Funding Source
PFH-FUND-AMOUNT Signed 11.2 PR560 PR82.1
Fund Amount
PFH-PAYROLL-YEAR Numeric 4
Current Payroll Year Contains the payroll year in which the
allocation was taken.
PRPENFSRCH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFHSET1 COMPANY PR560 PR82.1
EMPLOYEE
CHECK-ID
PENS-SEQ-NBR
FUNDING-SOURCE
PFHSET2 COMPANY
EMPLOYEE
PAYROLL-YEAR
FUNDING-SOURCE
CHECK-ID
PENS-SEQ-NBR
PRPENFSRCH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PFH-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PFH-COMPANY -> EMP-COMPANY
PFH-EMPLOYEE -> EMP-EMPLOYEE
Pens Payment PRPENPAY Not Required
PFH-COMPANY -> PNP-COMPANY
PFH-EMPLOYEE -> PNP-EMPLOYEE
PFH-PENS-SEQ-NBR -> PNP-PENS-SEQ-NBR
Prcheck PRCHECK Not Required
PFH-COMPANY -> PCH-COMPANY
PFH-EMPLOYEE -> PCH-EMPLOYEE
PFH-PENS-SEQ-NBR -> PCH-PENS-SEQ-NBR
PFH-CHECK-ID -> PCH-CHECK-ID
|
