Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PREMPSTATE


                            PREMPSTATE FILE

                             Employee State

Contains information relative to specific states that is used for quarterly
reporting.

REFERENCED BY

HR170     HR211     HR70.1    PR13.1    PR292     PR296
PR297     PR298     PR299

UPDATED BY

HR16.2    HR16.3    HR16.4    HR16.5    HR16.6    HR16.7
HR16.8    HR17.1    HR17.2    HR17.3    HR17.4    HR17.5
HR17.6    HR17.7    HR17.8    HR17.9    HR18.1    HR18.2
HR18.4    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PES-COMPANY            Numeric 4                                 HR16.2  HR16.3
Element: Company Hr    Identifies the AP company if the          HR16.4  HR16.5
                       resource type = V.  Identifies the HR     HR16.6  HR16.7
                       company if the resource type = E.  It is  HR16.8  HR17.1
                       blank for type A, P or Q resources.       HR17.2  HR17.3
                                                                 HR17.4  HR17.5
                                                                 HR17.6  HR17.7
                                                                 HR17.8  HR17.9
                                                                 HR18.1  HR18.2
                                                                 HR18.4

PES-EMPLOYEE           Numeric 9                                 HR16.2  HR16.3
Element: Employee      Contains the employee number. Each        HR16.4  HR16.5
                       person employed by the company is         HR16.6  HR16.7
                       assigned a unique number. The system      HR16.8  HR17.1
                       uses the employee number to correlate     HR17.2  HR17.3
                       all of the information related to that    HR17.4  HR17.5
                       person.                                   HR17.6  HR17.7
                                                                 HR17.8  HR17.9
                                                                 HR18.1  HR18.2
                                                                 HR18.4

PES-STATE              Alpha 2                                   HR16.2  HR16.3
Element: State or ProviThis field contains the two-character     HR16.4  HR16.5
                       state code of the address.                HR16.6  HR16.7
                                                                 HR16.8  HR17.1
                                                                 HR17.2  HR17.3
                                                                 HR17.4  HR17.5
                                                                 HR17.6  HR17.7
                                                                 HR17.8  HR17.9
                                                                 HR18.1  HR18.2
                                                                 HR18.4

PES-PRIV-DIS-PLAN      Alpha 1                                   HR17.7
Element: Priv Dis Plan Contains the value that indicates if
                       the employer offers a private disability
                       plan.

PES-DIS-PLAN-NBR       Alpha 14                                  HR17.7
Element: Dis Plan Nbr  Contains the value that identifies the
                       disability plan assigned to the
                       employee.

PES-OCC-CODE           Alpha 6                                   HR16.2  HR17.5
Element: Occ Code      Contains the employee's occupational
                       code.

PES-GEO-AREA-CODE      Alpha 2                                   HR16.2  HR16.7
Element: Geo Area Code Contains the geographic area code that    HR18.1
                       identifies where the employee works.

PES-BRANCH-CODE        Alpha 3                                   HR16.3  HR16.5
Element: Branch Code   Contains the branch code that             HR16.6  HR17.1
                       identifies the location where the         HR17.2  HR17.4
                       employee works.                           HR17.8

PES-SEASONAL-CODE      Alpha 2                                   HR16.4  HR16.6
Element: Seasonal Code Contains the state-defined code that      HR17.1  HR17.6
                       indicates if the employee has in-season
                       or out-of-season wages in the quarter.

PES-WAGE-PLAN-CODE     Alpha 1                                   HR16.5  HR17.4
Element: Wage Plan CodeContains the value that identifies the    HR18.4
                       wage plan code with which the employee
                       is associated.

PES-PLANT-CODE         Alpha 15                                  HR16.8
Element: Plant Code    Contains the plant location numbers
                       used to report Illinois state
                       unemployment insurance wages.

PES-ENTITY-CODE        Numeric 2                                 HR17.3
Element: Entity Code   Contains the 2-digit code that
                       represents a location (filing entity).

PES-ESTAB-REPORT       Alpha 1
Element: Estab Report  Contains the establishment number (the
                       last digit of the employer's account
                       number) for employers reporting by this
                       method.

PES-ER-HLTH-INS        Numeric 1                                 HR17.9
Element: Er Hlth Ins   Contains the numeric value that
                       identifies the employer's health
                       insurance plan.

PES-EE-HLTH-INS        Numeric 1                                 HR17.9
Element: Ee Hlth Ins   Contains the numeric value that
                       identifies the type of health insurance
                       the employee has.

PES-UNIT-NUMBER        Numeric 5                                 HR18.2
Element: Unit Number   Contains the unit number defined for
                       the employee.

                         PREMPSTATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PESSET1   COMPANY                                                HR11.1  HR16.1
          EMPLOYEE                                               HR16.2  HR16.3
          STATE                                                  HR16.4  HR16.5
                                                                 HR16.6  HR16.7
                                                                 HR16.8  HR17.1
                                                                 HR17.2  HR17.3
                                                                 HR17.4  HR17.5
                                                                 HR17.6  HR17.7
                                                                 HR17.8  HR17.9
                                                                 HR170   HR18.1
                                                                 HR18.2  HR18.4
                                                                 HR211   HR70.1
                                                                 PA115   PR13.1
                                                                 PR292   PR296
                                                                 PR297   PR298
                                                                 ...

                         PREMPSTATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PES-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PES-COMPANY     -> EMP-COMPANY
                            PES-EMPLOYEE    -> EMP-EMPLOYEE

State          PRSTATE      Required

                            PES-STATE       -> PSA-STATE