GP_ABS_TK_FCST (SQL Table)	Index Back
Absence Take Forecast Elements Used to define the elements to return with Absence Forecasting/Balance Inquiry online transaction

GP_ABS_TK_FCST

(SQL Table)

Absence Take Forecast Elements

Used to define the elements to return with Absence Forecasting/Balance Inquiry online transaction

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 TXN_ID Number(5,0) INTEGER NOT NULL Transaction ID

4 GP_ORDER Number(3,0) SMALLINT NOT NULL Utility field for data ordering

5 ENTRY_TYPE_FCST Character(3) VARCHAR2(3) NOT NULL This field is used on the GP_ABS_TK_FCST to define the entry type of the forecasting elements to be returned with the forecasting results.
Prompt Table: GP_ENT_ABS9_VW

6 PIN_FCST_RSLT_NUM Number(8,0) INTEGER NOT NULL This field is used on the GP_ABS_TK_FCST to identify the elements to be returned with the results of forecasting.
Prompt Table: %GP_EDIT_FLD13

7 DISPLAY_IN_SS Character(1) VARCHAR2(1) NOT NULL This field indicates whether the forecasting or balance element will be displayed in the Self-Service results grid.
Y/N Table Edit

8 FCST_RSLT_SS_LABEL Character(18) VARCHAR2(18) NOT NULL Label that will appear in the Self Service transaction for the Forecast Result

9 USE_IN_FCST_MSG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether the forecasting or balance field will be used in the forecasting customized message.
D=Do Not Use
F=Use First Instance
L=Use Last Instance
S=Summarize All Instances
Y/N Table Edit

10 FCST_MSG_BIND_VAR Number(2,0) SMALLINT NOT NULL This field will be used to indicate which bind variable substitution parameter will be used to display the forecasting or balance element in the forecasting message.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	TXN_ID	Number(5,0)	INTEGER NOT NULL	Transaction ID
4	GP_ORDER	Number(3,0)	SMALLINT NOT NULL	Utility field for data ordering
5	ENTRY_TYPE_FCST	Character(3)	VARCHAR2(3) NOT NULL	This field is used on the GP_ABS_TK_FCST to define the entry type of the forecasting elements to be returned with the forecasting results. Prompt Table: GP_ENT_ABS9_VW
6	PIN_FCST_RSLT_NUM	Number(8,0)	INTEGER NOT NULL	This field is used on the GP_ABS_TK_FCST to identify the elements to be returned with the results of forecasting. Prompt Table: %GP_EDIT_FLD13
7	DISPLAY_IN_SS	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the forecasting or balance element will be displayed in the Self-Service results grid. Y/N Table Edit
8	FCST_RSLT_SS_LABEL	Character(18)	VARCHAR2(18) NOT NULL	Label that will appear in the Self Service transaction for the Forecast Result
9	USE_IN_FCST_MSG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether the forecasting or balance field will be used in the forecasting customized message. D=Do Not Use F=Use First Instance L=Use Last Instance S=Summarize All Instances Y/N Table Edit
10	FCST_MSG_BIND_VAR	Number(2,0)	SMALLINT NOT NULL	This field will be used to indicate which bind variable substitution parameter will be used to display the forecasting or balance element in the forecasting message.