Lawson Insight Technical Documentation |
|
QUARTWAGE
QUARTWAGE FILE
Quarterly Wage
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.
REFERENCED BY
BN300 PR188 PR50.1 PR50.3 PR84.1 HR170
HR70.1 PR160 PR180 PR240 PR241 PR242
PR243 PR244 PR245 PR249 PR290 PR52.1
PR80.2 PR252 PR291 PR297 PR299 PA490
PR287 PR292
UPDATED BY
BN305 ET530 HR11.1 HR11.2 HR511 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR195 PR197 PR300 PR560 PR82.1 PR85.1
UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTW-COMPANY Numeric 4 ET530 PR195
Element: Company Hr PR197 PR560
PR82.1 PR85.1
UK560
QTW-EMPLOYEE Numeric 9 ET530 PR195
Element: Employee Contains the employee number. Each PR197 PR560
person employed by the company is PR82.1 PR85.1
assigned a unique number. The system UK560
uses the employee number to correlate
all of the information related to that
person.
QTW-PAYROLL-YEAR Numeric 4 ET530 PR195
Element: Payroll Year Contains the payroll year. PR197 PR560
PR82.1 PR85.1
UK560
QTW-QUARTER Numeric 1 ET530 PR195
Element: Quarter Contains the fiscal quarter for the PR197 PR560
data stored in this record. PR82.1 PR85.1
1 = First UK560
2 = Second
3 = Third
4 = Fourth
QTW-PAY-SUM-GRP Alpha 3 ET530 PR195
Element: Pay Sum Grp Contains the pay summary group for the PR197 PR560
data stored on this record. PR82.1 PR85.1
UK560
QTW-PROCESS-LEVEL Alpha 5 ET530 PR195
Element: Process Lev HrContains the process level. PR197 PR560
PR82.1 PR85.1
UK560
QTW-WORK-STATE Alpha 2 ET530 PR195
Element: Work State Contains the work state associated with PR197 PR240
this record. PR241 PR242
PR560 PR82.1
PR85.1 UK560
QTW-HOURS Signed 7.2 ET530 PR195
Element: Hours Contains the hours associated with this PR197 PR292
record. PR560 PR82.1
PR85.1 UK560
QTW-WAGE-AMOUNT Signed 13.2 ET530 PR195
Element: Wage Amount Contains the sum of all wage amounts PR197 PR50.1
from the time records. PR50.3 PR560
PR82.1 PR85.1
UK560
QTW-NON-CASH-AMT Signed 13.2 ET530 PR195
Element: Non Cash Amt Contains non-cash amounts associated PR197 PR560
with this record. PR80.2 PR82.1
PR85.1 UK560
QTW-OT-CALC-HOURS Signed 7.2 ET530 PR195
Element: Ot Calc Hours Contains hours calculated as overtime PR197 PR82.1
pay for this record. PR85.1
QTW-COUNTRY-CODE Alpha 2 ET530 PR195
Element: Country Code The country code. Required for VAT and PR197 PR560
intrastat reporting. Must be defined in PR82.1 PR85.1
IN01.1 (Country Maintenance). UK560
QTW-BUS-NBR-GRP Alpha 4 ET530 PR195
Element: Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
UK560
QTW-REPORT-ENTITY Alpha 5 ET530 PR195
Element: Report Entity Contains the report entity. PR197 PR560
PR82.1 PR85.1
Report Entity is the Process Level or UK560
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.
QTW-QC-ENT-NBR-GRP Alpha 4 ET530 PR195
Element: Qc Ent Nbr GrpContains the Quebec enterprise number PR197 PR560
group. PR82.1 PR85.1
UK560
QTW-CURRENCY-CODE Alpha 5 ET530 PR195
Element: Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ). UK560
QTW-CURR-ND Numeric 1 ET530 PR195
Element: Acct Nd The number of decimals assigned to a PR197 PR560
particular account as determined by the PR82.1 PR85.1
account currency. UK560
QTW-PENSION Alpha 1 ET530 PR195
Element: Pension Y = Yes PR197 PR560
" " = No PR82.1 PR85.1
UK560
QTW-PAY-UNITS Signed 7.2 ET530 PR195
Element: Pay Units PR197 PR560
PR82.1 PR85.1
QTW-UNIT-MEASURE Alpha 12 ET530 PR195
Element: Unit Measure PR197 PR560
PR82.1 PR85.1
QTW-HM-PROC-LEVEL Alpha 5 BN305 ET530
Element: Process Lev Hr HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR195 PR197
PR560 PR82.1
PR85.1 UK560
QUARTWAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTWSET1 COMPANY BN300 BN305
EMPLOYEE ET530 HR11.1
PAYROLL-YEAR HR11.2 HR511
QUARTER PA02.1 PA100
COUNTRY-CODE PA102 PA115
PAY-SUM-GRP PA13.1 PA13.2
REPORT-ENTITY PA502 PA513
BUS-NBR-GRP PA52.1 PA52.3
QC-ENT-NBR-GRP PA52.4 PA52.5
PROCESS-LEVEL PR110 PR113
WORK-STATE PR120 PR13.1
PENSION PR13.5 PR13.6
PR13.8 PR188
PR195 PR197
PR300 PR50.1
...
QTWSET10 COMPANY KeyChange HR170 HR70.1
HM-PROC-LEVEL PR560 UK560
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
PAY-SUM-GRP
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
QTWSET2 COMPANY KeyChange PR160 PR180
COUNTRY-CODE PR240 PR241
PAYROLL-YEAR PR242 PR243
EMPLOYEE PR244 PR245
PAY-SUM-GRP PR249 PR290
QUARTER PR52.1 PR80.2
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
QTWSET3 COMPANY KeyChange, Subset PR252 PR291
COUNTRY-CODE Where COUNTRY-CODE = "US" PR297 PR299
EMPLOYEE And PENSION != "Y"
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
QTWSET4 COMPANY Subset PA490 PR287
COUNTRY-CODE Where COUNTRY-CODE = "US" PR292
PAYROLL-YEAR
QUARTER
EMPLOYEE
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
REPORT-ENTITY
PENSION
QUARTWAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
QTW-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
QTW-COMPANY -> EMP-COMPANY
QTW-EMPLOYEE -> EMP-EMPLOYEE
Pay Sum Grp PAYSUMGRP Required
QTW-COMPANY -> PSG-COMPANY
QTW-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
Pik Pay Class PSGRELATE Not Required
QTW-COMPANY -> PSR-COMPANY
PRS-PAY-IN-KIND -> PSR-PAY-CLASS
QTW-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
Process Level PRSYSTEM Required
QTW-COMPANY -> PRS-COMPANY
QTW-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Not Required
QTW-COMPANY -> PQC-COMPANY
QTW-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
QTW-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Tips Pay Class PSGRELATE Not Required
QTW-COMPANY -> PSR-COMPANY
PRS-TIPS -> PSR-PAY-CLASS
QTW-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
Work State PRSTATE Required
When QTW-WORK-STATE != Spaces
QTW-WORK-STATE -> PSA-STATE
QUARTWAGE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wage Detail PRTIME
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
|