VENDOR CLASSIFICATION Table
Vendor classification data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DUNS_NUMBER |
XXX |
VARCHAR2 |
9 |
IS_8A_DISADVANTAGE |
XXX |
VARCHAR2 |
1 |
IS_DEBARRED |
XXX |
VARCHAR2 |
1 |
IS_DISABLED_OWNED |
XXX |
VARCHAR2 |
1 |
IS_EDUCATIONAL |
XXX |
VARCHAR2 |
1 |
IS_FOREIGN |
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_MINORITY_OWNED |
XXX |
VARCHAR2 |
1 |
IS_MUNICIPALITY |
XXX |
VARCHAR2 |
1 |
IS_NON_PROFIT |
XXX |
VARCHAR2 |
1 |
IS_SERVICE_DISABLED_VET_OWNED |
XXX |
VARCHAR2 |
1 |
IS_SMALL_BUSINESS |
XXX |
VARCHAR2 |
1 |
IS_SMALL_DISADVANTAGD_BUSINESS |
XXX |
VARCHAR2 |
1 |
IS_VETERAN_OWNED |
XXX |
VARCHAR2 |
1 |
IS_WOMAN_OWNED |
XXX |
VARCHAR2 |
1 |
MINORITY_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
NAICS_CODE_1 |
XXX |
VARCHAR2 |
6 |
SIC_CODE_1 |
XXX |
VARCHAR2 |
8 |
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 |