POI_TAXONOMY_HDR
This table contains information about the taxonomy properties. Taxonomy properties are description, category levels, category value, and category description separators and so on. It also stores the information about taxonomy type, which determines the specific category ID column to be used in the data set during classification process or during knowledge base creation.
Details
-
Schema: FUSION
-
Object owner: POI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POI_TAXONOMY_HDR_PK |
TAXONOMY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAXONOMY_ID | NUMBER | 18 | Yes | Uniquely identifies the taxonomy header. | |
| SYNCH_DATE | DATE | Synchronization date of taxonomy. | |||
| NAME | VARCHAR2 | 90 | Yes | Indicates the name of the taxonomy. | |
| DESCRIPTION | VARCHAR2 | 768 | Yes | Indicates the description of the taxonomy. | |
| LVL_COUNT | NUMBER | 18 | Yes | Number of levels based on number of category segments used. | |
| SEPERATOR | VARCHAR2 | 30 | Yes | Separator used to derive the column data from uploaded sheet. | |
| TARGET_COLUMN | VARCHAR2 | 30 | Target column to which the code is populated in the payload. | ||
| DESCRIPTION_SEPERATOR | VARCHAR2 | 30 | Description separator used in payload. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| SYNC_DATE | DATE | Synchronous date of taxonomy date. | |||
| 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. | ||
| 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. | |
| ENTITY_ID | NUMBER | 8 | Yes | Identifies the entity type for the taxonomy. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POI_TAXONOMY_HDR_U1 | Unique | Default | TAXONOMY_ID |