HGA_APPR_AWE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
6	END_DT	Date(10)	DATE NOT NULL	end date
7	ABS_BEGIN_DT	Date(10)	DATE	Absence Begin Date
8	ABS_END_DT	Date(10)	DATE	Absence End Date
9	ORIG_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
10	ORIG_BEGIN_DT	Date(10)	DATE	original begin date Default Value: GP_ABS_EVENT.BGN_DT
11	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
12	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void
13	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator
14	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
15	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
16	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
17	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
18	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
19	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
20	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
21	END_TIME	Time(15)	TIMESTAMP	Interview End Time
22	START_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing Start Time of Absence Take
23	END_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing End Time of Absence Take
24	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
25	EVT_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	config char
26	EVT_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	config char
27	EVT_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	config char
28	EVT_CONFIG1_DT	Date(10)	DATE	config date
29	EVT_CONFIG2_DT	Date(10)	DATE	config date
30	EVT_CONFIG3_DT	Date(10)	DATE	config date
31	EVT_CONFIG4_DT	Date(10)	DATE	config date
32	EVT_CONFIG1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
33	EVT_CONFIG2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
34	EVT_CONFIG3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
35	EVT_CONFIG4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
36	EVT_CONFIG1_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
37	EVT_CONFIG2_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
38	EVT_CONFIG3_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Config Monetary 3
39	EVT_CONFIG4_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
40	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
41	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
42	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
43	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
44	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved
45	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
46	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
47	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
48	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table
49	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
50	PROCESS_DT	Date(10)	DATE	Process Date
51	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.
52	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.
53	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
54	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
55	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
56	ACTION_DT_SS	Date(10)	DATE	Date Submitted
57	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
58	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number Default Value: 0
59	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
60	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
61	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.
62	COMMENTS	Long Character	CLOB	Comment
63	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
64	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
65	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.
66	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
67	REASON_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Reason field is required. Y/N Table Edit Default Value: N
68	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
69	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
70	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
71	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
72	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
73	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
74	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
75	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
76	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
77	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
78	EOAWSTART_DT	Date(10)	DATE	Start Date
79	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
80	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
81	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
82	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
83	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
84	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
85	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.
86	DISPLAY_REASON	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine whether the Absence Reason or Leave Donation Reason fields should display on the self-service pages.
87	DISP_CURR_BAL	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether or not to show the current balance of the entitlement on the self-service pages.
88	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
89	EOAWDTTM_COMPLETE	DateTime(26)	TIMESTAMP	Date/Time Completed
90	ORIGINATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Originator's ID
91	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
92	EOAWTHREAD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Thread Status A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial
93	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
94	DISP_USER_FIELDS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether or not to display the user fields in the entitlement.
95	ABS_UF1_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Character 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
96	ABS_UF2_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Character 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
97	ABS_UF3_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Character 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
98	ABS_UF4_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Character 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
99	ABS_UF5_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Date 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
100	ABS_UF6_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Date 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
101	ABS_UF7_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Date 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
102	ABS_UF8_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Date 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
103	ABS_UF9_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Monetary 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
104	ABS_UF10_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Monetary 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
105	ABS_UF11_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Monetary 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
106	ABS_UF12_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Monetary 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
107	ABS_UF13_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Decimal 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
108	ABS_UF14_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Decimal 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
109	ABS_UF15_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Decimal 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
110	ABS_UF16_SEQ_NUM	Number(2,0)	SMALLINT NOT NULL	User Field Decimal 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
111	ABS_USER_FLD1_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 1-Label, this label will be displayed in the Self Service Absences Transactions Pages
112	ABS_USER_FLD2_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 2-Label, this label will be displayed in the Self Service Absences Transactions Pages
113	ABS_USER_FLD3_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 3-Label, this label will be displayed in the Self Service Absences Transactions Pages
114	ABS_USER_FLD4_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 4-Label, this label will be displayed in the Self Service Absences Transactions Pages
115	ABS_USER_FLD5_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 5-Label, this label will be displayed in the Self Service Absences Transactions Pages
116	ABS_USER_FLD6_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 6-Label, this label will be displayed in the Self Service Absences Transactions Pages
117	ABS_USER_FLD7_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 7-Label, this label will be displayed in the Self Service Absences Transactions Pages
118	ABS_USER_FLD8_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 8-Label, this label will be displayed in the Self Service Absences Transactions Pages
119	ABS_USER_FLD9_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 9-Label, this label will be displayed in the Self Service Absences Transactions Pages
120	ABS_USER_FLD10_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 10-Label, this label will be displayed in the Self Service Absences Transactions Pages
121	ABS_USER_FLD11_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 11-Label, this label will be displayed in the Self Service Absences Transactions Pages
122	ABS_USER_FLD12_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 12-Label, this label will be displayed in the Self Service Absences Transactions Pages
123	ABS_USER_FLD13_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 13-Label, this label will be displayed in the Self Service Absences Transactions Pages
124	ABS_USER_FLD14_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 14-Label, this label will be displayed in the Self Service Absences Transactions Pages
125	ABS_USER_FLD15_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 15-Label, this label will be displayed in the Self Service Absences Transactions Pages
126	ABS_USER_FLD16_LBL	Character(30)	VARCHAR2(30) NOT NULL	User Field 16-Label, this label will be displayed in the Self Service Absences Transactions Pages
127	FCST_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether Forecasting a request is enabled.
128	FCST_REQ_APPR_ROLE	Character(1)	VARCHAR2(1) NOT NULL	This field indicates which role is required to Forecast in order to approve the absence request. A=Administrator B=Administrator and Manager M=Manager N=Not Applicable
129	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
130	SUBMIT_WITH_WARN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether a request can be submitted after Forecasting returns a warning message.
131	WARN_SUBMT_BY_ROLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate which role is allowed to submit an absence request that has a warning returned by Forecasting. B=Employee and Manager E=Employee M=Manager N=Not Applicable
132	SUBMIT_WITH_ERROR	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether an absence request can be submitted after Forecasting returns an error message
133	ERR_SUBMT_BY_ROLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate which role is allowed to approve an absence request that had an error returned after Forecasting is complete. A=Administrator B=Employee and Manager E=Employee M=Manager N=Not Applicable
134	DISPLAY_ORIG_BGN_D	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine whether the Absence Reason field should display on the self-service pages.