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     AC541     AC542     BN150     BN66.1
HR11.1    HR11.2    HR511     HR650     PA02.1    PA100
PA102     PA502     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     PR253     PR282     PR29.1    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR45.1    PR529     PR530
PR560     PR80.1    PR82.1    PR89.1    UK102     UK13.1
UK560     TA147     UK120

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       The company number represents an
                       established company and is entered on
                       all function codes.

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

TXGSET2   COMPANY                                                AC541   AC542
          PROCESS-LEVEL                                          BN150   BN66.1
                                                                 HR00.1  HR01.1
                                                                 HR11.1  HR11.2
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PBIP.1  PR05.5
                                                                 PR09.1  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 ...

                         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