ZCX_CSM_IMP_OBJ

Details

Schema: FUSION
Object owner: ZCX
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
ZCX_CSM_IMP_OBJ_INSTNS_PK	IMP_OBJ_INSTN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
IMP_OBJ_INSTN_ID	NUMBER		18	Yes	Primary Key attribute to uniquely identify a row.
IMP_OBJ_ID	NUMBER		18	Yes	Identifies the CSM artifact that is being imported using the import profile.
IMP_OBJ_GROUP_ID	NUMBER		18	Yes	Identifies the type of CSM artifact that is being imported using the import profile.
EXISTS_IN_SOURCE_FLAG	VARCHAR2	1			Artifact exists in the source environment boolean value indicator. 'Y' to indicate that the artifacts that has been\will be imported in target environment via CSM exists in the source environment.
EXISTS_IN_TARGET_FLAG	VARCHAR2	1			Artifact exists in the target environment boolean value indicator. 'Y' to indicate that the artifacts that has been\will be imported in target environment via CSM exists in the target environment.
OBJECT_IMPORT_OPTION_CODE	VARCHAR2	30		Yes	The code representing whether to import the object group: IMPORT, DO NOT IMPORT.
SOURCE_LAST_UPDATE_DATE	TIMESTAMP				Last Update timestamp of the imported Source Object when the import action was applied.
TARGET_LAST_IMPORT_DATE	TIMESTAMP				Last Update timestamp of the Target Object After the import action was applied
UPDATED_IN_SOURCE_FLAG	VARCHAR2	1			Artifact updated in the source environment boolean value indicator. 'Y' to indicate that the object that will be imported in target environment via CSM is a new version of the object in the source environment.
UPDATED_IN_TARGET_FLAG	VARCHAR2	1			Artifact updated in the target environment boolean value indicator. 'Y' to indicate that the object that will be imported in target environment via CSM has a new version of the object in the target environment since the last time the object was object was imported from source.
OBJ_IMP_ACTION_STATUS_CODE	VARCHAR2	30			The code representing the status of the imported object from the source: PENDING, APPLIED, APPLIED WITH ERROR, RESTORED, NOT_RESTORED_DUE_TO_TGT_CUST.
IMPORT_ACTION_PLAN	CLOB				The plan to execute when the object is imported in the target environment. the plan is built using the comparison data of the object in the source and target environment and the import option choice selected by the user for the object.
IMPORT_ACTION_RESULTS	CLOB				The results of the plan that was executed after the object was imported in the target environment.
RESTORE_ACTION_PLAN	CLOB				The plan to execute when the object is restored in the target environment.
RESTORE_ACTION_RESULTS	CLOB				The results of the plan that was executed after the object was restored in the target environment.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCX_CSM_IMP_OBJ_INSTNS	zcx_csm_imp_obj_groups	IMP_OBJ_GROUP_ID
ZCX_CSM_IMP_OBJ_INSTNS	zcx_csm_imp_objs	IMP_OBJ_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCX_CSM_IMP_OBJ_INSTNS_N1	Non Unique	Default	IMP_OBJ_GROUP_ID
ZCX_CSM_IMP_OBJ_INSTNS_N2	Non Unique	Default	IMP_OBJ_ID
ZCX_CSM_IMP_OBJ_INSTNS_PK	Unique	Default	IMP_OBJ_INSTN_ID