ZMM_IMP_TASKS_STG

Staging table to laod TASKS for bulk import.

Details

• Schema: FUSION

• Object owner: ZMM

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Comments	Status
SOURCE_OBJECT_UID	VARCHAR2	64		SOURCE_OBJECT_UID	Active
SOURCE_OBJECT_CD	VARCHAR2	30		SOURCE_OBJECT_CD	Active
OSR_SOURCE_OBJECT_UID	VARCHAR2	500		OSR_SOURCE_OBJECT_UID	Active
ASSOCIATED_OBJECT_UID	VARCHAR2	64		ASSOCIATED_OBJECT_UID	Active
ASSOCIATED_OBJECT_CD	VARCHAR2	30		ASSOCIATED_OBJECT_CD	Active
OSR_ASSOC_OBJECT_UID	VARCHAR2	500		OSR_ASSOC_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_TASKS_STG_N1	Non Unique	FUSION_TS_TX_IDX	OSR_SOURCE_OBJECT_UID	Active
ZMM_IMP_TASKS_STG_N2	Non Unique	FUSION_TS_TX_IDX	OSR_ASSOC_OBJECT_UID	Active
ZMM_IMP_TASKS_STG_N3	Non Unique	FUSION_TS_TX_IDX	BATCH_ID	Active
ZMM_IMP_TASKS_STG_N4	Non Unique	FUSION_TS_TX_IDX	SOURCE_OBJECT_UID	Active
ZMM_IMP_TASKS_STG_N5	Non Unique	FUSION_TS_TX_IDX	SOURCE_OBJECT_CD	Active
ZMM_IMP_TASKS_STG_N6	Non Unique	FUSION_TS_TX_IDX	ASSOCIATED_OBJECT_UID	Active
ZMM_IMP_TASKS_STG_N7	Non Unique	FUSION_TS_TX_IDX	ASSOCIATED_OBJECT_CD	Active
ZMM_IMP_TASKS_STG_N8	Non Unique	FUSION_TS_TX_IDX	NVL("BATCH_ID", 0)