QUARTDED

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
PR266 PR287 ZP529


UPDATED BY
BN232 BN305 BN335 BN66.1 HR11.1 HR11.2
HR170 HR28.1 HR511 HR70.1 LT101 ZH510
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR11.3 PR11.5 PR110 PR113 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR139
PR140 PR189 PR195 PR197 PR240 PR241
PR242 PR243 PR244 PR245 PR248 PR249
PR251 PR252 PR290 PR291 PR292 PR294
PR297 PR299 PR30.2 PR300 PR50.1 PR50.3
PR50.4 PR52.2 PR560 PR582 PR597 PR80.1
PR80.4 PR82.1 PR85.1 PR89.1 UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTD-COMPANY
Element: Company Hr		Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-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
QTD-PAYROLL-YEAR
Element: Payroll Year		Numeric 4
Contains the payroll year.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-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
QTD-DED-CODE
Element: Ded Code		Alpha 4
Contains the deduction code associated with this record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
This field contains the tax reporting process level.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-WORK-STATE
Element: Work State		Alpha 2
Contains the work state associated with this record.
PR195 PR197
PR240 PR241
PR242 PR299
PR560 PR582
PR82.1 PR85.1
UK560
QTD-DED-AMT
Element: Ded Amt		Signed 13.2
Contains the deduction amount associated with this record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-TAX-WAGES
Element: Tax Wages		Signed 13.2
Contains the taxable wages associated with this deduction record.
PR195 PR197
PR50.1 PR50.3
PR560 PR582
PR82.1 PR85.1
UK560 ZP529
QTD-WAGE-AMOUNT
Element: Wage Amount		Signed 13.2
Contains the sum of all wage amounts from the time records.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-EXCESS
Element: Excess		Signed 13.2
Contains excess wages by deduction.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-DED-TAX-CAT
Element: Ded Tax Cat		Derived
QTD-DED-TAX-AUTH
Element: Ded Tax Auth		Derived
QTD-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
QTD-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
QTD-BUS-NBR-GRP
Element: Bus Nbr Grp		Alpha 4
Contains the business number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-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
QTD-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted 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.
PR195 PR197
PR582 PR82.1
PR85.1
QTD-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
QTD-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
QTD-PENSION
Element: Pension		Alpha 1

" " = No
Y = Yes
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
QTD-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


QUARTDED FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTDSET1 COMPANY
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
DED-CODE
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
...
BN232 BN305
BN335 BN66.1
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
QTDSET10 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
DED-CODE
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
KeyChange
HR170 HR70.1
PR560 UK560
QTDSET2 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
EMPLOYEE
DED-CODE
QUARTER
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
KeyChange
BN335 PR11.3
PR11.5 PR240
PR241 PR242
PR243 PR244
PR245 PR249
PR251 PR266
PR292 PR50.1
PR50.3 PR50.4
PR52.2 PR560
PR597 UK560
QTDSET3 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
KeyChange, Subset
WhereCOUNTRY-CODE ="US"
AndPENSION !="Y"
PR252 PR297
PR299
QTDSET4 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
DED-CODE
QUARTER
WORK-STATE
PENSION
KeyChange, Subset
WhereCOUNTRY-CODE ="US"
PR287 PR290
PR291 PR292
PR294
QTDSET5 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
EMPLOYEE
REPORT-ENTITY
BUS-NBR-GRP
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QC-ENT-NBR-GRP
Subset
WhereCOUNTRY-CODE ="CA"
AndPENSION !="Y"
PR248


QUARTDED FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
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 DDC-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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Prdeddtl PRDEDDTL
QTD-OBJ-ID->PDE-QTD-OBJ-ID
  PDE-TAX-STATUS
  PDE-PYD-OBJ-ID

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

Home
Contact Us



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