[Home] [Help] [Dependency Information]
Object Name: | EDW_ITEM_PRDFAM_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Product Family level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ITEM_PRDFAM_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PROD_FAMILY_PK |
EDW_ITEM_PRDFAM_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the item dimension | ||
REQUEST_ID | NUMBER | Identifier used by the collection program | ||
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the item dimension | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
ERROR_CODE | VARCHAR2 | (2000) | Error code used to store messages | |
INSTANCE | VARCHAR2 | (40) | Instance from which the record was collected | |
NAME | VARCHAR2 | (320) | Name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by collection program to determine whether to insert/update/delete this record | |
PRODUCT_FAMILY | VARCHAR2 | (240) | Product family | |
PROD_FAMILY_DP | VARCHAR2 | (240) | Not currently used | |
PROD_FAMILY_PK | VARCHAR2 | (320) | 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 | ||
LAST_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, REQUEST_ID
, ALL_FK
, COLLECTION_STATUS
, DESCRIPTION
, ERROR_CODE
, INSTANCE
, NAME
, OPERATION_CODE
, PRODUCT_FAMILY
, PROD_FAMILY_DP
, PROD_FAMILY_PK
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM ENI.EDW_ITEM_PRDFAM_LSTG;
ENI.EDW_ITEM_PRDFAM_LSTG does not reference any database object
ENI.EDW_ITEM_PRDFAM_LSTG is referenced by following:
|
|
|