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

GP_PKG_AT5_AD

(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 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

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

3 EFFDT Date(10) DATE Effective Date

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

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

6 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.

7 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.

8 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.

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

10 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

11 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	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	EFFDT	Date(10)	DATE	Effective Date
4	TXN_ID	Number(5,0)	INTEGER NOT NULL	Transaction ID
5	GP_ORDER	Number(3,0)	SMALLINT NOT NULL	Utility field for data ordering
6	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.
7	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.
8	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.
9	FCST_RSLT_SS_LABEL	Character(18)	VARCHAR2(18) NOT NULL	Label that will appear in the Self Service transaction for the Forecast Result
10	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
11	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.