HGA_APPR_AW5_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	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	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	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
18	EVT_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	config char
19	EVT_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	config char
20	EVT_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	config char
21	EVT_CONFIG1_DT	Date(10)	DATE	config date
22	EVT_CONFIG2_DT	Date(10)	DATE	config date
23	EVT_CONFIG3_DT	Date(10)	DATE	config date
24	EVT_CONFIG4_DT	Date(10)	DATE	config date
25	EVT_CONFIG1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
26	EVT_CONFIG2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
27	EVT_CONFIG3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
28	EVT_CONFIG4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
29	EVT_CONFIG1_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
30	EVT_CONFIG2_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
31	EVT_CONFIG3_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Config Monetary 3
32	EVT_CONFIG4_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
33	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
34	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
35	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
36	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
37	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
38	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
39	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
40	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
41	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number Default Value: 0
42	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
43	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
44	COMMENTS	Long Character	CLOB	Comment
45	REASON_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Reason field is required. Y/N Table Edit Default Value: N
46	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
47	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
48	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
49	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
50	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
51	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
52	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
53	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
54	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
55	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
56	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.
57	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.
58	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.
59	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.
60	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
61	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
62	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
63	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
64	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
65	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
66	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
67	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
68	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
69	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
70	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
71	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
72	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
73	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
74	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
75	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
76	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
77	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
78	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
79	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
80	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
81	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
82	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
83	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
84	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
85	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
86	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
87	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
88	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
89	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
90	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
91	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
92	FCST_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether Forecasting a request is enabled.
93	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
94	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.
95	HGA_ABS_CUR_BAL	Character(20)	VARCHAR2(20) NOT NULL	Absence Request Approval Pagelet - Current Balance
96	ABS_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Absence Type Description
97	HGA_ABS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Absence Name
98	HGA_PARTIAL_DAYS	Character(100)	VARCHAR2(100) NOT NULL	HAG Partial Days descption
99	ABS_REASON_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Absence Reason
100	HGA_BGN_DATE2	Character(30)	VARCHAR2(30) NOT NULL	Start Date
101	HGA_END_DATE2	Character(30)	VARCHAR2(30) NOT NULL	Start Date
102	HGA_ORIG_BGN_DATE	Character(30)	VARCHAR2(30) NOT NULL	Original Start Date
103	ABSENCE_DURATION	Character(15)	VARCHAR2(15) NOT NULL	Absence Duration
104	ABS_PAR_TEXT01	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 1
105	ABS_PAR_TEXT02	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 2
106	ABS_PAR_TEXT03	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 3
107	ABS_PAR_TEXT04	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 4
108	ABS_PAR_TEXT05	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 5
109	ABS_PAR_TEXT06	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 6
110	ABS_PAR_TEXT07	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 7
111	ABS_PAR_TEXT08	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 8
112	ABS_PAR_TEXT09	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 9
113	ABS_PAR_TEXT10	Character(70)	VARCHAR2(70) NOT NULL	Absence Parameters Text 10
114	ABS_PAR_TEXT11	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
115	ABS_PAR_TEXT12	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
116	ABS_PAR_TEXT13	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
117	ABS_PAR_TEXT14	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
118	ABS_PAR_TEXT15	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
119	ABS_PAR_TEXT16	Character(80)	VARCHAR2(80) NOT NULL	Used to display the text for the UK Parental Leave parameters in the Absence Parameters page.
120	EOPCIMAGE_ID	Character(30)	VARCHAR2(30) NOT NULL	Image
121	EOPCUSE_MAP_DIR	Character(1)	VARCHAR2(1) NOT NULL	Use MAP Image Directory
122	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
123	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.
124	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
125	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