PRPENFSRCH

REFERENCED BY
PR197


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFH-COMPANY
Element: Company Hr		Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
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
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
PFH-PENS-SEQ-NBR
Element: Pens Seq Nbr		Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PFH-FUNDING-SOURCE
Element: Funding Source		Alpha 6
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PFH-FUND-AMOUNT
Element: Fund Amount		Signed 11.2
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PR85.1
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


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 PRAT.1
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 02:30:40 2016

Home
Contact Us



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