GP_ABS_FCST_MSG (SQL Table)	Index Back
Absence Forecasting Custom Msg This record will contain the customized messages from the Forecasting results.

GP_ABS_FCST_MSG

(SQL Table)

Absence Forecasting Custom Msg

This record will contain the customized messages from the Forecasting results.

Related Language Record: GP_ABS_FCST_LNG

Parent record: GP_ABS_SS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY
Set Control Field: COUNTRY

2 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_ABS_TAKE

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

4 FCST_CUSTOM_MSG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate what customize message to use for each of the major return status of Forecasting
E=Error
S=Success
W=Warning

5 FCST_VALUE Character(30) VARCHAR2(30) NOT NULL This field is used to contain the value returned out of Forecasting.

6 FCST_STATUS_TXT_ID Character(18) VARCHAR2(18) NOT NULL This field will be used to contain the HR Text Catalog entry that corresponds to the Forecasting return value.
Prompt Table: GP_ABS_HR_TEXT

7 FCST_DESCR_TEXT_ID Character(18) VARCHAR2(18) NOT NULL This field will be used to contain the HR Text Catalog entry that corresponds to the Forecasting return value.
Prompt Table: GP_ABS_HR_TEXT

8 FCST_DISPLAY_OPTN Character(1) VARCHAR2(1) NOT NULL This field will be used to indicate which Forecasting messages will display.
B=Status and Description
D=Message Description
S=Status Message
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY Set Control Field: COUNTRY
2	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_ABS_TAKE
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	FCST_CUSTOM_MSG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate what customize message to use for each of the major return status of Forecasting E=Error S=Success W=Warning
5	FCST_VALUE	Character(30)	VARCHAR2(30) NOT NULL	This field is used to contain the value returned out of Forecasting.
6	FCST_STATUS_TXT_ID	Character(18)	VARCHAR2(18) NOT NULL	This field will be used to contain the HR Text Catalog entry that corresponds to the Forecasting return value. Prompt Table: GP_ABS_HR_TEXT
7	FCST_DESCR_TEXT_ID	Character(18)	VARCHAR2(18) NOT NULL	This field will be used to contain the HR Text Catalog entry that corresponds to the Forecasting return value. Prompt Table: GP_ABS_HR_TEXT
8	FCST_DISPLAY_OPTN	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to indicate which Forecasting messages will display. B=Status and Description D=Message Description S=Status Message Default Value: S