QUARTWAGE – Quarterly Wage

System
Payroll (PR)
Prefix
QTW
Primary key
COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, PAY-SUM-GRP, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION
Fields
21
Updated by
41 programs
Referenced by
26 programs

QUARTWAGE is the Quarterly Wage table in Lawson Payroll (prefix QTW). It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, PAY-SUM-GRP, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION (QTWSET1); alternate indexes: QTWSET10, QTWSET2, QTWSET3 and QTWSET4. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAYSUMGRP, PSGRELATE, PRQCENTGRP and PRSTATE and 1:M to PRTIME. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 33 more and referenced by BN300, HR170, HR70.1, PA490, PR160, PR180, PR188, PR240 and 18 more. The table has 21 fields, 5 indexes and 9 documented relations.

About QUARTWAGE

This file contains all pay history for an employee, summarized by quarter. This file 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, pay 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 (21)

Column = COBOL field name without the QTW- 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
#QTW-COMPANY PK
COMPANY		Numeric 4—PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-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
#QTW-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-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
#QTW-PAY-SUM-GRP PK
PAY_SUM_GRP		Alpha 3Contains the pay summary group for the data stored on this record.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-WORK-STATE PK
WORK_STATE		Alpha 2Contains the work state associated with this record.PR195, PR197, PR240, PR241, PR242, PR560, PR582, PR82.1 +1 more
#QTW-HOURS
HOURS		Signed 7.2Contains the hours associated with this record.PR195, PR197, PR292, PR560, PR582, PR82.1, PR85.1
#QTW-WAGE-AMOUNT
WAGE_AMOUNT		Signed 13.2Contains the sum of all wage amounts from the time records.PR195, PR197, PR50.1, PR50.3, PR560, PR582, PR82.1, PR85.1
#QTW-NON-CASH-AMT
NON_CASH_AMT		Signed 13.2Contains non-cash amounts associated with this record.PR195, PR197, PR560, PR582, PR80.2, PR82.1, PR85.1
#QTW-OT-CALC-HOURS
OT_CALC_HOURS		Signed 7.2Contains hours calculated as overtime pay for this record.PR195, PR197, PR582, PR82.1, PR85.1
#QTW-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
#QTW-BUS-NBR-GRP PK
BUS_NBR_GRP		Alpha 4Contains the business number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-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
#QTW-QC-ENT-NBR-GRP PK
QC_ENT_NBR_GRP		Alpha 4Contains the Quebec enterprise number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-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
#QTW-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
#QTW-PENSION PK
PENSION		Alpha 1" " = No
  • Y Yes
PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-PAY-UNITS
PAY_UNITS		Signed 7.2—PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—PR195, PR197, PR560, PR582, PR82.1, PR85.1
#QTW-HM-PROC-LEVEL SET10
HM_PROC_LEVEL		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more

Indexes (5)

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
QTWSET1
  1. COMPANY
  2. EMPLOYEE
  3. PAYROLL-YEAR
  4. QUARTER
  5. COUNTRY-CODE
  6. PAY-SUM-GRP
  7. REPORT-ENTITY
  8. BUS-NBR-GRP
  9. QC-ENT-NBR-GRP
  10. PROCESS-LEVEL
  11. WORK-STATE
  12. PENSION
PrimaryBN300, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
QTWSET10
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PAYROLL-YEAR
  5. QUARTER
  6. COUNTRY-CODE
  7. PAY-SUM-GRP
  8. REPORT-ENTITY
  9. BUS-NBR-GRP
  10. QC-ENT-NBR-GRP
  11. PROCESS-LEVEL
  12. WORK-STATE
  13. PENSION
KeyChangeHR170, HR70.1, PR560
QTWSET2
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. EMPLOYEE
  5. PAY-SUM-GRP
  6. QUARTER
  7. REPORT-ENTITY
  8. BUS-NBR-GRP
  9. QC-ENT-NBR-GRP
  10. PROCESS-LEVEL
  11. WORK-STATE
  12. PENSION
KeyChangePR160, PR180, PR240, PR241, PR242, PR243, PR244, PR245 +4 more
QTWSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. EMPLOYEE
  4. PAYROLL-YEAR
  5. REPORT-ENTITY
  6. PROCESS-LEVEL
  7. PAY-SUM-GRP
  8. QUARTER
  9. WORK-STATE
KeyChange, SubsetWhere COUNTRY-CODE = "US" And PENSION != "Y"PR252, PR291, PR292, PR297, PR299
QTWSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. QUARTER
  5. EMPLOYEE
  6. PAY-SUM-GRP
  7. PROCESS-LEVEL
  8. WORK-STATE
  9. REPORT-ENTITY
  10. PENSION
SubsetWhere COUNTRY-CODE = "US"PA490, PR271, PR287, PR292

Relations

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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
QTW-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
QTW-COMPANY→EMP-COMPANY
QTW-EMPLOYEE→EMP-EMPLOYEE
Pay Sum GrpPAYSUMGRPRequired
QTW-COMPANY→PSG-COMPANY
QTW-PAY-SUM-GRP→PSG-PAY-SUM-GRP
Pik Pay ClassPSGRELATENot Required
QTW-COMPANY→PSR-COMPANY
PRS-PAY-IN-KIND→PSR-PAY-CLASS
QTW-PAY-SUM-GRP→PSR-PAY-SUM-GRP
Process LevelPRSYSTEMRequired
QTW-COMPANY→PRS-COMPANY
QTW-PROCESS-LEVEL→PRS-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPNot Required
QTW-COMPANY→PQC-COMPANY
QTW-PROCESS-LEVEL→PQC-PROCESS-LEVEL
QTW-QC-ENT-NBR-GRP→PQC-QC-ENT-NBR-GRP
Tips Pay ClassPSGRELATENot Required
QTW-COMPANY→PSR-COMPANY
PRS-TIPS→PSR-PAY-CLASS
QTW-PAY-SUM-GRP→PSR-PAY-SUM-GRP
Work StatePRSTATERequiredWhen QTW-WORK-STATE != Spaces
QTW-WORK-STATE→PSA-STATE

One to many (1) — child tables

RelationTableRulesConditionField map
Wage DetailPRTIME
QTW-COMPANY→PRT-COMPANY
QTW-EMPLOYEE→PRT-EMPLOYEE
QTW-PAYROLL-YEAR→PRT-PAYROLL-YEAR
QTW-QUARTER→PRT-QUARTER
QTW-PAY-SUM-GRP→PRT-PAY-SUM-GRP
QTW-PROCESS-LEVEL→PRT-PROCESS-LEVEL
QTW-WORK-STATE→PRT-WORK-STATE
—→PRT-CHECK-ID
—→PRT-TIME-SEQ

Programs

Updated by (41)

Referenced by (26)