MSC_COLL_CYCLE_STATISTICS
This table tracks collection entity statistics for every entity which is part of current collection cycle.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_COLL_CYCLE_STATISTICS_PK |
REFRESH_NUMBER, ENTITY |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| REFRESH_NUMBER | NUMBER | Yes | This identifies an unique cycle id of a collection process. | |
| ENTITY | VARCHAR2 | 33 | Yes | Name of the entity that is collected during collection process of a particular cycle. |
| INPUT_STG_RECORDS | NUMBER | Number of records populated into staging table during collection process of a particular cycle. | ||
| PROCESSED_RECORDS | NUMBER | Number of records read from the staging table during load process of a particular cycle. | ||
| MERGED_RECORDS | NUMBER | Number of records inserted/updated in the ODS tables during collections process of a particular cycle. | ||
| DELETED_RECORDS | NUMBER | Number of records deleted from the ODS table during load process of a particular cycle. | ||
| ERROR_RECORDS | VARCHAR2 | 20 | Number of records errored out during load of collections process of a particular cycle. | |
| PULL_INSERT_TIME | VARCHAR2 | 100 | Time taken to insert records from MSC_AP View or records (DML_TYPE = I and U) from MVLOG to Staging table. | |
| PULL_DELETE_TIME | VARCHAR2 | 100 | Time taken to insert records (DML_TYPE = D) from MVLOG to Staging table. | |
| LOAD_MTI_TIME | VARCHAR2 | 100 | Time taken to insert records to Temp/Staging tables in Load Code. | |
| LOAD_DELETE_TIME | VARCHAR2 | 100 | Time taken to delete records from ODS tables in Load Code (precoll delete in target collection/delete in incremental collection). | |
| LOAD_MERGE_TIME | VARCHAR2 | 100 | Time taken to MERGE records to ODS table in Load Code. | |
| LOAD_UPDATE_TIME | VARCHAR2 | 100 | Time taken to update error records in staging table. | |
| LOAD_XREF_TIME | VARCHAR2 | 100 | Time taken to process records to XREF. | |
| GATHER_STATS_TIME | VARCHAR2 | 100 | Time taken to gather schema stats for entity tables. | |
| PULL_FRAMEWORK_TIME | VARCHAR2 | 100 | Time taken for framework before calling entity _PULL procedure. | |
| FRAMEWORK_TIME | VARCHAR2 | 100 | Time taken to execute framework code | |
| 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. | |
| ORG_CODE_LIST | VARCHAR2 | 4000 | Comma delimited list of organization codes associated with the collection for respective entity. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_COLL_CYCLE_STATISTICS_U1 | Unique | Default | REFRESH_NUMBER, ENTITY |