[Home] [Help] [Dependency Information]
Object Name: | EDW_DUNS_DOMESTIC_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_DUNS_DOMESTIC_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the DUNS Domestic 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_DUNS_DOMESTIC_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | DOMESTIC_ULT_PK |
EDW_DUNS_DOMESTIC_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Identifier used by collection program | ||
GLOBAL_ULT_FK_KEY | NUMBER | System generated foreign key to the Global Ultimate level | ||
CITY | VARCHAR2 | (60) | City of record for the business site. | |
ADDRESS | VARCHAR2 | (80) | Address of record for the business site. | |
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 | |
TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the business site. | |
STATE_PROV | VARCHAR2 | (60) | State or provence of record for the business site. | |
ROW_ID | ROWID | (10) | Row identifier | |
POSTAL_CODE | VARCHAR2 | (40) | Postal Code of record for the business site. | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
NAME | VARCHAR2 | (160) | Name of record for the Domestic Ultimate. The Domestic Ultimate is the ultimate parent company within the same country as the business site. | |
INSTANCE | VARCHAR2 | (40) | Source database instance for DUNS Domestic. | |
GLOBAL_ULT_FK | VARCHAR2 | (40) | Foreign key to the Global Ultimate level | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
DUNS_NUMBER | VARCHAR2 | (40) | D&B unique number for the business site | |
DOMESTIC_ULT_PK | VARCHAR2 | (40) | Unique identifier for Domestic Ultimate DUNS Number | |
DOMESTIC_ULT_DP | VARCHAR2 | (160) | Unique Domestic Ultimate name | |
COUNTRY | VARCHAR2 | (40) | Country of record for the business site. | |
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 REQUEST_ID
, GLOBAL_ULT_FK_KEY
, CITY
, ADDRESS
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, TELEPHONE
, STATE_PROV
, ROW_ID
, POSTAL_CODE
, OPERATION_CODE
, NAME
, INSTANCE
, GLOBAL_ULT_FK
, ERROR_CODE
, DUNS_NUMBER
, DOMESTIC_ULT_PK
, DOMESTIC_ULT_DP
, COUNTRY
, COLLECTION_STATUS
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.EDW_DUNS_DOMESTIC_LSTG;
POA.EDW_DUNS_DOMESTIC_LSTG does not reference any database object
POA.EDW_DUNS_DOMESTIC_LSTG is referenced by following:
|
|
|