ZMM_IMP_ACTIVITIES_STG

Staging table to laod ZMM_ACTIVITIES for bulk import.

Details

• Schema: FUSION

• Object owner: ZMM

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Comments	Status
SOURCE_OBJECT_ID	NUMBER		18	SOURCE_OBJECT_ID	Active
SOURCE_OBJECT_CD	VARCHAR2	30		SOURCE_OBJECT_CD	Active
OSR_SOURCE_OBJECT_UID	VARCHAR2	500		OSR_SOURCE_OBJECT_UID	Active
BATCH_ID	NUMBER		18	BATCH_ID	Active
ORIG_SYSTEM	VARCHAR2	100		ORIG_SYSTEM	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZMM_IMP_ACTIVITIES_STG_N1	Non Unique	FUSION_TS_TX_IDX	OSR_SOURCE_OBJECT_UID	Active
ZMM_IMP_ACTIVITIES_STG_N2	Non Unique	FUSION_TS_TX_IDX	BATCH_ID	Active
ZMM_IMP_ACTIVITIES_STG_N4	Non Unique	FUSION_TS_TX_IDX	ORIG_SYSTEM	Active
ZMM_IMP_ACTIVITIES_STG_N5	Non Unique	FUSION_TS_TX_IDX	SOURCE_OBJECT_ID	Active
ZMM_IMP_ACTIVITIES_STG_N6	Non Unique	FUSION_TS_TX_IDX	SOURCE_OBJECT_CD	Active
ZMM_IMP_ACTIVITIES_STG_N7	Non Unique	FUSION_TS_TX_IDX	NVL("BATCH_ID", 0)