GPAU_ABSRET_CAL

#	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	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	GPAU_ADV_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be advanced within a Calendar Period.
10	GPAU_ADV_TO_DT	Date(10)	DATE	This is the end date of the period that is to be advanced within a Calendar Period.
11	GPAU_SKP_FROM_DT	Date(10)	DATE	This is the start date of the period that is to be skipped (not paid) within a Calendar Period.
12	GPAU_SKP_TO_DT	Date(10)	DATE	This is the end date of the period that is to be skipped (not paid) within a Calendar Period.
13	GPAU_ORIG_RUNID	Character(18)	VARCHAR2(18) NOT NULL	When an absence is to be paid in advance, this identifies the Calendar Group in which a Calendar would normally have been included.
14	GPAU_ORIG_PYMTDT	Date(10)	DATE	This is the Payment Date that the Calendar would normally paid on if it were not paid in advance.
15	GPAU_ORIG_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Original Calendar Period ID. Used in Australian Absence Advance to recors the Period in which the payment was originally die to be paid.
16	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
17	GPAU_ADV_SPLIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether the calendar is being split up or not. P=Part of Period Advanced S=Split Period, both advanced W=Whole Period Advanced