|
|
QUARTDED FILE
Quarterly Deduction
This file contains all deduction history for an employee, summarized by
quarter, and 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, deduction 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
BN232 BN335 HR170 HR70.1 PA115 PR265
PR50.1 PR50.4 PR50.3 PR52.2 PR297 PR298
PR290 PR291 PR292
UPDATED BY
BN500 PR150 PR195 PR199 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTD-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
QTD-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.
QTD-PAYROLL-YEAR Numeric 4 BN500 PR150
Current Payroll Year Contains the payroll year. PR195 PR199
PR560 PR82.1
PR85.1
QTD-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
QTD-DED-CODE Alpha 4 BN500 PR150
Deduction Code Contains the deduction code associated PR195 PR199
with this record. PR560 PR82.1
PR85.1
QTD-PROCESS-LEVEL Alpha 5 BN500 PR150
Process Level Contains the process level associated PR195 PR199
with this record. PR560 PR82.1
PR85.1
QTD-WORK-STATE Alpha 2 BN500 PR150
Work State Contains the work state associated with PR195 PR199
this record. PR560 PR82.1
PR85.1
QTD-DED-AMT Signed 9.2 BN500 PR150
Deduction Amount Contains the deduction amount PR195 PR199
associated with this record. PR560 PR82.1
PR85.1
QTD-TAX-WAGES Signed 11.2 BN500 PR150
Taxable Wages Contains the taxable wages associated PR195 PR199
with this deduction record. PR50.1 PR50.3
PR560 PR82.1
PR85.1
QTD-WAGE-AMOUNT Signed 11.2 BN500 PR150
Wage Amount Contains the sum of all wage amounts PR195 PR199
from the time records. PR560 PR82.1
PR85.1
QTD-EXCESS Signed 11.2 BN500 PR150
Excess Contains excess wages by deduction. PR195 PR199
PR560 PR82.1
PR85.1
QTD-DED-TAX-CAT Derived
Ded Tax Cat
QTD-DED-TAX-AUTH Derived
Ded Tax Auth
QUARTDED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTDSET1 COMPANY BN232 BN335
EMPLOYEE BN500 HR170
PAYROLL-YEAR HR70.1 PA115
QUARTER PR150 PR195
DED-CODE PR199 PR265
PROCESS-LEVEL PR300 PR50.1
WORK-STATE PR50.4 PR560
PR82.1 PR85.1
QTDSET2 COMPANY KeyChange BN335 PR50.1
PAYROLL-YEAR PR50.3 PR50.4
EMPLOYEE PR52.2
DED-CODE
QUARTER
PROCESS-LEVEL
WORK-STATE
QTDSET3 COMPANY KeyChange PR297 PR298
PAYROLL-YEAR
EMPLOYEE
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QTDSET4 COMPANY KeyChange PR290 PR291
PAYROLL-YEAR PR292
PROCESS-LEVEL
EMPLOYEE
DED-CODE
QUARTER
WORK-STATE
QUARTDED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
QTD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
QTD-COMPANY -> DDC-COMPANY
QTD-DED-CODE -> DDC-DED-CODE
Employee EMPLOYEE Required
QTD-COMPANY -> EMP-COMPANY
QTD-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
QTD-COMPANY -> PRS-COMPANY
QTD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Tax Authority PRTAXAUTH Required
When QTD-CALC-TYPE = "W"
DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When QTD-WORK-STATE != Spaces
QTD-WORK-STATE -> PSA-STATE
|