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 HEMS.1
HEP4.1 HLTM.1 HPOS.1 HPQC.1 HPRS.1 HR02.1
HR11.1 HR11.2 HR11.4 HR15.1 HR155 HR156
HR170 HR203 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 LT111 LT13.5 PR521 ZH156 ZH500
ZH510 EXI2.1 EXI3.1 EXI4.1 LP100 LP101
LP130 LP251 LP260 LP262 LP51.1 HS00.1
HS704 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 PA228 PA230 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 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
PR12.6 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 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 PR36.4 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 PRAT.1 UK102 ZP296
TA147 TM470


UPDATED BY
HR03.1 HR51.7 PA30.1 HR00.1 HR01.1

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 HR11.4


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 02:16:07 2016

Home
Contact Us



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