GP_ABS_TK_FCS_V (SQL View)	Index Back
Absence Take Forecasting View Used to view Absence Take Forecasting where transaction type is Absence Forecasting

GP_ABS_TK_FCS_V

(SQL View)

Absence Take Forecasting View

Used to view Absence Take Forecasting where transaction type is Absence Forecasting

SELECT PIN_NUM ,EFFDT ,TXN_ID ,GP_ORDER ,ENTRY_TYPE_FCST ,PIN_FCST_RSLT_NUM ,DISPLAY_IN_SS ,FCST_RSLT_SS_LABEL ,USE_IN_FCST_MSG ,FCST_MSG_BIND_VAR FROM PS_GP_ABS_TK_FCST WHERE TXN_ID =100

# 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
Default Value: 100

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
Default Value: N

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

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
Default Value: D

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 Default Value: 100
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 Default Value: N
8	FCST_RSLT_SS_LABEL	Character(18)	VARCHAR2(18) NOT NULL	Label that will appear in the Self Service transaction for the Forecast Result Prompt Table: GP_ABS_HR_TEXT
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 Default Value: D
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.