PROCESS_INSTANCEPrompt Table: DP_CAL2_VW
Prompt Table: DP_CALTIME_VW
DP_PUBCFGVW_AET(SQL Table) |
Index Back |
|---|---|
Forecast View Info table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DP_FCSTARTYEAR | Number(4,0) | SMALLINT NOT NULL | DP_FCSTARTYEAR |
| 3 | DP_FCSTARTPERIOD | Number(3,0) | SMALLINT NOT NULL | DP_FCSTARTPERIOD |
| 4 | DP_CONFIGHISTPDS | Number(3,0) | SMALLINT NOT NULL | DP_CONFIGHISTPDS |
| 5 | DP_CONFIGFUTUREPDS | Number(3,0) | SMALLINT NOT NULL | DP_CONFIGFUTUREPDS |
| 6 | DP_CALENDARID | Character(20) | VARCHAR2(20) NOT NULL |
DP_CALENDARID
Prompt Table: DP_CAL2_VW |
| 7 | DP_TIMEPERIODCODE | Character(10) | VARCHAR2(10) NOT NULL |
DP_TIMEPERIODCODE
Prompt Table: DP_CALTIME_VW |
| 8 | DP_WEIGHTPROFILE | Character(20) | VARCHAR2(20) NOT NULL | DP_WEIGHTPROFILE |
| 9 | DP_ROUNDDECIMALS | Signed Number(3,0) | DECIMAL(2) NOT NULL | DP_ROUNDDECIMALS |
| 10 | DP_PDSPERYEAR | Number(2,0) | SMALLINT NOT NULL | DP_PDSPERYEAR |
| 11 | DP_USERDATACODE | Character(20) | VARCHAR2(20) NOT NULL | DP_USERDATACODE |