LPEMPLEAVE – Employee Leave of Absence

System: Absence Management (LP)
Prefix: LEL
Primary key: COMPANY, EMPLOYEE, SEQ-NBR
Fields: 64
Updated by: 6 programs
Referenced by: 4 programs

LPEMPLEAVE is the Employee Leave of Absence table in Lawson Absence Management (prefix LEL). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (LELSET1); alternate indexes: LELSET2, LELSET3 and LELSET4. It is related 1:1 to PRSYSTEM, INSTCTRYCD, EMPLOYEE, PCODES, PAEMPLOYEE and TAREASCLSS and 1:M to HRHISTORY. It is updated by HR11.1, HR93.9, LP09.1, LP251, LP51.1 and PA115 and referenced by HR170, HR70.1, LP151 and LP220. The table has 64 fields, 4 indexes and 8 documented relations.

About LPEMPLEAVE

No description in the Lawson data dictionary.

Fields (64)

Column = COBOL field name without the LEL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`LEL-COMPANY` PK COMPANY	Numeric 4	—	LP51.1
#`LEL-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	LP51.1
#`LEL-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	LP51.1
#`LEL-BEGIN-DATE` SET2 SET3 BEGIN_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-REQUEST-DATE` REQUEST_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-INTERMITTENT` INTERMITTENT	Numeric 1	— `0` No `1` Yes	LP51.1
#`LEL-LEAVE-REASON` SET3 LEAVE_REASON	Alpha 10	—	LP51.1
#`LEL-REASON-CLASS` SET3 REASON_CLASS	Alpha 3	—	LP51.1
#`LEL-EMP-NOTIFY-DT` EMP_NOTIFY_DT	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-EMP-RESP-DT` EMP_RESP_DT	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-MGR-NOTIFY-DT` MGR_NOTIFY_DT	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-STATUS` STATUS	Alpha 10	—	LP51.1
#`LEL-SERVICE-DATE` SERVICE_DATE	Numeric 2	— `00` Hire Date `01` Adjusted Hire Date `02` Anniversary Date `03` Seniority Date `04` First Day Worked `05` Benefit Date 1 `06` Benefit Date 2 `07` Benefit Date 3 `08` Benefit Date 4 `09` Benefit Date 5	LP51.1
#`LEL-GOVT-QUALIFY` GOVT_QUALIFY	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-ELIGIBLE-DATE` ELIGIBLE_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-STATE-QUALIFY` STATE_QUALIFY	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-ST-ELIG-DATE` ST_ELIG_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-BN-QUALIFY` BN_QUALIFY	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-BN-PAID-THRU` BN_PAID_THRU	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-PAY-STATUS` PAY_STATUS	Numeric 1	— `0` Not Determined `1` Paid `2` Partially Paid `3` Unpaid	LP51.1
#`LEL-PAY-THRU-DATE` PAY_THRU_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-DISABILITY` DISABILITY	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-DISABLE-EFFECT` DISABLE_EFFECT	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-WORKERS-COMP` WORKERS_COMP	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-EXPECT-RETURN` EXPECT_RETURN	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-RETURN-TO-WORK` RETURN_TO_WORK	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-RESTRICT-DUTY` RESTRICT_DUTY	Numeric 1	— `0` No `1` Yes	LP51.1
#`LEL-RESTRICT-THRU` RESTRICT_THRU	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-PHYS-RELEASE` PHYS_RELEASE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-CONTACT-ADDR` CONTACT_ADDR	Alpha 1	— `1` Home Address `2` Supplemental Address `3` Other	LP51.1
#`LEL-ADDR1` ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	LP51.1
#`LEL-ADDR2` ADDR2	Alpha 30 (Lower Case)	This field contains the second line of address information.	LP51.1
#`LEL-ADDR3` ADDR3	Alpha 30 (Lower Case)	This field contains the third line of address information.	LP51.1
#`LEL-CITY` CITY	Alpha 58 (Lower Case)	This field contains the city of the address.	LP51.1
#`LEL-STATE-OR-PROV` STATE_OR_PROV	Alpha 2	This field contains the two-character state code of the address.	LP51.1
#`LEL-POSTAL-CODE` POSTAL_CODE	Alpha 10	This field contains the postal code of the address.	LP51.1
#`LEL-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	LP51.1
#`LEL-PHONE-CNTRY` PHONE_CNTRY	Alpha 6	—	LP51.1
#`LEL-PHONE-NBR` PHONE_NBR	Alpha 15	—	LP51.1
#`LEL-LOA-DATE-1` LOA_DATE_1	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-LOA-DATE-2` LOA_DATE_2	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-LOA-DATE-3` LOA_DATE_3	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-LOA-DATE-4` LOA_DATE_4	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-LOA-DATE-5` LOA_DATE_5	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-CREATE-DATE` SET4 CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP51.1
#`LEL-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP51.1
#`LEL-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	LP51.1
#`LEL-DATE-STAMP` SET4 DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP51.1
#`LEL-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP51.1
#`LEL-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP51.1
#`LEL-EE-GOVT-QUAL` EE_GOVT_QUAL	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-EE-STATE-QUAL` EE_STATE_QUAL	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-COMP-QUALIFY` COMP_QUALIFY	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-EE-COMP-QUAL` EE_COMP_QUAL	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-COMP-ELIG-DATE` COMP_ELIG_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-LEAVE-END-DATE` LEAVE_END_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-ST-LV-END-DATE` ST_LV_END_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-CO-LV-END-DATE` CO_LV_END_DATE	Numeric 8 (yyyymmdd)	—	LP51.1
#`LEL-HRH-OBJ-ID` HRH_OBJ_ID	Numeric 12	—	LP51.1
#`LEL-USE-WORK-EMAIL` USE_WORK_EMAIL	Numeric 1	— `0` Not Determined `1` No `2` Yes	LP51.1
#`LEL-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	—	LP51.1
#`LEL-MEMO` MEMO	Alpha 60 (Lower Case)	—	LP51.1
#`LEL-ACTION-CODE` ACTION_CODE	Alpha 10	—	LP51.1

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`LELSET1`	`COMPANY` `EMPLOYEE` `SEQ-NBR`	Primary	HR11.1, HR170, HR70.1, HR93.9, LP09.1, LP220, LP251, LP51.1 +1 more
`LELSET2`	`COMPANY` `EMPLOYEE` `BEGIN-DATE` `SEQ-NBR`	KeyChange	LP251
`LELSET3`	`COMPANY` `REASON-CLASS` `LEAVE-REASON` `EMPLOYEE` `BEGIN-DATE` `SEQ-NBR`	KeyChange	LP151
`LELSET4`	`COMPANY` `CREATE-DATE` ↓ `DATE-STAMP` ↓ `EMPLOYEE` `SEQ-NBR`	KeyChange	—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (7) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`LEL-COMPANY`	→	`PRS-COMPANY (PRSSET1)`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Country Code

INSTCTRYCD

Required

When LEL-COUNTRY-CODE != Spaces

LEL-COUNTRY-CODE → INT-COUNTRY-CODE

Employee

EMPLOYEE

Required

`LEL-COMPANY`	→	`EMP-COMPANY`
`LEL-EMPLOYEE`	→	`EMP-EMPLOYEE`

Leave Reason

PCODES

Required

When LEL-LEAVE-REASON != Spaces

`"LR"`	→	`PCO-TYPE`
`LEL-LEAVE-REASON`	→	`PCO-CODE`

Leave Status

PCODES

Required

When (LEL-STATUS != Spaces)

`"LS"`	→	`PCO-TYPE`
`LEL-STATUS`	→	`PCO-CODE`

Paemployee

PAEMPLOYEE

Required

`LEL-COMPANY`	→	`PEM-COMPANY`
`LEL-EMPLOYEE`	→	`PEM-EMPLOYEE`

Reason Class

TAREASCLSS

Required

When (LEL-REASON-CLASS != Spaces)

`LEL-COMPANY`	→	`TRL-COMPANY`
`LEL-REASON-CLASS`	→	`TRL-REASON-CLASS`

One to many (1) — child tables

Relation Table Rules Condition Field map

Hrhistory

HRHISTORY

Delete Cascades

Valid When LEL-HRH-OBJ-ID != Zeroes

`LEL-COMPANY`	→	`HRH-COMPANY`
`LEL-EMPLOYEE`	→	`HRH-EMPLOYEE`
`LEL-HRH-OBJ-ID`	→	`HRH-OBJ-ID`
—	→	`HRH-FLD-NBR`
—	→	`HRH-POS-LEVEL`
—	→	`HRH-BEG-DATE`
—	→	`HRH-SEQ-NBR`

Programs

Updated by (6)

HR11.1 Employee
HR93.9 Employee Leave of Absence Audit Inquiry
LP09.1 Reason Class
LP251 Employee Leave of Absence Report
LP51.1 Employee Leave of Absence
PA115 Employee Purge

Referenced by (4)

HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
LP151 FMLA Rolling 12 Month Update
LP220 Employee Absence Plan or Leave History Report

LPEMPLEAVE – Employee Leave of Absence

About LPEMPLEAVE

Fields (64) Copy as SQL

Indexes (4)

Relations

One to one (7) — lookups and parents

One to many (1) — child tables

Programs

Updated by (6)

Referenced by (4)

Fields (64)