PRTAXLOC

UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
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 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR00.1 HR01.1 HR04.9 HR11.1 HR11.2
HR211 HR28.1 HR511 LT101 PR521 ZH510
EXI2.1 EXI4.1 LP130 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR12.6
PR120 PR128 PR13.1 PR13.2 PR13.5 PR13.6
PR13.7 PR13.8 PR13.9 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR14.1 PR14.2
PR140 PR15.1 PR15.2 PR189 PR195 PR205
PR26.1 PR26.2 PR29.1 PR30.2 PR313 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR37.1 PR39.1 PR39.2 PR45.1 PR47.1
PR47.2 PR514 PR529 PR530 PR539 PR560
PR582 PR80.1 PR80.3 PR80.4 PR82.1 PR89.1
UK102 UK47.1 UK47.2 UK560 ZP530 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY
Element: Company Hr		Numeric 4
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-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. 		...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-RECORD-TYPE
Element: Record Type		Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
" " = System
U = User		 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-LOCAT-CODE
Element: Locat Code		Alpha 10
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-DED-CODE
Element: Ded Code		Alpha 4
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive		 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record. 		...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed. 		...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PXL-USER-ID
Element: User		Alpha 10 (Lower Case)
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR28.1 HR511
LP130 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR13.9 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR14.1 PR15.2
PR189 PR205
PR29.1 PR30.2
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1


PRTAXLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXLSET1 COMPANY
EMPLOYEE
LOCAT-CODE
DED-CODE
...
BN100 BN101
BN102 BN103
BN104 BN105
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
PXLSET2 COMPANY
LOCAT-CODE
EMPLOYEE
DED-CODE
HR04.9 PR113
PR313
PXLSET3 COMPANY
EMPLOYEE
LOCAT-CODE
DED-CODE
Subset
WhereACTIVE-FLAG ="A"
...
BN150 BN305
HR11.1 HR11.2
HR28.1 HR511
LT101 PR521
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1


PRTAXLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:27:24 2016

Home
Contact Us



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