DP_CONTROLGRPS

(SQL Table)
 Index Back

Control Groups

Control Groups

  • Parent Record Of DPA_CTLGRPWRKQU DPIP_CTLGRPWRKQ DP_CTLGRPWRKQUE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: DP_CONFIGVIEWS
    Set Control Field: DP_CONFIGVIEW

    2 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    5 DP_ERRCOEFF_LIMIT Number(21,4) DECIMAL(20,4) NOT NULL DP_ERRCOEFF_LIMIT
    6 DP_TRACKINGTEST Number(5,3) DECIMAL(4,3) NOT NULL DP_TRACKINGTEST
    7 DP_TRACKSIGLMT Number(1,0) SMALLINT NOT NULL DP_TRACKSIGLMT
    8 DP_MODELCHGFREQ Number(2,0) SMALLINT NOT NULL DP_MODELCHGFREQ
    9 DP_SUSP_FCPERIODS Number(4,0) SMALLINT NOT NULL DP_SUSP_FCPERIODS
    10 DP_REASGROWTHLOW Number(3,0) SMALLINT NOT NULL DP_REASGROWTHLOW
    11 DP_REASGROWTHHIGH Number(3,0) SMALLINT NOT NULL DP_REASGROWTHHIGH
    12 DP_DEPROMOTE Character(1) VARCHAR2(1) NOT NULL DP_DEPROMOTE

    Y/N Table Edit

    Default Value: N

    13 DP_HISTRESETSTAT Character(1) VARCHAR2(1) NOT NULL DP_HISTRESETSTAT

    Y/N Table Edit

    Default Value: N

    14 DP_HISTRESETPROR Character(1) VARCHAR2(1) NOT NULL DP_HISTRESETPROR

    Y/N Table Edit

    Default Value: N

    15 DP_HISTRESETADJ Character(1) VARCHAR2(1) NOT NULL DP_HISTRESETADJ

    Y/N Table Edit

    Default Value: N

    16 DP_LIFECHGTHRESHLD Number(6,2) DECIMAL(5,2) NOT NULL DP_LIFECHGTHRESHLD
    17 DP_BF_SEAS_TYPE Character(25) VARCHAR2(25) NOT NULL DP_BF_SEAS_TYPE

    Prompt Table: DP_SEASTYPES_VW

    18 DP_BF_ACCURACY Character(40) VARCHAR2(40) NOT NULL DP_BF_ACCURACY

    Prompt Table: DP_ACCYMETHD_VW

    19 DP_TRENDELIMPDS Number(4,0) SMALLINT NOT NULL Trend Elimination Periods
    20 DP_REPL_OUTLIERS Character(1) VARCHAR2(1) NOT NULL DP_REPL_OUTLIERS

    Y/N Table Edit

    Default Value: N

    21 DP_OUTLIERS_SD Number(5,3) DECIMAL(4,3) NOT NULL DP_OUTLIERS_SD
    22 DP_OUTLIERS_RATIO Number(15,4) DECIMAL(14,4) NOT NULL DP_OUTLIERS_RATIO
    23 DP_OUTLIERS_METHOD Character(40) VARCHAR2(40) NOT NULL DP_OUTLIERS_METHOD

    Prompt Table: DP_OUTLMETHD_VW

    24 DP_ROLLBACK_PARAM Signed Number(4,0) DECIMAL(3) NOT NULL DP_ROLLBACK_PARAM
    25 DP_CENSUS_TRNDCYCL Character(38) VARCHAR2(38) NOT NULL DP_CENSUS_TRNDCYCL
    26 DP_CENSUS_TD_ADJ Character(1) VARCHAR2(1) NOT NULL DP_CENSUS_TD_ADJ

    Y/N Table Edit

    Default Value: N

    27 DP_SIM_MA Character(1) VARCHAR2(1) NOT NULL DP_SIM_MA

    Y/N Table Edit

    Default Value: N

    28 DP_SIM_WMA Character(1) VARCHAR2(1) NOT NULL DP_SIM_WMA

    Y/N Table Edit

    Default Value: N

    29 DP_SIM_LR Character(1) VARCHAR2(1) NOT NULL DP_SIM_LR

    Y/N Table Edit

    Default Value: N

    30 DP_SIM_SES Character(1) VARCHAR2(1) NOT NULL DP_SIM_SES

    Y/N Table Edit

    Default Value: N

    31 DP_SIM_AES Character(1) VARCHAR2(1) NOT NULL DP_SIM_AES

    Y/N Table Edit

    Default Value: N

    32 DP_SIM_DESB Character(1) VARCHAR2(1) NOT NULL DP_SIM_DESB

    Y/N Table Edit

    Default Value: N

    33 DP_SIM_DESH Character(1) VARCHAR2(1) NOT NULL DP_SIM_DESH

    Y/N Table Edit

    Default Value: N

    34 DP_SIM_TESB Character(1) VARCHAR2(1) NOT NULL DP_SIM_TESB

    Y/N Table Edit

    Default Value: N

    35 DP_SIM_HW Character(1) VARCHAR2(1) NOT NULL DP_SIM_HW

    Y/N Table Edit

    Default Value: N

    36 DP_SIM_CROSTON Character(1) VARCHAR2(1) NOT NULL DP_SIM_CROSTON

    Y/N Table Edit

    Default Value: N

    37 DP_SIM_CENSUSX11 Character(1) VARCHAR2(1) NOT NULL DP_SIM_CENSUSX11

    Y/N Table Edit

    Default Value: N

    38 DP_SIM_BOX Character(1) VARCHAR2(1) NOT NULL DP_SIM_BOX

    Y/N Table Edit

    Default Value: N

    39 DP_LIFE_TRACKTEST Number(15,4) DECIMAL(14,4) NOT NULL DP_LIFE_TRACKTEST
    40 DP_TS_TYPE Character(1) VARCHAR2(1) NOT NULL DP_TS_TYPE
    1=Exponential Smoothing
    2=Average
    41 DP_TS_SMOOTHINGWT Number(6,4) DECIMAL(5,4) NOT NULL DP_TS_SMOOTHINGWT
    42 DP_MA_SIM_PDS1 Number(2,0) SMALLINT NOT NULL DP_MA_SIM_PDS1
    43 DP_MA_SIM_PDS2 Number(2,0) SMALLINT NOT NULL DP_MA_SIM_PDS2
    44 DP_MA_SIM_PDS3 Number(2,0) SMALLINT NOT NULL DP_MA_SIM_PDS3
    45 DP_MA_SIM_PDS4 Number(2,0) SMALLINT NOT NULL DP_MA_SIM_PDS4
    46 DP_MA_SIM_PDS5 Number(2,0) SMALLINT NOT NULL DP_MA_SIM_PDS5
    47 DP_EVAL_RESETSTAT Character(1) VARCHAR2(1) NOT NULL DP_EVAL_RESETSTAT

    Y/N Table Edit

    Default Value: N

    48 DP_EVAL_RESETPRO Character(1) VARCHAR2(1) NOT NULL DP_EVAL_RESETPRO

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    50 DP_ERRORRATIOTYPE Character(1) VARCHAR2(1) NOT NULL DP_ERRORRATIOTYPE
    0=Statistical
    1=Prorated
    2=Adjusted
    51 DP_ZERODMD_MODEL Character(40) VARCHAR2(40) NOT NULL Default Zero Demand Model

    Prompt Table: DP_DMDMETHD_VW

    52 DP_ALPHA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_ALPHA
    53 DP_BETA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_BETA
    54 DP_GAMMA_DEFAULT Number(21,4) DECIMAL(20,4) NOT NULL DP_HW_GAMMA
    55 DP_SLOPE_DEFAULT Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_SLOPE
    56 DP_INTERCEPT_DEF Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_LR_INTERCEPT
    57 DP_DEF_FINALLEVEL Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_HW_FINALLEVEL
    58 DP_DEF_FINALTREND Signed Number(22,4) DECIMAL(20,4) NOT NULL DP_HW_FINALTREND
    59 DP_SIM_HW_MULT Character(1) VARCHAR2(1) NOT NULL DP_SIM_HW

    Y/N Table Edit

    Default Value: N

    60 DP_SIM_CENSUSX11_M Character(1) VARCHAR2(1) NOT NULL DP_SIM_CENSUSX11

    Y/N Table Edit

    Default Value: N