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     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