CMP_CWB_POST_RUN
Stores Post Process Run Information
Details
-
Schema: FUSION
-
Object owner: CMP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMP_CWB_POST_RUN_PK |
RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | RUN_ID | |
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | BUSINESS_GROUP_ID | |
| PLAN_ID | NUMBER | 18 | Yes | PLAN_ID | |
| PERIOD_ID | NUMBER | 18 | Yes | PERIOD_ID | |
| RUN_REQUESTID | NUMBER | 18 | RUN__REQUESTID | ||
| RUN_STATUS | VARCHAR2 | 30 | Yes | RUN_STATUS | |
| RUN_START_TIMESTAMP | TIMESTAMP | RUN_START_TIMESTAMP | |||
| RUN_END_TIMESTAMP | TIMESTAMP | RUN_END_TIMESTAMP | |||
| STEP1_REQUESTID | NUMBER | 18 | STEP1_REQUESTID | ||
| STEP1_START_TIMESTAMP | TIMESTAMP | STEP1_START_TIMESTAMP | |||
| STEP1_END_TIMESTAMP | TIMESTAMP | STEP1_END_TIMESTAMP | |||
| STEP1_STATUS | VARCHAR2 | 30 | STEP1_STATUS | ||
| STEP2_REQUESTID | NUMBER | 18 | STEP2_REQUESTID | ||
| BACKOUT_PERSONS_PROCESSED | NUMBER | BACKOUT_PERSONS_PROCESSED | |||
| BACKOUT_PERSONS_FAILED | NUMBER | BACKOUT_PERSONS_FAILED | |||
| BACKOUT_SALARY_PROCESSED | NUMBER | BACKOUT_SALARY_PROCESSED | |||
| BACKOUT_SALARY_FAILED | NUMBER | BACKOUT_SALARY_FAILED | |||
| BACKOUT_ELEMENTS_PROCESSED | NUMBER | BACKOUT_ELEMENTS_PROCESSED | |||
| BACKOUT_ELEMENTS_FAILED | NUMBER | BACKOUT_ELEMENTS_FAILED | |||
| BACKOUT_STOCKS_PROCESSED | NUMBER | BACKOUT_STOCKS_PROCESSED | |||
| BACKOUT_STOCKS_FAILED | NUMBER | BACKOUT_STOCKS_FAILED | |||
| BACKOUT_PROMOTIONS_PROCESSED | NUMBER | BACKOUT_PROMOTIONS_PROCESSED | |||
| BACKOUT_PROMOTIONS_FAILED | NUMBER | BACKOUT_PROMOTIONS_FAILED | |||
| BACKOUT_RANKS_PROCESSED | NUMBER | BACKOUT_RANKS_PROCESSED | |||
| BACKOUT_RANKS_FAILED | NUMBER | BACKOUT_RANKS_FAILED | |||
| BACKOUT_REQUEST_ID | NUMBER | BACKOUT_REQUEST_ID | |||
| STEP2_START_TIMESTAMP | TIMESTAMP | STEP2_START_TIMESTAMP | |||
| STEP2_END_TIMESTAMP | TIMESTAMP | STEP2_END_TIMESTAMP | |||
| STEP2_STATUS | VARCHAR2 | 30 | STEP2_STATUS | ||
| ACTION_ID_PLAN | NUMBER | 18 | ACTION_ID_PLAN | ||
| ACTION_REASON_ID_PLAN | NUMBER | 18 | ACTION_REASON_ID_PLAN | ||
| DEBUG_LEVEL | NUMBER | DEBUG_LEVEL | |||
| TEST_MODE_FLAG | VARCHAR2 | 1 | TEST_MODE_FLAG | ||
| MAX_THREADS | NUMBER | MAX_THREADS | |||
| MAX_ERRORS | NUMBER | MAX_ERRORS | |||
| TOTAL_THREADS | NUMBER | TOTAL_THREADS | |||
| TOTAL_ERRORS | NUMBER | TOTAL_ERRORS | |||
| TOTAL_PERSONS_SELECTED | NUMBER | TOTAL_PERSONS_SELECTED | |||
| TOTAL_PERSONS_PROCESSED | NUMBER | TOTAL_PERSONS_PROCESSED | |||
| TOTAL_PERSONS_POSTED | NUMBER | TOTAL_PERSONS_POSTED | |||
| TOTAL_PERSONS_FAILED | NUMBER | TOTAL_PERSONS_FAILED | |||
| TOTAL_ROWS_PROMOTION_SELECTED | NUMBER | TOTAL_ROWS_PROMOTION_SELECTED | |||
| TOTAL_ROWS_PROMOTION_PROCESSED | NUMBER | TOTAL_ROWS_PROMOTION_PROCESSED | |||
| TOTAL_ROWS_PROMOTION_POSTED | NUMBER | TOTAL_ROWS_PROMOTION_POSTED | |||
| TOTAL_ROWS_PROMOTION_FAILED | NUMBER | TOTAL_ROWS_PROMOTION_FAILED | |||
| TOTAL_ROWS_RANK_SELECTED | NUMBER | TOTAL_ROWS_RANK_SELECTED | |||
| TOTAL_ROWS_RANK_PROCESSED | NUMBER | TOTAL_ROWS_RANK_PROCESSED | |||
| TOTAL_ROWS_RANK_POSTED | NUMBER | TOTAL_ROWS_RANK_POSTED | |||
| TOTAL_ROWS_RANK_FAILED | NUMBER | TOTAL_ROWS_RANK_FAILED | |||
| TOTAL_ROWS_STOCK_SELECTED | NUMBER | TOTAL_ROWS_STOCK_SELECTED | |||
| TOTAL_ROWS_STOCK_PROCESSED | NUMBER | TOTAL_ROWS_STOCK_PROCESSED | |||
| TOTAL_ROWS_STOCK_POSTED | NUMBER | TOTAL_ROWS_STOCK_POSTED | |||
| TOTAL_ROWS_STOCK_FAILED | NUMBER | TOTAL_ROWS_STOCK_FAILED | |||
| TOTAL_ROWS_SALARY_SELECTED | NUMBER | TOTAL_ROWS_SALARY_SELECTED | |||
| TOTAL_ROWS_SALARY_PROCESSED | NUMBER | TOTAL_ROWS_SALARY_PROCESSED | |||
| TOTAL_ROWS_SALARY_POSTED | NUMBER | TOTAL_ROWS_SALARY_POSTED | |||
| TOTAL_ROWS_SALARY_FAILED | NUMBER | TOTAL_ROWS_SALARY_FAILED | |||
| TOTAL_ROWS_ELEMENTS_SELECTED | NUMBER | TOTAL_ROWS_ELEMENTS_SELECTED | |||
| TOTAL_ROWS_ELEMENTS_PROCESSED | NUMBER | TOTAL_ROWS_ELEMENTS_PROCESSED | |||
| TOTAL_ROWS_ELEMENTS_POSTED | NUMBER | TOTAL_ROWS_ELEMENTS_POSTED | |||
| TOTAL_ROWS_ELEMENTS_FAILED | NUMBER | TOTAL_ROWS_ELEMENTS_FAILED | |||
| TOTAL_SALARY_COMPONENTS | NUMBER | TOTAL_SALARY_COMPONENTS | |||
| SALARY_COMPONENT1 | VARCHAR2 | 30 | SALARY_COMPONENT1 | ||
| SALARY_COMPONENT2 | VARCHAR2 | 30 | SALARY_COMPONENT2 | ||
| SALARY_COMPONENT3 | VARCHAR2 | 30 | SALARY_COMPONENT3 | ||
| SALARY_COMPONENT4 | VARCHAR2 | 30 | SALARY_COMPONENT4 | ||
| SALARY_COMPONENT5 | VARCHAR2 | 30 | SALARY_COMPONENT5 | ||
| TOTAL_ELEMENTS | NUMBER | TOTAL_ELEMENTS | |||
| ATTRIBUTE_NAME1 | VARCHAR2 | 30 | ATTRIBUTE_NAME1 | ||
| ATTRIBUTE_NAME2 | VARCHAR2 | 30 | ATTRIBUTE_NAME2 | ||
| ATTRIBUTE_NAME3 | VARCHAR2 | 30 | ATTRIBUTE_NAME3 | ||
| ATTRIBUTE_NAME4 | VARCHAR2 | 30 | ATTRIBUTE_NAME4 | ||
| ATTRIBUTE_NAME5 | VARCHAR2 | 30 | ATTRIBUTE_NAME5 | ||
| INPUT_VALUE_ID1 | NUMBER | 18 | INPUT_VALUE_ID1 | ||
| INPUT_VALUE_ID2 | NUMBER | 18 | INPUT_VALUE_ID2 | ||
| INPUT_VALUE_ID3 | NUMBER | 18 | INPUT_VALUE_ID3 | ||
| INPUT_VALUE_ID4 | NUMBER | 18 | INPUT_VALUE_ID4 | ||
| INPUT_VALUE_ID5 | NUMBER | 18 | Attr INPUT_VALUE_ID5 | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMP_CWB_POST_RUN_N1 | Non Unique | Default | PERIOD_ID, PLAN_ID |
| CMP_CWB_POST_RUN_N2 | Non Unique | Default | RUN_STATUS |
| CMP_CWB_POST_RUN_PK | Unique | Default | RUN_ID |