HGA_EVENTDTL_VW

#	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	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	end date
6	ORIG_BEGIN_DT	Date(10)	DATE	original begin date Default Value: GP_ABS_EVENT.BGN_DT
7	ABS_ENTRY_SRC	Character(1)	VARCHAR2(1) NOT NULL	Absence Entry Source 1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration Default Value: 1
8	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
9	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator Y/N Table Edit Default Value: N
10	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: %GP_EDIT_FLD1
11	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
12	BEGIN_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	indicates whether first day of an absence event began counts as half a day Y/N Table Edit Default Value: N
13	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
14	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
15	ALL_DAYS_IND	Character(1)	VARCHAR2(1) NOT NULL	All Days Indicator N=Apply To Begin Day Only Y=Apply To All Days Default Value: N
16	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
17	END_TIME	Time(15)	TIMESTAMP	Interview End Time
18	START_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing Start Time of Absence Take
19	END_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing End Time of Absence Take
20	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
21	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
22	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
23	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
24	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table
25	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
26	PROCESS_DT	Date(10)	DATE	Process Date
27	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.
28	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.
29	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
30	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
31	DURATION_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration Hrs
32	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
33	DURATION_DAYS	Number(8,3)	DECIMAL(7,3) NOT NULL	Duration (Days)
34	ACTION_DT_SS	Date(10)	DATE	Date Submitted
35	ABS_WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Push Back S=Submitted V=Saved
36	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.
37	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number Default Value: 0
38	FIRST_PROC_DT	Date(10)	DATE	GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
39	COMMENTS	Long Character	CLOB	Comment
40	GPIN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This object is a copy of the standard DESCR field, however it contains additional labels not available on the standard.
41	USED_BY	Character(1)	VARCHAR2(1) NOT NULL	USED_BY A=All Countries C=Specific Country
42	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
43	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
44	EFFDT_OTH	Date(10)	DATE	Other Effective Date
45	DESCR40	Character(40)	VARCHAR2(40) NOT NULL	Description
46	GP_ABS_EVT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Absence event status F=Finalized N=Not Processed P=Processed
47	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
48	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
49	ABS_PARTIAL_DAYS	Character(3)	VARCHAR2(3) NOT NULL	Partial Days Indicator ADH=All Day Half ALL=All Day BD=Begin Day Hours BDH=Begin Day Half BE=Begin and Day Hours BEH=Begin and End days Half ED=End Day Hours EDH=End Day Half
50	ABS_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Absence Category A=Approved O=Other P=Planned
51	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
52	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
53	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
54	FISCAL_QUARTER	Character(2)	VARCHAR2(2) NOT NULL	Fiscal Quarter
55	CALENDAR_QUARTER	Character(2)	VARCHAR2(2) NOT NULL	Calendar Quarter
56	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
57	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field