PRTAXGRP FILE
Tax Group
This file contains user-defined tax groups. Tax groups are used to group
non-federal withholding type deductions together for employees paid in
multiple taxing jurisdictions.
Time records with the same tax group are added together, and withholding
deductions associated with the tax group are updated.
REFERENCED BY
BN150 HPXG.1 HR170 HR211 HR70.1 PR128
PR131 PR132 PR134 PR136 PR137 PR140
PR150 PR195 PR199 PR30.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1
PR45.1 PR530 PR80.1 PR82.1 PR85.1 UK102
UK330 UK120
UPDATED BY
PR11.1 HR11.1 PA115 BN100 BN101 BN102
BN103 BN104 BN105 BN145 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN45.1 BN531
BN65.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 HR511 PA100 PA52.1 PA52.4 PA52.5
PR13.1 PR13.2 PR14.1 PR15.1 PR15.2 PR205
PR26.1 PR39.1 PR39.2 PR514
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXG-COMPANY Numeric 4 PR11.1
Company The company number represents an
established company and is entered on
all function codes.
PXG-EMPLOYEE Numeric 9 PR11.1
Employee 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.
PXG-TAX-GROUP Alpha 10 PR11.1
Reportable Income Contains the user-defined tax group.
Group
PXG-DED-CODE Alpha 4 PR11.1
Deduction Code Contains the employee deductions
associated with the tax group.
PXG-DEFAULT-FLAG Alpha 1 PR11.1
Default Flag Contains the value that indicates if
default withholding deductions must be
withheld for an employee that works in
multiple taxing authorities.
Y = Yes
PRTAXGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXGSET1 COMPANY BN150 HPXG.1
EMPLOYEE HR11.1 HR170
TAX-GROUP HR211 HR70.1
DED-CODE PA115 PR11.1
PR128 PR131
PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR30.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
...
PXGSET2 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
DED-CODE BN104 BN105
TAX-GROUP BN145 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
...
PRTAXGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PXG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
PXG-COMPANY -> DDC-COMPANY
PXG-DED-CODE -> DDC-DED-CODE
Emp Deduction EMDEDMASTR Required
PXG-COMPANY -> EDM-COMPANY
PXG-EMPLOYEE -> EDM-EMPLOYEE
PXG-DED-CODE -> EDM-DED-CODE
Zeroes -> EDM-SEQ-NBR
Employee EMPLOYEE Required
PXG-COMPANY -> EMP-COMPANY
PXG-EMPLOYEE -> EMP-EMPLOYEE
|