PRDEDDTL

REFERENCED BY
PR141 PR262 PR294


UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR300
PR582 PR80.1 PR80.4 PR82.1 PR85.1 PR89.1
PRAT.1 HR00.1 HR01.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDE-COMPANY
Element: Company Hr
Numeric 4
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
PDE-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.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
PDE-PYD-OBJ-ID
Element: Pyd Obj Id
Numeric 12
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR85.1 PR89.1
PRAT.1
PDE-QTD-OBJ-ID
Element: Qtd Obj Id
Numeric 12
BN66.1 PR140
PR189 PR195
PR197 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PDE-TAX-STATUS
Element: Tax Status
Alpha 2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
PDE-NONTAX-REMUN
Element: Nontax Remun
Signed 13.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR85.1 PR89.1
PRAT.1
PDE-TAXABLE-MATCH
Element: Taxable Match
Signed 13.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR85.1 PR89.1
PRAT.1
PDE-REMUN-CODE
Element: Remun Code
Alpha 4


PRDEDDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDESET1 PYD-OBJ-ID
TAX-STATUS
BN66.1 PR140
PR141 PR189
PR195 PR197
PR262 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PDESET2 QTD-OBJ-ID
TAX-STATUS
PYD-OBJ-ID
KeyChange, Subset
WhereQTD-OBJ-ID !=Zeroes
PR294 PR300
PDESET3 COMPANY
EMPLOYEE
PYD-OBJ-ID
TAX-STATUS
Subset
WhereTAX-STATUS !=Spaces
HR00.1 HR01.1
HR11.1 PA115


PRDEDDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PDE-COMPANY->EMP-COMPANY
PDE-EMPLOYEE->EMP-EMPLOYEE


File created: Thu Jun 09 02:30:31 2016

Home
Contact Us



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