ZCX_CSM_IMP_PROFILES

Import profiles defines the fusion artifacts that should be imported or not imported from the source environment to a target environment using CSM. It records the status of imported artifacts as the csm job runs and allows to view information about the imported artifacts by the CSM process after it finishes.

Details

• Schema: FUSION

• Object owner: ZCX

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
ZCX_CSM_IMP_PROFILES_PK	IMP_PROFILE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
IMP_PROFILE_ID	NUMBER		18	Yes	Primary Key attribute to uniquely identify a row.
IMPORT_PROFILE_CODE	VARCHAR2	30		Yes	The code representing the type of the import profile:Default , Import CSM Job.
AUTO_APPROVE_FLAG	VARCHAR2	1		Yes	Auto Approve Import Profile boolean value indicator. 'Y' to indicate that the import profile can be used by the CSM import process without requiring the import profile to be manually approved by the user.
ARCHIVE_ID	NUMBER		18		Identifies the CSM archive that is associated with the import profile.
DEF_PROFILE_STATUS_CODE	VARCHAR2	30			The code representing the status of the default profile: BUILDING, UPDATED WITH NEW OBJECTS, READY.
CSM_IMP_STATUS_CODE	VARCHAR2	30			The code representing the status of the CSM job associated with the import profile: BACKUP, INPROGRESS, FAILED_BACKUP, IMPORT INPROGRESS, FAILED_IMPORT, COMPLETED, RESTORE INPROGRESS, FAILED_RESTORE, RESTORED.
OBJECTS_IMP_STATUS_CODE	VARCHAR2	30			The code representing the import status of the csm archive objects associated with the import profile: BUILDING COMPARISON DATA, REVIEW, CANCELLED, APPROVED, RUNNING, RUNNING WITH ERRORS, APPLIED, APPLIED WITH ERRORS, PARTIALLY APPLIED WITH ERRORS, RESTORING, RESTORED, PARTIALLY RESTORED.
CSM_IMP_START_DATE	TIMESTAMP				Indicates the date and time when the CSM import process started.
CSM_IMP_END_DATE	TIMESTAMP				Indicates the date and time when the CSM import process finished.
CSM_RESTORE_START_DATE	TIMESTAMP				Indicates the date and time when the CSM restore process started.
CSM_RESTORE_END_DATE	TIMESTAMP				Indicates the date and time when the CSM restore process finished.
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.
PREVIOUS_IMPORT_OPTION	CLOB				Serialized Map containing list of roles, by stripe, that were reported as missing, but the user chose not to create.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCX_CSM_IMP_PROFILES	zcx_csm_archives	ARCHIVE_ID
zcx_csm_imp_objs	zcx_csm_imp_profiles	CREATED_BY_PROFILE_ID
zcx_csm_imp_obj_groups	zcx_csm_imp_profiles	IMPORT_PROFILE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCX_CSM_IMP_PROFILES_N1	Non Unique	Default	ARCHIVE_ID
ZCX_CSM_IMP_PROFILES_PK	Unique	Default	IMP_PROFILE_ID