[Home] [Help] [Dependency Information]
Object Name: | EDW_BRES_RESCAT_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Resource Category 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_BRES_RESCAT_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | RESOURCE_CATEGORY_PK |
EDW_BRES_RESCAT_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_FK_KEY | NUMBER | System generated foreign key to the plant level | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
RESOURCE_TYPE_FK_KEY | NUMBER | System generated foreign key to the resource type level | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ERROR_CODE | VARCHAR2 | (2000) | Code to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance from which the record was collected | |
NAME | VARCHAR2 | (320) | Resource category name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
PLANT_FK | VARCHAR2 | (120) | Foreign key to the plant level | |
RESOURCE_CATEGORY | VARCHAR2 | (80) | Resource Category | |
RESOURCE_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
RESOURCE_CATEGORY_PK | VARCHAR2 | (80) | Unique Identifier of the resource category | |
RESOURCE_TYPE_FK | VARCHAR2 | (80) | Foreign key to the resource type level | |
ROW_ID | ROWID | (10) | Row Identifier | |
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 PLANT_FK_KEY
, REQUEST_ID
, RESOURCE_TYPE_FK_KEY
, COLLECTION_STATUS
, DESCRIPTION
, ERROR_CODE
, INSTANCE
, NAME
, OPERATION_CODE
, PLANT_FK
, RESOURCE_CATEGORY
, RESOURCE_CATEGORY_DP
, RESOURCE_CATEGORY_PK
, RESOURCE_TYPE_FK
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM ENI.EDW_BRES_RESCAT_LSTG;
ENI.EDW_BRES_RESCAT_LSTG does not reference any database object
ENI.EDW_BRES_RESCAT_LSTG is referenced by following:
|
|
|