|
TAXIDEXMP FILE
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
BN66.1 PR140 PR189 PR195 PR220 PR262
PR80.1 PR89.1 UK13.1 UK50.3
UPDATED BY
PR05.1 PR05.2 PR20.5 PR20.2 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TID-COMPANY Numeric 4 PR05.2 PR20.5
Element: Company Hr
TID-PAY-DED-FLAG Alpha 1 PR05.2 PR20.5
Element: Pay Ded Flag 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
TID-PAY-CODE Alpha 4 PR05.2 PR20.5
Element: Pay Code 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.
TID-DED-CODE Alpha 4 PR05.2 PR20.5
Element: Ded Code Contains a deduction for both types of
records.
TID-TAXABLE-FLAG Alpha 1 PR20.5
Element: Taxable Flag 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
TAXIDEXMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TIDSET1 COMPANY BN66.1 HR00.1
PAY-DED-FLAG HR01.1 PR05.1
PAY-CODE PR05.2 PR140
DED-CODE PR189 PR195
PR20.2 PR20.5
PR220 PR262
PR80.1 PR89.1
UK13.1 UK50.3
TAXIDEXMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|