FMLA_LV_HISTORY(SQL Table) |
Index Back |
|---|---|
FMLA Leave HistoryThe FMLA LEAVE HISTORY record is used to record leave taken against an FMLA Leave request. The table can be initially loaded with scheduled leave from a posting calendar, and then subsequently maintained to reflect actual leave taken. This table presents a week-at-a-glance, containing a daily record of hours taken. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | FMLA_REQUEST_ID |
Character(3) | VARCHAR2(3) NOT NULL |
FMLA Request ID
Default Value: NEW Prompt Table: FMLA_LV_REQUEST |
| 3 | WEEK_BEGIN_DT |
Date(10) | DATE NOT NULL | Week Begin Dt |
| 4 | SUN_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Sunday |
| 5 | SUN_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 6 | MON_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Monday |
| 7 | MON_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 8 | TUES_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Tuesday |
| 9 | TUES_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 10 | WED_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Wednesday |
| 11 | WED_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 12 | THURS_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Thursday |
| 13 | THURS_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 14 | FRI_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Friday |
| 15 | FRI_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |
| 16 | SAT_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Saturday |
| 17 | SAT_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid
Y/N Table Edit Default Value: N |