EMSTATUS – Employee/Applicant Status

System
Human Resources (HR)
Prefix
EMS
Primary key
COMPANY, EMP-STATUS
Fields
14
Updated by
5 programs
Referenced by
248 programs

EMSTATUS is the Employee/Applicant Status table in Lawson Human Resources (prefix EMS). It is indexed by COMPANY, EMP-STATUS (EMSSET1). It is related 1:1 to PRSYSTEM and 1:M to EMPLOYEE. It is updated by HR00.1, HR01.1, HR03.1, HR51.7 and PA30.1 and referenced by BN106, BN150, BN231, BN232, BN238, BN242, BN245, BN246 and 240 more. The table has 14 fields, 1 index and 2 documented relations.

About EMSTATUS

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.

Fields (14)

Column = COBOL field name without the EMS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
EMS-COMPANY PK
COMPANY		Numeric 4The number that represents an established company and is entered on all functions.HR03.1, HR51.7, PA30.1
EMS-EMP-STATUS PK
EMP_STATUS		Alpha 2Contains the status of the employee or applicant.HR03.1, HR51.7, PA111, PA30.1
EMS-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the status description.BN245, HR03.1, PA242, PA30.1
EMS-PAY-STATUS
PAY_STATUS		Alpha 2Contains 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
HR03.1, PA30.1
EMS-EMP-APP
EMP_APP		Numeric 1Indicates if the status is used on employee or applicant records.
  • 0 Employee Status
  • 1 Applicant Status
HR51.7, PA30.1
EMS-COUNT
COUNT		Numeric 1Select 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
HR03.1
EMS-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR03.1, PA30.1
EMS-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR03.1, PA30.1
EMS-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR03.1, PA30.1
EMS-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR03.1, PA30.1
EMS-HIPAA-EMP-CODE
HIPAA_EMP_CODE		Alpha 2—
  • AO Active Military (Overseas)
  • AU Active Military (US)
  • FT Full-time
  • L1 Leave of Absence
  • PT Part-time
  • RT Retired
  • TE Terminated
HR03.1
EMS-REL-TO-ORG
REL_TO_ORG		Alpha 20—HR51.7
EMS-REL-STATUS
REL_STATUS		Alpha 20—HR51.7
EMS-WORK-TYPE
WORK_TYPE		Alpha 20—HR51.7

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EMSSET1COMPANY, EMP-STATUSPrimaryBN106, BN150, BN231, BN232, BN238, BN242, BN245, BN246 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredEMS-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
EmployeeEMPLOYEEValid When EMS-EMP-APP = ZeroesEMS-COMPANY → EMP-COMPANY, EMS-EMP-STATUS → EMP-EMP-STATUS, → EMP-EMPLOYEE

Programs

Updated by (5)

Referenced by (248)