GP_ABSEVT_FCS_V

(SQL View)
Index Back

Absence Forecasting Results

Used to store the results of online absence forecasting

SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM , END_DT , PIN_NUM , TXN_ID , GP_ORDER , PIN_FCST_RSLT_NUM , ENTRY_TYPE_FCST , FCST_VAL_CHAR , FCST_VAL_NUM , FCST_VAL_DT , CAL_RUN_ID , ACM_FROM_DT , ACM_THRU_DT , USER_KEY1 , USER_KEY2 , USER_KEY3 , USER_KEY4 , USER_KEY5 , USER_KEY6 FROM PS_GP_ABS_EVT_FCST WHERE TXN_ID = 100

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 BGN_DT Date(10) DATE Begin Date
4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
5 END_DT Date(10) DATE end date
6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
7 TXN_ID Number(5,0) INTEGER NOT NULL Transaction ID
8 GP_ORDER Number(3,0) SMALLINT NOT NULL Utility field for data ordering
9 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.
10 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.
11 FCST_VAL_CHAR Character(30) VARCHAR2(30) NOT NULL This field is used on the GP_ABS_EVT_FCST to store the character value when the PIN_FCST_RSLT_NUM is a character element.
12 FCST_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL This field is used on the GP_ABS_EVT_FCST to store the numeric value when the PIN_FCST_RSLT_NUM is a numeric element.
13 FCST_VAL_DT Date(10) DATE This field is used on the GP_ABS_EVT_FCST to store the date value when the PIN_FCST_RSLT_NUM is a date element.
14 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
15 ACM_FROM_DT Date(10) DATE From Date
16 ACM_THRU_DT Date(10) DATE Through Date
17 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
18 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
19 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
20 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
21 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
22 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6