| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_CONFIGVIEW |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
|
| 2 |
DP_CONFIGLEVEL |
Number(2,0) |
SMALLINT NOT NULL |
DP_CONFIGLEVEL
|
| 3 |
DP_FORECASTITEM |
Character(120) |
VARCHAR2(120) NOT NULL |
DP_FORECASTITEM
|
| 4 |
DP_FCST_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Forecast Year
|
| 5 |
DP_FCST_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
DP_FCST_PERIOD
|
| 6 |
DP_CALCYEARPERIOD |
Number(6,0) |
INTEGER NOT NULL |
DP_CALCYEARPERIOD
|
| 7 |
DP_DATESTAMP |
DateTime(26) |
TIMESTAMP |
DP_DATESTAMP
|
| 8 |
DP_ACTUALDEMAND |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_ACTUALDEMAND
|
| 9 |
DP_DEMANDVALUE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_DEMANDVALUE
|
| 10 |
DP_ADJDEMAND |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Adjusted Demand
|
| 11 |
DP_DMD_PROCESS_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DMD_PROCESS_ACT
0=Not Adjusted
1=Direct
|
| 12 |
DP_DMD_COMMENT |
Character(50) |
VARCHAR2(50) NOT NULL |
DP_DMD_COMMENT
|
| 13 |
DP_STATFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STATFORECAST
|
| 14 |
DP_PROFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PROFORECAST
|
| 15 |
DP_ADJFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ADJFORECAST
|
| 16 |
DP_FORECASTADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECASTADJ
|
| 17 |
DP_FC_PROCESS_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FC_PROCESS_ACT
0=Not Adjusted/Prorated
1=Not Adjusted/Not Prorated
2=Direct/Prorated
3=Direct/Not Prorated
4=Promoted/Prorated
5=Promoted/Not Prorated
6=Event/Prorated
7=Event/Not Prorated
|
| 18 |
DP_FC_COMMENT |
Character(50) |
VARCHAR2(50) NOT NULL |
DP_FC_COMMENT
|
| 19 |
DP_SUMMFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_SUMMFORECAST
|
| 20 |
DP_EVALSTATFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALSTATFORE
|
| 21 |
DP_EVALADJFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALADJFORE
|
| 22 |
DP_EVALPRORFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALPRORFORE
|
| 23 |
DP_RESULTANTADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_RESULTANTADJ
|
| 24 |
DP_RES_PROCESS_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_RES_PROCESS_ACT
0=Not Adjusted/Prorated
1=Not Adjusted/Not Prorated
2=Direct/Prorated
3=Direct/Not Prorated
4=Promoted/Prorated
5=Promoted/Not Prorated
6=Event/Prorated
7=Event/Not Prorated
Default Value: 0
|
| 25 |
DP_PERIODPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODPRICE
|
| 26 |
DP_PERIODCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODCOST
|
| 27 |
DP_PERIODAVGPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODAVGPRICE
|
| 28 |
DP_MAPEADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPEADJ
|
| 29 |
DP_MAPEPROR |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPEPROR
|
| 30 |
DP_MAPESTAT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPESTAT
|
| 31 |
DP_MAPEEVALADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPEEVALADJ
|
| 32 |
DP_MAPEEVALPROR |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPEEVALPROR
|
| 33 |
DP_MAPEEVALSTAT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAPEEVALSTAT
|
| 34 |
DP_USERDATA01 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA01
|
| 35 |
DP_USERDATA02 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA02
|
| 36 |
DP_USERDATA03 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA03
|
| 37 |
DP_USERDATA04 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA04
|
| 38 |
DP_USERDATA05 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA05
|
| 39 |
DP_USERDATA06 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA06
|
| 40 |
DP_USERDATA07 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA07
|
| 41 |
DP_USERDATA08 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_USERDATA08
|
| 42 |
DP_USERDATA09 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_USERDATA09
|
| 43 |
DP_USERDATA10 |
Date(10) |
DATE |
DP_USERDATA10
|
| 44 |
DP_FORECAST01 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST01
|
| 45 |
DP_FORECAST02 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST02
|
| 46 |
DP_FORECAST03 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST03
|
| 47 |
DP_FORECAST04 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST04
|
| 48 |
DP_FORECAST05 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST05
|
| 49 |
DP_FORECAST06 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST06
|
| 50 |
DP_FORECAST07 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST07
|
| 51 |
DP_FORECAST08 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST08
|
| 52 |
DP_FORECAST09 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST09
|
| 53 |
DP_FORECAST10 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST10
|
| 54 |
DP_ACTDEMAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_ACTDEMAUDIT
Y/N Table Edit
|
| 55 |
DP_ADJDEMAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_ADJDEMAUDIT
Y/N Table Edit
|
| 56 |
DP_ADJFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_ADJFOREAUDIT
Y/N Table Edit
|
| 57 |
DP_EVADJFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_EVADJFOREAUDIT
Y/N Table Edit
|
| 58 |
DP_EVPROFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_EVPROFOREAUDIT
Y/N Table Edit
|
| 59 |
DP_EVSTATFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_EVSTATFOREAUDIT
Y/N Table Edit
|
| 60 |
DP_FOREADJAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FOREADJAUDIT
Y/N Table Edit
|
| 61 |
DP_FORECAST01AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST01AUDIT
Y/N Table Edit
|
| 62 |
DP_FORECAST02AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST02AUDIT
Y/N Table Edit
|
| 63 |
DP_FORECAST03AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST03AUDIT
Y/N Table Edit
|
| 64 |
DP_FORECAST04AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST04AUDIT
Y/N Table Edit
|
| 65 |
DP_FORECAST05AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST05AUDIT
Y/N Table Edit
|
| 66 |
DP_FORECAST06AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST06AUDIT
Y/N Table Edit
|
| 67 |
DP_FORECAST07AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST07AUDIT
Y/N Table Edit
|
| 68 |
DP_FORECAST08AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST08AUDIT
Y/N Table Edit
|
| 69 |
DP_FORECAST09AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST09AUDIT
Y/N Table Edit
|
| 70 |
DP_FORECAST10AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FORECAST10AUDIT
Y/N Table Edit
|
| 71 |
DP_MAPEADJAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEADJAUDIT
Y/N Table Edit
|
| 72 |
DP_MAPEEVADJAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVADJAUDIT
Y/N Table Edit
|
| 73 |
DP_MAPEEVPRORAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVPRORAUDIT
Y/N Table Edit
|
| 74 |
DP_MAPEEVSTATAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVSTATAUDIT
Y/N Table Edit
|
| 75 |
DP_MAPEPRORAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEPRORAUDIT
Y/N Table Edit
|
| 76 |
DP_MAPESTATAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPESTATAUDIT
Y/N Table Edit
|
| 77 |
DP_PROFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_PROFOREAUDIT
Y/N Table Edit
|
| 78 |
DP_RESULTADJAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_RESULTADJAUDIT
Y/N Table Edit
|
| 79 |
DP_STATFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_STATFOREAUDIT
Y/N Table Edit
|
| 80 |
DP_SUMMFOREAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_SUMMFOREAUDIT
Y/N Table Edit
|
| 81 |
DP_USERDATA01AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA01AUDIT
Y/N Table Edit
|
| 82 |
DP_USERDATA02AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA02AUDIT
Y/N Table Edit
|
| 83 |
DP_USERDATA03AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA03AUDIT
Y/N Table Edit
|
| 84 |
DP_USERDATA04AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA04AUDIT
Y/N Table Edit
|
| 85 |
DP_USERDATA05AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA05AUDIT
Y/N Table Edit
|
| 86 |
DP_USERDATA06AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA06AUDIT
Y/N Table Edit
|
| 87 |
DP_USERDATA07AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_USERDATA07AUDIT
Y/N Table Edit
|
| 88 |
DP_DMDVALUEAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Reference # Description
08/28/07 TH ICE 1688432000 Corrected Auditing of Period Price, Period Cost, Period Average Price and Demand Value - new audit flag field
Y/N Table Edit
Default Value: N
|
| 89 |
DP_PDAVGPRICEAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Reference # Description
08/28/07 TH ICE 1688432000 Corrected Auditing of Period Price, Period Cost, Period Average Price and Demand Value - new audit flag field
Y/N Table Edit
Default Value: N
|
| 90 |
DP_PDCOSTAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Reference # Description
08/28/07 TH ICE 1688432000 Corrected Auditing of Period Price, Period Cost, Period Average Price and Demand Value - new audit flag field
Y/N Table Edit
Default Value: N
|
| 91 |
DP_PDPRICEAUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Reference # Description
08/28/07 TH ICE 1688432000 Corrected Auditing of Period Price, Period Cost, Period Average Price and Demand Value - new audit flag field
Y/N Table Edit
Default Value: N
|