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 BN150 BN231 BN232 BN238 BN242
BN245 BN246 BN305 BN66.1 ZB01.1 ZB10.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 HR228 HR28.1 HR511
HR515 HR52.2 HR54.1 HR55.2 HR70.1 HRS1.1
HRSC.1 HS703 LT101 LT11.5 PR521 ZH156
ZH510 EXI2.1 EXI3.1 EXI4.1 LP100 LP101
LP130 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 PA228 PA231 PA232 PA233 PA234
PA235 PA236 PA238 PA239 PA24.1 PA241
PA242 PA243 PA244 PA249 PA27.1 PA272
PA28.1 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 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 ZE521 ZE531 ZE540
PR03.1 PR110 PR113 PR12.1 PR12.3 PR12.6
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
PR30.2 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 ZP296
ZP530 TA147 TA170 TM470 HEMS.1 HR203
PA230 PA48.1


UPDATED BY
HR00.1 HR01.1 HR03.1 HR51.7 ZH500 PA111
PA30.1 PA532 WA01.1 WA01.2

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
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
Select 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 BN150
BN231 BN232
BN238 BN242
BN245 BN246
BN305 BN66.1
ZB01.1 ZB10.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


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: Thu Jun 09 11:14:49 2016

Home
Contact Us



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