[Home] [Help] [Dependency Information]
Object Name: | EDW_GEOG_LOCATION_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_GEOG_LOCATION_LSTG
POA.EDW_GEOG_LOCATION_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Location 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_GEOG_LOCATION_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LOCATION_PK |
EDW_GEOG_LOCATION_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS_LINE_1 | VARCHAR2 | (240) | Address line 1 | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Address line 2 | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Address line 3 | |
ADDRESS_LINE_4 | VARCHAR2 | (240) | Address line 4 | |
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) | |
CREATION_DATE | DATE | Standard Who column | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LOCATION_DP | VARCHAR2 | (480) | Unique name for Location | |
LOCATION_PK | VARCHAR2 | (240) | Unique identifier for Location | |
NAME | VARCHAR2 | (480) | Location name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
POSTCODE_CITY_FK | VARCHAR2 | (480) | Foreign key to the Postal Code City level | |
POSTCODE_CITY_FK_KEY | NUMBER | System generated foreign key to the Postal Code City level | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | VARCHAR2 | (20) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, ADDRESS_LINE_4
, COLLECTION_STATUS
, CREATION_DATE
, ERROR_CODE
, INSTANCE
, LAST_UPDATE_DATE
, LOCATION_DP
, LOCATION_PK
, NAME
, OPERATION_CODE
, POSTCODE_CITY_FK
, POSTCODE_CITY_FK_KEY
, REQUEST_ID
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM POA.EDW_GEOG_LOCATION_LSTG;
POA.EDW_GEOG_LOCATION_LSTG does not reference any database object
POA.EDW_GEOG_LOCATION_LSTG is referenced by following:
|
|
|