[Home] [Help] [Dependency Information]
Object Name: | EDW_SPSC_SEGMENT_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_SPSC_SEGMENT_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the UNSPSC Segment level table. Data is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_SPSC_SEGMENT_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SEGMENT_PK |
EDW_SPSC_SEGMENT_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the UNSPSC dimension | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the UNSPSC dimension | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
SEGMENT_PK | VARCHAR2 | (40) | Unique identifier for Segment | |
SEGMENT_DP | VARCHAR2 | (120) | Unique name for Segment | |
SEGMENT_CODE | VARCHAR2 | (40) | Segment code | |
ROW_ID | ROWID | (10) | Row identifier | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
NAME | VARCHAR2 | (120) | Name of the Segment | |
INSTANCE | VARCHAR2 | (40) | Source database instance | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the level table. It does not refer to the movement of the data from the source to the staging table) | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, REQUEST_ID
, ALL_FK
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, SEGMENT_PK
, SEGMENT_DP
, SEGMENT_CODE
, ROW_ID
, OPERATION_CODE
, NAME
, INSTANCE
, ERROR_CODE
, COLLECTION_STATUS
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.EDW_SPSC_SEGMENT_LSTG;
POA.EDW_SPSC_SEGMENT_LSTG does not reference any database object
POA.EDW_SPSC_SEGMENT_LSTG is referenced by following:
|
|
|