DP_FCITEMSTATS

(SQL Table)
 Index Back

Forecast Item Statistics

Forecast Item Statistics

  • Parent record: DP_FCITEMS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    2 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
    3 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
    4 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

    Prompt Table: DP_FCMETHODS_VW

    5 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
    6 DP_X11_TRENDCYCLE Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_X11_TRENDCYCLE
    7 DP_X11_IRREGSTAT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_X11_IRREGSTAT
    8 DP_BOX_PARTIALCOEF Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_PARTIALCOEF
    9 DP_BOX_AUTOCOEFF Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_BOX_AUTOCOEFF
    10 DP_SEASONFACTOR Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_SEASONFACTOR
    11 DP_TRADINGDAYS Number(4,0) SMALLINT NOT NULL DP_TRADINGDAYS