DPA_CONTROLGRPS

(SQL Table)
Index Back

DP Archive Record

Online: 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
Set Control Field: DP_CONFIGVIEW

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