Batch Thread Capacity History
Module: Common
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_RUN_TM | NUMBER | 4 | 0 | Run Time | DW_EWB_X_EWDI_BASE_F1_TIME_D | F1_TIME_KEY | |
| BATCH_CD | VARCHAR2 | 8 | Batch Control | DW_EWB_X_EWDI_BASE_CI_BATCH_CTRL_D | BATCH_CD | ||
| BATCH_NBR | NUMBER | 10 | 0 | Batch Number | |||
| BATCH_RERUN_NBR | NUMBER | 10 | 0 | Batch Rerun Number | |||
| BATCH_THREAD_NBR | NUMBER | 10 | 0 | Thread Nbr | |||
| JOB_END_MINS | NUMBER | Job End Minutes | |||||
| JOB_START_MINS | NUMBER | Job Start Minutes | |||||
| RUN_PROCESSING_DT | NUMBER | 38 | 0 | Run Date | |||
| SOURCE_RECORD_ID | VARCHAR2 | 281 | Source Record Id | ||||
| BATCH_BUS_DT | NUMBER | 38 | 0 | Batch Business Date | |||
| BATCH_THREAD_CAP_COUNT | NUMBER | 38 | 0 | Batch Thread Cap Count | |||
| BAT_JOB_ID | VARCHAR2 | 38 | Batch Job ID | ||||
| END_DT | NUMBER | 38 | 0 | End Date | |||
| F1_MINUTE_IN_DAY | NUMBER | 4 | 0 | Minute in Day | |||
| START_DT | NUMBER | 38 | 0 | Start Date | |||
| SUBMIT_METH_FLG | VARCHAR2 | 38 | Submission Method | ||||
| SUBMIT_USER_ID | VARCHAR2 | 38 | Submitting User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| THREADPOOL | VARCHAR2 | 254 | Threadpool | ||||
| THREAD_END_DT | NUMBER | 38 | 0 | Thread End Date | |||
| THREAD_END_TM | NUMBER | 38 | 0 | Thread End Time | |||
| THREAD_START_DT | NUMBER | 38 | 0 | Thread Start Date | |||
| THREAD_START_TM | NUMBER | 38 | 0 | Thread Start Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |