HGA_EVENT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HGA_EEID_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: GP_SS_EE_RCD_VW
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	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.
7	ORIG_BEGIN_DT	Date(10)	DATE	original begin date Default Value: GP_ABS_EVENT.BGN_DT
8	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
9	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
10	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator Default Value: N
11	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: GP_ABS_REASN_VW Set Control Field: ABSENCE_REASON
12	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
13	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
14	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
15	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
16	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
17	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
18	END_TIME	Time(15)	TIMESTAMP	Interview End Time
19	START_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing Start Time of Absence Take
20	END_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing End Time of Absence Take
21	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
22	EVT_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	config char
23	EVT_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	config char
24	EVT_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	config char
25	EVT_CONFIG1_DT	Date(10)	DATE	config date
26	EVT_CONFIG2_DT	Date(10)	DATE	config date
27	EVT_CONFIG3_DT	Date(10)	DATE	config date
28	EVT_CONFIG4_DT	Date(10)	DATE	config date
29	EVT_CONFIG1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
30	EVT_CONFIG2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
31	EVT_CONFIG3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
32	EVT_CONFIG4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
33	EVT_CONFIG1_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
34	EVT_CONFIG2_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
35	EVT_CONFIG3_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Config Monetary 3
36	EVT_CONFIG4_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
37	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
38	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
39	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
40	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
41	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved
42	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
43	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
44	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
45	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table
46	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
47	PROCESS_DT	Date(10)	DATE	Process Date
48	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.
49	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.
50	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
51	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
52	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
53	ACTION_DT_SS	Date(10)	DATE	Date Submitted
54	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow 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=Rework S=Submitted V=Data Saved
55	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number Default Value: 0
56	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
57	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
58	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.
59	COMMENTS	Long Character	CLOB	Comment
60	EXCL_HOLIDAYS	Character(1)	VARCHAR2(1) NOT NULL	This fields indicates if the end date calculation needs to substract holidays N=No Y=Yes Default Value: N
61	EXCL_NON_WORK	Character(1)	VARCHAR2(1) NOT NULL	This fields indicates if the end date calculation needs to substract days off N=No Y=Yes Default Value: N
62	START_END_HOL_RULE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether the start or end date of an absence request can be scheduled for a holiday.
63	START_END_OFF_RULE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether the start or end date can be scheduled for an off-day
64	REASON_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Reason field is required. Y/N Table Edit Default Value: N
65	ALLOW_PARTIAL_DAYS	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether partial days are allowed for a particular absence take Y/N Table Edit Default Value: N
66	PARTIAL_DAYS_OPTN	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to indicate what types of partial days are allowed B=Partial Hours and Half Days D=Half Days H=Partial Hours N=None Default Value: N
67	FCST_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting. Y/N Table Edit Default Value: N
68	FCST_REQ_SUBMIT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether Forecasting is required to submit an absence request. Y/N Table Edit Default Value: N
69	FCST_REQ_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether Forecasting is required to approve an absence request. Y/N Table Edit Default Value: N
70	FCST_MESSAGE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate which type of Forecasting message to use as a result of Forecasting being complete, default message or a customized message. C=Customized Message D=Default Message
71	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID Prompt Table: GP_ABS_AWPR_VW1
72	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID Prompt Table: GP_ABS_AWPR_VW2
73	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
74	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
75	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
76	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
77	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
78	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
79	BAL_ACCUM_DISP_OPT	Character(1)	VARCHAR2(1) NOT NULL	This field will dictate how the current balance will be calculated and displayed on the self-service pages. N=Not Summarized S=Summarized
80	CURR_BAL_ACCUM	Number(8,0)	INTEGER NOT NULL	This field is used to contain the pin number of the accumulator that will represent the current balance of the entitlements.
81	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
82	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
83	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
84	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
85	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	User ID
86	HGA_WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow 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
87	ABS_CAN_REASON	Character(3)	VARCHAR2(3) NOT NULL	Cancel Reason Prompt Table: HGA_CAN_RSN Set Control Field: ABS_CAN_REASON
88	HGA_CANCEL_PRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Cancellation Approval Process ID
89	HGA_CANCEL_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Absence Cancellation Approval Definition ID
90	HGA_CAN_REQ_AS	Character(1)	VARCHAR2(1) NOT NULL	Cancel Allow As E=Employee M=Manager N=Not Applicable
91	HGA_CAN_ALLOW_BY	Character(1)	VARCHAR2(1) NOT NULL	Cancel Allowed By B=Employee and Manager E=Employee M=Manager
92	HGA_CAN_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Cancel As
93	HGA_CANCEL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Delete Event option 1=All Events 2=All Events Except Processed 3=All Events Except Finalized 4=Not Used
94	HGA_DISP_CAN_RSN	Character(1)	VARCHAR2(1) NOT NULL	Display Cancel Reason
95	HGA_APPR_FOR_PND	Character(1)	VARCHAR2(1) NOT NULL	Approval Required for pending requests
96	HGA_CAN_RSN_REQ	Character(1)	VARCHAR2(1) NOT NULL	Cancel Reason Required
97	HGA_EMP_AUTH_REQ	Character(1)	VARCHAR2(1) NOT NULL	Employee Authorization Required Y/N Table Edit
98	HGA_OVRD_EMP_AUTH	Character(1)	VARCHAR2(1) NOT NULL	Override Authorization Y/N Table Edit