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 BN66.1 PR140 PR195 PR560 PR80.1 PR89.1 UPDATED BY HR00.1 HR01.1 PBIP.1 PR09.1 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. TAXGROUP FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN TXGSET1 COMPANY HR00.1 HR01.1 HEAD-PROC-LEV PBIP.1 PR09.1 PROCESS-LEVEL PR209 PR27.1 PR289 PR290 PR291 PR292 PR293 PR294 PR296 PR297 PR298 TXGSET2 COMPANY BN66.1 HR00.1 PROCESS-LEVEL HR01.1 PBIP.1 PR09.1 PR140 PR195 PR27.1 PR289 PR290 PR291 PR292 PR293 PR294 PR297 PR298 PR560 PR80.1 PR89.1 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 |