RUN_FINT_DDHUPD(SQL Table) |
Index Back |
|---|---|
Demand Data UpdatesRun Control Table is also used as a log for Demand Data History Updates. Each row is inserted by either Process Scheduler when running routine processes or by the Demand Data Update Component (user initiated). It is updated by AE to log activity per process initiated. Date Initials Reference # Description 03/10/10 TH ICE 1928568000 Changes to help users populate worksheets required by the Process Integration Pack |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DP_SPECS_ID |
Character(20) | VARCHAR2(20) NOT NULL |
DP_SPECS_ID
Prompt Table: FINT_EXP_SPECS |
| 4 | DP_DDHUPD_DTTM | DateTime(26) | TIMESTAMP |
datetime of last update to demand_history table
Default Value: %DateTime |
| 5 | DP_DDHUPD_DATE | Date(10) | DATE |
DP_DDHUPD_DATE
Default Value: %DATE |
| 6 | DP_DDHUPD_DATE_FR | Date(10) | DATE NOT NULL | DP_DDHUPD_DATE_FR |
| 7 | DP_DDHUPD_DATE_TO | Date(10) | DATE NOT NULL | DP_DDHUPD_DATE_TO |
| 8 | DP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | DP_DESCR |
| 9 | DP_DDH_EXEC | Number(3,0) | SMALLINT NOT NULL | Process execution flag: 1 = executed by user 0 = executed by recurrence. This field used by demand history processes to determine when the select date windows should be automatically incremented if this is a scheduled process or if the select date windows should be taken directly from the run control table, without manipulation. |
| 10 | DP_ADJ_REASON | Character(8) | VARCHAR2(8) NOT NULL |
DP_ADJ_REASON
Prompt Table: DP_ADJ_REASN_VW |
| 11 | DP_ADJ_COMMENT | Character(50) | VARCHAR2(50) NOT NULL | DP_ADJ_COMMENT |
| 12 | DP_RETRY_COUNT | Number(3,0) | SMALLINT NOT NULL | DP_RETRY_COUNT |
| 13 | DP_PROCEED_BTN | Character(1) | VARCHAR2(1) NOT NULL | Proceed |
| 14 | DP_CREATEITEMS | Character(1) | VARCHAR2(1) NOT NULL |
DP_CREATEITEMS
Y/N Table Edit Default Value: N |
| 15 | SALES_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Sales
Y/N Table Edit Default Value: Y |
| 16 | DP_LOCATION | Character(5) | VARCHAR2(5) NOT NULL |
DP_LOCATION
Y/N Table Edit Default Value: N |
| 17 | DP_FILEPATH | Character(254) | VARCHAR2(254) NOT NULL | DP_FILEPATH |
| 18 | FINT_OUTPUT_XML | Character(1) | VARCHAR2(1) NOT NULL |
Export as XML files
Y/N Table Edit Default Value: Y |
| 19 | DP_DAILYWEIGHTS | Character(1) | VARCHAR2(1) NOT NULL |
DP_DAILYWEIGHTS
Y/N Table Edit |
| 20 | DP_SELECT_BTN | Character(1) | VARCHAR2(1) NOT NULL |
Select Fields
Y/N Table Edit |