GPES_ABSEVT_AD

#	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 Rcd Nbr
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE NOT NULL	end date
6	GPES_SICK_DATE	Date(10)	DATE	Date to Sick note
7	GPES_PHYSICIAN_ID	Character(6)	VARCHAR2(6) NOT NULL	Physician ID
8	GPES_AREA_ID_CODE	Character(11)	VARCHAR2(11) NOT NULL	Area Identifier Code
9	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
10	CONTRIB_DAYS_ESP	Number(3,0)	SMALLINT NOT NULL	Contribution Days Default Value: 0
11	CONTRIB_BASE_ESP	Number(19,6)	DECIMAL(18,6) NOT NULL	Common Contingency Base Default Value: 0
12	CONTRIB_OVER_ESP	Number(19,6)	DECIMAL(18,6) NOT NULL	Contribution Overtime
13	GPES_SUBSIDY_BASE	Number(19,6)	DECIMAL(18,6) NOT NULL	Subsidy base
14	GPES_LACKING_IND	Character(1)	VARCHAR2(1) NOT NULL	Lacking Period Indicator N=Regular Benefit Y=No Benefit Default Value: N
15	GPES_CHILD_NUM	Number(3,0)	SMALLINT NOT NULL	Number of children in the event of multiple births of adoption or foster care of more than one minor simultaneously. Default Value: 0
16	GPES_DAYS_BSE_OVRD	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if contribution days and contribution bases (common contingencies and overtime) are overriden. Its possible values are Y or N. F=FDI Only N=No Y=Yes Default Value: N