OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDDP_XVIEWSPECPrompt Table: DP_XVIEWSPEC_VW
Prompt Table: DP_CONFIGVIEWS
Prompt Table: %EDITTABLE
Prompt Table: DP_ADJ_REASONS
DP_RUN_CNTL_XVW(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DP_XVIEWSPEC |
Character(20) | VARCHAR2(20) NOT NULL |
DP_XVIEWSPEC
Prompt Table: DP_XVIEWSPEC_VW |
| 4 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CONFIGVIEWS |
| 5 | DP_TARGETVIEW | Character(20) | VARCHAR2(20) NOT NULL |
DP_TARGETVIEW
Prompt Table: %EDITTABLE |
| 6 | DP_TIMEPERIODCODE | Character(10) | VARCHAR2(10) NOT NULL | DP_TIMEPERIODCODE |
| 7 | DP_HISTDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_HISTDEMANDPDS |
| 8 | DP_CONFIGFUTUREPDS | Number(3,0) | SMALLINT NOT NULL | DP_CONFIGFUTUREPDS |
| 9 | DP_TOPDYR | Character(7) | VARCHAR2(7) NOT NULL | DP_TOPDYR |
| 10 | DP_ADJ_REASON | Character(8) | VARCHAR2(8) NOT NULL |
DP_ADJ_REASON
Prompt Table: DP_ADJ_REASONS |
| 11 | DP_ADJ_COMMENT | Character(50) | VARCHAR2(50) NOT NULL | DP_ADJ_COMMENT |