[Home] [Help] [Dependency Information]
Object Name: | EDW_ITEM_PROD_GRP_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Product Group level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ITEM_PROD_GRP_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PRODUCT_GROUP_PK |
EDW_ITEM_PROD_GRP_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_CATEG_FK_KEY | NUMBER | System generated foreign key to the Product Category level | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
SECONDARY_CODE_ID | NUMBER | System generated unique identifer for the Product Group (Secondary Interest Code) record in the source database | ||
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Description of the Product Group (Secondary Interest Code) | |
ENABLED_FLAG | VARCHAR2 | (20) | Enabled flag | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance from which the record was collected | |
NAME | VARCHAR2 | (320) | Product group name | |
OPERATION_CODE | VARCHAR2 | (40) | Code used by the collection program to determine whether to insert/update/delete this record | |
PRODUCT_CATEG_FK | VARCHAR2 | (240) | Foreign key to the product category level | |
PRODUCT_GROUP_DP | VARCHAR2 | (240) | Not currently used | |
PRODUCT_GROUP_PK | VARCHAR2 | (240) | Unique identifier | |
ROW_ID | ROWID | (10) | Row ID | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
CREATION_DATE | DATE | Standard Who column | ||
DELETION_DATE | DATE | Deletion date of the record | ||
LAST_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCT_CATEG_FK_KEY
, REQUEST_ID
, SECONDARY_CODE_ID
, COLLECTION_STATUS
, DESCRIPTION
, ENABLED_FLAG
, ERROR_CODE
, INSTANCE_CODE
, NAME
, OPERATION_CODE
, PRODUCT_CATEG_FK
, PRODUCT_GROUP_DP
, PRODUCT_GROUP_PK
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, DELETION_DATE
, LAST_UPDATE_DATE
FROM ENI.EDW_ITEM_PROD_GRP_LSTG;
ENI.EDW_ITEM_PROD_GRP_LSTG does not reference any database object
ENI.EDW_ITEM_PROD_GRP_LSTG is referenced by following:
|
|
|