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

GP_ABS_NRP_FMAD

(SQL Table)

Absence Forecasting Custom Msg

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

Related Language Record: GP_ABS_NRP_FLAD

Parent record: GP_ABS_SS

# 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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

3 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

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 EFFDT Date(10) DATE Effective Date

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

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

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

9 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

#	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	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
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	EFFDT	Date(10)	DATE	Effective Date
6	FCST_VALUE	Character(30)	VARCHAR2(30) NOT NULL	This field is used to contain the value returned out of Forecasting.
7	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.
8	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.
9	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