Data Warehouse

BUSINESS_ADDRESS_1

First line in business address

VARCHAR2

30

BUSINESS_ADDRESS_2

Second line in business address

VARCHAR2

30

BUSINESS_CITY

City of the business address

NUMBER

1

BUSINESS_COUNTRY_CODE

Country code of business address

VARCHAR2

5

BUSINESS_COUNTRY_NAME

Country name of business address

VARCHAR2

20

BUSINESS_NAME

Name of business

VARCHAR2

30

BUSINESS_POSTAL_CODE

Postal code of business address

VARCHAR2

16

BUSINESS_STATE

State of the business address

NUMBER

1

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

XXX

VARCHAR2

9

GLOBAL_DUNS_NUMBER

XXX

VARCHAR2

9

IS_8A_DISADVANTAGE

XXX

VARCHAR2

1

IS_DEBARRED

XXX

VARCHAR2

1

IS_DISABLED_OWNED

XXX

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

XXX

VARCHAR2

1

IS_LABOR_SURPLUS_AREA

XXX

VARCHAR2

1

IS_LARGE_BUSINESS

XXX

VARCHAR2

1

IS_MANUALLY_UPDATED

XXX

VARCHAR2

1

IS_MINORITY_OWNED

XXX

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

XXX

VARCHAR2

1

IS_SMALL_BUSINESS

XXX

VARCHAR2

1

IS_SMALL_DISADVANTAGD_BUSINESS

XXX

VARCHAR2

1

IS_VETERAN_BUSINESS_ENTERPRISE

XXX

VARCHAR2

1

IS_VETERAN_CERTIFICATION

XXX

VARCHAR2

1

IS_VETERAN_OWNED

XXX

VARCHAR2

1

IS_VIETNAM_VETERAN

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

VARCHAR2

1

IS_WOMAN_OWNED

XXX

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

50

MAILING_CITY

XXX

VARCHAR2

60

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

4

MINORITY_DESCRIPTION

XXX

VARCHAR2

30

NAICS_CODE_1

XXX

VARCHAR2

6

NAICS_CODE_2

XXX

VARCHAR2

6

NAICS_CODE_3

XXX

VARCHAR2

6

NAICS_DESCRIPTION_1

XXX

VARCHAR2

30

NAICS_DESCRIPTION_2

XXX

VARCHAR2

30

NAICS_DESCRIPTION_3

XXX

VARCHAR2

30

SIC_CODE_1

XXX

VARCHAR2

8

SIC_CODE_2

XXX

VARCHAR2

8

SIC_CODE_3

XXX

VARCHAR2

8

SIC_DESCRIPTION_1

XXX

VARCHAR2

30

SIC_DESCRIPTION_2

XXX

VARCHAR2

30

SIC_DESCRIPTION_3

XXX

VARCHAR2

30

VENDOR_KEY

Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

11

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8