DPA_CONTROLGRPS(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_CONTROLGRPS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
| 2 | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table:
DP_CONFIGVIEWS
|
|
| 3 | Character(20) | VARCHAR2(20) NOT NULL | DP_CONTROLGROUP | |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_DESCRIPTION | Character(120) | VARCHAR2(120) NOT NULL | Description |
| 6 | DP_ERRCOEFF_LIMIT | Number(21,4) | DECIMAL(20,4) NOT NULL | DP_ERRCOEFF_LIMIT |
| 7 | DP_TRACKINGTEST | Number(5,3) | DECIMAL(4,3) NOT NULL | DP_TRACKINGTEST |
| 8 | DP_TRACKSIGLMT | Number(1,0) | SMALLINT NOT NULL | DP_TRACKSIGLMT |
| 9 | DP_MODELCHGFREQ | Number(2,0) | SMALLINT NOT NULL | DP_MODELCHGFREQ |
| 10 | DP_SUSP_FCPERIODS | Number(4,0) | SMALLINT NOT NULL | DP_SUSP_FCPERIODS |
| 11 | DP_REASGROWTHLOW | Number(3,0) | SMALLINT NOT NULL | DP_REASGROWTHLOW |
| 12 | DP_REASGROWTHHIGH | Number(3,0) | SMALLINT NOT NULL | DP_REASGROWTHHIGH |
| 13 | DP_DEPROMOTE | Character(1) | VARCHAR2(1) NOT NULL |
DP_DEPROMOTE
Y/N Table Edit |
| 14 | DP_HISTRESETSTAT | Character(1) | VARCHAR2(1) NOT NULL |
DP_HISTRESETSTAT
Y/N Table Edit |
| 15 | DP_HISTRESETPROR | Character(1) | VARCHAR2(1) NOT NULL |
DP_HISTRESETPROR
Y/N Table Edit |
| 16 | DP_HISTRESETADJ | Character(1) | VARCHAR2(1) NOT NULL |
DP_HISTRESETADJ
Y/N Table Edit |
| 17 | DP_LIFECHGTHRESHLD | Number(6,2) | DECIMAL(5,2) NOT NULL | DP_LIFECHGTHRESHLD |
| 18 | DP_BF_SEAS_TYPE | Character(25) | VARCHAR2(25) NOT NULL |
DP_BF_SEAS_TYPE
Prompt Table: DP_SEASTYPES_VW |
| 19 | DP_BF_ACCURACY | Character(40) | VARCHAR2(40) NOT NULL |
DP_BF_ACCURACY
Prompt Table: DP_ACCYMETHD_VW |
| 20 | DP_REPL_OUTLIERS | Character(1) | VARCHAR2(1) NOT NULL |
DP_REPL_OUTLIERS
Y/N Table Edit |
| 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 |
| 27 | DP_SIM_MA | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_MA
Y/N Table Edit |
| 28 | DP_SIM_WMA | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_WMA
Y/N Table Edit |
| 29 | DP_SIM_LR | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_LR
Y/N Table Edit |
| 30 | DP_SIM_SES | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_SES
Y/N Table Edit |
| 31 | DP_SIM_AES | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_AES
Y/N Table Edit |
| 32 | DP_SIM_DESB | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_DESB
Y/N Table Edit |
| 33 | DP_SIM_DESH | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_DESH
Y/N Table Edit |
| 34 | DP_SIM_TESB | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_TESB
Y/N Table Edit |
| 35 | DP_SIM_HW | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_HW
Y/N Table Edit |
| 36 | DP_SIM_HW_MULT | Character(1) | VARCHAR2(1) NOT NULL | DP_SIM_HW |
| 37 | DP_SIM_CROSTON | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_CROSTON
Y/N Table Edit |
| 38 | DP_SIM_CENSUSX11 | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_CENSUSX11
Y/N Table Edit |
| 39 | DP_SIM_BOX | Character(1) | VARCHAR2(1) NOT NULL |
DP_SIM_BOX
Y/N Table Edit |
| 40 | DP_LIFE_TRACKTEST | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_LIFE_TRACKTEST |
| 41 | DP_TS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_TS_TYPE
1=Exponential Smoothing 2=Average |
| 42 | DP_TS_SMOOTHINGWT | Number(6,4) | DECIMAL(5,4) NOT NULL | DP_TS_SMOOTHINGWT |
| 43 | DP_MA_SIM_PDS1 | Number(2,0) | SMALLINT NOT NULL | DP_MA_SIM_PDS1 |
| 44 | DP_MA_SIM_PDS2 | Number(2,0) | SMALLINT NOT NULL | DP_MA_SIM_PDS2 |
| 45 | DP_MA_SIM_PDS3 | Number(2,0) | SMALLINT NOT NULL | DP_MA_SIM_PDS3 |
| 46 | DP_MA_SIM_PDS4 | Number(2,0) | SMALLINT NOT NULL | DP_MA_SIM_PDS4 |
| 47 | DP_MA_SIM_PDS5 | Number(2,0) | SMALLINT NOT NULL | DP_MA_SIM_PDS5 |
| 48 | DP_EVAL_RESETSTAT | Character(1) | VARCHAR2(1) NOT NULL |
DP_EVAL_RESETSTAT
Y/N Table Edit |
| 49 | DP_EVAL_RESETPRO | Character(1) | VARCHAR2(1) NOT NULL |
DP_EVAL_RESETPRO
Y/N Table Edit |
| 50 | DP_EVAL_RESETADJ | Character(1) | VARCHAR2(1) NOT NULL |
DP_EVAL_RESETADJ
Y/N Table Edit |
| 51 | DP_ERRORRATIOTYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_ERRORRATIOTYPE
0=Statistical 1=Prorated 2=Adjusted |