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 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| QTW-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||
| 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. |
|
||||||||||
| QTW-PAYROLL-YEAR Element: Payroll Year | Numeric 4 Contains the payroll year. |
|
||||||||||
| 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 |
|
||||||||||
| QTW-PAY-SUM-GRP Element: Pay Sum Grp | Alpha 3 Contains the pay summary group for the data stored on this record. |
|
||||||||||
| QTW-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the process level. |
|
||||||||||
| QTW-WORK-STATE Element: Work State | Alpha 2 Contains the work state associated with this record. |
|
||||||||||
| QTW-HOURS Element: Hours | Signed 7.2 Contains the hours associated with this record. |
|
||||||||||
| QTW-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Contains the sum of all wage amounts from the time records. |
|
||||||||||
| QTW-NON-CASH-AMT Element: Non Cash Amt | Signed 13.2 Contains non-cash amounts associated with this record. |
|
||||||||||
| QTW-OT-CALC-HOURS Element: Ot Calc Hours | Signed 7.2 Contains hours calculated as overtime pay for this record. |
|
||||||||||
| 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). |
|
||||||||||
| QTW-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group. |
|
||||||||||
| 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. |
|
||||||||||
| QTW-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec enterprise number group. |
|
||||||||||
| QTW-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||
| QTW-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||
| QTW-PENSION Element: Pension | Alpha 1 Y = Yes " " = No |
|
||||||||||
| QTW-PAY-UNITS Element: Pay Units | Signed 7.2 |
|
||||||||||
| QTW-UNIT-MEASURE Element: Unit Measure | Alpha 12 |
|
||||||||||
| QTW-HM-PROC-LEVEL Element: Process Lev Hr | Alpha 5 |
| 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 |
|
| ||||||||||||||||||||||||||||||||||||
| 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 |
|
| ||||||||||||||||||||||||||||||||||||
| 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 |
|
| ||||||||||||||||||||||||||||||||||||
| QTWSET3 |
COMPANY COUNTRY-CODE EMPLOYEE PAYROLL-YEAR REPORT-ENTITY PROCESS-LEVEL PAY-SUM-GRP QUARTER WORK-STATE |
|
| ||||||||||||||||||||||||||||||||||||
| QTWSET4 |
COMPANY COUNTRY-CODE PAYROLL-YEAR QUARTER EMPLOYEE PAY-SUM-GRP PROCESS-LEVEL WORK-STATE REPORT-ENTITY PENSION |
|
| ||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM |
Required
| |||||||||
| Employee | EMPLOYEE |
Required
| |||||||||
| Pay Sum Grp | PAYSUMGRP |
Required
| |||||||||
| Pik Pay Class | PSGRELATE |
Not Required
| |||||||||
| Process Level | PRSYSTEM |
Required
| |||||||||
| Prqcentgrp | PRQCENTGRP |
Not Required
| |||||||||
| Tips Pay Class | PSGRELATE |
Not Required
| |||||||||
| Work State | PRSTATE |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wage Detail | PRTIME |
|
All trademarks and registered trademarks are the property of their
respective owners.