Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             EMSTATUS FILE

                       Employee/Applicant Status

Contains employee and applicant statuses. Applicant statuses are created in
PA30.1 (Applicant Status) of the Lawson Personnel system. Employee statuses
are created in HR03.1 (Employee Status Codes) of the Lawson Human Resource
system. The pay status field in this file determines if an employee is paid.

REFERENCED BY

AC541     AC542     BN150     BN231     BN232     BN238
BN242     BN245     BN246     HC01.1    HC02.1    HC02.3
HCST.1    HEMS.1    HR15.1    HR155     HR170     HR203
HR211     HR213     HR217     HR220     HR511     HR54.1
HR55.2    HR650     HR70.1    HRS1.1    HRSC.1    HS00.1
PA111     PA120     PA149     PA16.1    PA201     PA211
PA212     PA214     PA215     PA216     PA217     PA218
PA219     PA220     PA221     PA222     PA224     PA225
PA230     PA231     PA232     PA233     PA234     PA235
PA236     PA238     PA239     PA241     PA242     PA243
PA244     PA249     PA272     PA290     PA295     PA296
PA300     PA305     PA31.1    PA310     PA311     PA315
PA320     PA325     PA330     PA335     PA345     PA350
PA355     PA360     PA370     PA390     PA391     PA393
PA41.1    PA42.1    PA43.1    PA43.2    PA45.1    PA48.1
PA49.1    PA49.3    PA490     PA502     PA513     PA53.1
PA531     PA532     PA54.1    PA549     PA64.1    PA64.2
PA65.1    PA65.2    PA66.3    TR22.1    TR500     PR03.1
PR128     PR13.1    PR13.5    PR13.6    PR13.8    PR131
PR132     PR134     PR135     PR136     PR139     PR14.1
PR15.2    PR195     PR205     PR283     PR296     PR30.1
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR36.1    PR39.1
PR39.2    PR530     PR82.1    PR85.1    UK102     TA170
TM470     UK120

UPDATED BY

HR03.1    PA30.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

EMS-COMPANY          Numeric 4                                   HR03.1  PA30.1
Company              The number that represents an
                     established company and is entered on
                     all functions.

EMS-EMP-STATUS       Alpha 2                                     HR03.1  PA111
Employee Status      Contains the status of the employee or      PA30.1
                     applicant.

EMS-DESCRIPTION      Alpha 30  (Lower Case)                      BN245   HR03.1
Description          Contains the status description.            PA242   PA30.1

EMS-PAY-STATUS       Alpha 2                                     HR03.1  PA30.1
Payment Status       Contains the pay status.
                     NB = No Pay - Benefits
                     NN = No Pay - No Benefits
                     PB = Pay - Benefits
                     PN = Pay - No Benefits
                     TB = Term Pay - Benefits
                     TN = Term Pay - No Benefits

EMS-EMP-APP          Numeric 1                                   PA30.1
Type                 Indicates if the status is used on
                     employee or applicant records.
                     0 = Employee Status
                     1 = Applicant Status

EMS-COUNT            Numeric 1                                   HR03.1
Count                Indicates how an employee assigned to a
                     status code should be reflected in head
                     counts and FTE counts in the Lawson
                     Personnel Administration system.

                     1 = Excluded
                     2 = Active
                     3 = Not Active

                         EMSTATUS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMSSET1   COMPANY                                                AC541   AC542
          EMP-STATUS                                             BN150   BN231
                                                                 BN232   BN238
                                                                 BN242   BN245
                                                                 BN246   HC01.1
                                                                 HC02.1  HC02.3
                                                                 HCST.1  HEMS.1
                                                                 HR00.1  HR01.1
                                                                 HR03.1  HR15.1
                                                                 HR155   HR170
                                                                 HR203   HR211
                                                                 HR213   HR217
                                                                 HR220   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 ...

                         EMSTATUS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            EMS-COMPANY    -> PRS-COMPANY
                            Spaces         -> PRS-PROCESS-LEVEL