VENDOR CLASSIFICATION Table
Stores vendor business classification attributes derived from Dun and Bradstreet and related enrichment sources. Includes industry codes, size indicators, ownership classifications, certification flags, and regulatory indicators. Each row represents classification data associated with a vendor.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DUNS_NUMBER |
Dun and Bradstreet DUNS number uniquely identifying the vendor 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_EDUCATIONAL |
Indicator showing whether the vendor is an educational institution. |
VARCHAR2 |
1 |
IS_FOREIGN |
Indicator showing whether the vendor is a foreign entity. |
VARCHAR2 |
1 |
IS_HISTORICAL_BLACK_COLLEGE |
Indicator showing whether the vendor is a historically black college or university. |
VARCHAR2 |
1 |
IS_HOSPITAL |
Indicator showing whether the vendor is classified as a 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_MINORITY_OWNED |
Indicator showing whether the business is minority owned. |
VARCHAR2 |
1 |
IS_MUNICIPALITY |
Indicator showing whether the vendor is a municipality or government entity. |
VARCHAR2 |
1 |
IS_NON_PROFIT |
Indicator showing whether the vendor is registered as a non profit organization. |
VARCHAR2 |
1 |
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_OWNED |
Indicator showing whether the vendor is veteran owned. |
VARCHAR2 |
1 |
IS_WOMAN_OWNED |
Indicator showing whether the business is woman owned. |
VARCHAR2 |
1 |
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 |
SIC_CODE_1 |
Primary Standard Industrial Classification code assigned to the vendor. |
VARCHAR2 |
8 |
VENDOR_KEY |
Foreign key linking to the primary VENDOR record associated with the classification attributes. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
Timestamp indicating when the classification record was loaded into the warehouse. |
DATE |