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
BN150 BN231 BN232 BN238 BN242 BN245
BN246 HC01.1 HC02.1 HC02.3 HCST.1 HEMS.1
HR11.1 HR15.1 HR155 HR170 HR203 HR211
HR213 HR511 HR54.1 HR55.2 HR70.1 HR700
HRS1.1 HRSC.1 HS00.1 HS12.1 HS13.1 HS15.1
PA02.1 PA100 PA102 PA111 PA115 PA120
PA13.1 PA13.2 PA149 PA16.1 PA20.1 PA201
PA21.1 PA211 PA212 PA214 PA215 PA216
PA217 PA218 PA219 PA22.1 PA220 PA221
PA222 PA224 PA225 PA230 PA231 PA232
PA233 PA234 PA235 PA236 PA238 PA239
PA24.1 PA241 PA242 PA243 PA244 PA249
PA272 PA290 PA295 PA300 PA305 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 PA43.1 PA43.2 PA45.1
PA48.1 PA49.1 PA49.3 PA490 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA520 PA53.1
PA531 PA532 PA54.1 PA549 PA64.1 PA64.2
PA65.1 PA65.2 PA66.3 TR21.1 TR22.1 TR500
HS22.1 HS22.2 PR03.1 PR128 PR13.1 PR131
PR132 PR134 PR135 PR136 PR139 PR14.1
PR140 PR15.2 PR160 PR180 PR195 PR205
PR296 PR30.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR39.1 PR39.2 PR530 PR80.1 PR82.1
UK102 TA170 TM470 UK120
UPDATED BY
HR03.1 PA30.1 HR00.1 HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMS-COMPANY Numeric 4 HR03.1 PA30.1
Company The number that represents an
established company and is entered on
all functions.
EMS-EMP-STATUS Alpha 2 HR03.1 PA111
Employee Status Contains the status of the employee or PA30.1
applicant.
EMS-DESCRIPTION Alpha 30 (Lower Case) BN245 HR03.1
Description Contains the status description. PA242 PA30.1
EMS-PAY-STATUS Alpha 2 HR03.1 PA30.1
Payment 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
Type Indicates if the status is used on
employee or applicant records.
0 = Employee Status
1 = Applicant Status
EMS-COUNT Numeric 1 HR03.1
Count Indicates how an employee assigned to a
status code should be reflected in head
counts and FTE counts in the Lawson
Personnel Administration system.
1 = Excluded
2 = Active
3 = Not Active
EMSTATUS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMSSET1 COMPANY BN150 BN231
EMP-STATUS BN232 BN238
BN242 BN245
BN246 HC01.1
HC02.1 HC02.3
HCST.1 HEMS.1
HR00.1 HR01.1
HR03.1 HR11.1
HR15.1 HR155
HR170 HR203
HR211 HR213
HR511 HR54.1
HR55.2 HR70.1
HR700 HRS1.1
HRSC.1 HS00.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
|