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 |