TAXGROUP FILE
Payroll Tax Reporting Group
The Payroll Tax Reporting Group serves as both the header and detail file for
tax reporting groups. Tax reporting groups are used for quarterly and W-2
reporting and payment taxation processing. When the system generates W-2s or
quarterly reports, it uses information from the head process level, such as
name, address, and tax ID, instead of the company information.
For payment taxation processing, the system checks for a link to a head
process level if the employee's home process level is not to be treated
independently for tax reporting (Independent field value = N). If the system
finds a head process level, the head process level determines the tax
authority and tax company used for the employee's payment taxation processing.
If the system does not find a head process level, all taxation processing
takes place at the company level.
REFERENCED BY
PR05.5 PR209 PR227 PR240 PR241 PR242
PR243 PR244 PR245 PR248 PR252 PR289
PR290 PR291 PR292 PR293 PR294 PR296
PR297 PR298 PR299 AC541 AC542 BN150
BN66.1 HR11.1 HR11.2 HR511 HR650 PA02.1
PA100 PA102 PA502 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR120 PR128 PR13.1
PR13.5 PR13.6 PR13.8 PR130 PR131 PR132
PR134 PR136 PR140 PR189 PR195 PR250
PR251 PR253 PR282 PR29.1 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 PR89.1 UK102 TA147
UK120
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR09.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXG-COMPANY Numeric 4 PR09.1
Company The company number represents an
established company and is entered on
all function codes.
TXG-HEAD-PROC-LEV Alpha 5 PR09.1
Head Process Level Contains the process level that is
defined as a head process level. A
federal taxing authority for this
process level must exist in the Taxing
Authority Code Header file.
TXG-PROCESS-LEVEL Alpha 5 PR09.1
Process Level Contains the process level. When a
record in this file is created as the
header record for the head process
level, this value is the same as the
value in the Head Process Level field.
TXG-PL-OPTION Alpha 1 HR00.1 HR01.1
Process Level Option Contains the value that represents if PBIP.1 PR09.1
the head process level is an independent PR197
process level or not.
N = No ; Not Independent
Y = Yes; Independent
" " = No ; Not Independent
TAXGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXGSET1 COMPANY HR00.1 HR01.1
HEAD-PROC-LEV PBIP.1 PR05.5
PROCESS-LEVEL PR09.1 PR197
PR209 PR227
PR240 PR241
PR242 PR243
PR244 PR245
PR248 PR252
PR289 PR290
PR291 PR292
PR293 PR294
PR296 PR297
PR298 PR299
TXGSET2 COMPANY AC541 AC542
PROCESS-LEVEL BN150 BN66.1
HR00.1 HR01.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PBIP.1 PR05.5
PR09.1 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
...
TAXGROUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TXG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Head Proc Lev PRSYSTEM Required
TXG-COMPANY -> PRS-COMPANY
TXG-HEAD-PROC-LEV -> PRS-PROCESS-LEVEL
Process Level PRSYSTEM Required
When TXG-PROCESS-LEVEL != Spaces
TXG-COMPANY -> PRS-COMPANY
TXG-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
|
