MSC_CC_MODIFIED_ENTITIES
This table tracks if an entity has changed during the last cycle of fusion collections. Used for rollback purposes.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_CC_MODIFIED_ENTITIES_PK |
ENTITY, INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTITY | VARCHAR2 | 33 | Yes | The name of the entity that may have been modified. | |
| EXCHG_PARTITION_STATUS | VARCHAR2 | 20 | The status of exchange partition, indicating whether occured or not | ||
| INSTANCE_ID | NUMBER | Yes | The instance id of the source that made the change. | ||
| LAST_CYCLE_ID | NUMBER | The cycle id (refresh number) that last changed this entity. | |||
| LAST_TGT_CYCLE_ID | NUMBER | 18 | Cycle id of last target collections run | ||
| INPUT_STG_RECORDS | NUMBER | Number of records populated into staging table during fusion source pull of a particular cycle. | |||
| ERROR_RECORDS | NUMBER | Number of records errored out during load of collections process of a particular cycle. | |||
| DELAYED_RECORDS | NUMBER | Number of records that will be retried later for collections of a particular cycle. | |||
| PROCESSED_RECORDS | NUMBER | Number of records read from the staging table during load process of a particular cycle. | |||
| DELETED_RECORDS | NUMBER | Number of records deleted from the ODS 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. | |||
| 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. | ||
| 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 | ||
| UPG_FLAG | NUMBER | This column represents whether the upgrade is needed for that entity. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_CC_MODIFIED_ENTITIES | msc_cc_master_entities | ENTITY |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_CC_MODIFIED_ENTITIES_U1 | Unique | Default | ENTITY, INSTANCE_ID |