Data Warehouse

BUSINESS_ADDRESS_1

Primary business street address line one.

VARCHAR2

30

BUSINESS_ADDRESS_2

Primary business street address line two.

VARCHAR2

30

BUSINESS_CITY

Business city name.

VARCHAR2

30

BUSINESS_COUNTRY_CODE

Business country code.

VARCHAR2

5

BUSINESS_COUNTRY_NAME

Business country name.

VARCHAR2

20

BUSINESS_NAME

Registered business name as reported by Dun and Bradstreet.

VARCHAR2

30

BUSINESS_POSTAL_CODE

Business postal code.

VARCHAR2

16

BUSINESS_STATE

Business state or province code.

VARCHAR2

5

DB_CAGE_CODE

Db Cage Code.

VARCHAR2

5

DB_CEO_NAME

Db Ceo Name.

VARCHAR2

30

DB_CEO_TITLE

Db Ceo Title.

VARCHAR2

30

DB_CONGRESSIONAL_DISTRICT

Db Congressional District.

VARCHAR2

2

DB_DOMESTIC_DUNS_NUMBER

Db Domestic Duns Number.

VARCHAR2

9

DB_DOMESTIC_NAME

Db Domestic Name.

VARCHAR2

30

DB_EMPLOYEES_HERE

Db Employees Here.

VARCHAR2

9

DB_EMPLOYEES_TOTAL

Db Employees Total.

VARCHAR2

9

DB_FEDERAL_TAX_ID

Db Federal Tax Id.

VARCHAR2

9

DB_GLOBAL_DUNS_NUMBER

Db Global Duns Number.

VARCHAR2

9

DB_GLOBAL_NAME

Db Global Name.

VARCHAR2

30

DB_HQ_DUNS_NUMBER

Db Hq Duns Number.

VARCHAR2

9

DB_HQ_INDICATOR

Db Hq Indicator.

VARCHAR2

1

DB_HQ_NAME

Db Hq Name.

VARCHAR2

30

DB_LEGAL_STATUS_CODE

Db Legal Status Code.

VARCHAR2

1

DB_LEGAL_STATUS_DESC

Db Legal Status Desc.

VARCHAR2

30

DB_LOCATION_STATUS_CODE

Db Location Status Code.

VARCHAR2

1

DB_LOCATION_STATUS_DESC

Db Location Status Desc.

VARCHAR2

30

DB_PARENT_DUNS_NUMBER

Db Parent Duns Number.

VARCHAR2

9

DB_PARENT_NAME

Db Parent Name.

VARCHAR2

30

DB_SALES

Db Sales.

VARCHAR2

15

DB_SDB_BEGIN_DATE

Db Sdb Begin Date.

VARCHAR2

8

DB_SDB_END_DATE

Db Sdb End Date.

VARCHAR2

8

DB_TRADE_STYLE_1

Db Trade Style 1.

VARCHAR2

30

DB_TRADE_STYLE_2

Db Trade Style 2.

VARCHAR2

30

DB_TRADE_STYLE_3

Db Trade Style 3.

VARCHAR2

30

DB_TRADE_STYLE_4

Db Trade Style 4.

VARCHAR2

30

DB_TRADE_STYLE_5

Db Trade Style 5.

VARCHAR2

30

DUNS_NUMBER

Dun and Bradstreet DUNS number uniquely identifying the business entity.

VARCHAR2

9

GLOBAL_DUNS_NUMBER

Global DUNS number identifying the global ultimate parent entity.

VARCHAR2

9

IS_8A_DISADVANTAGE

Indicator showing whether the vendor participates in the 8a disadvantaged business program.

VARCHAR2

1

IS_DEBARRED

Indicator showing whether the vendor is debarred or excluded from doing business.

VARCHAR2

1

IS_DISABLED_OWNED

Indicator showing whether the vendor is disabled owned.

VARCHAR2

1

IS_DISABLED_VETERAN_ENTERPRISE

Is Disabled Veteran Enterprise.

VARCHAR2

1

IS_DISABLED_VET_BUS_ENTERPRISE

Is Disabled Vet Bus Enterprise.

VARCHAR2

1

IS_DISAD_BUSINESS_ENTERPRISE

Is Disad Business Enterprise.

VARCHAR2

1

IS_EDUCATIONAL

Is Educational.

VARCHAR2

1

IS_FOREIGN

Is Foreign.

VARCHAR2

1

IS_FOREIGN_NON_PROFIT

Is Foreign Non Profit.

VARCHAR2

1

IS_GLOBAL_COMPANY

Is Global Company.

VARCHAR2

1

IS_HISTORICAL_BLACK_COLLEGE

Is Historical Black College.

VARCHAR2

1

IS_HOSPITAL

Is Hospital.

VARCHAR2

1

IS_HUB_ZONE

Indicator showing whether the vendor is certified as a HUBZone business.

VARCHAR2

1

IS_LABOR_SURPLUS_AREA

Indicator showing whether the vendor is located in a labor surplus area.

VARCHAR2

1

IS_LARGE_BUSINESS

Indicator showing whether the vendor qualifies as a large business.

VARCHAR2

1

IS_MANUALLY_UPDATED

Is Manually Updated.

VARCHAR2

1

IS_MINORITY_OWNED

Indicator showing whether the business is minority owned.

VARCHAR2

1

IS_MUNICIPALITY

Is Municipality.

VARCHAR2

1

IS_NON_PROFIT

Is Non Profit.

VARCHAR2

1

IS_PUBLIC_OWNED

Is Public Owned.

VARCHAR2

1

IS_PUBLIC_OWNED_DESC

Is Public Owned Desc.

VARCHAR2

30

IS_SERVICE_DISABLED_VET_OWNED

Indicator showing whether the vendor is service disabled veteran owned.

VARCHAR2

1

IS_SMALL_BUSINESS

Indicator showing whether the vendor qualifies as a small business.

VARCHAR2

1

IS_SMALL_DISADVANTAGD_BUSINESS

Indicator showing whether the vendor qualifies as a small disadvantaged business.

VARCHAR2

1

IS_VETERAN_BUSINESS_ENTERPRISE

Is Veteran Business Enterprise.

VARCHAR2

1

IS_VETERAN_CERTIFICATION

Is Veteran Certification.

VARCHAR2

1

IS_VETERAN_OWNED

Indicator showing whether the vendor is veteran owned.

VARCHAR2

1

IS_VIETNAM_VETERAN

Is Vietnam Veteran.

VARCHAR2

1

IS_WOMAN_OWNED

Indicator showing whether the business is woman owned.

VARCHAR2

1

MAILING_ADDRESS

Mailing Address.

VARCHAR2

30

MAILING_CITY

Mailing City.

VARCHAR2

30

MAILING_COUNTRY_CODE

Mailing Country Code.

VARCHAR2

5

MAILING_COUNTRY_NAME

Mailing Country Name.

VARCHAR2

20

MAILING_PHONE

Mailing Phone.

VARCHAR2

16

MAILING_POSTAL_CODE

Mailing Postal Code.

VARCHAR2

16

MAILING_STATE

Mailing State.

VARCHAR2

5

MINORITY_DESCRIPTION

Description of the minority ownership classification.

VARCHAR2

30

NAICS_CODE_1

Primary North American Industry Classification System code assigned to the vendor.

VARCHAR2

6

NAICS_CODE_2

Secondary NAICS industry classification code.

VARCHAR2

6

NAICS_CODE_3

Tertiary NAICS industry classification code.

VARCHAR2

6

NAICS_DESCRIPTION_1

Description of the primary NAICS classification.

VARCHAR2

30

NAICS_DESCRIPTION_2

Description of the secondary NAICS classification.

VARCHAR2

30

NAICS_DESCRIPTION_3

Description of the tertiary NAICS classification.

VARCHAR2

30

SIC_CODE_1

Primary Standard Industrial Classification code assigned to the vendor.

VARCHAR2

8

SIC_CODE_2

Secondary SIC classification code.

VARCHAR2

8

SIC_CODE_3

Tertiary SIC classification code.

VARCHAR2

8

SIC_DESCRIPTION_1

Description of the primary SIC classification.

VARCHAR2

30

SIC_DESCRIPTION_2

Description of the secondary SIC classification.

VARCHAR2

30

SIC_DESCRIPTION_3

Description of the tertiary SIC classification.

VARCHAR2

30

VENDOR_KEY

Foreign key linking to the primary VENDOR record associated with the Dun and Bradstreet profile.

VARCHAR2

11

WAREHOUSE_LOAD_DATE

Timestamp indicating when the record was loaded into the warehouse.

DATE