EMSTATUS

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 BN149 BN150 BN231 BN232 BN238
BN242 BN245 BN246 BN305 BN66.1 HC01.2
HC02.3 HC02.5 HAP3.1 HCRE.1 HEP4.1 HLTM.1
HPOS.1 HPQC.1 HPRS.1 HR02.1 HR11.1 HR11.2
HR15.1 HR155 HR156 HR170 HR211 HR213
HR217 HR220 HR511 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 HS703 PR521 XH700
XH777 EXI2.1 EXI3.1 EXI4.1 LP100 LP101
LP130 LP140 LP251 LP260 LP262 LP51.1
HS00.1 HS704 PA02.1 PA100 PA102 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 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 PA392 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 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 PR13.9 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR139 PR14.1
PR140 PR15.2 PR160 PR180 PR189 PR195
PR205 PR271 PR274 PR283 PR284 PR29.1
PR296 PR30.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR37.1 PR39.1
PR39.2 PR45.1 PR512 PR529 PR530 PR539
PR560 PR582 PR80.1 PR80.2 PR80.3 PR80.4
PR82.1 PR88.1 PR89.1 UK102 UK13.1 UK560
TA147 TA170 TM470


UPDATED BY
HR03.1 HR51.7 PA30.1 HEMS.1 HR00.1 HR01.1
HR203 PA111 PA230 PA532

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMS-COMPANY
Element: Company Hr
Numeric 4
The number that represents an established company and is entered on all functions.
HR03.1 HR51.7
PA30.1
EMS-EMP-STATUS
Element: Emp Status
Alpha 2
Contains the status of the employee or applicant.
HR03.1 HR51.7
PA111 PA30.1
EMS-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the status description.
BN245 HR03.1
PA242 PA30.1
XH700 XH777
EMS-PAY-STATUS
Element: Pay Status
Alpha 2
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
HR03.1 PA30.1
EMS-EMP-APP
Element: Emp App
Numeric 1
Indicates if the status is used on employee or applicant records.
0 = Employee Status
1 = Applicant Status
HR51.7 PA30.1
EMS-COUNT
Element: Count
Numeric 1
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
HR03.1
EMS-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR03.1 PA30.1
EMS-USER-ID
Element: User
Alpha 10 (Lower Case)
HR03.1 PA30.1
EMS-DATE-STAMP
Element: 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
Element: 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
Element: 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
Element: Alpha 20
Alpha 20
HR51.7
EMS-REL-STATUS
Element: Alpha 20
Alpha 20
HR51.7
EMS-WORK-TYPE
Element: Alpha 20
Alpha 20
HR51.7


EMSTATUS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMSSET1 COMPANY
EMP-STATUS
...
BN106 BN149
BN150 BN231
BN232 BN238
BN242 BN245
BN246 BN305
BN66.1 HC01.2
HC02.3 HC02.5
HAP3.1 HCRE.1
HEMS.1 HEP4.1
HLTM.1 HPOS.1
HPQC.1 HPRS.1
HR00.1 HR01.1
HR02.1 HR03.1
HR11.1 HR11.2
HR15.1 HR155


EMSTATUS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EMS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


EMSTATUS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:49:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.