|
|
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 HR170 HR70.1 PA115 PR265
PR50.1 PR50.3 PR160 PR180 PR290 PR52.1
PR80.2 PR291 PR292 PR297 PR298
UPDATED BY
BN500 PR150 PR195 PR199 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTW-COMPANY Numeric 4 BN500 PR150
Company The company number represents an PR195 PR199
established company and is entered on PR560 PR82.1
all function codes. PR85.1
QTW-EMPLOYEE Numeric 9 BN500 PR150
Employee Contains the employee number. Each PR195 PR199
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 BN500 PR150
Current Payroll Year Contains the payroll year. PR195 PR199
PR560 PR82.1
PR85.1
QTW-QUARTER Numeric 1 BN500 PR150
Quarter Contains the fiscal quarter for the PR195 PR199
data stored in this record. PR560 PR82.1
1 = First PR85.1
2 = Second
3 = Third
4 = Fourth
QTW-PAY-SUM-GRP Alpha 3 BN500 PR150
Payment Summary Contains the pay summary group for the PR195 PR199
Group data stored on this record. PR560 PR82.1
PR85.1
QTW-PROCESS-LEVEL Alpha 5 BN500 PR150
Process Level Contains the process level. PR195 PR199
PR560 PR82.1
PR85.1
QTW-WORK-STATE Alpha 2 BN500 PR150
Work State Contains the work state associated with PR195 PR199
this record. PR560 PR82.1
PR85.1
QTW-HOURS Signed 7.2 BN500 PR150
Hours Contains the hours associated with this PR195 PR199
record. PR292 PR560
PR82.1 PR85.1
QTW-WAGE-AMOUNT Signed 11.2 BN500 PR150
Wage Amount Contains the sum of all wage amounts PR195 PR199
from the time records. PR50.1 PR50.3
PR560 PR82.1
PR85.1
QTW-NON-CASH-AMT Signed 11.2 PR150 PR195
Non Cash Amt Contains non-cash amounts associated PR199 PR560
with this record. PR80.2 PR82.1
PR85.1
QTW-OT-CALC-HOURS Signed 7.2 BN500 PR150
Ot Calc Hours Contains hours calculated as overtime PR195 PR199
pay for this record. PR82.1 PR85.1
QUARTWAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTWSET1 COMPANY BN300 BN305
EMPLOYEE BN500 HR170
PAYROLL-YEAR HR70.1 PA115
QUARTER PR150 PR195
PAY-SUM-GRP PR199 PR265
PROCESS-LEVEL PR300 PR50.1
WORK-STATE PR50.3 PR560
PR82.1 PR85.1
QTWSET2 COMPANY KeyChange PR160 PR180
EMPLOYEE PR290 PR52.1
PAYROLL-YEAR PR80.2
PAY-SUM-GRP
QUARTER
PROCESS-LEVEL
WORK-STATE
QTWSET3 COMPANY KeyChange PR291 PR292
EMPLOYEE PR297 PR298
PAYROLL-YEAR
PROCESS-LEVEL
PAY-SUM-GRP
QUARTER
WORK-STATE
QTWSET4 COMPANY
PAYROLL-YEAR
QUARTER
EMPLOYEE
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
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
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
|