| # |
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
|
| 3 |
REQUEST_DT |
Date(10) |
DATE NOT NULL |
Request Date
Default Value: %DATE
|
| 4 |
BEGIN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
|
| 5 |
RETURN_DT |
Date(10) |
DATE NOT NULL |
Return Date
|
| 6 |
LEAVE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Status
A=Actual/Completed
E=Expected/Open
Default Value: E
|
| 7 |
FMLA_LEAVE_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Leave Reason
BA=Birth or Adoption
CC=Care of Child
CP=Care of Parent
CS=Care of Spouse
EI=Employee Illness
|
| 8 |
FMLA_LEAVE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of FMLA Leave
C=Continuous
I=Intermittent
R=Irregular Intermittent
Default Value: C
|
| 9 |
TIME_RQSTD |
Number(4,0) |
SMALLINT NOT NULL |
Time Requested
|
| 10 |
TIME_RQSTD_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Requested (Units)
D=Days
H=Hours
W=Weeks
Default Value: D
|
| 11 |
FMLA_PLAN_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Family Medical Leave Plan ID
Prompt Table:
FMLA_PLAN_TBL
|
| 12 |
FMLA_YEAR_BEGIN_DT |
Date(10) |
DATE |
FMLA Year Begin Date
|
| 13 |
JOB_EFFDT |
Date(10) |
DATE |
Job Effective Date
|
| 14 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 15 |
STD_HOURS_OVRD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Stnd Hours Override
|
| 16 |
FMLA_ELIG_CALC_DT |
Date(10) |
DATE |
Date of Last Determination
|
| 17 |
FMLA_ELIG_HRS |
Number(4,0) |
SMALLINT NOT NULL |
FMLA Eligible Hours
|
| 18 |
FMLA_HRS_PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Hours Eligibility
Y/N Table Edit
Default Value: N
|
| 19 |
FMLA_ELIG_SVC_WKS |
Number(4,0) |
SMALLINT NOT NULL |
FMLA Eligible Serv Weeks
|
| 20 |
FMLA_SVC_PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Service Eligibility
Y/N Table Edit
Default Value: N
|
| 21 |
BEGIN_FMLA_WEEKS |
Signed Number(5,1) |
DECIMAL(3,1) NOT NULL |
FMLA Entitlement (As of Begin)
|
| 22 |
RETURN_FMLA_WEEKS |
Signed Number(5,1) |
DECIMAL(3,1) NOT NULL |
FMLA Entitlement (As Of End)
|
| 23 |
FMLA_LV_APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
D=Denied
O=Open
Default Value: O
|
| 24 |
APPROVER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver Empl ID
|
| 25 |
APPRVL_DT |
Date(10) |
DATE |
Approval Date
|
| 26 |
REASON_DENIED |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason Denied
IH=Insufficient Earned Hours
IL=Insufficient Leave Remaining
IS=Insufficient Service
MC=No Medical Certification
NR=Not a Covered Reason
OP=Second Opinion NonSupportive
|
| 27 |
LEAVE_CANCELLED_DT |
Date(10) |
DATE |
Leave Canceled On
|