PRPENFSRC

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNF-COMPANY
Element: Company Hr		Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-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.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-PENS-SEQ-NBR
Element: Pens Seq Nbr		Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-FUNDING-SOURCE
Element: Funding Source		Alpha 6
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-FUND-AMOUNT
Element: Fund Amount		Signed 11.2
PR29.1 PR529
PR560 PR582
PR82.1 PR85.1
UK560
PNF-PAYMENT-DESC
Element: Payment Desc		Alpha 15 (Lower Case)
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNF-RETRO-PAYMENT
Element: Retro Payment		Alpha 1

" " = No
N = No
Y = Yes; open payment
P = Closed; retro payment
PR195 PR197
PR29.1 PR529
PR560 PR582
PR82.1 PR85.1
UK560


PRPENFSRC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNFSET1 COMPANY
EMPLOYEE
PENS-SEQ-NBR
FUNDING-SOURCE
RETRO-PAYMENT
BN66.1 PR140
PR160 PR180
PR189 PR195
PR197 PR229
PR29.1 PR300
PR529 PR560
PR582 PR80.1
PR80.2 PR80.4
PR82.1 PR85.1
PR89.1 UK560
PNFSET2 COMPANY
FUNDING-SOURCE
RETRO-PAYMENT
EMPLOYEE
PENS-SEQ-NBR
PR04.1


PRPENFSRC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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 EMP-DEPARTMENT !=Spaces
PNF-COMPANY->PFS-COMPANY
EMP-PROCESS-LEVEL->PFS-PROCESS-LEVEL
EMP-DEPARTMENT->PFS-DEPARTMENT
PNF-FUNDING-SOURCE->PFS-FUNDING-SOURCE

File created: Wed Jun 08 20:51:12 2016

Home
Contact Us



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