CSE_CONDITION_EVENT_CODES_B

Entity that holds the definition of the condition event codes. This is a fairly generic definition table where all the various types like disgnostic codes, failure codes, resoultion codes, and cause codes, etc can be defined and stored.

Details

• Schema: FUSION

• Object owner: CSE

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CSE_CONDITION_EVENT_CODES_B_PK	CONDITION_EVENT_CODE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONDITION_EVENT_CODE_ID	NUMBER		18	Yes	Unique identifier and primary key for the event code. System generated using the Fusion Global Unique ID generator.
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.
CONDITION_EVENT_TYPE_CODE	VARCHAR2	30		Yes	The type of the event code. The various types are defined in the lookup with the type ORA_MNT_EVENTCODE_STATUS.
CONDITION_EVENT_CODE	VARCHAR2	30		Yes	The unique user identifier for the condition event. It is unique across the system.
CATEGORY_CODE	VARCHAR2	30			Optionally categorize event codes to simplify ordering, selection, and reporting. Values drawn from an extensible lookup CSE_CONDITION_EVENT CATEGORY_TYPE.
ACTIVE_END_DATE	TIMESTAMP				The date when the condition event code is end dated.
SOURCE_REF_ID	VARCHAR2	36			Reference Identifiers from any third party systems.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CSE_CONDITION_EVENT_CODES_B_U1	Unique	Default	CONDITION_EVENT_CODE_ID
CSE_EVENT_CODES_B_N01	Non Unique	Default	CONDITION_EVENT_TYPE_CODE