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
PR220 PR89.1 PRTX.1
UPDATED BY
PR05.1 PR05.2 PR20.5 PR20.2 HR00.1 HR01.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TID-COMPANY Numeric 4 PR05.2 PR20.5
Company The company number represents an
established company and is entered on
all function codes.
TID-PAY-DED-FLAG Alpha 1 PR05.2 PR20.5
Pay Code or Deduct Contains the value that indicates if
Code Flag 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
Payment 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
Deduction Code Contains a deduction for both types of
records.
TID-TAXABLE-FLAG Alpha 1 PR20.5
Taxable or Contains a value that identifies how
Non-Taxable Flag 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 HR00.1 HR01.1
PAY-DED-FLAG PR05.1 PR05.2
PAY-CODE PR197 PR20.2
DED-CODE PR20.5 PR220
PR89.1 PRTX.1
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
|
