Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMSTATUS


                             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

BN106     BN150     BN231     BN232     BN238     BN242
BN245     BN246     BN305     BN66.1    ET530     ETI1.1
ETI2.1    ETI3.1    HC01.2    HC02.3    HC02.5    HAP3.1
HEMS.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1    HR02.1
HR11.1    HR11.2    HR15.1    HR155     HR170     HR203
HR211     HR213     HR217     HR220     HR511     HR515
HR54.1    HR55.2    HR70.1    HRS1.1    HRSC.1    LP100
LP101     LP130     LP251     LP260     LP262     LP51.1
HS00.1    PA02.1    PA100     PA102     PA111     PA113
PA115     PA120     PA13.1    PA13.2    PA149     PA16.1
PA182     PA20.1    PA201     PA21.1    PA210     PA211
PA212     PA214     PA215     PA216     PA217     PA218
PA219     PA22.1    PA220     PA221     PA222     PA224
PA225     PA227     PA230     PA231     PA232     PA233
PA234     PA235     PA236     PA238     PA239     PA24.1
PA241     PA242     PA243     PA244     PA249     PA27.1
PA272     PA290     PA295     PA296     PA31.1    PA310
PA311     PA315     PA320     PA325     PA330     PA335
PA34.1    PA345     PA35.1    PA350     PA355     PA36.1
PA360     PA370     PA38.1    PA390     PA391     PA393
PA41.1    PA42.1    PA42.3    PA43.1    PA43.2    PA45.1
PA48.1    PA49.1    PA49.3    PA496     PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA520     PA53.1
PA531     PA532     PA534     PA535     PA54.1    PA549
PA594     PA64.1    PA64.2    PA65.1    PA65.2    PA66.3
TR21.1    TR22.1    TR26.1    TR500     PR03.1    PR110
PR113     PR12.1    PR12.3    PR120     PR128     PR13.1
PR13.5    PR13.6    PR13.8    PR130     PR131     PR132
PR134     PR135     PR136     PR139     PR14.1    PR140
PR15.2    PR160     PR180     PR189     PR195     PR205
PR274     PR283     PR284     PR29.1    PR296     PR30.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
PR39.1    PR39.2    PR45.1    PR512     PR529     PR530
PR539     PR560     PR80.1    PR80.2    PR80.3    PR82.1
PR88.1    PR89.1    UK102     UK13.1    UK560     TA147
TA170     TM470

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

EMS-PAY-STATUS         Alpha 2                                   HR03.1  PA30.1
Element: Pay 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
Element: Emp App       Indicates if the status is used on
                       employee or applicant records.
                       0 = Employee Status
                       1 = Applicant Status

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

                       1 = Excluded
                       2 = Active
                       3 = Not Active

EMS-ACTIVE-FLAG        Alpha 1                                   HR03.1  PA30.1
Element: Active Flag   The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

EMS-USER-ID            Alpha 10  (Lower Case)                    HR03.1  PA30.1
Element: User

EMS-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR03.1  PA30.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

EMS-TIME-STAMP         Numeric 6  (hhmmss)                       HR03.1  PA30.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

EMS-HIPAA-EMP-CODE     Alpha 2                                   HR03.1
Element: Hipaa Emp CodeAO = Active Military (Overseas)
                       AU = Active Military (US)
                       FT = Full-time
                       L1 = Leave of Absence
                       PT = Part-time
                       RT = Retired
                       TE = Terminated

                         EMSTATUS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMSSET1   COMPANY                                                BN106   BN150
          EMP-STATUS                                             BN231   BN232
                                                                 BN238   BN242
                                                                 BN245   BN246
                                                                 BN305   BN66.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  ETI3.1
                                                                 HC01.2  HC02.3
                                                                 HC02.5  HAP3.1
                                                                 HEMS.1  HEP4.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR00.1
                                                                 HR01.1  HR02.1
                                                                 HR03.1  HR11.1
                                                                 HR11.2  HR15.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

                         EMSTATUS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE
                            Valid When EMS-EMP-APP = Zeroes

                            EMS-COMPANY       -> EMP-COMPANY
                            EMS-EMP-STATUS    -> EMP-EMP-STATUS
                                                 EMP-EMPLOYEE