QUARTWAGE

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
PR287


UPDATED BY
BN300 BN305 HR11.1 HR11.2 HR170 HR28.1
HR511 HR70.1 LT101 ZH510 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA490 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR160 PR180 PR188 PR195
PR197 PR240 PR241 PR242 PR243 PR244
PR245 PR249 PR252 PR290 PR291 PR292
PR293 PR297 PR299 PR30.2 PR300 PR50.1
PR50.3 PR52.1 PR560 PR582 PR80.2 PR82.1
PR84.1 PR85.1 UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTW-COMPANY
Element: Company Hr
Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-EMPLOYEE
Element: Employee
Numeric 9
Contains 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
UK560
QTW-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
Contains the payroll year.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-QUARTER
Element: Quarter
Numeric 1
Contains 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
UK560
QTW-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
Contains the pay summary group for the data stored on this record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-WORK-STATE
Element: Work State
Alpha 2
Contains the work state associated with this record.
PR195 PR197
PR240 PR241
PR242 PR560
PR582 PR82.1
PR85.1 UK560
QTW-HOURS
Element: Hours
Signed 7.2
Contains the hours associated with this record.
PR195 PR197
PR292 PR560
PR582 PR82.1
PR85.1 UK560
QTW-WAGE-AMOUNT
Element: Wage Amount
Signed 13.2
Contains the sum of all wage amounts from the time records.
PR195 PR197
PR50.1 PR50.3
PR560 PR582
PR82.1 PR85.1
UK560
QTW-NON-CASH-AMT
Element: Non Cash Amt
Signed 13.2
Contains non-cash amounts associated with this record.
PR195 PR197
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560
QTW-OT-CALC-HOURS
Element: Ot Calc Hours
Signed 7.2
Contains hours calculated as overtime pay for this record.
PR195 PR197
PR582 PR82.1
PR85.1
QTW-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-REPORT-ENTITY
Element: Report Entity
Alpha 5
Contains 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
UK560
QTW-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-PENSION
Element: Pension
Alpha 1

Y = Yes
" " = No
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTW-PAY-UNITS
Element: Pay Units
Signed 7.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
QTW-UNIT-MEASURE
Element: Unit Measure
Alpha 12
PR195 PR197
PR560 PR582
PR82.1 PR85.1
QTW-HM-PROC-LEVEL
Element: Process Lev Hr
Alpha 5
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR195
PR197 PR30.2
PR560 PR582
PR82.1 PR85.1
UK560 ZH510


QUARTWAGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTWSET1 COMPANY
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
PAY-SUM-GRP
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
...
BN300 BN305
HR11.1 HR11.2
HR28.1 HR511
LT101 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR188
QTWSET10 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
PAY-SUM-GRP
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
KeyChange
HR170 HR70.1
PR560 UK560
QTWSET2 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
EMPLOYEE
PAY-SUM-GRP
QUARTER
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
KeyChange
PR160 PR180
PR240 PR241
PR242 PR243
PR244 PR245
PR249 PR290
PR52.1 PR80.2
QTWSET3 COMPANY
COUNTRY-CODE
EMPLOYEE
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
KeyChange, Subset
WhereCOUNTRY-CODE ="US"
AndPENSION !="Y"
PR252 PR291
PR292 PR297
PR299
QTWSET4 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
QUARTER
EMPLOYEE
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
REPORT-ENTITY
PENSION
Subset
WhereCOUNTRY-CODE ="US"
PA490 PR287
PR292


QUARTWAGE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:27:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.