OSS_USAGE_EVENT

Details

Schema: FUSION
Object owner: OSS
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
oss_usage_event_batches_PK	BATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Unique identifier usage rating batch.
BATCH_NUMBER	VARCHAR2	120			Alternate identifier usage rating batch.
BATCH_NAME	VARCHAR2	300			Name of Usage Events Batch
BATCH_DESCRIPTION	VARCHAR2	2000			Batch description of usage rating batch.
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID associated with usage Event Import Batch.
PROCESSED_DATETIME	DATE				Date and timestamp on which the batch got processed.
COUNT_OF_EVENTS	NUMBER				Number of usage events associated with batch.
COUNT_OF_EVENTS_INPROCESS	NUMBER				Number of usage events being processed.
COUNT_OF_EVENTS_ERRORED	NUMBER				Number of usage events with errors.
COUNT_OF_EVENTS_PROCESSED	NUMBER				Number of usage events processed successfully.
BATCH_STATUS	VARCHAR2	30			Batch status of usage rating batch.
BATCH_PROCESS_STATUS	VARCHAR2	30			Files used to captured process status of usage rating batch.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
TRUEUP_FLAG	VARCHAR2	1			This column indicates whether the batch can be used for creating usage events for the true-up process.
END_DATE	DATE				It records the end date of the batch.
PRICER_TYPE	VARCHAR2	30			It describes which pricer will be used for rating
OWNER_RESOURCE_ID	NUMBER		18		Party ID of the user who created the usage event batch.
USAGE_TYPE	VARCHAR2	30			Describes the type of usage batch
SCHEDULE_TYPE	VARCHAR2	30			Describes the Schedule type of the usage batch
RATING_PROC_SCHEDULE_DATETIME	TIMESTAMP				Date after which Batch becomes eligible for Rating
CREATION_TYPE	VARCHAR2	30			Describes the Creation type of the usage batch
CRITERIA_JSON	CLOB				It records the criteria in JSON format.
CRITERIA_SQL	CLOB				It records the criteria in SQL format.
REVERSED_EVENTS_COUNT	NUMBER		18		Records the count of events reversed in the current ReRating batch
INCLUDE_REVERSAL_EVENT_FLAG	VARCHAR2	1			Indicates if Rerating should also include reversal events.
PARTITION_KEY	VARCHAR2	128		Yes	Column used for persisting the value of partition key for child entity tables.
PARTITION_NUMBER	NUMBER	10		Yes	Unique number used for accessing partition wise data.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
OSS_USAGE_EVENT_BATCHES_N2	Non Unique	Default	TRUEUP_FLAG, END_DATE
OSS_USAGE_EVENT_BATCHES_N3	Non Unique	Default	PROCESSED_DATETIME
OSS_USAGE_EVENT_BATCHES_N4	Non Unique	Default	BATCH_NAME
oss_usage_event_batches_N1	Non Unique	Default	BATCH_STATUS
oss_usage_event_batches_U1	Unique	Default	BATCH_ID
oss_usage_event_batches_U2	Unique	oss_usage_event_batches_U2	BATCH_NUMBER