FMLA_LV_ACTVTY (SQL Table)	Index Back
FMLA Leave Request Activity FMLA LEAVE HISTORY is used to record all administrative activity against an FMLA protected leave (or request for such leave). Such activity would include communications with the employee, the sending and receipt of notices and other documentation, requests for extension, etc. Each activity record has an associated Follow-up flag which can be used as a "tickler." All entry into this table is optional, and this is the only tale which remains open for entry after a leave is completed.

FMLA_LV_ACTVTY

(SQL Table)

FMLA Leave Request Activity

FMLA LEAVE HISTORY is used to record all administrative activity against an FMLA protected leave (or request for such leave). Such activity would include communications with the employee, the sending and receipt of notices and other documentation, requests for extension, etc. Each activity record has an associated Follow-up flag which can be used as a "tickler." All entry into this table is optional, and this is the only tale which remains open for entry after a leave is completed.

Parent record: FMLA_LV_REQUEST

# 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 ACTIVITY_DT Date(10) DATE NOT NULL Activity Date
Default Value: %DATE

4 FMLA_ACTIVITY_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
2MRQ=Second Medical Opinion Reqst
CMNT=General Comment
EEIN=Inquiry By Employee
EXTN=Extension of Leave Requested
MREQ=Medical Certification Request
NOLS=Notice of Leave Sent

5 FOLLOW_UP_FLAG Character(1) VARCHAR2(1) NOT NULL Follow up Required Flag
N=
Y=Follow Up
Default Value: N

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

#	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	ACTIVITY_DT	Date(10)	DATE NOT NULL	Activity Date Default Value: %DATE
4	FMLA_ACTIVITY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Activity Type 2MRQ=Second Medical Opinion Reqst CMNT=General Comment EEIN=Inquiry By Employee EXTN=Extension of Leave Requested MREQ=Medical Certification Request NOLS=Notice of Leave Sent
5	FOLLOW_UP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Follow up Required Flag N= Y=Follow Up Default Value: N
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254