|
|
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 PA115 PR188 PR265 PR50.1
PR50.3 PR84.1 HR170 HR70.1 PR160 PR180
PR240 PR241 PR242 PR243 PR244 PR245
PR290 PR52.1 PR252 PR291 PR292 PR297
PR298 PR299 PA490
UPDATED BY
HR11.1 HR11.2 HR511 PA02.1 PA100 PA102
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 PR197 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTW-COMPANY Numeric 4 PR197 PR560
Element: Company Hr Identifies the AP company if the PR82.1 PR85.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
QTW-EMPLOYEE Numeric 9 PR197 PR560
Element: Employee Contains the employee number. Each PR82.1 PR85.1
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.
QTW-PAYROLL-YEAR Numeric 4 PR197 PR560
Element: Current PayrolContains the payroll year. PR82.1 PR85.1
QTW-QUARTER Numeric 1 PR197 PR560
Element: Quarter Contains the fiscal quarter for the PR82.1 PR85.1
data stored in this record.
1 = First
2 = Second
3 = Third
4 = Fourth
QTW-PAY-SUM-GRP Alpha 3 PR197 PR560
Payment Summary Contains the pay summary group for the PR82.1 PR85.1
Group data stored on this record.
QTW-PROCESS-LEVEL Alpha 5 PR197 PR560
Element: Process Lev HrContains the process level. PR82.1 PR85.1
QTW-WORK-STATE Alpha 2 PR197 PR560
Element: Work State Contains the work state associated with PR82.1 PR85.1
this record.
QTW-HOURS Signed 7.2 PR197 PR292
Element: Hours Contains the hours associated with this PR560 PR82.1
record. PR85.1
QTW-WAGE-AMOUNT Signed 13.2 PR197 PR50.1
Element: Wage Amount Contains the sum of all wage amounts PR50.3 PR560
from the time records. PR82.1 PR85.1
QTW-NON-CASH-AMT Signed 13.2 PR197 PR560
Element: Non Cash Amt Contains non-cash amounts associated PR82.1 PR85.1
with this record.
QTW-OT-CALC-HOURS Signed 7.2 PR197 PR82.1
Element: Ot Calc Hours Contains hours calculated as overtime PR85.1
pay for this record.
QTW-COUNTRY-CODE Alpha 2 PR197 PR560
Element: Country Code The country code. Required for VAT and PR82.1 PR85.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
QTW-BUS-NBR-GRP Alpha 4 PR197 PR560
Element: Bus Nbr Grp Contains the business number group. PR82.1 PR85.1
QTW-REPORT-ENTITY Alpha 5 PR197 PR560
Element: Report Entity Contains the report entity. 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 PR197 PR560
Element: Qc Ent Nbr GrpContains the Quebec enterprise number PR82.1 PR85.1
group.
QTW-CURRENCY-CODE Alpha 5 PR197 PR560
Element: Currency Code This field contains the company base PR82.1 PR85.1
currency code established in Company
(GL10.1 ).
QTW-CURR-ND Numeric 1 PR197 PR560
Account Currency Represents the number of decimals PR82.1 PR85.1
Code defined for the currency of the object.
QTW-PENSION Alpha 1 PR197 PR560
Element: Pension Y = Yes PR82.1 PR85.1
" " = No
QTW-PAY-UNITS Signed 7.2 PR197 PR560
Element: Pay Units PR82.1 PR85.1
QTW-UNIT-MEASURE Alpha 12 PR197 PR560
Element: Unit Measure PR82.1 PR85.1
QTW-HM-PROC-LEVEL Alpha 5 HR11.1 HR11.2
Element: Process Lev HrContains the employee's home process HR511 PA02.1
level. PA100 PA102
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 PR197
PR560 PR82.1
PR85.1
QUARTWAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTWSET1 COMPANY BN300 BN305
EMPLOYEE HR11.1 HR11.2
PAYROLL-YEAR HR511 PA02.1
QUARTER PA100 PA102
COUNTRY-CODE PA115 PA13.1
PAY-SUM-GRP PA13.2 PA502
REPORT-ENTITY PA513 PA52.1
BUS-NBR-GRP PA52.3 PA52.4
QC-ENT-NBR-GRP PA52.5 PR110
PROCESS-LEVEL PR113 PR120
WORK-STATE PR13.1 PR13.5
PENSION PR13.6 PR13.8
PR188 PR197
PR265 PR300
PR50.1 PR50.3
...
QTWSET10 COMPANY KeyChange HR170 HR70.1
HM-PROC-LEVEL PR560
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 PR290 PR52.1
QUARTER
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" 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
QTWSET7 COMPANY KeyChange
COUNTRY-CODE
PAYROLL-YEAR
BUS-NBR-GRP
PROCESS-LEVEL
EMPLOYEE
PAY-SUM-GRP
QUARTER
WORK-STATE
REPORT-ENTITY
QTWSET8 COMPANY KeyChange, Subset
COUNTRY-CODE Where WORK-STATE = "QC"
PAYROLL-YEAR And QC-ENT-NBR-GRP != Spaces
QC-ENT-NBR-GRP
PROCESS-LEVEL
EMPLOYEE
PAY-SUM-GRP
QUARTER
REPORT-ENTITY
QTWSET9 COMPANY KeyChange
COUNTRY-CODE
PAYROLL-YEAR
PROCESS-LEVEL
BUS-NBR-GRP
QC-ENT-NBR-GRP
EMPLOYEE
PAY-SUM-GRP
QUARTER
WORK-STATE
REPORT-ENTITY
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
|
