PSARCH_IDDP_SUMMSPECDP_CONFIGVIEWPrompt Table: DP_CFGVWUSER_VW
Prompt Table: DP_CONFIGLEVELS
Prompt Table: DP_CONFIGLEVELS
Prompt Table: DP_FCITEMS1_VW
Y/N Table Edit
Y/N Table Edit
DPA_SUMM_SPEC(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_SUMM_SPEC |
| # | 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_SUMMSPEC |
Character(20) | VARCHAR2(20) NOT NULL | DP_SUMMSPEC |
| 3 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CFGVWUSER_VW |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_FROMLEVEL | Number(3,0) | SMALLINT NOT NULL |
DP_FROMLEVEL
Prompt Table: DP_CONFIGLEVELS |
| 6 | DP_TOLEVEL | Number(2,0) | SMALLINT NOT NULL |
DP_TOLEVEL
Prompt Table: DP_CONFIGLEVELS |
| 7 | DP_FORECASTITEM | Character(120) | VARCHAR2(120) NOT NULL |
DP_FORECASTITEM
Prompt Table: DP_FCITEMS1_VW |
| 8 | DP_FROMPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_FROMPERIOD |
| 9 | DP_FROMYEAR | Number(4,0) | SMALLINT NOT NULL | DP_FROMYEAR |
| 10 | DP_TOPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_TOPERIOD |
| 11 | DP_TOYEAR | Number(4,0) | SMALLINT NOT NULL | DP_TOYEAR |
| 12 | DP_CREATEGROUPS | Character(1) | VARCHAR2(1) NOT NULL |
DP_CREATEGROUPS
Y/N Table Edit |
| 13 | DP_DELETEGROUPS | Character(1) | VARCHAR2(1) NOT NULL |
DP_DELETEGROUPS
Y/N Table Edit |
| 14 | DP_ROUNDDECIMALS | Signed Number(3,0) | DECIMAL(2) NOT NULL | DP_ROUNDDECIMALS |
| 15 | DP_PDSPERYEAR | Number(2,0) | SMALLINT NOT NULL | DP_PDSPERYEAR |
| 16 | DP_LASTDEMAND | Character(8) | VARCHAR2(8) NOT NULL | DP_LASTDEMAND |
| 17 | DP_FIRSTFORECAST | Character(8) | VARCHAR2(8) NOT NULL | DP_FIRSTFORECAST |
| 18 | DP_LASTFORECAST | Character(8) | VARCHAR2(8) NOT NULL | DP_LASTFORECAST |
| 19 | DP_THRESHOLDPCT | Number(3,0) | SMALLINT NOT NULL | DP_THRESHOLDPCT |
| 20 | DP_CHKACTDEMAND | Number(1,0) | SMALLINT NOT NULL | DP_CHKACTDEMAND |
| 21 | DP_CHKADJDEMAND | Number(1,0) | SMALLINT NOT NULL | DP_CHKADJDEMAND |
| 22 | DP_CHKADJFORE | Number(1,0) | SMALLINT NOT NULL | DP_CHKADJFORE |
| 23 | DP_CHKDMDVALUE | Number(1,0) | SMALLINT NOT NULL | DP_CHKDMDVALUE |
| 24 | DP_CHKADJREASON | Number(1,0) | SMALLINT NOT NULL | DP_CHKADJREASON |
| 25 | DP_CHKFORE01 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE01 |
| 26 | DP_CHKFORE02 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE02 |
| 27 | DP_CHKFORE03 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE03 |
| 28 | DP_CHKFORE04 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE04 |
| 29 | DP_CHKFORE05 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE05 |
| 30 | DP_CHKFORE06 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE06 |
| 31 | DP_CHKFORE07 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE07 |
| 32 | DP_CHKFORE08 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE08 |
| 33 | DP_CHKFORE09 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE09 |
| 34 | DP_CHKFORE10 | Number(1,0) | SMALLINT NOT NULL | DP_CHKFORE10 |
| 35 | DP_CHKFOREADJ | Number(1,0) | SMALLINT NOT NULL | DP_CHKFOREADJ |
| 36 | DP_CHKAVEPRICE | Number(1,0) | SMALLINT NOT NULL | DP_CHKAVEPRICE |
| 37 | DP_CHKAVECOST | Number(1,0) | SMALLINT NOT NULL | DP_CHKAVECOST |
| 38 | DP_CHKPERIODPRICE | Number(1,0) | SMALLINT NOT NULL | DP_CHKPERIODPRICE |
| 39 | DP_CHKPRORATED | Number(1,0) | SMALLINT NOT NULL | DP_CHKPRORATED |
| 40 | DP_CHKSTATISTICAL | Number(1,0) | SMALLINT NOT NULL | DP_CHKSTATISTICAL |
| 41 | DP_CHKSUMMARY | Number(1,0) | SMALLINT NOT NULL | DP_CHKSUMMARY |
| 42 | DP_CHKUSER01 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER01 |
| 43 | DP_CHKUSER02 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER02 |
| 44 | DP_CHKUSER03 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER03 |
| 45 | DP_CHKUSER04 | Number(2,0) | SMALLINT NOT NULL | DP_CHKUSER04 |
| 46 | DP_CHKUSER05 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER05 |
| 47 | DP_CHKUSER06 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER06 |
| 48 | DP_CHKUSER07 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER07 |
| 49 | DP_CHKUSER08 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER08 |
| 50 | DP_CHKUSER09 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER09 |
| 51 | DP_CHKUSER10 | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSER10 |
| 52 | DP_CHKUSERFLDS | Number(1,0) | SMALLINT NOT NULL | DP_CHKUSERFLDS |
| 53 | DP_CHKCUBE | Number(1,0) | SMALLINT NOT NULL | DP_CHKCUBE |
| 54 | DP_CHKWEIGHT | Number(1,0) | SMALLINT NOT NULL | DP_CHKWEIGHT |
| 55 | DP_PROCEED_BTN | Character(1) | VARCHAR2(1) NOT NULL | Proceed |
| 56 | DP_CHKHSTADJFC | Number(1,0) | SMALLINT NOT NULL | Adjusted Forecast History |
| 57 | DP_CHKHSTPROFC | Number(1,0) | SMALLINT NOT NULL | Prorated Forecast History |
| 58 | DP_CHKHSTSTATFC | Number(1,0) | SMALLINT NOT NULL | Statistical Forecast History |
| 59 | DP_CHKEVALADJ | Number(1,0) | SMALLINT NOT NULL | Evaluated Adjusted Forecast |
| 60 | DP_CHKEVALPRO | Number(1,0) | SMALLINT NOT NULL | Evaluated Prorated Forecast |
| 61 | DP_CHKEVALSTAT | Number(1,0) | SMALLINT NOT NULL | Evaluated Statistical Forecast |
| 62 | DP_CHKHSTEADJ | Number(1,0) | SMALLINT NOT NULL | Evaluated Adjusted History |
| 63 | DP_CHKHSTEPRO | Number(1,0) | SMALLINT NOT NULL | Evaluated Prorated History |
| 64 | DP_CHKHSTESTAT | Number(1,0) | SMALLINT NOT NULL | Evaluated Statistical History |