|
|
PRPENFSRCH FILE
REFERENCED BY
PR197
UPDATED BY
PR160 PR180 PR560 PR82.1 PR85.1 PR29.1
PR529
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFH-COMPANY Numeric 4 PR160 PR180
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.
PFH-EMPLOYEE Numeric 9 PR160 PR180
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.
PFH-CHECK-ID Numeric 12 PR160 PR180
Internal Check ID Contains the payment identification PR560 PR82.1
Number number (unique payment identifier used PR85.1
in tracking payment information).
PFH-PENS-SEQ-NBR Numeric 4 PR160 PR180
Element: Pens Seq Nbr PR560 PR82.1
PFH-FUNDING-SOURCE Alpha 6 PR160 PR180
Element: Funding Source PR560 PR82.1
PFH-FUND-AMOUNT Signed 11.2 PR160 PR180
Element: Fund Amount PR560 PR82.1
PR85.1
PFH-PAYROLL-YEAR Numeric 4 PR160 PR180
Element: Current PayrolContains the payroll year in which the PR560 PR82.1
allocation was taken. PR85.1
PRPENFSRCH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFHSET1 COMPANY PR197 PR29.1
EMPLOYEE PR529 PR560
CHECK-ID PR82.1 PR85.1
PENS-SEQ-NBR
FUNDING-SOURCE
PFHSET2 COMPANY PR160 PR180
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
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
|
