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

XXX

VARCHAR2

5

DB_CEO_NAME

XXX

VARCHAR2

30

DB_CEO_TITLE

XXX

VARCHAR2

30

DB_CONGRESSIONAL_DISTRICT

XXX

VARCHAR2

2

DB_DOMESTIC_DUNS_NUMBER

XXX

VARCHAR2

9

DB_DOMESTIC_NAME

XXX

VARCHAR2

30

DB_EMPLOYEES_HERE

XXX

VARCHAR2

9

DB_EMPLOYEES_TOTAL

XXX

VARCHAR2

9

DB_FEDERAL_TAX_ID

XXX

VARCHAR2

9

DB_GLOBAL_DUNS_NUMBER

XXX

VARCHAR2

9

DB_GLOBAL_NAME

XXX

VARCHAR2

30

DB_HQ_DUNS_NUMBER

XXX

VARCHAR2

9

DB_HQ_INDICATOR

XXX

VARCHAR2

1

DB_HQ_NAME

XXX

VARCHAR2

30

DB_LEGAL_STATUS_CODE

XXX

VARCHAR2

1

DB_LEGAL_STATUS_DESC

XXX

VARCHAR2

30

DB_LOCATION_STATUS_CODE

XXX

VARCHAR2

1

DB_LOCATION_STATUS_DESC

XXX

VARCHAR2

30

DB_PARENT_DUNS_NUMBER

XXX

VARCHAR2

9

DB_PARENT_NAME

XXX

VARCHAR2

30

DB_SALES

XXX

VARCHAR2

15

DB_SDB_BEGIN_DATE

XXX

VARCHAR2

8

DB_SDB_END_DATE

XXX

VARCHAR2

8

DB_TRADE_STYLE_1

XXX

VARCHAR2

30

DB_TRADE_STYLE_2

XXX

VARCHAR2

30

DB_TRADE_STYLE_3

XXX

VARCHAR2

30

DB_TRADE_STYLE_4

XXX

VARCHAR2

30

DB_TRADE_STYLE_5

XXX

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

XXX

VARCHAR2

1

IS_DISABLED_VET_BUS_ENTERPRISE

XXX

VARCHAR2

1

IS_DISAD_BUSINESS_ENTERPRISE

XXX

VARCHAR2

1

IS_EDUCATIONAL

XXX

VARCHAR2

1

IS_FOREIGN

XXX

VARCHAR2

1

IS_FOREIGN_NON_PROFIT

XXX

VARCHAR2

1

IS_GLOBAL_COMPANY

XXX

VARCHAR2

1

IS_HISTORICAL_BLACK_COLLEGE

XXX

VARCHAR2

1

IS_HOSPITAL

XXX

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

XXX

VARCHAR2

1

IS_MINORITY_OWNED

Indicator showing whether the business is minority owned.

VARCHAR2

1

IS_MUNICIPALITY

XXX

VARCHAR2

1

IS_NON_PROFIT

XXX

VARCHAR2

1

IS_PUBLIC_OWNED

XXX

VARCHAR2

1

IS_PUBLIC_OWNED_DESC

XXX

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

XXX

VARCHAR2

1

IS_VETERAN_CERTIFICATION

XXX

VARCHAR2

1

IS_VETERAN_OWNED

Indicator showing whether the vendor is veteran owned.

VARCHAR2

1

IS_VIETNAM_VETERAN

An indicator that the person is a Vietnam veteran (Y or N)

VARCHAR2

1

IS_WOMAN_OWNED

Indicator showing whether the business is woman owned.

VARCHAR2

1

MAILING_ADDRESS

The mailing address of an MIT building, as distinguished from the street address; usually 77 Massachusetts Avenue, Cambridge. For example: Walker Memorial, Bldg. 50: Street Address: 142 Memorial Drive; Mailing Address: 77 Massachusetts Avenue.

VARCHAR2

30

MAILING_CITY

XXX

VARCHAR2

30

MAILING_COUNTRY_CODE

XXX

VARCHAR2

5

MAILING_COUNTRY_NAME

XXX

VARCHAR2

20

MAILING_PHONE

XXX

VARCHAR2

16

MAILING_POSTAL_CODE

XXX

VARCHAR2

16

MAILING_STATE

XXX

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