DP_PUBLISHNAMEDP_PUBLISH_DATEDP_FORECASTITEM1=Additive
2=Multiplicative
DP_PUB_FCIT_EXT(SQL Table) |
Index Back |
|---|---|
DP_PUB_FCIT_EXTDP_PUB_FCIT_EXT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_PUBLISHNAME |
Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 2 | DP_PUBLISH_DATE |
Date(10) | DATE NOT NULL | DP_PUBLISH_DATE |
| 3 | DP_FORECASTITEM |
Character(120) | VARCHAR2(120) NOT NULL | DP_FORECASTITEM |
| 4 | DP_MEAN_ERROR | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_MEAN_ERROR |
| 5 | DP_MEANABSERROR | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_MEANABSERROR |
| 6 | DP_MOVINGAVERAGE | Character(1) | VARCHAR2(1) NOT NULL | DP_MOVINGAVERAGE |
| 7 | DP_ERRORRATIO | Number(17,6) | DECIMAL(16,6) NOT NULL | DP_ERRORRATIO |
| 8 | DP_TRACKSIGNAL00 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL00 |
| 9 | DP_TRACKSIGNAL01 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL01 |
| 10 | DP_TRACKSIGNAL02 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL02 |
| 11 | DP_TRACKSIGNAL03 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL03 |
| 12 | DP_TRACKSIGNAL04 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL04 |
| 13 | DP_TRACKSIGNAL05 | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | DP_TRACKSIGNAL05 |
| 14 | DP_ACCURACY_STAT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL |
DP_ACCURACY_STAT
1=Additive 2=Multiplicative |
| 15 | DP_MA_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_MA_ALPHA |
| 16 | DP_MA_FINALLEVEL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_MA_FINALLEVEL |
| 17 | DP_WMA_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_WMA_ALPHA |
| 18 | DP_WMA_FINALLEVEL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_WMA_FINALLEVEL |
| 19 | DP_LR_ELASTICITY | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_ELASTICITY |
| 20 | DP_LR_FTEST | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_FTEST |
| 21 | DP_LR_INTERCEPT | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_INTERCEPT |
| 22 | DP_LR_SLOPE | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_SLOPE |
| 23 | DP_LR_TTEST1 | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_TTEST1 |
| 24 | DP_LR_TTEST2 | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LR_TTEST2 |
| 25 | DP_SES_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_SES_ALPHA |
| 26 | DP_SES_FINALLEVEL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_SES_FINALLEVEL |
| 27 | DP_AES_BETA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_AES_BETA |
| 28 | DP_DESB_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_DESB_ALPHA |
| 29 | DP_DESH_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_DESH_ALPHA |
| 30 | DP_DESH_FINALLEVEL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_DESH_FINALLEVEL |
| 31 | DP_DESH_FINALTREND | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_DESH_FINALTREND |
| 32 | DP_DESH_GAMMA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_DESH_GAMMA |
| 33 | DP_TESB_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_TESB_ALPHA |
| 34 | DP_CROSTON_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_CROSTON_ALPHA |
| 35 | DP_HW_ALPHA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_HW_ALPHA |
| 36 | DP_HW_BETA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_HW_BETA |
| 37 | DP_HW_FINALLEVEL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_HW_FINALLEVEL |
| 38 | DP_HW_FINALTREND | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_HW_FINALTREND |
| 39 | DP_HW_GAMMA | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_HW_GAMMA |
| 40 | DP_BOX_ACF_BOUNDRY | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_ACF_BOUNDRY |
| 41 | DP_BOX_AR_PARAM | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_AR_PARAM |
| 42 | DP_BOX_AR_SEAS_PAR | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_AR_SEAS_PAR |
| 43 | DP_BOX_AUTOCOEFF | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_AUTOCOEFF |
| 44 | DP_BOX_CONST_PARAM | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_CONST_PARAM |
| 45 | DP_BOX_MA_PARAM | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_MA_PARAM |
| 46 | DP_BOX_MA_SEAS_PAR | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_MA_SEAS_PAR |
| 47 | DP_BOX_NONSEAS_D | Number(1,0) | SMALLINT NOT NULL | DP_BOX_NONSEAS_D |
| 48 | DP_BOX_NONSEAS_P | Number(16,0) | DECIMAL(16) NOT NULL | DP_BOX_NONSEAS_P |
| 49 | DP_BOX_NONSEAS_PDE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_NONSEAS_PDE |
| 50 | DP_BOX_NONSEAS_PIN | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_NONSEAS_PIN |
| 51 | DP_BOX_NONSEAS_Q | Number(16,0) | DECIMAL(16) NOT NULL | DP_BOX_NONSEAS_Q |
| 52 | DP_BOX_NONSEAS_QDE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_NONSEAS_QDE |
| 53 | DP_BOX_NONSEAS_QIN | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_NONSEAS_QIN |
| 54 | DP_BOX_NUM_LAGS | Number(5,0) | INTEGER NOT NULL | DP_BOX_NUM_LAGS |
| 55 | DP_BOX_PARTIALCOEF | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BOX_PARTIALCOEF |
| 56 | DP_BOX_SEAS_D | Number(1,0) | SMALLINT NOT NULL | DP_BOX_SEAS_D |
| 57 | DP_BOX_SEAS_LEN | Number(5,0) | INTEGER NOT NULL | DP_BOX_SEAS_LEN |
| 58 | DP_BOX_SEAS_P | Number(16,0) | DECIMAL(16) NOT NULL | DP_BOX_SEAS_P |
| 59 | DP_BOX_SEAS_PDECAY | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_SEAS_PDECAY |
| 60 | DP_BOX_SEAS_PINIT | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_SEAS_PINIT |
| 61 | DP_BOX_SEAS_Q | Number(16,0) | DECIMAL(16) NOT NULL | DP_BOX_SEAS_Q |
| 62 | DP_BOX_SEAS_QDECAY | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_SEAS_QDECAY |
| 63 | DP_BOX_SEAS_QINIT | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_BOX_SEAS_QINIT |
| 64 | DP_BOX_TRANS_METH | Character(1) | VARCHAR2(1) NOT NULL | DP_BOX_TRANS_METH |
| 65 | DP_AIC | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_AIC |
| 66 | DP_BIC | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_BIC |
| 67 | DP_CHI_SQR | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_CHI_SQR |
| 68 | DP_COCHRANE | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_COCHRANE |
| 69 | DP_DW | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_DW |
| 70 | DP_LJUNG_BOX | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_LJUNG_BOX |
| 71 | DP_ME | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_ME |
| 72 | DP_MAE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_MAE |
| 73 | DP_MAPE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_MAPE |
| 74 | DP_MSE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_MSE |
| 75 | DP_NORMALITY | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_NORMALITY |
| 76 | DP_RSQUARE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_RSQUARE |
| 77 | DP_ADJ_RSQUARE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_ADJ_RSQUARE |
| 78 | DP_RMSE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_RMSE |
| 79 | DP_SDE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_SDE |
| 80 | DP_SSE | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_SSE |
| 81 | DP_SSR | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_SSR |
| 82 | DP_X11_TTEST | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_X11_TTEST |
| 83 | DP_THEIL | Signed Number(22,4) | DECIMAL(20,4) NOT NULL | DP_THEIL |