QUARTDED – Quarterly Deduction

System
Payroll (PR)
Prefix
QTD
Primary key
COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION
Fields
22
Updated by
43 programs
Referenced by
34 programs

QUARTDED is the Quarterly Deduction table in Lawson Payroll (prefix QTD). It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION (QTDSET1); alternate indexes: QTDSET10, QTDSET2, QTDSET3, QTDSET4 and QTDSET5. It is related 1:1 to PRSYSTEM, DEDCODE, EMPLOYEE, PRQCENTGRP, PRTAXAUTH and PRSTATE and 1:M to PRDEDDTL. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 35 more and referenced by BN232, BN335, BN66.1, HR170, HR70.1, PR11.3, PR11.5, PR139 and 26 more. The table has 22 fields, 6 indexes and 8 documented relations.

About QUARTDED

This file contains all deduction history for an employee, summarized by quarter, and is updated every time you run PR199 (Payroll Close) to close a payroll cycle. One of the primary functions of this file is to produce W-2 information. Therefore, deduction history for an employee is stored by work state, process level, and department. Creating records by process level is necessary to accommodate tax processing by process level, and including department level storage enables reporting summary totals by department.

Fields (22)

Column = COBOL field name without the QTD- 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
#QTD-COMPANY PK
COMPANY		Numeric 4—PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-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.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-QUARTER PK
QUARTER		Numeric 1Contains the fiscal quarter for the data stored in this record.
  • 1 First
  • 2 Second
  • 3 Third
  • 4 Fourth
PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-DED-CODE PK
DED_CODE		Alpha 4Contains the deduction code associated with this record.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5This field contains the tax reporting process level.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-WORK-STATE PK
WORK_STATE		Alpha 2Contains the work state associated with this record.PR195, PR197, PR240, PR241, PR242, PR299, PR560, PR582 +2 more
#QTD-DED-AMT
DED_AMT		Signed 13.2Contains the deduction amount associated with this record.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-TAX-WAGES
TAX_WAGES		Signed 13.2Contains the taxable wages associated with this deduction record.PR195, PR197, PR50.1, PR50.3, PR560, PR582, PR82.1, PR85.1 +1 more
#QTD-WAGE-AMOUNT
WAGE_AMOUNT		Signed 13.2Contains the sum of all wage amounts from the time records.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-EXCESS
EXCESS		Signed 13.2Contains excess wages by deduction.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-DED-TAX-CAT
DED_TAX_CAT		Derived——
#QTD-DED-TAX-AUTH
DED_TAX_AUTH		Derived——
#QTD-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-REPORT-ENTITY PK
REPORT_ENTITY		Alpha 5Contains the report entity. Report Entity is the Process Level or Company that this Process Level reports to for tax reporting. If the Process Level itself is independent then the independent Process Level is the Report Entity. If the Process Level is non independent and is associated to a independent head Process Level then the independent head Process Level is the Report Entity. If the Process Level is non independent and is not associated to a independent head Process Level then the Company is the Report Entity.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-BUS-NBR-GRP PK
BUS_NBR_GRP		Alpha 4Contains the business number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-QC-ENT-NBR-GRP PK
QC_ENT_NBR_GRP		Alpha 4Contains the Quebec enterprise number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.PR195, PR197, PR582, PR82.1, PR85.1
#QTD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-PENSION PK
PENSION		Alpha 1" " = No
  • Y Yes
PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTD-HM-PROC-LEVEL SET10
HM_PROC_LEVEL		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more

Indexes (6)

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
QTDSET1
  1. COMPANY
  2. EMPLOYEE
  3. PAYROLL-YEAR
  4. QUARTER
  5. COUNTRY-CODE
  6. DED-CODE
  7. REPORT-ENTITY
  8. BUS-NBR-GRP
  9. QC-ENT-NBR-GRP
  10. PROCESS-LEVEL
  11. WORK-STATE
  12. PENSION
PrimaryBN232, BN305, BN335, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1 +22 more (list truncated in source)
QTDSET10
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PAYROLL-YEAR
  5. QUARTER
  6. COUNTRY-CODE
  7. DED-CODE
  8. REPORT-ENTITY
  9. BUS-NBR-GRP
  10. QC-ENT-NBR-GRP
  11. PROCESS-LEVEL
  12. WORK-STATE
  13. PENSION
KeyChangeHR170, HR70.1, PR560
QTDSET2
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. EMPLOYEE
  5. DED-CODE
  6. QUARTER
  7. REPORT-ENTITY
  8. BUS-NBR-GRP
  9. QC-ENT-NBR-GRP
  10. PROCESS-LEVEL
  11. WORK-STATE
  12. PENSION
KeyChangeBN335, BN66.1, PR11.3, PR11.5, PR140, PR189, PR195, PR240 +19 more
QTDSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. EMPLOYEE
  5. REPORT-ENTITY
  6. PROCESS-LEVEL
  7. DED-CODE
  8. QUARTER
  9. WORK-STATE
KeyChange, SubsetWhere COUNTRY-CODE = "US" And PENSION != "Y"PR252, PR297, PR299
QTDSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. REPORT-ENTITY
  5. PROCESS-LEVEL
  6. EMPLOYEE
  7. DED-CODE
  8. QUARTER
  9. WORK-STATE
  10. PENSION
KeyChange, SubsetWhere COUNTRY-CODE = "US"PR287, PR290, PR291, PR292, PR294
QTDSET5
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. EMPLOYEE
  5. REPORT-ENTITY
  6. BUS-NBR-GRP
  7. PROCESS-LEVEL
  8. DED-CODE
  9. QUARTER
  10. WORK-STATE
  11. QC-ENT-NBR-GRP
SubsetWhere COUNTRY-CODE = "CA" And PENSION != "Y"PR248

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
QTD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequired
QTD-COMPANY→DDC-COMPANY
QTD-DED-CODE→DDC-DED-CODE
EmployeeEMPLOYEERequired
QTD-COMPANY→EMP-COMPANY
QTD-EMPLOYEE→EMP-EMPLOYEE
Process LevelPRSYSTEMRequired
QTD-COMPANY→PRS-COMPANY
QTD-PROCESS-LEVEL→PRS-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPNot Required
QTD-COMPANY→PQC-COMPANY
QTD-PROCESS-LEVEL→PQC-PROCESS-LEVEL
QTD-QC-ENT-NBR-GRP→PQC-QC-ENT-NBR-GRP
Tax AuthorityPRTAXAUTHRequiredWhen DDC-CALC-TYPE = "T"
DDC-TAX-ID-CODE→PRX-TAX-ID-CODE
Work StatePRSTATERequiredWhen QTD-WORK-STATE != Spaces
QTD-WORK-STATE→PSA-STATE

One to many (1) — child tables

RelationTableRulesConditionField map
PrdeddtlPRDEDDTL
QTD-OBJ-ID→PDE-QTD-OBJ-ID
—→PDE-TAX-STATUS
—→PDE-PYD-OBJ-ID

Programs

Updated by (43)

Referenced by (34)