eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: POA.EDW_DUNS_NUMBER_LSTG

Object Details

Object Name:	EDW_DUNS_NUMBER_LSTG
Object Type:	TABLE
Owner:	POA
FND Design Data:	POA.EDW_DUNS_NUMBER_LSTG
Subobject Name:
Status:	VALID

This is the interface table for the DUNS Number level table. Data is staged here for verification and cleansing, before loading it into the dimension level table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_DUNS_NUMBER_LSTG_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	DUNS_NUM_PK
EDW_DUNS_NUMBER_LSTG_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
REQUEST_ID	NUMBER		Identifier used by collection program
PARENT_FK_KEY	NUMBER		System generated foreign key to Parent level
HQ_FK_KEY	NUMBER		System generated foreign key to Headquarter level
DOMESTIC_ULT_FK_KEY	NUMBER		System generated foreign key to Domestic Ultimate level
ZIP_CODE	VARCHAR2	(40)	D&B Postal Code of record for the business site.
WOMAN_OWNED_FLAG	VARCHAR2	(80)	D&B Identifies business as Woman-Owned (US)
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
UPDATE_FACT_FLAG	VARCHAR2	(20)	Indicates facts should be updated
TRADE_STYLE	VARCHAR2	(160)	Trade style used by the business
TOTAL_PAYMENTS	VARCHAR2	(40)	Total number of payment experiences
TOTAL_DEBT	VARCHAR2	(40)	Total debt
TOTAL_ASSETS	VARCHAR2	(40)	Total current and long term assets.
TELEPHONE	VARCHAR2	(40)	Telephone number of record
SUITS_COUNT	VARCHAR2	(40)	Number of law suits
STATE_PROV	VARCHAR2	(60)	State or Provence of record
SMALL_BUSINESS_FLAG	VARCHAR2	(80)	D&B identified business as a small business (US)
SLOW_PAYMENTS	VARCHAR2	(40)	Slow payments
SIC_CODE2	VARCHAR2	(40)	Secondary standard industry classification
SIC_CODE1	VARCHAR2	(40)	Primary standard industry classification
SIC1_DESCRIPTION	VARCHAR2	(40)	Primary standard industry classification description
SALES	VARCHAR2	(40)	Total sales for the business site
ROW_ID	ROWID	(10)	Row identifier
PREV_TOTAL_ASSETS	VARCHAR2	(40)	Total current and long term assets of the previous period
PREV_STATEMENT_TYPE	VARCHAR2	(80)	Audited or unaudited during the previous period
PREV_SALES	VARCHAR2	(40)	Total sales for the business site in the previous period
PREV_NET_WORTH	VARCHAR2	(40)	Total net worth in the previous period
PREV_CURRENT_LIABILITIES	VARCHAR2	(40)	Current liabilities for the business site in the previous period
PREV_CURRENT_ASSETS	VARCHAR2	(40)	Current assets for the business site in the previous period
PAYDEX_PRIOR_Q3	VARCHAR2	(80)	Paydex score 3 quarters ago
PAYDEX_PRIOR_Q2	VARCHAR2	(80)	Paydex score 2 quarters ago
PAYDEX_PRIOR_Q1	VARCHAR2	(80)	Paydex score prior quarter
PAYDEX_NORM	VARCHAR2	(80)	Normal Paydex score
PAYDEX_CURRENT	VARCHAR2	(80)	Current Paydex score
PARENT_TELEPHONE	VARCHAR2	(40)	Telephone of record for the Parent
PARENT_STATE_PROV	VARCHAR2	(60)	State or provence of record for the Parent
PARENT_POSTAL_CODE	VARCHAR2	(40)	Postal code of record for the Parent
PARENT_NAME	VARCHAR2	(160)	Name of record for the Parent
PARENT_FK	VARCHAR2	(40)	Foreign key to the top level of the DUNS dimension
PARENT_DUNS	VARCHAR2	(40)	DUNS number of the Parent
PARENT_COUNTRY	VARCHAR2	(40)	Country of record for the Parent
PARENT_CITY	VARCHAR2	(60)	City of record for the Parent
PARENT_ADDRESS	VARCHAR2	(80)	Address of record for the Parent
OWNS_RENTS_IND	VARCHAR2	(80)	Indicates if the business site rents or owns the site
OPERATION_CODE	VARCHAR2	(30)	Code used by the loader program to determine whether to insert/update/delete this record
OOB_IND	VARCHAR2	(80)	D&B indicates site is out-of -business.
NET_WORTH	VARCHAR2	(40)	Net worth
NET_PROFIT	VARCHAR2	(40)	Net profit
NEGATIVE_PAYMENTS	VARCHAR2	(40)	Number of negative payment experiences
NAME	VARCHAR2	(160)	Name of record for the business site
MINORITY_OWNED_TYPE	VARCHAR2	(80)	D&B Minority Owned Business type
MINORITY_OWNED_FLAG	VARCHAR2	(80)	D&B indicator that business is minority owned
LOCATION_STATUS	VARCHAR2	(80)	D&B indicates if business is a headquarters, branch/division, or single location
LIENS_COUNT	VARCHAR2	(40)	Number of liens against the business site
LEGAL_STATUS	VARCHAR2	(80)	Legal status
LABOR_SURPLUS_FLAG	VARCHAR2	(80)	D&B indicates area of labor surplus as defined by US Department of Labor
JUDGMENTS_COUNT	VARCHAR2	(40)	Number of judgements with the business site
ISO9000_REGISTRATION	VARCHAR2	(40)	D&B indicates ISO 9000 registration
INVENTORY	VARCHAR2	(40)	Inventory value
INSTANCE	VARCHAR2	(40)	Source database instance
IMPORT_FLAG	VARCHAR2	(80)	D&B identifies business as an importer
HQ_TELEPHONE	VARCHAR2	(40)	Telephone of record for the Headquarters
HQ_STATE_PROV	VARCHAR2	(60)	State or provence of record for the Headquarters
HQ_POSTAL_CODE	VARCHAR2	(40)	Postal code on record for the Headquarters
HQ_NAME	VARCHAR2	(160)	Name of record for the Headquarters
HQ_FLAG	VARCHAR2	(80)	D&B flag identifying site as a Headquarter location
HQ_FK	VARCHAR2	(40)	Foreign key to the Headquarter dimension level
HQ_DUNS	VARCHAR2	(40)	Headquarters DUNS Number
HQ_COUNTRY	VARCHAR2	(40)	Country of record for the Headquarter
HQ_CITY	VARCHAR2	(60)	City of record for the Headquarter
HQ_ADDRESS	VARCHAR2	(80)	Address of record for the Headquarter
HISTORY	VARCHAR2	(80)	D&B code indicating that detrimental information exists for the company
HIGH_RISK_IND	VARCHAR2	(80)	High risk indicator
HIGH_CREDIT	VARCHAR2	(40)	Maxmum credit of any payment experience
GLOBAL_ULT_TELEPHONE	VARCHAR2	(40)	Telephone number of record for the Global Ultimate
GLOBAL_ULT_STATE_PROV	VARCHAR2	(60)	State or Provence of record for the Global Ultimate
GLOBAL_ULT_POSTAL_CODE	VARCHAR2	(40)	Postal code of record for the Global Ultimate
GLOBAL_ULT_NAME	VARCHAR2	(160)	Name of record for the Global Ultimate
GLOBAL_ULT_DUNS	VARCHAR2	(40)	DUNS number for the Global Ultimate
GLOBAL_ULT_COUNTRY	VARCHAR2	(40)	Country of record for the Global Ultimate
GLOBAL_ULT_CITY	VARCHAR2	(60)	City of record for the Global Ultimate
GLOBAL_ULT_ADDRESS	VARCHAR2	(80)	Address of record for the GLobal Ultimate
FIRE_DISASTER_IND	VARCHAR2	(80)	D&B indicates catestrophic event occurred
FEDERAL_TAX_ID	VARCHAR2	(40)	Federal tax identifier
FAILURE_SCORE	VARCHAR2	(80)	D&B indicates risk of failure on a scale of 1-5 for US companies and 1-10 for Canadian companies.
FAILURE_NATL_PCNT_RANK	VARCHAR2	(80)	Relative ranking of a company among scorable companies in the local country database
FAILURE_NATL_INCE_DFT	VARCHAR2	(80)	Number of national incidence of default
FAILURE_INDU_PCNT_RANK	VARCHAR2	(80)	Relative ranking of a company among scorable companies in the industry database
FAILURE_INDU_INCE_DFT	VARCHAR2	(80)	Number of national incidence of default
FAILURE_IND	VARCHAR2	(80)	D&B indicates company has defaulted
EXPORT_FLAG	VARCHAR2	(80)	D&B indicates business exports
ERROR_CODE	VARCHAR2	(2000)	Error Code
EMPLOYEES_TOTAL	VARCHAR2	(40)	Total number of employees
DUNS_NUM_PK	VARCHAR2	(40)	Unique identifier for the DUNS number
DUNS_NUM_DP	VARCHAR2	(160)	Unique Name for the DUNS number
DUNS_NUMBER	VARCHAR2	(40)	DUNS Number of record
DOMESTIC_ULT_TELEPHONE	VARCHAR2	(40)	Telephone number of record for the Domestic Ultimate
DOMESTIC_ULT_STATE_PROV	VARCHAR2	(60)	State or Provence of record for the Domestic Ultimate
DOMESTIC_ULT_POSTAL_CODE	VARCHAR2	(40)	Postal code on record for the Domestic Ultimate
DOMESTIC_ULT_NAME	VARCHAR2	(160)	Name of record for the Domestic Ultimate
DOMESTIC_ULT_FK	VARCHAR2	(40)	Foreign key to the Domestic Ultimate level
DOMESTIC_ULT_DUNS	VARCHAR2	(40)	DUNS number of the Domestic Ultimate
DOMESTIC_ULT_COUNTRY	VARCHAR2	(40)	Country of record for the Domestic Ultimate
DOMESTIC_ULT_CITY	VARCHAR2	(60)	City of record for the Domestic Ultimate
DOMESTIC_ULT_ADDRESS	VARCHAR2	(80)	Address of record for the Domestic Ultimate
DNB_RATING	VARCHAR2	(80)	Business rating assigned by D&B
DISADVANTAGED_FLAG	VARCHAR2	(80)	D&B identified business as disadvantaged (US)
DELINQUENCY_SCORE	VARCHAR2	(80)	D&B indicates risk of delinquent payments
DEBARMENT_FLAG	VARCHAR2	(80)	D&B indicates business debarred from doing business with the US government
CURRENT_STATEMENT_TYPE	VARCHAR2	(80)	Audited or unaudited
CURRENT_LIABILITIES	VARCHAR2	(40)	Current liabilities for the business site
CURRENT_ASSETS	VARCHAR2	(40)	Total current and long term assets.
CRIMINAL_PROCEEDINGS_IND	VARCHAR2	(80)	D&B indicates criminal proceedings exist
COUNTRY	VARCHAR2	(80)	Country of record for the business site
CONTROL_YEAR	VARCHAR2	(40)	Year current control was assumed
CONG_DIST_CODE3	VARCHAR2	(80)	Congressional District Code 3 (US)
CONG_DIST_CODE2	VARCHAR2	(80)	Congressional District Code 2 (US)
CONG_DIST_CODE1	VARCHAR2	(80)	Congressional District Code 1 (US)
COMPANY_NAME	VARCHAR2	(120)	Company name of record
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)
CITY	VARCHAR2	(60)	D&B City of record for the business site.
CEO_TITLE	VARCHAR2	(40)	Title of the Chief Executive Officer
CEO_NAME	VARCHAR2	(60)	Name of the Chief Executive Officer
CASH	VARCHAR2	(40)	Cash on hand and liquid assets
BUSINESS_MOVED_IND	VARCHAR2	(80)	D&B indicates that business moved
BANKRUPTCY_IND	VARCHAR2	(80)	D&B indicates that business has filed for bankruptcy
AVERAGE_HIGH_CREDIT	VARCHAR2	(40)	Maximum credit of any payment period
ADDRESS	VARCHAR2	(80)	Address of record
ACCOUNTS_RECEIVABLES	VARCHAR2	(40)	Accounts receivable; amount of sales made and billed to customers on credit terms
SDB_EXIT_DATE	DATE		Date at which point the business no longer classified as a small or disadvantaged business
SDB_ENTRANCE_DATE	DATE		Date at which point the business is classified as a small or disadvantaged business
REPORT_BASE_DATE	DATE		D&B Date basis for the report
PREV_STATEMENT_DATE	DATE		Date of the income, profit and loss statement for the previous period
LAST_UPDATE_DATE	DATE		Standard Who Column
DNB_LAST_UPDATE_DATE	DATE		Last date the record was updated in the warehouse from D&B
CURRENT_STATEMENT_DATE	DATE		Date of the income, profit and loss statement
CREATION_DATE	DATE		Standard Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      PARENT_FK_KEY
,      HQ_FK_KEY
,      DOMESTIC_ULT_FK_KEY
,      ZIP_CODE
,      WOMAN_OWNED_FLAG
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE1
,      UPDATE_FACT_FLAG
,      TRADE_STYLE
,      TOTAL_PAYMENTS
,      TOTAL_DEBT
,      TOTAL_ASSETS
,      TELEPHONE
,      SUITS_COUNT
,      STATE_PROV
,      SMALL_BUSINESS_FLAG
,      SLOW_PAYMENTS
,      SIC_CODE2
,      SIC_CODE1
,      SIC1_DESCRIPTION
,      SALES
,      ROW_ID
,      PREV_TOTAL_ASSETS
,      PREV_STATEMENT_TYPE
,      PREV_SALES
,      PREV_NET_WORTH
,      PREV_CURRENT_LIABILITIES
,      PREV_CURRENT_ASSETS
,      PAYDEX_PRIOR_Q3
,      PAYDEX_PRIOR_Q2
,      PAYDEX_PRIOR_Q1
,      PAYDEX_NORM
,      PAYDEX_CURRENT
,      PARENT_TELEPHONE
,      PARENT_STATE_PROV
,      PARENT_POSTAL_CODE
,      PARENT_NAME
,      PARENT_FK
,      PARENT_DUNS
,      PARENT_COUNTRY
,      PARENT_CITY
,      PARENT_ADDRESS
,      OWNS_RENTS_IND
,      OPERATION_CODE
,      OOB_IND
,      NET_WORTH
,      NET_PROFIT
,      NEGATIVE_PAYMENTS
,      NAME
,      MINORITY_OWNED_TYPE
,      MINORITY_OWNED_FLAG
,      LOCATION_STATUS
,      LIENS_COUNT
,      LEGAL_STATUS
,      LABOR_SURPLUS_FLAG
,      JUDGMENTS_COUNT
,      ISO9000_REGISTRATION
,      INVENTORY
,      INSTANCE
,      IMPORT_FLAG
,      HQ_TELEPHONE
,      HQ_STATE_PROV
,      HQ_POSTAL_CODE
,      HQ_NAME
,      HQ_FLAG
,      HQ_FK
,      HQ_DUNS
,      HQ_COUNTRY
,      HQ_CITY
,      HQ_ADDRESS
,      HISTORY
,      HIGH_RISK_IND
,      HIGH_CREDIT
,      GLOBAL_ULT_TELEPHONE
,      GLOBAL_ULT_STATE_PROV
,      GLOBAL_ULT_POSTAL_CODE
,      GLOBAL_ULT_NAME
,      GLOBAL_ULT_DUNS
,      GLOBAL_ULT_COUNTRY
,      GLOBAL_ULT_CITY
,      GLOBAL_ULT_ADDRESS
,      FIRE_DISASTER_IND
,      FEDERAL_TAX_ID
,      FAILURE_SCORE
,      FAILURE_NATL_PCNT_RANK
,      FAILURE_NATL_INCE_DFT
,      FAILURE_INDU_PCNT_RANK
,      FAILURE_INDU_INCE_DFT
,      FAILURE_IND
,      EXPORT_FLAG
,      ERROR_CODE
,      EMPLOYEES_TOTAL
,      DUNS_NUM_PK
,      DUNS_NUM_DP
,      DUNS_NUMBER
,      DOMESTIC_ULT_TELEPHONE
,      DOMESTIC_ULT_STATE_PROV
,      DOMESTIC_ULT_POSTAL_CODE
,      DOMESTIC_ULT_NAME
,      DOMESTIC_ULT_FK
,      DOMESTIC_ULT_DUNS
,      DOMESTIC_ULT_COUNTRY
,      DOMESTIC_ULT_CITY
,      DOMESTIC_ULT_ADDRESS
,      DNB_RATING
,      DISADVANTAGED_FLAG
,      DELINQUENCY_SCORE
,      DEBARMENT_FLAG
,      CURRENT_STATEMENT_TYPE
,      CURRENT_LIABILITIES
,      CURRENT_ASSETS
,      CRIMINAL_PROCEEDINGS_IND
,      COUNTRY
,      CONTROL_YEAR
,      CONG_DIST_CODE3
,      CONG_DIST_CODE2
,      CONG_DIST_CODE1
,      COMPANY_NAME
,      COLLECTION_STATUS
,      CITY
,      CEO_TITLE
,      CEO_NAME
,      CASH
,      BUSINESS_MOVED_IND
,      BANKRUPTCY_IND
,      AVERAGE_HIGH_CREDIT
,      ADDRESS
,      ACCOUNTS_RECEIVABLES
,      SDB_EXIT_DATE
,      SDB_ENTRANCE_DATE
,      REPORT_BASE_DATE
,      PREV_STATEMENT_DATE
,      LAST_UPDATE_DATE
,      DNB_LAST_UPDATE_DATE
,      CURRENT_STATEMENT_DATE
,      CREATION_DATE
FROM POA.EDW_DUNS_NUMBER_LSTG;

Dependencies

[top of page]

POA.EDW_DUNS_NUMBER_LSTG does not reference any database object

POA.EDW_DUNS_NUMBER_LSTG is referenced by following:

APPS: EDW_DUNS_NUMBER_LSTG