DPA_CONTROLGRPS(SQL Table) |
Index Back |
---|---|
DP Archive RecordOnline: DP_CONTROLGRPS |
# | 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
Prompt Table:
DP_CONFIGVIEWS
|
3 | DP_CONTROLGROUP | 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 |