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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PXLSET1COMPANY, EMPLOYEE, LOCAT-CODE, DED-CODEPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
PXLSET2COMPANY, LOCAT-CODE, EMPLOYEE, DED-CODEHR04.9, PR113, PR313
PXLSET3COMPANY, EMPLOYEE, LOCAT-CODE, DED-CODESubsetWhere ACTIVE-FLAG = "A"BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPXL-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequiredPXL-COMPANY → DDC-COMPANY, PXL-DED-CODE → DDC-DED-CODE
Emp DeductionEMDEDMASTRRequiredPXL-COMPANY → EDM-COMPANY, PXL-EMPLOYEE → EDM-EMPLOYEE, PXL-DED-CODE → EDM-DED-CODE, Zeroes → EDM-SEQ-NBR
EmployeeEMPLOYEERequiredPXL-COMPANY → EMP-COMPANY, PXL-EMPLOYEE → EMP-EMPLOYEE
LocationPCODESRequired"LO" → PCO-TYPE, PXL-LOCAT-CODE → PCO-CODE

Programs

Updated by (79)

Referenced by (45)