SVC_WF_ETT

Details

Schema: FUSION
Object owner: SVC
Object type: TABLE
Tablespace: svc_wf_ett_data

Primary Key

Name	Columns
SVC_WF_ETT_DATA_PK	ETT_DATA_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ETT_DATA_ID	NUMBER		18	Yes	Auto-generated number and primary key for this table.
WORKFLOW_OBJECT_ID	NUMBER		18		Foreign key that references SVC_WF_OBJECTS.OBJECT_ID.
BATCH_ID	NUMBER		18		Representation of Elapsed time Batch Job Identifier.
TEMPLATE_ID	NUMBER		18	Yes	Reference to SVC_AP_TEMPLATES.TEMPLATE_ID.
OBJECT_TYPE	VARCHAR2	64			Object type of the data to process.
OBJECT_ID	NUMBER		18		Id of the parent object for the Elapsed time Job.
STATUS	VARCHAR2	64			Indicates the Elapsed status of Object.
DATE_PROCESSED	TIMESTAMP				Date the job processed this data row.
START_DATE	TIMESTAMP				Date this data row is introduced. Used to compute time elapsed compared to expiry date.
EXPIRY_DATE	TIMESTAMP				Expiry date of this object row based on the configured template condition.
OBJECT_NUMBER	VARCHAR2	30			Reference Number of the parent object for the Elapsed time Job.
RETRY_COUNT	NUMBER		1		Number of time this data row was tried by the runtime.
DETAILS	VARCHAR2	1000			Any message need capturing while processing this data row.
OBJECT_VALUE	TIMESTAMP				Indicates the date and time of the object last modification or creation date and time based on template condition.	Obsolete
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
SVC_WF_ETT_DATA	svc_ap_templates	TEMPLATE_ID
SVC_WF_ETT_DATA	svc_wf_objects	WORKFLOW_OBJECT_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
SVC_WF_ETT_DATA_N1	Non Unique	Default	OBJECT_TYPE, OBJECT_ID, OBJECT_VALUE	Obsolete
SVC_WF_ETT_DATA_N2	Non Unique	Default	WORKFLOW_OBJECT_ID, OBJECT_ID, OBJECT_VALUE, OBJECT_TYPE	Obsolete
SVC_WF_ETT_DATA_N3	Non Unique	Default	TEMPLATE_ID, STATUS
SVC_WF_ETT_DATA_N4	Non Unique	Default	EXPIRY_DATE, STATUS, LAST_UPDATE_DATE
SVC_WF_ETT_DATA_N5	Non Unique	Default	OBJECT_ID, OBJECT_TYPE
SVC_WF_ETT_DATA_PK	Unique	Default	ETT_DATA_ID