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
PR209 PR27.1 PR289 PR290 PR291 PR292
PR293 PR294 PR296 PR297 PR298 AC541
AC542 BN150 BN66.1 PR128 PR131 PR132
PR134 PR136 PR195 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR530 PR560 PR82.1 PR89.1
UK102 UK120
UPDATED BY
HR00.1 HR01.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 PR09.1 PR197
the head process level is an independent
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 PR09.1 PR197
PROCESS-LEVEL PR209 PR27.1
PR289 PR290
PR291 PR292
PR293 PR294
PR296 PR297
PR298
TXGSET2 COMPANY AC541 AC542
PROCESS-LEVEL BN150 BN66.1
HR00.1 HR01.1
PR09.1 PR128
PR131 PR132
PR134 PR136
PR195 PR197
PR27.1 PR289
PR290 PR291
PR292 PR293
PR294 PR297
PR298 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
...
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
|
