FUN_ENTITY_TAGS
Captures the tags attached to business objects in FA
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
fun_entity_tags_PK |
TAG_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TAG_ID | NUMBER | 18 | Yes | Indicates unique identifier associated to the row. | |
ENTITY_APPLICATION_ID | NUMBER | 18 | Yes | Indicates functional area within a suite of ERP products. | |
ENTITY_OBJECT_NAME | VARCHAR2 | 100 | Yes | Indicates reference to the table that stores the details of the record to which tag is associated. | |
ENTITY_REFERENCE_ID1 | NUMBER | 18 | Yes | Indicates reference key information that will uniquely identify a record in other products view. | |
ENTITY_REFERENCE_ID2 | NUMBER | 18 | Indicates reference key information that will uniquely identify a record in other products view. | ||
ENTITY_REFERENCE_ID3 | NUMBER | 18 | Indicates reference key information that will uniquely identify a record in other products view. | ||
ENTITY_REFERENCE_ID4 | NUMBER | 18 | Indicates reference key information that will uniquely identify a record in other products view. | ||
ENTITY_REFERENCE_ID5 | NUMBER | 18 | Indicates reference key information that will uniquely identify a record in other products view. | ||
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. | ||
TAG_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates seeded tag category lookup types that qualify a group of tags with similar intent | |
TAG_VALUE_CODE | VARCHAR2 | 30 | Yes | Indicates tag name assigned to the record in other products view. | |
TAG_PROPERTIES | BLOB | Yes | Captures additional details about the record to which the tag is associated. | ||
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. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FUN_ENTITY_TAGS_N1 | Non Unique | Default | ENTITY_OBJECT_NAME, ENTITY_REFERENCE_ID1, NVL("ENTITY_REFERENCE_ID2",(-99)), TAG_TYPE_CODE |
FUN_ENTITY_TAGS_N2 | Non Unique | Default | ENTITY_OBJECT_NAME, TAG_VALUE_CODE, TAG_TYPE_CODE |
FUN_ENTITY_TAGS_U1 | Unique | Default | TAG_ID |