GPNL_EA_REQUEST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 1
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
7	GP_ABS_SEC_VAL_FLG	Date(10)	DATE	Section Validation Flag
8	GPNL_ABS_HOURS	Number(5,2)	DECIMAL(4,2) NOT NULL	Number of Leave Hours
9	GPNL_CHILD_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name of Child
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	MONDAY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Monday Y/N Table Edit Default Value: N
12	TUESDAY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Tuesday Y/N Table Edit Default Value: N
13	WEDNESDAY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Wednesday Y/N Table Edit Default Value: N
14	THURSDAY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Thursday Y/N Table Edit Default Value: N
15	FRIDAY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Friday Y/N Table Edit Default Value: N
16	GPNL_ELIG_RQST	Character(1)	VARCHAR2(1) NOT NULL	The request for leave has been submitted at least 2 month prior to the leave, for the employee to be eligible for parental leave. Y/N Table Edit Default Value: N
17	GPNL_ELIG_EMPL	Character(1)	VARCHAR2(1) NOT NULL	An employee has to be employed for at least 1 year to be eligible for parental leave. Y/N Table Edit Default Value: N
18	GPNL_ELIG_CHILD	Character(1)	VARCHAR2(1) NOT NULL	An employee's child should be younger than 8 years old for the employee to be eligible for parental leave. Y/N Table Edit Default Value: N
19	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
20	LAST_UPDT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Updated User Name