|
|
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
BN106 BN150 BN231 BN232 BN238 BN242
BN245 BN246 BN305 BN66.1 ET530 ETI1.1
ETI2.1 ETI3.1 HC01.2 HC02.3 HC02.5 HAP3.1
HEMS.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR02.1
HR11.1 HR11.2 HR15.1 HR155 HR170 HR203
HR211 HR213 HR217 HR220 HR511 HR515
HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1 LP100
LP101 LP130 LP251 LP260 LP262 LP51.1
HS00.1 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 PA230 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 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 PR120 PR128 PR13.1
PR13.5 PR13.6 PR13.8 PR130 PR131 PR132
PR134 PR135 PR136 PR139 PR14.1 PR140
PR15.2 PR160 PR180 PR189 PR195 PR205
PR274 PR283 PR284 PR29.1 PR296 PR30.1
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR39.1 PR39.2 PR45.1 PR512 PR529 PR530
PR539 PR560 PR80.1 PR80.2 PR80.3 PR82.1
PR88.1 PR89.1 UK102 UK13.1 UK560 TA147
TA170 TM470
UPDATED BY
HR03.1 PA30.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMS-COMPANY Numeric 4 HR03.1 PA30.1
Element: Company Hr The number that represents an
established company and is entered on
all functions.
EMS-EMP-STATUS Alpha 2 HR03.1 PA111
Element: Emp Status Contains the status of the employee or PA30.1
applicant.
EMS-DESCRIPTION Alpha 30 (Lower Case) BN245 HR03.1
Element: Description Contains the status description. PA242 PA30.1
EMS-PAY-STATUS Alpha 2 HR03.1 PA30.1
Element: Pay 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
Element: Emp App Indicates if the status is used on
employee or applicant records.
0 = Employee Status
1 = Applicant Status
EMS-COUNT Numeric 1 HR03.1
Element: Count 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
EMS-ACTIVE-FLAG Alpha 1 HR03.1 PA30.1
Element: Active Flag The Active flag of the credit card
type.
A = Active
I = Inactive
EMS-USER-ID Alpha 10 (Lower Case) HR03.1 PA30.1
Element: User
EMS-DATE-STAMP Numeric 8 (yyyymmdd) HR03.1 PA30.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
EMS-TIME-STAMP Numeric 6 (hhmmss) HR03.1 PA30.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
EMS-HIPAA-EMP-CODE Alpha 2 HR03.1
Element: Hipaa Emp CodeAO = Active Military (Overseas)
AU = Active Military (US)
FT = Full-time
L1 = Leave of Absence
PT = Part-time
RT = Retired
TE = Terminated
EMSTATUS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMSSET1 COMPANY BN106 BN150
EMP-STATUS BN231 BN232
BN238 BN242
BN245 BN246
BN305 BN66.1
ET530 ETI1.1
ETI2.1 ETI3.1
HC01.2 HC02.3
HC02.5 HAP3.1
HEMS.1 HEP4.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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EMS-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
EMSTATUS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
