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 BN66.1 HR170 HR70.1 PA115
PR139 PR140 PR189 PR265 PR50.1 PR50.4
PR50.3 PR80.1 PR89.1 PR240 PR241 PR242
PR243 PR244 PR245 PR52.2 PR252 PR297
PR298 PR299 PR290 PR291 PR292 PR248
UPDATED BY
AC542 BN500 PR195 PR197 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTD-COMPANY Numeric 4 AC542 BN500
Company The company number represents an PR195 PR197
established company and is entered on PR560 PR82.1
all function codes. PR85.1
QTD-EMPLOYEE Numeric 9 AC542 BN500
Employee Contains the employee number. Each PR195 PR197
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 AC542 BN500
Current Payroll Year Contains the payroll year. PR195 PR197
PR560 PR82.1
PR85.1
QTD-QUARTER Numeric 1 AC542 BN500
Quarter Contains the fiscal quarter for the PR195 PR197
data stored in this record. PR560 PR82.1
1 = First PR85.1
2 = Second
3 = Third
4 = Fourth
QTD-DED-CODE Alpha 4 AC542 BN500
Deduction Code Contains the deduction code associated PR195 PR197
with this record. PR560 PR82.1
PR85.1
QTD-PROCESS-LEVEL Alpha 5 AC542 BN500
Process Level This field contains the tax reporting PR195 PR197
process level. PR560 PR82.1
PR85.1
QTD-WORK-STATE Alpha 2 AC542 BN500
Work State Contains the work state associated with PR195 PR197
this record. PR560 PR82.1
PR85.1
QTD-DED-AMT Signed 13.2 AC542 BN500
Deduction Amount Contains the deduction amount PR195 PR197
associated with this record. PR560 PR82.1
PR85.1
QTD-TAX-WAGES Signed 13.2 AC542 BN500
Taxable Wages Contains the taxable wages associated PR195 PR197
with this deduction record. PR50.1 PR50.3
PR560 PR82.1
PR85.1
QTD-WAGE-AMOUNT Signed 13.2 AC542 BN500
Wage Amount Contains the sum of all wage amounts PR195 PR197
from the time records. PR560 PR82.1
PR85.1
QTD-EXCESS Signed 13.2 AC542 BN500
Excess Contains excess wages by deduction. PR195 PR197
PR560 PR82.1
PR85.1
QTD-DED-TAX-CAT Derived
Ded Tax Cat
QTD-DED-TAX-AUTH Derived
Ded Tax Auth
QTD-COUNTRY-CODE Alpha 2 AC542 PR195
Country Code The country code. Required for VAT and PR197 PR560
intrastat reporting. Must be defined in PR82.1 PR85.1
IN01.1 (Country Maintenance).
QTD-REPORT-ENTITY Alpha 5 AC542 PR195
Report Entity Contains the report entity. PR197 PR560
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.
QTD-BUS-NBR-GRP Alpha 4 AC542 PR195
Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
QTD-QC-ENT-NBR-GRP Alpha 4 AC542 PR195
Qc Ent Nbr Grp Contains the Quebec enterprise number PR197 PR560
group. PR82.1 PR85.1
QTD-OBJ-ID Numeric 12 AC542 PR195
Object This is the object identifier. It is PR197 PR82.1
Identification used to relate commitments or posted PR85.1
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
QTD-CURRENCY-CODE Alpha 5 AC542 PR195
Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ).
QTD-CURR-ND Numeric 1 AC542 PR195
Currency Number of Represents the number of decimals PR197 PR560
Decimals defined for the currency of the object. PR82.1 PR85.1
QTD-PENSION Alpha 1 AC542 PR195
Pension " " = No PR197 PR560
Y = Yes PR82.1 PR85.1
QUARTDED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTDSET1 COMPANY AC542 BN232
EMPLOYEE BN335 BN500
PAYROLL-YEAR BN66.1 HR170
QUARTER HR70.1 PA115
COUNTRY-CODE PR139 PR140
DED-CODE PR189 PR195
REPORT-ENTITY PR197 PR265
BUS-NBR-GRP PR300 PR50.1
QC-ENT-NBR-GRP PR50.4 PR560
PROCESS-LEVEL PR80.1 PR82.1
WORK-STATE PR85.1 PR89.1
PENSION
QTDSET2 COMPANY KeyChange BN335 PR240
COUNTRY-CODE PR241 PR242
PAYROLL-YEAR PR243 PR244
EMPLOYEE PR245 PR50.1
DED-CODE PR50.3 PR50.4
QUARTER PR52.2 PR560
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
QTDSET3 COMPANY KeyChange, Subset PR252 PR297
COUNTRY-CODE Where COUNTRY-CODE = "US" PR298 PR299
PAYROLL-YEAR And PENSION != "Y"
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QTDSET4 COMPANY KeyChange, Subset PR252 PR290
COUNTRY-CODE Where COUNTRY-CODE = "US" PR291 PR292
PAYROLL-YEAR PR297 PR298
REPORT-ENTITY PR299
PROCESS-LEVEL
EMPLOYEE
DED-CODE
QUARTER
WORK-STATE
PENSION
QTDSET5 COMPANY Subset PR248
COUNTRY-CODE Where COUNTRY-CODE = "CA"
PAYROLL-YEAR And PENSION != "Y"
EMPLOYEE
REPORT-ENTITY
BUS-NBR-GRP
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QC-ENT-NBR-GRP
QTDSET6 COMPANY Subset
COUNTRY-CODE Where COUNTRY-CODE = "CA"
PAYROLL-YEAR And PENSION != "Y"
EMPLOYEE And QC-ENT-NBR-GRP != Spaces
REPORT-ENTITY
QC-ENT-NBR-GRP
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
BUS-NBR-GRP
QUARTDED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
QTD-COMPANY -> PRS-COMPANY (PRSSET1)
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
Prqcentgrp PRQCENTGRP Not Required
QTD-COMPANY -> PQC-COMPANY
QTD-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
QTD-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Tax Authority PRTAXAUTH Required
When QTD-CALC-TYPE = "T"
DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When QTD-WORK-STATE != Spaces
QTD-WORK-STATE -> PSA-STATE
QUARTDED FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prdeddtl PRDEDDTL
QTD-OBJ-ID -> PDE-QTD-OBJ-ID
PDE-TAX-STATUS
PDE-PYD-OBJ-ID
|
