AUC_DIVERSE_VW(SQL View) |
Index Back |
---|---|
AUC Diversity ViewStrategic Sourcing Diversity View |
SELECT SETID , BIDDER_ID , WOMEN_OWNED , EMERGING_SM_BUS , DISABLED , VETERAN_FLG , HUBZONE_PROG , SMALL_BUS_SIZE , VETERAN_OWNED , SMALL_DISADV , OTHER_PREF_PROG , '' FROM PS_BIDDER_FPDS UNION SELECT SETID , VENDOR_ID , WOMEN_OWNED , EMERGING_SM_BUS , DISABLED , VETERAN_FLG , HUBZONE_PROG , SMALL_BUS_SIZE , VETERAN_OWNED , SMALL_DISADV , OTHER_PREF_PROG , ETHNICITY2 FROM PS_VNDR_RPT_ELEM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
3 | WOMEN_OWNED | Character(1) | VARCHAR2(1) NOT NULL |
WOMEN_OWNED
N=No Y=Yes |
4 | EMERGING_SM_BUS | Character(1) | VARCHAR2(1) NOT NULL |
EMERGING_SM_BUS
N=No Y=Yes |
5 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
N=No Y=Yes |
6 | VETERAN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VETERAN flag indicator
N=No Y=Yes |
7 | HUBZONE_PROG | Character(1) | VARCHAR2(1) NOT NULL |
HUBZONE_PROG
A=HUBZone Sole Source B=HUBZone Set-Aside C=HUBZone Price Evaluation Pref D=Combined HUBZone Price Adjust E=Not Applicable X=: If applicable, select one |
8 | SMALL_BUS_SIZE | Character(1) | VARCHAR2(1) NOT NULL |
Included the value with the longname for proper ordering in the listbox.
A=A) 50 or less B=B) 51 - 100 C=C) 101 - 250 D=D) 251 - 500 E=E) 501 - 750 F=F) 751 - 1,000 G=G) Over 1,000 M=M) 1,000,000 or less N=N) 1,000,001 - 2,000,000 P=P) 2,000,001 - 3,500,000 R=R) 3,500,001 - 5,000,000 S=S) 5,000,001 - 10,000,000 T=T) 10,000,001 - 17,000,000 X=: If applicable, select one Z=Z) Over 17,000,000 |
9 | VETERAN_OWNED | Character(1) | VARCHAR2(1) NOT NULL |
VETERAN_OWNED
A=Service Disabled VOSB B=Other Veteran Owned Sm Bus C=Not Veteran Owned Sm Business X=: If applicable, select one |
10 | SMALL_DISADV | Character(1) | VARCHAR2(1) NOT NULL |
SMALL_DISADV
A=8(a) Contract Award B=8(a) with HUBZone Priority C=SDB Set-Aside D=SDB Price Evaluation Adjust E=SDB Participating Program F=Not Applicable X=: If applicable, select one |
11 | OTHER_PREF_PROG | Character(1) | VARCHAR2(1) NOT NULL |
OTHER_PREF_PROG
A=Directed to JWOD Nonprofit B=Small Business Set-Aside C=Buy Indian D=No Preference/Not listed E=Very Small Business Set-Aside X=: If applicable, select one |
12 | ETHNICITY2 | Character(1) | VARCHAR2(1) NOT NULL |
Ethnicity
A=Asian American B=African American H=Hispanic American N=Native American O=Other |