ZMM_IMP_WF_ASSIGNEES

Details

Schema: FUSION
Object owner: ZMM
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
ZMM_IMP_WF_ASSIGNEES_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TASK_ID	VARCHAR2	64			TASK_ID	Active
ASSIGNEE	VARCHAR2	400			ASSIGNEE	Active
VERSION	NUMBER				VERSION	Active
GUID	VARCHAR2	64			GUID	Active
ISGROUP	VARCHAR2	2			ISGROUP	Active
ASSIGNEETYPE	VARCHAR2	20			ASSIGNEETYPE	Active
BATCH_ID	NUMBER		18	Yes	BATCH_ID	Active
IMPORT_STATUS_CODE	VARCHAR2	30			IMPORT_STATUS_CODE	Active
INTERFACE_ROW_ID	NUMBER		18	Yes	INTERFACE_ROW_ID	Active
TASK_ORIG_SYSTEM	VARCHAR2	100			TASK_ORIG_SYSTEM	Active
TASK_NUMBER	VARCHAR2	500			TASK_NUMBER	Active
ASSIGNEE_ORIG_SYSTEM	VARCHAR2	100			ASSIGNEE_ORIG_SYSTEM	Active
OSR_ASSIGNEE_ID	VARCHAR2	500			OSR_ASSIGNEE_ID	Active
ACTION_CODE	VARCHAR2	10			ACTION_CODE
INTERNAL_ACTION_CODE	VARCHAR2	10			INTERNAL_ACTION_CODE
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active
INTERNAL_OVN	NUMBER		9		INTERNAL_OVN
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
FILE_RECORD_NUM	NUMBER		10		FILE_RECORD_NUM	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZMM_IMP_WF_ASSIGNEES_N2	Non Unique	FUSION_TS_TX_IDX	TASK_ORIG_SYSTEM	Active
ZMM_IMP_WF_ASSIGNEES_N3	Non Unique	FUSION_TS_TX_IDX	TASK_NUMBER	Active
ZMM_IMP_WF_ASSIGNEES_N4	Non Unique	FUSION_TS_TX_IDX	OSR_ASSIGNEE_ID	Active
ZMM_IMP_WF_ASSIGNEES_N6	Non Unique	FUSION_TS_TX_IDX	INTERFACE_ROW_ID	Active
ZMM_IMP_WF_ASSIGNEES_N7	Non Unique	FUSION_TS_TX_IDX	IMPORT_STATUS_CODE	Active
ZMM_IMP_WF_ASSIGNEES_N8	Non Unique	FUSION_TS_TX_IDX	ASSIGNEE_ORIG_SYSTEM	Active
ZMM_IMP_WF_ASSIGNEES_PK	Unique	FUSION_TS_TX_IDX	BATCH_ID, INTERFACE_ROW_ID