PRPENFSRCH

UPDATED BY
BN66.1 PR140 PR160 PR180 PR189 PR195
PR197 PR29.1 PR300 PR529 PR560 PR582
PR80.1 PR80.2 PR80.4 PR82.1 PR85.1 PR89.1
UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFH-COMPANY
Element: Company Hr
Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PFH-EMPLOYEE
Element: Employee
Numeric 9
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.
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PFH-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification number (unique payment identifier used in tracking payment information).
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560
PFH-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PFH-FUNDING-SOURCE
Element: Funding Source
Alpha 6
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PFH-FUND-AMOUNT
Element: Fund Amount
Signed 11.2
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560
PFH-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
Contains the payroll year in which the allocation was taken.
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560


PRPENFSRCH FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFHSET1 COMPANY
EMPLOYEE
CHECK-ID
PENS-SEQ-NBR
FUNDING-SOURCE
BN66.1 PR140
PR189 PR195
PR197 PR29.1
PR300 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 UK560
PFHSET2 COMPANY
EMPLOYEE
PAYROLL-YEAR
FUNDING-SOURCE
CHECK-ID
PENS-SEQ-NBR
PR160 PR180
PR80.2


PRPENFSRCH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:19 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.