|
PRTAXLOC FILE
REFERENCED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 ETI1.1
HR211 PR140 PR195 PR26.1 PR26.2 PR39.1
PR39.2 PR47.1 PR47.2 PR514 PR539 PR89.1
UK47.1 UK47.2 HR04.9
UPDATED BY
BN150 BN305 ET530 ETI2.1 HR11.1 HR11.2
HR511 LP130 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR113 PR120 PR128
PR13.1 PR13.5 PR13.6 PR13.7 PR13.8 PR130
PR131 PR132 PR134 PR136 PR14.1 PR15.2
PR189 PR205 PR29.1 PR313 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 UK102 UK560
TA147 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY Numeric 4 BN150 BN305
Element: Company Hr ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-EMPLOYEE Numeric 9 BN150 BN305
Element: Employee Contains the employee number. Each ET530 ETI2.1
person employed by the company is HR11.1 HR11.2
assigned a unique number. The system HR511 LP130
uses the employee number to correlate PA02.1 PA100
all of the information related to that PA102 PA115
person. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-RECORD-TYPE Alpha 1 BN150 BN305
Element: Record Type This field identifies the type of ET530 ETI2.1
record defined. HR11.1 HR11.2
HR511 LP130
Valid values are: PA02.1 PA100
S = Summary PA102 PA115
D = Detail PA13.1 PA13.2
" " = System PA502 PA513
U = User PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-LOCAT-CODE Alpha 10 BN150 BN305
Element: Locat Code ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-DED-CODE Alpha 4 BN150 BN305
Element: Ded Code ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-ACTIVE-FLAG Alpha 1 BN150 BN305
Element: Active Flag The Active flag of the credit card ET530 ETI2.1
type. HR11.1 HR11.2
A = Active HR511 LP130
I = Inactive PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-DATE-STAMP Numeric 8 (yyyymmdd) BN150 BN305
Element: Date Stamp This field contains the server date ET530 ETI2.1
(month, date, and year) of the last HR11.1 HR11.2
change to this record. HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-TIME-STAMP Numeric 6 (hhmmss) BN150 BN305
Element: Time Stamp Contains the server time (hour, minute, ET530 ETI2.1
and second) when the record was last HR11.1 HR11.2
changed. HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PXL-USER-ID Alpha 10 (Lower Case) BN150 BN305
Element: User ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.2
PR189 PR205
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
PRTAXLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXLSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
LOCAT-CODE BN104 BN105
DED-CODE BN145 BN150
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ET530
ETI1.1 ETI2.1
HR00.1 HR01.1
...
PXLSET2 COMPANY HR04.9 PR113
LOCAT-CODE PR313
EMPLOYEE
DED-CODE
PXLSET3 COMPANY Subset BN150 BN305
EMPLOYEE Where ACTIVE-FLAG = "A" ET530 ETI2.1
LOCAT-CODE HR11.1 HR11.2
DED-CODE HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
...
PRTAXLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PXL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
PXL-COMPANY -> DDC-COMPANY
PXL-DED-CODE -> DDC-DED-CODE
Emp Deduction EMDEDMASTR Required
PXL-COMPANY -> EDM-COMPANY
PXL-EMPLOYEE -> EDM-EMPLOYEE
PXL-DED-CODE -> EDM-DED-CODE
Zeroes -> EDM-SEQ-NBR
Employee EMPLOYEE Required
PXL-COMPANY -> EMP-COMPANY
PXL-EMPLOYEE -> EMP-EMPLOYEE
Location PCODES Required
"LO" -> PCO-TYPE
PXL-LOCAT-CODE -> PCO-CODE
|