HRLOA

Leave of Absence (LO) Database

Seq Field Name Type Length Dec Description

1

L_ACCUM

C

1

0

Accumulate Seniority During Leave?

2

L_CHADATE

T

8

0

Last Change Date

3

L_COMPANY

C

3

0

Company Code

4

L_COVERED

C

1

0

Benefits Coverage During Leave (Y/N

5

L_DEVENT

T

8

0

Date FMLA Event Occurred

6

L_DLVEND

T

8

0

Leave End Date

7

L_DLVSTART

T

8

0

Leave Start Date

8

L_DMCERT

T

8

0

FMLA Medical Certification Date

9

L_DMRECERT

T

8

0

FMLA Medical Recertification Date

10

L_DREQUEST

T

8

0

FMLA Leave Request Date

11

L_EMPNO

C

9

0

Employee ID

12

L_EVENT

C

15

0

FMLA Event Reason Code

13

L_FMISC1

C

30

0

Leave Notes

14

L_LVDAYS

N

11

5

Time on Leave

15

L_LVPAY

T

8

0

Paid Through Date

16

L_LVREASON

C

8

0

Absence Reason Code

17

L_LVRETURN

T

8

0

Scheduled Return Date

18

L_LVTYPE

C

20

0

Leave Type

19

L_NAME

C

30

0

FMLA Family Member

20

L_RELATION

C

25

0

FMLA Relation Code

21

_EVENT

C

25

0

FMLA Event Reason Description

22

_RELATION

C

25

0

FMLA Relation Description

23

_ZFILTER

C

25

0

Filter Function