OSS_T_USAGE_SERVICE_MAPPING
Following table be used to capture service mapping information.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
OSS_T_USAGE_SERVICE_MAPPING_PK |
USAGE_SERVICE_MAPPING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USAGE_SERVICE_MAPPING_ID | NUMBER | 18 | Yes | Identifies the service mapping for the row. | |
| SOURCE_OBJECT_NAME | VARCHAR2 | 240 | In the context of usage service mapping, "Tracks the source object name" refers to the process of identifying and recording the specific name or identifier of the original object (or source) from which usage data is derived or mapped. | ||
| SOURCE_OBJECT_FULL_NAME | VARCHAR2 | 300 | Tracking the "source object full name" for a given service mapping refers to the process of identifying and recording the complete, detailed name or identifier of the source object from which usage or service data is derived. | ||
| SOURCE_ATTRIBUTE_NAME | VARCHAR2 | 240 | Tracks the source attribute name for given service mapping. | ||
| SOURCE_OBJECT_TABLE | VARCHAR2 | 240 | Tracking the "source object table name" for a given service mapping involves identifying and recording the specific table name in a database from which data is being pulled, processed, or mapped to a particular service. | ||
| SOURCE_ATTRIBUTE_COLUMN | VARCHAR2 | 240 | Tracks the source attribute column for given service mapping. | ||
| TARGET_OBJECT_NAME | VARCHAR2 | 240 | Tracking the "target object name" for a given service mapping refers to identifying and recording the specific name of the object where data or actions are directed after being processed or mapped from a source object. This target object is the endpoint in the service mapping process, where the outcome of a service. | ||
| TARGET_ATTRIBUTE_NAME | VARCHAR2 | 240 | Tracks the target attribute name for given service mapping. | ||
| SERVICE_MAPPING_ELEMENT | CLOB | Tracks the service mapping element for given service mapping. | |||
| SERVICE_MAPPING_FLAG | VARCHAR2 | 1 | Tracks the status of mapping field for given service mapping, eg.V for Valid, I for Invalid and G for Groovy. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| EVENT_TYPE_ID | NUMBER | 18 | Tracking the "event type identifier" for a given service mapping involves recording the specific identifier associated with a particular type of event or action within a system. This event type identifier helps to categorize and distinguish different types of events or actions, ensuring that they are correctly mapped to the appropriate service or process. | ||
| RATE_PLAN_DETERMINANT_ID | NUMBER | 18 | Tracking the "rateplan determinant identifier" for a given service mapping involves recording the specific identifier associated with a particular type of rateplan determinant or action within a system. | ||
| 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_T_USAGE_SERVICE_MAPPING_N1 | Non Unique | Default | REQUEST_ID, SOURCE_OBJECT_NAME, SOURCE_ATTRIBUTE_NAME |
| OSS_T_USAGE_SERVICE_MAPPING_N2 | Non Unique | Default | EVENT_TYPE_ID, SOURCE_OBJECT_NAME, SOURCE_ATTRIBUTE_NAME |
| OSS_T_USAGE_SERVICE_MAPPING_N3 | Non Unique | Default | EVENT_TYPE_ID, TARGET_OBJECT_NAME, TARGET_ATTRIBUTE_NAME |
| OSS_T_USAGE_SERVICE_MAPPING_PK | Unique | Default | USAGE_SERVICE_MAPPING_ID |
| OSS_T_USAGE_SERVICE_MAPPING_U1 | Unique | Default | REQUEST_ID, TARGET_OBJECT_NAME, TARGET_ATTRIBUTE_NAME |