|
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 PR252 PR289 PR290
PR291 PR292 PR293 PR294 PR296 PR297
PR298 PR299 TP231 BN150 HR11.1 HR11.2
HR511 PA02.1 PA100 PA102 PA502 PA52.1
PA52.3 PA52.4 PA52.5 PR11.1 PR110 PR113
PR120 PR128 PR13.1 PR13.5 PR13.6 PR13.8
PR130 PR131 PR132 PR134 PR136 PR240
PR241 PR242 PR243 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
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR82.1 UK102 TA147 TP135
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR09.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXG-COMPANY Numeric 4 PR09.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
TXG-HEAD-PROC-LEV Alpha 5 PR09.1
Element: Head Process LContains 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
Element: Process Lev HrContains 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
Element: Process Level 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
PR252 PR289
PR290 PR291
PR292 PR293
PR294 PR296
PR297 PR298
PR299 TP231
TXGSET2 COMPANY BN150 HR00.1
PROCESS-LEVEL HR01.1 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PBIP.1 PR05.5
PR09.1 PR11.1
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
...
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
|