GP_PKG_AT5_VW (SQL View)	Index Back
Packaging Absence Forecast vw Packaging Absence Forecast vw

GP_PKG_AT5_VW

(SQL View)

Packaging Absence Forecast vw

SELECT PIN_NUM + 50000000 ,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

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

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.

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.

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

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