DP_FCITEMS

(SQL Table)
 Index Back

Forecast Items

The subrecords contain the following arrays SUBREC_INT = Tracking Signals SUBREC_CHAR = Security Group SUBREC_NBR = Profile Factors

  • Parent Record Of DPA_FCITEMSTATS DPA_FCITEM_UOMS DP_FCITEMSTATS DP_FCITEM_UOMS

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

    Prompt Table: DP_VIEW1USER_VW

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

    Prompt Table: DP_CONFIGLEVELS

    3 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
    4 DP_NEXTLEVEL Number(10,0) DECIMAL(10) NOT NULL DP_NEXTLEVEL
    5 DP_NEXTFCITEM Character(120) VARCHAR2(120) NOT NULL DP_NEXTFCITEM
    6 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION
    7 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP

    Prompt Table: DP_CONTROLGRPS

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: DP_SEASPROFILES

    11 DP_HISTDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_HISTDEMANDPDS
    12 DP_EFFDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_EFFDEMANDPDS
    13 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

    14 DP_CALCULATIONTYPE Character(1) VARCHAR2(1) NOT NULL DP_CALCULATIONTYPE
    0=Best Fit
    1=Reoptimize
    2=No Calculation
    15 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

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

    Prompt Table: UNITS_TBL

    17 DP_WEIGHT Number(13,2) DECIMAL(12,2) NOT NULL DP_WEIGHT
    18 DP_WEIGHTUOM Character(3) VARCHAR2(3) NOT NULL DP_WEIGHTUOM

    Prompt Table: UNITS_TBL

    19 DP_VOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_VOLUME
    20 DP_VOLUMEUOM Character(3) VARCHAR2(3) NOT NULL DP_VOLUMEUOM

    Prompt Table: UNITS_TBL

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

    Prompt Table: UNITS_TBL

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

    Prompt Table: DP_FORECASTER

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

    Y/N Table Edit

    Default Value: N

    44 DP_SUSPENDEDITEM Character(1) VARCHAR2(1) NOT NULL DP_SUSPENDEDITEM

    Y/N Table Edit

    Default Value: N

    45 DP_EVALPERIODS Number(2,0) SMALLINT NOT NULL DP_EVALPERIODS
    46 DP_UPDATETOINVPOL Character(1) VARCHAR2(1) NOT NULL DP_UPDATETOINVPOL

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: DP_WTPROFILES

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 2

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

    Default Value: 2

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

    Y/N Table Edit

    Default Value: N

    199 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

    Default Value: N