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

GP_AUD_ABSTB_VW

(SQL View)

Absence Take Forecasting View

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

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 =110

# 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

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.
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 GP_AUD_CHAR_NM1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics

8 GP_AUD_LINK1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics

9 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics

10 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

11 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

12 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

13 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
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. 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	GP_AUD_CHAR_NM1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
8	GP_AUD_LINK1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
9	GP_AUD_CHAR_VAL1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
10	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
11	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
12	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
13	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.