DP_FCI_VIEW

(SQL View)
 Index Back

FCST built using Row Lvl Sec.

SELECT DISTINCT(B.OPRID) , A.DP_CONFIGVIEW , A.DP_CONFIGLEVEL , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION , A.DP_TEMPLATEITEM , A.DP_LIFEPROFILEITEM , E.DP_NEXTLEVEL , E.DP_NEXTFCITEM , E.DP_CONTROLGROUP , E.DP_USESSEASONPROF , E.DP_DETSEASPROFILE , E.DP_SEASONALITYPROF , E.DP_HISTDEMANDPDS , E.DP_EFFDEMANDPDS , E.DP_FCMETHOD , E.DP_CALCULATIONTYPE , E.DP_PRORATE , E.DP_BASEUOM , E.DP_WEIGHT , E.DP_WEIGHTUOM , E.DP_VOLUME , E.DP_VOLUMEUOM , E.DP_NEXTLEVELUOM , E.DP_NEXTLEVELCONV , E.DP_STANDARDCOST , E.DP_STANDARDPRICE , E.DP_AVGPRICE , E.UTILIZ_CD , E.UTILIZ_GROUP , E.DP_FORECASTANALYST , E.DP_STATFOREDEV , E.DP_PRORATEDFOREDEV , E.DP_ADJFOREDEV , E.DP_MEAN_ERROR , E.DP_MEANABSERROR , E.DP_PERIODCREATED , E.DP_YEARCREATED , E.DP_LASTRESETYR , E.DP_LASTRESETPD , E.DP_CURRENTMODELYR , E.DP_CURRENTMODELPD , E.DP_FC_EFFYR , E.DP_FC_EFFPD , E.DP_MA_PERIODS , E.DP_SUSPENDEDITEM , E.DP_EVALPERIODS , E.DP_UPDATETOINVPOL , E.DP_AUDITREVIEWDONE , E.DP_DESCRIPTION , E.DP_LIFEPROFILE , E.DP_ERRORRATIO , E.DP_TRACKSIGNAL00 , E.DP_TRACKSIGNAL01 , E.DP_TRACKSIGNAL02 , E.DP_TRACKSIGNAL03 , E.DP_TRACKSIGNAL04 , E.DP_TRACKSIGNAL05 , E.DP_ITEMCODE , E.DP_LOCATION , E.DP_ROUNDDECIMALS , E.DP_WEIGHTPROFILE , E.DP_UD01 , E.DP_UD02 , E.DP_UD03 , E.DP_UD04 , E.DP_UD05 , E.DP_UD06 , E.DP_UD07 , E.DP_UD08 , E.DP_UD09 , E.DP_UD10 , E.DP_UD11 , E.DP_UD12 , E.DP_UD13 , E.DP_UD14 , E.DP_UD15 , E.DP_UD16 , E.DP_UD17 , E.DP_UD18 , E.DP_UD19 , E.DP_UD20 , E.DP_UD21 , E.DP_UD22 , E.DP_UD23 , E.DP_UD24 , E.DP_UD25 , E.DP_UD26 , E.DP_UD27 , E.DP_UD28 , E.DP_UD29 , E.DP_UD30 , E.DP_UD31 , E.DP_UD32 , E.DP_UD33 , E.DP_UD34 , E.DP_UD35 , E.DP_UD36 , E.DP_UD37 , E.DP_UD38 , E.DP_UD39 , E.DP_UD40 , E.DP_UD41 , E.DP_UD42 , E.DP_UD43 , E.DP_UD44 , E.DP_UD45 , E.DP_UD46 , E.DP_UD47 , E.DP_UD48 , E.DP_UD49 , E.DP_UD50 , E.DP_SUMMGROUP , E.DP_MA_FINALLEVEL , E.DP_MA_ALPHA , E.DP_WMA_FINALLEVEL , E.DP_WMA_ALPHA , E.DP_LR_FTEST , E.DP_LR_INTERCEPT , E.DP_LR_SLOPE , E.DP_LR_ELASTICITY , E.DP_LR_TTEST1 , E.DP_LR_TTEST2 , E.DP_SES_FINALLEVEL , E.DP_SES_ALPHA , E.DP_AES_BETA , E.DP_DESB_ALPHA , E.DP_DESH_FINALLEVEL , E.DP_DESH_ALPHA , E.DP_DESH_GAMMA , E.DP_DESH_FINALTREND , E.DP_TESB_ALPHA , E.DP_CROSTON_ALPHA , E.DP_HW_FINALLEVEL , E.DP_HW_ALPHA , E.DP_HW_BETA , E.DP_HW_GAMMA , E.DP_HW_FINALTREND , E.DP_X11_IRREGAVSTAT , E.DP_BOX_ACF_BOUNDRY , E.DP_BOX_AR_PARAM , E.DP_BOX_AR_SEAS_PAR , E.DP_BOX_CONST_PARAM , E.DP_BOX_MA_PARAM , E.DP_BOX_MA_SEAS_PAR , E.DP_BOX_NONSEAS_D , E.DP_BOX_NONSEAS_P , E.DP_BOX_NONSEAS_PDE , E.DP_BOX_NONSEAS_PIN , E.DP_BOX_NONSEAS_Q , E.DP_BOX_NONSEAS_QDE , E.DP_BOX_NONSEAS_QIN , E.DP_BOX_NUM_LAGS , E.DP_BOX_SEAS_D , E.DP_BOX_SEAS_LEN , E.DP_BOX_SEAS_P , E.DP_BOX_SEAS_PINIT , E.DP_BOX_SEAS_PDECAY , E.DP_BOX_SEAS_Q , E.DP_BOX_SEAS_QINIT , E.DP_BOX_SEAS_QDECAY , E.DP_AIC , E.DP_BIC , E.DP_CHI_SQR , E.DP_COCHRANE , E.DP_DW , E.DP_LJUNG_BOX , E.DP_ME , E.DP_MAE , E.DP_MAPE , E.DP_MSE , E.DP_NORMALITY , E.DP_RSQUARE , E.DP_ADJ_RSQUARE , E.DP_RMSE , E.DP_SDE , E.DP_SSE , E.DP_SSR , E.DP_X11_TTEST , E.DP_THEIL , E.DP_STDDEV , E.DP_INHIBITED , E.DP_ROLLBACKPERIODS , E.DP_SEASONALITYTYPE , E.DP_ACCURACY_STAT , E.DP_BOX_TRANS_METH , E.DP_LASTEVALPDS , E.DP_DEMANDAVERAGE , E.DP_RESTART_CONTROL , E.DP_ALPHA_DEFAULT , E.DP_BETA_DEFAULT , E.DP_GAMMA_DEFAULT , E.DP_SLOPE_DEFAULT , E.DP_INTERCEPT_DEF , E.DP_LASTCHANGEDATE , E.DP_DATESTAMP FROM PS_DP_ROLEFCITM A , PS_DP_FCITEMS E , PSOPRDEFN B , PSROLEUSER C , PS_DP_VIEW1USER_VW D WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_CONFIGVIEW = D.DP_CONFIGVIEW AND A.DP_CONFIGVIEW = E.DP_CONFIGVIEW AND B.OPRID = D.OPRID AND A.DP_FORECASTITEM = E.DP_FORECASTITEM

SELECT DISTINCT(B.OPRID) , A.DP_CONFIGVIEW , A.DP_CONFIGLEVEL , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION , A.DP_TEMPLATEITEM , A.DP_LIFEPROFILEITEM , E.DP_NEXTLEVEL , E.DP_NEXTFCITEM , E.DP_CONTROLGROUP , E.DP_USESSEASONPROF , E.DP_DETSEASPROFILE , E.DP_SEASONALITYPROF , E.DP_HISTDEMANDPDS , E.DP_EFFDEMANDPDS , E.DP_FCMETHOD , E.DP_CALCULATIONTYPE , E.DP_PRORATE , E.DP_BASEUOM , E.DP_WEIGHT , E.DP_WEIGHTUOM , E.DP_VOLUME , E.DP_VOLUMEUOM , E.DP_NEXTLEVELUOM , E.DP_NEXTLEVELCONV , E.DP_STANDARDCOST , E.DP_STANDARDPRICE , E.DP_AVGPRICE , E.UTILIZ_CD , E.UTILIZ_GROUP , E.DP_FORECASTANALYST , E.DP_STATFOREDEV , E.DP_PRORATEDFOREDEV , E.DP_ADJFOREDEV , E.DP_MEAN_ERROR , E.DP_MEANABSERROR , E.DP_PERIODCREATED , E.DP_YEARCREATED , E.DP_LASTRESETYR , E.DP_LASTRESETPD , E.DP_CURRENTMODELYR , E.DP_CURRENTMODELPD , E.DP_FC_EFFYR , E.DP_FC_EFFPD , E.DP_MA_PERIODS , E.DP_SUSPENDEDITEM , E.DP_EVALPERIODS , E.DP_UPDATETOINVPOL , E.DP_AUDITREVIEWDONE , E.DP_DESCRIPTION , E.DP_LIFEPROFILE , E.DP_ERRORRATIO , E.DP_TRACKSIGNAL00 , E.DP_TRACKSIGNAL01 , E.DP_TRACKSIGNAL02 , E.DP_TRACKSIGNAL03 , E.DP_TRACKSIGNAL04 , E.DP_TRACKSIGNAL05 , E.DP_ITEMCODE , E.DP_LOCATION , E.DP_ROUNDDECIMALS , E.DP_WEIGHTPROFILE , E.DP_UD01 , E.DP_UD02 , E.DP_UD03 , E.DP_UD04 , E.DP_UD05 , E.DP_UD06 , E.DP_UD07 , E.DP_UD08 , E.DP_UD09 , E.DP_UD10 , E.DP_UD11 , E.DP_UD12 , E.DP_UD13 , E.DP_UD14 , E.DP_UD15 , E.DP_UD16 , E.DP_UD17 , E.DP_UD18 , E.DP_UD19 , E.DP_UD20 , E.DP_UD21 , E.DP_UD22 , E.DP_UD23 , E.DP_UD24 , E.DP_UD25 , E.DP_UD26 , E.DP_UD27 , E.DP_UD28 , E.DP_UD29 , E.DP_UD30 , E.DP_UD31 , E.DP_UD32 , E.DP_UD33 , E.DP_UD34 , E.DP_UD35 , E.DP_UD36 , E.DP_UD37 , E.DP_UD38 , E.DP_UD39 , E.DP_UD40 , E.DP_UD41 , E.DP_UD42 , E.DP_UD43 , E.DP_UD44 , E.DP_UD45 , E.DP_UD46 , E.DP_UD47 , E.DP_UD48 , E.DP_UD49 , E.DP_UD50 , E.DP_SUMMGROUP , E.DP_MA_FINALLEVEL , E.DP_MA_ALPHA , E.DP_WMA_FINALLEVEL , E.DP_WMA_ALPHA , E.DP_LR_FTEST , E.DP_LR_INTERCEPT , E.DP_LR_SLOPE , E.DP_LR_ELASTICITY , E.DP_LR_TTEST1 , E.DP_LR_TTEST2 , E.DP_SES_FINALLEVEL , E.DP_SES_ALPHA , E.DP_AES_BETA , E.DP_DESB_ALPHA , E.DP_DESH_FINALLEVEL , E.DP_DESH_ALPHA , E.DP_DESH_GAMMA , E.DP_DESH_FINALTREND , E.DP_TESB_ALPHA , E.DP_CROSTON_ALPHA , E.DP_HW_FINALLEVEL , E.DP_HW_ALPHA , E.DP_HW_BETA , E.DP_HW_GAMMA , E.DP_HW_FINALTREND , E.DP_X11_IRREGAVSTAT , E.DP_BOX_ACF_BOUNDRY , E.DP_BOX_AR_PARAM , E.DP_BOX_AR_SEAS_PAR , E.DP_BOX_CONST_PARAM , E.DP_BOX_MA_PARAM , E.DP_BOX_MA_SEAS_PAR , E.DP_BOX_NONSEAS_D , E.DP_BOX_NONSEAS_P , E.DP_BOX_NONSEAS_PDE , E.DP_BOX_NONSEAS_PIN , E.DP_BOX_NONSEAS_Q , E.DP_BOX_NONSEAS_QDE , E.DP_BOX_NONSEAS_QIN , E.DP_BOX_NUM_LAGS , E.DP_BOX_SEAS_D , E.DP_BOX_SEAS_LEN , E.DP_BOX_SEAS_P , E.DP_BOX_SEAS_PINIT , E.DP_BOX_SEAS_PDECAY , E.DP_BOX_SEAS_Q , E.DP_BOX_SEAS_QINIT , E.DP_BOX_SEAS_QDECAY , E.DP_AIC , E.DP_BIC , E.DP_CHI_SQR , E.DP_COCHRANE , E.DP_DW , E.DP_LJUNG_BOX , E.DP_ME , E.DP_MAE , E.DP_MAPE , E.DP_MSE , E.DP_NORMALITY , E.DP_RSQUARE , E.DP_ADJ_RSQUARE , E.DP_RMSE , E.DP_SDE , E.DP_SSE , E.DP_SSR , E.DP_X11_TTEST , E.DP_THEIL , E.DP_STDDEV , E.DP_INHIBITED , E.DP_ROLLBACKPERIODS , E.DP_SEASONALITYTYPE , E.DP_ACCURACY_STAT , E.DP_BOX_TRANS_METH , E.DP_LASTEVALPDS , E.DP_DEMANDAVERAGE , E.DP_RESTART_CONTROL , E.DP_ALPHA_DEFAULT , E.DP_BETA_DEFAULT , E.DP_GAMMA_DEFAULT , E.DP_SLOPE_DEFAULT , E.DP_INTERCEPT_DEF , E.DP_LASTCHANGEDATE , E.DP_DATESTAMP FROM PS_DP_ROLEFCITM A , PS_DP_FCITEMS E , PSOPRDEFN B , PSROLEUSER C , PS_DP_VIEW1USER_VW D WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_CONFIGVIEW = D.DP_CONFIGVIEW AND A.DP_CONFIGVIEW = E.DP_CONFIGVIEW AND B.OPRID = D.OPRID AND A.DP_FORECASTITEM = E.DP_FORECASTITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: DP_VIEW1USER_VW

3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL

Prompt Table: DP_CONFIGLEVELS

4 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
5 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION
6 DP_TEMPLATEITEM Character(1) VARCHAR2(1) NOT NULL DP_TEMPLATEITEM

Y/N Table Edit

Default Value: N

7 DP_LIFEPROFILEITEM Character(1) VARCHAR2(1) NOT NULL DP_LIFEPROFILEITEM

Y/N Table Edit

Default Value: N

8 DP_NEXTLEVEL Number(10,0) DECIMAL(10) NOT NULL DP_NEXTLEVEL
9 DP_NEXTFCITEM Character(120) VARCHAR2(120) NOT NULL DP_NEXTFCITEM
10 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP

Prompt Table: DP_CONTROLGRPS

11 DP_USESSEASONPROF Character(1) VARCHAR2(1) NOT NULL DP_USESSEASONPROF

Y/N Table Edit

Default Value: N

12 DP_DETSEASPROFILE Character(1) VARCHAR2(1) NOT NULL DP_DETSEASPROFILE

Y/N Table Edit

Default Value: N

13 DP_SEASONALITYPROF Character(20) VARCHAR2(20) NOT NULL DP_SEASONALITYPROF

Prompt Table: DP_SEASPROFILES

14 DP_HISTDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_HISTDEMANDPDS
15 DP_EFFDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_EFFDEMANDPDS
16 DP_FCMETHOD Character(4) VARCHAR2(4) NOT NULL DP_FCMETHOD
0=No Model Selected
10=Tpl Exponential Smoothing - Br
14=Holt Winters
15=Weighted Moving Average
18=Box Jenkins/ARIMA
19=Census X-11
24=Croston
4=Moving Average
5=Exponential Smoothing
6=Linear Regression
7=Adaptive Exponential Smoothing
8=Dbl Exponential Smoothing - Br
9=Dbl Exponential Smoothing - Ho

Default Value: 0

Prompt Table: DP_FCMETHODS_VW

17 DP_CALCULATIONTYPE Character(1) VARCHAR2(1) NOT NULL DP_CALCULATIONTYPE
0=Best Fit
1=Reoptimize
2=No Calculation
18 DP_PRORATE Character(1) VARCHAR2(1) NOT NULL DP_PRORATE Date Initials Reference # Description 06/08/07 TH ICE 1614042000 Modified Proration to allow Proration based upon the Number of Child Items

Y/N Table Edit

19 DP_BASEUOM Character(3) VARCHAR2(3) NOT NULL DP_BASEUOM

Prompt Table: UNITS_TBL

20 DP_WEIGHT Number(13,2) DECIMAL(12,2) NOT NULL DP_WEIGHT
21 DP_WEIGHTUOM Character(3) VARCHAR2(3) NOT NULL DP_WEIGHTUOM

Prompt Table: UNITS_TBL

22 DP_VOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_VOLUME
23 DP_VOLUMEUOM Character(3) VARCHAR2(3) NOT NULL DP_VOLUMEUOM

Prompt Table: UNITS_TBL

24 DP_NEXTLEVELUOM Character(3) VARCHAR2(3) NOT NULL DP_NEXTLEVELUOM

Prompt Table: UNITS_TBL

25 DP_NEXTLEVELCONV Number(13,2) DECIMAL(12,2) NOT NULL DP_NEXTLEVELCONV
26 DP_STANDARDCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDCOST
27 DP_STANDARDPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDPRICE
28 DP_AVGPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_AVGPRICE
29 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type
30 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
31 DP_FORECASTANALYST Character(20) VARCHAR2(20) NOT NULL DP_FORECASTANALYST

Prompt Table: DP_FORECASTER

32 DP_STATFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_STATFOREDEV
33 DP_PRORATEDFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_PRORATEDFOREDEV
34 DP_ADJFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_ADJFOREDEV
35 DP_MEAN_ERROR Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_MEAN_ERROR
36 DP_MEANABSERROR Number(15,4) DECIMAL(14,4) NOT NULL DP_MEANABSERROR
37 DP_PERIODCREATED Number(2,0) SMALLINT NOT NULL DP_PERIODCREATED
38 DP_YEARCREATED Number(4,0) SMALLINT NOT NULL DP_YEARCREATED
39 DP_LASTRESETYR Number(4,0) SMALLINT NOT NULL DP_LASTRESETYR
40 DP_LASTRESETPD Number(2,0) SMALLINT NOT NULL DP_LASTRESETPD
41 DP_CURRENTMODELYR Number(4,0) SMALLINT NOT NULL DP_CURRENTMODELYR
42 DP_CURRENTMODELPD Number(2,0) SMALLINT NOT NULL DP_CURRENTMODELPD
43 DP_FC_EFFYR Number(4,0) SMALLINT NOT NULL DP_FC_EFFYR
44 DP_FC_EFFPD Number(3,0) SMALLINT NOT NULL DP_FC_EFFPD
45 DP_MA_PERIODS Number(3,0) SMALLINT NOT NULL DP_MA_PERIODS
46 DP_SUSPENDEDITEM Character(1) VARCHAR2(1) NOT NULL DP_SUSPENDEDITEM

Y/N Table Edit

Default Value: N

47 DP_EVALPERIODS Number(2,0) SMALLINT NOT NULL DP_EVALPERIODS
48 DP_UPDATETOINVPOL Character(1) VARCHAR2(1) NOT NULL DP_UPDATETOINVPOL

Y/N Table Edit

49 DP_AUDITREVIEWDONE Character(1) VARCHAR2(1) NOT NULL DP_AUDITREVIEWDONE

Y/N Table Edit

Default Value: N

50 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
51 DP_LIFEPROFILE Character(10) VARCHAR2(10) NOT NULL DP_LIFEPROFILE
52 DP_ERRORRATIO Number(17,6) DECIMAL(16,6) NOT NULL DP_ERRORRATIO
53 DP_TRACKSIGNAL00 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL00
54 DP_TRACKSIGNAL01 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL01
55 DP_TRACKSIGNAL02 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL02
56 DP_TRACKSIGNAL03 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL03
57 DP_TRACKSIGNAL04 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL04
58 DP_TRACKSIGNAL05 Signed Number(7,4) DECIMAL(5,4) NOT NULL DP_TRACKSIGNAL05
59 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
60 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
61 DP_ROUNDDECIMALS Signed Number(3,0) DECIMAL(2) NOT NULL DP_ROUNDDECIMALS
62 DP_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE

Prompt Table: DP_WTPROFILES

63 DP_UD01 Character(30) VARCHAR2(30) NOT NULL DP_UD01
64 DP_UD02 Character(30) VARCHAR2(30) NOT NULL DP_UD02
65 DP_UD03 Character(30) VARCHAR2(30) NOT NULL DP_UD03
66 DP_UD04 Character(30) VARCHAR2(30) NOT NULL DP_UD04
67 DP_UD05 Character(30) VARCHAR2(30) NOT NULL DP_UD05
68 DP_UD06 Character(30) VARCHAR2(30) NOT NULL DP_UD06
69 DP_UD07 Character(30) VARCHAR2(30) NOT NULL DP_UD07
70 DP_UD08 Character(30) VARCHAR2(30) NOT NULL DP_UD08
71 DP_UD09 Character(30) VARCHAR2(30) NOT NULL DP_UD09
72 DP_UD10 Character(30) VARCHAR2(30) NOT NULL DP_UD10
73 DP_UD11 Character(20) VARCHAR2(20) NOT NULL DP_UD11
74 DP_UD12 Character(20) VARCHAR2(20) NOT NULL DP_UD12
75 DP_UD13 Character(20) VARCHAR2(20) NOT NULL DP_UD13
76 DP_UD14 Character(20) VARCHAR2(20) NOT NULL DP_UD14
77 DP_UD15 Character(20) VARCHAR2(20) NOT NULL DP_UD15
78 DP_UD16 Character(20) VARCHAR2(20) NOT NULL DP_UD16
79 DP_UD17 Character(20) VARCHAR2(20) NOT NULL DP_UD17
80 DP_UD18 Character(20) VARCHAR2(20) NOT NULL DP_UD18
81 DP_UD19 Character(20) VARCHAR2(20) NOT NULL DP_UD19
82 DP_UD20 Character(20) VARCHAR2(20) NOT NULL DP_UD20
83 DP_UD21 Character(10) VARCHAR2(10) NOT NULL DP_UD21
84 DP_UD22 Character(10) VARCHAR2(10) NOT NULL DP_UD22
85 DP_UD23 Character(10) VARCHAR2(10) NOT NULL DP_UD23
86 DP_UD24 Character(10) VARCHAR2(10) NOT NULL DP_UD24
87 DP_UD25 Character(10) VARCHAR2(10) NOT NULL DP_UD25
88 DP_UD26 Character(10) VARCHAR2(10) NOT NULL DP_UD26
89 DP_UD27 Character(10) VARCHAR2(10) NOT NULL DP_UD27
90 DP_UD28 Character(10) VARCHAR2(10) NOT NULL DP_UD28
91 DP_UD29 Character(10) VARCHAR2(10) NOT NULL DP_UD29
92 DP_UD30 Character(10) VARCHAR2(10) NOT NULL DP_UD30
93 DP_UD31 Character(10) VARCHAR2(10) NOT NULL DP_UD31
94 DP_UD32 Character(10) VARCHAR2(10) NOT NULL DP_UD32
95 DP_UD33 Character(10) VARCHAR2(10) NOT NULL DP_UD33
96 DP_UD34 Character(10) VARCHAR2(10) NOT NULL DP_UD34
97 DP_UD35 Character(10) VARCHAR2(10) NOT NULL DP_UD35
98 DP_UD36 Character(10) VARCHAR2(10) NOT NULL DP_UD36
99 DP_UD37 Character(10) VARCHAR2(10) NOT NULL DP_UD37
100 DP_UD38 Character(10) VARCHAR2(10) NOT NULL DP_UD38
101 DP_UD39 Character(10) VARCHAR2(10) NOT NULL DP_UD39
102 DP_UD40 Character(10) VARCHAR2(10) NOT NULL DP_UD40
103 DP_UD41 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD41
104 DP_UD42 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD42
105 DP_UD43 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD43
106 DP_UD44 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD44
107 DP_UD45 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD45
108 DP_UD46 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD46
109 DP_UD47 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD47
110 DP_UD48 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD48
111 DP_UD49 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD49
112 DP_UD50 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD50
113 DP_SUMMGROUP DateTime(26) TIMESTAMP DP_SUMMGROUP
114 DP_MA_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_MA_FINALLEVEL
115 DP_MA_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_MA_ALPHA
116 DP_WMA_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_WMA_FINALLEVEL
117 DP_WMA_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_WMA_ALPHA
118 DP_LR_FTEST Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_FTEST
119 DP_LR_INTERCEPT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_INTERCEPT
120 DP_LR_SLOPE Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_SLOPE
121 DP_LR_ELASTICITY Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_ELASTICITY
122 DP_LR_TTEST1 Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_TTEST1
123 DP_LR_TTEST2 Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_TTEST2
124 DP_SES_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_SES_FINALLEVEL
125 DP_SES_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_SES_ALPHA
126 DP_AES_BETA Number(21,4) DECIMAL(20,4) NOT NULL DP_AES_BETA
127 DP_DESB_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_DESB_ALPHA
128 DP_DESH_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_DESH_FINALLEVEL
129 DP_DESH_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_DESH_ALPHA
130 DP_DESH_GAMMA Number(21,4) DECIMAL(20,4) NOT NULL DP_DESH_GAMMA
131 DP_DESH_FINALTREND Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_DESH_FINALTREND
132 DP_TESB_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_TESB_ALPHA
133 DP_CROSTON_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_CROSTON_ALPHA
134 DP_HW_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_HW_FINALLEVEL
135 DP_HW_ALPHA Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_ALPHA
136 DP_HW_BETA Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_BETA
137 DP_HW_GAMMA Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_GAMMA
138 DP_HW_FINALTREND Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_HW_FINALTREND
139 DP_X11_IRREGAVSTAT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_X11_IRREGAVSTAT
140 DP_BOX_ACF_BOUNDRY Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_ACF_BOUNDRY
141 DP_BOX_AR_PARAM Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_AR_PARAM
142 DP_BOX_AR_SEAS_PAR Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_AR_SEAS_PAR
143 DP_BOX_CONST_PARAM Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_CONST_PARAM
144 DP_BOX_MA_PARAM Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_MA_PARAM
145 DP_BOX_MA_SEAS_PAR Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_MA_SEAS_PAR
146 DP_BOX_NONSEAS_D Number(1,0) SMALLINT NOT NULL DP_BOX_NONSEAS_D
147 DP_BOX_NONSEAS_P Number(16,0) DECIMAL(16) NOT NULL DP_BOX_NONSEAS_P
148 DP_BOX_NONSEAS_PDE Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_NONSEAS_PDE
149 DP_BOX_NONSEAS_PIN Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_NONSEAS_PIN
150 DP_BOX_NONSEAS_Q Number(16,0) DECIMAL(16) NOT NULL DP_BOX_NONSEAS_Q
151 DP_BOX_NONSEAS_QDE Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_NONSEAS_QDE
152 DP_BOX_NONSEAS_QIN Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_NONSEAS_QIN
153 DP_BOX_NUM_LAGS Number(5,0) INTEGER NOT NULL DP_BOX_NUM_LAGS
154 DP_BOX_SEAS_D Number(1,0) SMALLINT NOT NULL DP_BOX_SEAS_D
155 DP_BOX_SEAS_LEN Number(5,0) INTEGER NOT NULL DP_BOX_SEAS_LEN
156 DP_BOX_SEAS_P Number(16,0) DECIMAL(16) NOT NULL DP_BOX_SEAS_P
157 DP_BOX_SEAS_PINIT Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_SEAS_PINIT
158 DP_BOX_SEAS_PDECAY Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_SEAS_PDECAY
159 DP_BOX_SEAS_Q Number(16,0) DECIMAL(16) NOT NULL DP_BOX_SEAS_Q
160 DP_BOX_SEAS_QINIT Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_SEAS_QINIT
161 DP_BOX_SEAS_QDECAY Number(21,4) DECIMAL(20,4) NOT NULL DP_BOX_SEAS_QDECAY
162 DP_AIC Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_AIC
163 DP_BIC Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BIC
164 DP_CHI_SQR Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_CHI_SQR
165 DP_COCHRANE Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_COCHRANE
166 DP_DW Number(21,4) DECIMAL(20,4) NOT NULL DP_DW
167 DP_LJUNG_BOX Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LJUNG_BOX
168 DP_ME Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_ME
169 DP_MAE Number(21,4) DECIMAL(20,4) NOT NULL DP_MAE
170 DP_MAPE Number(21,4) DECIMAL(20,4) NOT NULL DP_MAPE
171 DP_MSE Number(21,4) DECIMAL(20,4) NOT NULL DP_MSE
172 DP_NORMALITY Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_NORMALITY
173 DP_RSQUARE Number(21,4) DECIMAL(20,4) NOT NULL DP_RSQUARE
174 DP_ADJ_RSQUARE Number(21,4) DECIMAL(20,4) NOT NULL DP_ADJ_RSQUARE
175 DP_RMSE Number(21,4) DECIMAL(20,4) NOT NULL DP_RMSE
176 DP_SDE Number(21,4) DECIMAL(20,4) NOT NULL DP_SDE
177 DP_SSE Number(21,4) DECIMAL(20,4) NOT NULL DP_SSE
178 DP_SSR Number(21,4) DECIMAL(20,4) NOT NULL DP_SSR
179 DP_X11_TTEST Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_X11_TTEST
180 DP_THEIL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_THEIL
181 DP_STDDEV Number(22,4) DECIMAL(21,4) NOT NULL DP_STDDEV
182 DP_INHIBITED Character(1) VARCHAR2(1) NOT NULL DP_INHIBITED

Y/N Table Edit

Default Value: N

183 DP_ROLLBACKPERIODS Number(3,0) SMALLINT NOT NULL DP_ROLLBACKPERIODS
1=Additive
2=Multiplicative
184 DP_SEASONALITYTYPE Character(1) VARCHAR2(1) NOT NULL DP_SEASONALITYTYPE
1=Additive
2=Multiplicative

Default Value: 2

185 DP_ACCURACY_STAT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_ACCURACY_STAT
1=Additive
2=Multiplicative
186 DP_BOX_TRANS_METH Character(1) VARCHAR2(1) NOT NULL DP_BOX_TRANS_METH

Default Value: 2

187 DP_LASTEVALPDS Number(3,0) SMALLINT NOT NULL DP_LASTEVALPDS
188 DP_DEMANDAVERAGE Number(13,2) DECIMAL(12,2) NOT NULL DP_DEMANDAVERAGE
189 DP_RESTART_CONTROL Character(7) VARCHAR2(7) NOT NULL DP_RESTART_CONTROL
190 DP_ALPHA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_ALPHA
191 DP_BETA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_BETA
192 DP_GAMMA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_GAMMA
193 DP_SLOPE_DEFAULT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_SLOPE
194 DP_INTERCEPT_DEF Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_INTERCEPT
195 DP_LASTCHANGEDATE DateTime(26) TIMESTAMP DP_LASTCHANGEDATE
196 DP_DATESTAMP DateTime(26) TIMESTAMP DP_DATESTAMP