TAXIDEXMP

Pay/Deduction Exemption Code

The Pay/Deduction Exemption Code file contains two types of records. PR05.2 (Taxable Wages Table) creates type D records that represent withholding deductions whose taxable wage is to be reduced by the amount of a designated deduction. PR20.5 (Withholding Exemptions) creates type P records that represent withholding deductions that are not to be used in calculating taxes for a designated pay code.

REFERENCED BY
PR262 UK13.1 UK50.3


UPDATED BY
BN66.1 HR00.1 HR01.1 PR05.1 PR05.2 PR140
PR189 PR195 PR20.2 PR20.5 PR220 PR80.1
PR80.4 PR89.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TID-COMPANY
Element: Company Hr
Numeric 4
PR05.2 PR20.5
TID-PAY-DED-FLAG
Element: Pay Ded Flag
Alpha 1
Contains the value that indicates if the record is a type D (created by PR05.2 - Taxable Wages Table) or a type P (created by PR20.5 - Withholding Exemptions).
D = Deduction Code
P = Pay Summary Group
PR05.2 PR20.5
TID-PAY-CODE
Element: Pay Code
Alpha 4
For type D (created by PR05.2 - Taxable Wages Table) records, this field contains a deduction. For type P (created by PR20.5 - Withholding Exemptions) records, this field contains a pay code.
PR05.2 PR20.5
TID-DED-CODE
Element: Ded Code
Alpha 4
Contains a deduction for both types of records.
PR05.2 PR20.5
TID-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
Contains a value that identifies how the deduction is treated. The system uses this field only with type P records. If the value in this field is E (Exempt), the deduction entered is exempt from the pay code amount. If the value in this field is T (Taxable Wages only), the taxable wages associated with the deduction entered are updated by the amount of the pay code. The tax amount for the deduction is not withheld.
T = Update Taxable Only
E = Exempt from Taxation
PR20.5
TID-DED-TAXABLE
Element: Taxable Flag
Alpha 1


TAXIDEXMP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TIDSET1 COMPANY
PAY-DED-FLAG
PAY-CODE
DED-CODE
BN66.1 HR00.1
HR01.1 PR05.1
PR05.2 PR140
PR189 PR195
PR20.2 PR20.5
PR220 PR262
PR80.1 PR80.4
PR89.1 UK13.1
UK50.3


TAXIDEXMP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TID-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Ded Code DEDCODE Required
When TID-PAY-DED-FLAG ="D"
TID-COMPANY->DDC-COMPANY
TID-PAY-CODE->DDC-DED-CODE
Deduction DEDCODE Required
TID-COMPANY->DDC-COMPANY
TID-DED-CODE->DDC-DED-CODE
Pay Sum Grp PAYSUMGRP Required
When TID-PAY-DED-FLAG ="P"
TID-COMPANY->PSG-COMPANY
TID-PAY-CODE->PSG-PAY-SUM-GRP


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

Home
Contact Us



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