EGP_FULL_CATEGORY_LIST
This table stores relationship between all catalogs and categories, including shared category hierarchies.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGP_FULL_CATEGORY_LIST_PK |
CATEGORY_SET_ID, CATEGORY_ID, LOAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CATEGORY_SET_ID | NUMBER | 18 | Yes | Collection of items grouped into categories. | |
| CATEGORY_ID | NUMBER | 18 | Yes | Category belonging to the Item Catalog | |
| PARENT_CATEGORY_ID | NUMBER | 18 | Identifier of the parent category. | ||
| PARENT_CATEGORY_ID1 | NUMBER | 18 | Identifier of the 1st level parent category. | ||
| PARENT_CATEGORY_ID2 | NUMBER | 18 | Identifier of the 2nd level parent category. | ||
| PARENT_CATEGORY_ID3 | NUMBER | 18 | Identifier of the 3rd level parent category. | ||
| PARENT_CATEGORY_ID4 | NUMBER | 18 | Identifier of the 4th level parent category. | ||
| PARENT_CATEGORY_ID5 | NUMBER | 18 | Identifier of the 5th level parent category. | ||
| PARENT_CATEGORY_ID6 | NUMBER | 18 | Identifier of the 6th level parent category. | ||
| PARENT_CATEGORY_ID7 | NUMBER | 18 | Identifier of the 7th level parent category. | ||
| PARENT_CATEGORY_ID8 | NUMBER | 18 | Identifier of the 8th level parent category. | ||
| PARENT_CATEGORY_ID9 | NUMBER | 18 | Identifier of the 9th level parent category. | ||
| PARENT_CATEGORY_ID10 | NUMBER | 18 | Identifier of the 10th level parent category. | ||
| PARENT_CATEGORY_ID11 | NUMBER | 18 | Identifier of the 11th level parent category. | ||
| PARENT_CATEGORY_ID12 | NUMBER | 18 | Identifier of the 12th level parent category. | ||
| PARENT_CATEGORY_ID13 | NUMBER | 18 | Identifier of the 13th level parent category. | ||
| PARENT_CATEGORY_ID14 | NUMBER | 18 | Identifier of the 14th level parent category. | ||
| PARENT_CATEGORY_ID15 | NUMBER | 18 | Identifier of the 15th level parent category. | ||
| REFERENCE_CATEGORY_SET_ID | NUMBER | 18 | Identifier of the source catalog from which the category is reference shared. | ||
| CATEGORY_SHARED_FLAG | VARCHAR2 | 1 | Flag that specifies if the category is reference shared. | ||
| LOAD_ID | NUMBER | 18 | Yes | Number of times data has been loaded into this table. For internal use only. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_FULL_CATEGORY_LIST_N1 | Non Unique | Default | CATEGORY_SET_ID, REFERENCE_CATEGORY_SET_ID, PARENT_CATEGORY_ID, LOAD_ID |
| EGP_FULL_CATEGORY_LIST_N2 | Non Unique | Default | CATEGORY_ID, LOAD_ID |
| EGP_FULL_CATEGORY_LIST_U1 | Unique | Default | CATEGORY_SET_ID, CATEGORY_ID, LOAD_ID |