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 BN305 BN66.1 HR170 HR70.1 PA115
PR140 PR188 PR189 PR265 PR50.1 PR50.3
PR80.1 PR80.2 PR84.1 PR89.1 PR160 PR180
PR240 PR241 PR242 PR243 PR244 PR245
PR290 PR52.1 PR252 PR291 PR292 PR297
PR298 PR299 PA490
UPDATED BY
AC542 BN500 PR195 PR197 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTW-COMPANY Numeric 4 AC542 BN500
Company The company number represents an PR195 PR197
established company and is entered on PR560 PR82.1
all function codes. PR85.1
QTW-EMPLOYEE Numeric 9 AC542 BN500
Employee Contains the employee number. Each PR195 PR197
person employed by the company is PR560 PR82.1
assigned a unique number. The system PR85.1
uses the employee number to correlate
all of the information related to that
person.
QTW-PAYROLL-YEAR Numeric 4 AC542 BN500
Current Payroll Year Contains the payroll year. PR195 PR197
PR560 PR82.1
PR85.1
QTW-QUARTER Numeric 1 AC542 BN500
Quarter Contains the fiscal quarter for the PR195 PR197
data stored in this record. PR560 PR82.1
1 = First PR85.1
2 = Second
3 = Third
4 = Fourth
QTW-PAY-SUM-GRP Alpha 3 AC542 BN500
Payment Summary Contains the pay summary group for the PR195 PR197
Group data stored on this record. PR560 PR82.1
PR85.1
QTW-PROCESS-LEVEL Alpha 5 AC542 BN500
Process Level Contains the process level. PR195 PR197
PR560 PR82.1
PR85.1
QTW-WORK-STATE Alpha 2 AC542 BN500
Work State Contains the work state associated with PR195 PR197
this record. PR560 PR82.1
PR85.1
QTW-HOURS Signed 7.2 AC542 BN500
Hours Contains the hours associated with this PR195 PR197
record. PR292 PR560
PR82.1 PR85.1
QTW-WAGE-AMOUNT Signed 13.2 AC542 BN500
Wage Amount Contains the sum of all wage amounts PR195 PR197
from the time records. PR50.1 PR50.3
PR560 PR82.1
PR85.1
QTW-NON-CASH-AMT Signed 13.2 AC542 PR195
Non Cash Amt Contains non-cash amounts associated PR197 PR560
with this record. PR80.2 PR82.1
PR85.1
QTW-OT-CALC-HOURS Signed 7.2 AC542 BN500
Ot Calc Hours Contains hours calculated as overtime PR195 PR197
pay for this record. PR82.1 PR85.1
QTW-COUNTRY-CODE Alpha 2 AC542 PR195
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).
QTW-BUS-NBR-GRP Alpha 4 AC542 PR195
Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
QTW-REPORT-ENTITY Alpha 5 AC542 PR195
Report Entity Contains the report entity. PR197 PR560
PR82.1 PR85.1
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.
QTW-QC-ENT-NBR-GRP Alpha 4 AC542 PR195
Qc Ent Nbr Grp Contains the Quebec enterprise number PR197 PR560
group. PR82.1 PR85.1
QTW-CURRENCY-CODE Alpha 5 AC542 PR195
Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ).
QTW-CURR-ND Numeric 1 AC542 PR195
Currency Number of Represents the number of decimals PR197 PR560
Decimals defined for the currency of the object. PR82.1 PR85.1
QTW-PENSION Alpha 1 AC542 PR195
Pension Y = Yes PR197 PR560
" " = No PR82.1 PR85.1
QTW-PAY-UNITS Signed 7.2
Pay Units
QTW-UNIT-MEASURE Alpha 12
Unit Measure
QUARTWAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTWSET1 COMPANY AC542 BN300
EMPLOYEE BN305 BN500
PAYROLL-YEAR BN66.1 HR170
QUARTER HR70.1 PA115
COUNTRY-CODE PR140 PR188
PAY-SUM-GRP PR189 PR195
REPORT-ENTITY PR197 PR265
BUS-NBR-GRP PR300 PR50.1
QC-ENT-NBR-GRP PR50.3 PR560
PROCESS-LEVEL PR80.1 PR82.1
WORK-STATE PR84.1 PR85.1
PENSION PR89.1
QTWSET2 COMPANY KeyChange BN66.1 PR140
COUNTRY-CODE PR160 PR180
PAYROLL-YEAR PR189 PR195
EMPLOYEE PR197 PR240
PAY-SUM-GRP PR241 PR242
QUARTER PR243 PR244
REPORT-ENTITY PR245 PR290
BUS-NBR-GRP PR52.1 PR80.1
QC-ENT-NBR-GRP PR80.2 PR85.1
PROCESS-LEVEL PR89.1
WORK-STATE
PENSION
QTWSET3 COMPANY KeyChange, Subset PR252 PR291
COUNTRY-CODE Where COUNTRY-CODE = "US" PR292 PR297
EMPLOYEE And PENSION != "Y" PR298 PR299
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
QTWSET4 COMPANY Subset PA490
COUNTRY-CODE Where COUNTRY-CODE = "US"
PAYROLL-YEAR
QUARTER
EMPLOYEE
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
REPORT-ENTITY
PENSION
QTWSET5 COMPANY Subset
COUNTRY-CODE Where COUNTRY-CODE = "CA"
EMPLOYEE And PENSION != "Y"
PAYROLL-YEAR
REPORT-ENTITY
BUS-NBR-GRP
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
QC-ENT-NBR-GRP
QTWSET6 COMPANY Subset
COUNTRY-CODE Where COUNTRY-CODE = "CA"
EMPLOYEE And PENSION != "Y"
PAYROLL-YEAR And QC-ENT-NBR-GRP != Spaces
REPORT-ENTITY
QC-ENT-NBR-GRP
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
BUS-NBR-GRP
QUARTWAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
QTW-COMPANY -> PRS-COMPANY (PRSSET1)
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
|
