PSARCH_IDDP_CONFIGVIEWPrompt Table: DP_CONFIGVIEWS
DP_CONFIGLEVELPrompt Table: UNITS_TBL
DPA_CONFIGLEVEL(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_CONFIGLEVELS |
| # | 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_CONFIGLEVEL |
Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_CONFIGSTATUS | Character(10) | VARCHAR2(10) NOT NULL | DP_CONFIGSTATUS |
| 6 | DP_DEFAULTFCITEM | Character(120) | VARCHAR2(120) NOT NULL | DP_DEFAULTFCITEM |
| 7 | DP_DESCRIPTION | Character(120) | VARCHAR2(120) NOT NULL | Description |
| 8 | DP_NEXTLEVELUOMGRP | Character(10) | VARCHAR2(10) NOT NULL |
DP_NEXTLEVELUOMGRP
Prompt Table: UNITS_TBL |
| 9 | DP_FCAST00_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weights |
| 10 | DP_FCAST01_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 01 |
| 11 | DP_FCAST02_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 02 |
| 12 | DP_FCAST03_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 03 |
| 13 | DP_FCAST04_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 04 |
| 14 | DP_FCAST05_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 05 |
| 15 | DP_FCAST06_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 06 |
| 16 | DP_FCAST07_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 07 |
| 17 | DP_FCAST08_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 08 |
| 18 | DP_FCAST09_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 09 |
| 19 | DP_FCAST10_WGT | Number(3,0) | SMALLINT NOT NULL | Forecast Weight 10 |
| 20 | DP_FCAST_WGT01 | Number(3,0) | SMALLINT NOT NULL | Forecast Weight |
| 21 | DP_FCAST00_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Errors |
| 22 | DP_FCAST01_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 01 |
| 23 | DP_FCAST02_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 02 |
| 24 | DP_FCAST03_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 03 |
| 25 | DP_FCAST04_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 04 |
| 26 | DP_FCAST05_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 05 |
| 27 | DP_FCAST06_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 06 |
| 28 | DP_FCAST07_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 07 |
| 29 | DP_FCAST08_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 08 |
| 30 | DP_FCAST09_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 09 |
| 31 | DP_FCAST10_ERR | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error 10 |
| 32 | DP_FCAST_ERR01 | Number(19,4) | DECIMAL(18,4) NOT NULL | Forecast Error |