PRTAXLOC – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PXL
Primary key
COMPANY, EMPLOYEE, LOCAT-CODE, DED-CODE
Fields
9
Updated by
79 programs
Referenced by
45 programs

PRTAXLOC is a Lawson Payroll table (prefix PXL); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, LOCAT-CODE, DED-CODE (PXLSET1); alternate indexes: PXLSET2 and PXLSET3. It is related 1:1 to PRSYSTEM, DEDCODE, EMDEDMASTR, EMPLOYEE and PCODES. It is updated by BN150, BN305, EXI2.1, EXI4.1, HR00.1, HR01.1, HR11.1, HR11.2 and 71 more and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN245 and 37 more. The table has 9 fields, 3 indexes and 5 documented relations.

About PRTAXLOC

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the PXL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PXL-COMPANY PK
COMPANY		Numeric 4—BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are: " " = System
  • S Summary
  • D Detail
  • U User
BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-LOCAT-CODE PK
LOCAT_CODE		Alpha 10—BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-DED-CODE PK
DED_CODE		Alpha 4—BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-DATE-STAMP
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, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-TIME-STAMP
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, HR11.4, HR28.1 +52 more (list truncated in source)
#PXL-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PXLSET1
  1. COMPANY
  2. EMPLOYEE
  3. LOCAT-CODE
  4. DED-CODE
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
PXLSET2
  1. COMPANY
  2. LOCAT-CODE
  3. EMPLOYEE
  4. DED-CODE
HR04.9, PR113, PR313
PXLSET3
  1. COMPANY
  2. EMPLOYEE
  3. LOCAT-CODE
  4. DED-CODE
SubsetWhere ACTIVE-FLAG = "A"BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEDCODEEMDEDMASTREMPLOYEEPCODESPRTAXLOC

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PXL-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequired
PXL-COMPANY→DDC-COMPANY
PXL-DED-CODE→DDC-DED-CODE
Emp DeductionEMDEDMASTRRequired
PXL-COMPANY→EDM-COMPANY
PXL-EMPLOYEE→EDM-EMPLOYEE
PXL-DED-CODE→EDM-DED-CODE
Zeroes→EDM-SEQ-NBR
EmployeeEMPLOYEERequired
PXL-COMPANY→EMP-COMPANY
PXL-EMPLOYEE→EMP-EMPLOYEE
LocationPCODESRequired
"LO"→PCO-TYPE
PXL-LOCAT-CODE→PCO-CODE

Programs

Updated by (79)

Referenced by (45)