GPAU_ABSEVT_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
7	END_DT	Date(10)	DATE NOT NULL	end date
8	GPAU_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events. Prompt Table: GPAU_ADVTYP_VW
9	GPAU_ADV_BGN_DT	Date(10)	DATE	The Begin Date used when calculating an Advance for an Absence. This is normally the same as the Begin Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
10	GPAU_ADV_END_DT	Date(10)	DATE	The End Date used when calculating an Advance for an Absence. This is normally the same as the End Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
11	GPAU_ADV_CAL_RUNID	Character(18)	VARCHAR2(18) NOT NULL	This is the Calendar Group ID in which Advance Payments are to be included for an Absence Event. Prompt Table: GPAU_ADVCAL_VW
12	GPAU_ADV_PYMTDT	Date(10)	DATE	This is the date on which the Advance Payment is to be made. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid in advance.
13	GPAU_ADV_PRD	Character(10)	VARCHAR2(10) NOT NULL	This identifies the Calendar Period to which the Advance Payment is to be attributed. Prompt Table: GP_CAL_PRD
14	GPAU_RET_CAL_RUNID	Character(18)	VARCHAR2(18) NOT NULL	This is the Calendar Group ID in which payments are to be made on return from an absence that is paid in advance. Prompt Table: GPAU_ADVCAL_VW
15	GPAU_RET_PYMTDT	Date(10)	DATE	This is the date on which the 'On Return' Payments are to be made for an Absence that is paid in advance. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid on return.
16	GPAU_RET_PRD	Character(10)	VARCHAR2(10) NOT NULL	This identifies the Calendar Period to which 'On Return' Payments are to be attributed for an Absence paid in advance. Prompt Table: GP_CAL_PRD
17	GPAU_START_SEG_SW	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether a Segmentation Trigger is required at the end of an Absence Event or not. A trigger is required if only the absence part of the last period is to be calculated in advance.
18	GPAU_END_SEG_SW	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether a Segmentation Trigger is required at the start of an Absence Event or not. A trigger is required if only the absence part of the first period is to be calculated in advance.
19	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table