Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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