DPA_FCITEMSTATS

(SQL Table)
 Index Back

DP Archive Record

Online: DP_FCITEMSTATS

  • Parent record: DP_FCITEMS

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

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