Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAXGROUP


                             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     PR253     PR289
PR290     PR291     PR292     PR293     PR294     PR296
PR297     PR299     BN150     BN305     BN66.1    ET530
ETI2.1    HR11.1    HR11.2    HR511     LP130     PA02.1
PA100     PA102     PA115     PA13.1    PA13.2    PA502
PA513     PA52.1    PA52.3    PA52.4    PA52.5    PR11.1
PR11.2    PR110     PR113     PR120     PR128     PR13.1
PR13.5    PR13.6    PR13.8    PR130     PR131     PR132
PR134     PR136     PR140     PR189     PR195     PR226
PR240     PR241     PR242     PR243     PR250     PR251
PR282     PR287     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     PR80.1    PR82.1    PR89.1    UK102     UK13.1
UK560     TA147

UPDATED BY

HR00.1    HR01.1    PR09.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXG-COMPANY            Numeric 4                                 PR09.1
Element: Company Hr

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: Pl Option     Contains the value that represents if     PR09.1
                       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                                          PR05.5  PR09.1
          PROCESS-LEVEL                                          PR209   PR227
                                                                 PR252   PR253
                                                                 PR289   PR290
                                                                 PR291   PR292
                                                                 PR293   PR294
                                                                 PR296   PR297
                                                                 PR299

TXGSET2   COMPANY                                                BN150   BN305
          PROCESS-LEVEL                                          BN66.1  ET530
                                                                 ETI2.1  HR00.1
                                                                 HR01.1  HR11.1
                                                                 HR11.2  HR511
                                                                 LP130   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR05.5
                                                                 PR09.1  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 ...

                         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