GPMX_MASABS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	DELETE_DATA	Character(1)	VARCHAR2(1) NOT NULL	Clear Data in Temp Table
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
6	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason 10=Vacations
7	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
8	ABS_END_DT	Date(10)	DATE	Absence End Date
9	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_TBL
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
12	GPMX_DATE	Date(10)	DATE	Date - Mexico Default Value: %date
13	FCST_DTTM	DateTime(26)	TIMESTAMP	This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.
14	DATE1	Date(10)	DATE	Date 1
15	ABS_EVT_FCST_VAL	Character(30)	VARCHAR2(30) NOT NULL	This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
16	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
17	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
19	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
20	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
21	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
22	COMMENTS	Long Character	CLOB	Comment