|
|
PRDEDDTL FILE
REFERENCED BY
PR294
UPDATED BY
PR197 PR82.1 PR85.1 PR300 HR00.1 HR01.1
HR11.1 PA115 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDE-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PDE-EMPLOYEE Numeric 9
Element: 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.
PDE-PYD-OBJ-ID Numeric 12
Element: Pyd Obj Id
PDE-QTD-OBJ-ID Numeric 12 PR197 PR82.1
Element: Qtd Obj Id PR85.1
PDE-TAX-STATUS Alpha 2
Element: Tax Status
PDE-NONTAX-REMUN Signed 13.2
Element: Nontax Remun
PDE-TAXABLE-MATCH Signed 13.2
Element: Taxable Match
PDE-REMUN-CODE Alpha 4
Element: Remun Code
PRDEDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDESET1 PYD-OBJ-ID PR197 PR82.1
TAX-STATUS PR85.1
PDESET2 QTD-OBJ-ID KeyChange, Subset PR294 PR300
TAX-STATUS Where QTD-OBJ-ID != Zeroes
PYD-OBJ-ID
PDESET3 COMPANY Subset HR00.1 HR01.1
EMPLOYEE Where TAX-STATUS != Spaces HR11.1 PA115
PYD-OBJ-ID PBIP.1 PR197
TAX-STATUS
PDESET4 COMPANY Subset
EMPLOYEE Where REMUN-CODE != Spaces
PYD-OBJ-ID
REMUN-CODE
PDESET5 COMPANY Subset
EMPLOYEE Where REMUN-CODE != Spaces
REMUN-CODE
PYD-OBJ-ID
PRDEDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PDE-COMPANY -> EMP-COMPANY (EMPSET1)
PDE-EMPLOYEE -> EMP-EMPLOYEE
|
