AUC_DIVERSE_VW

(SQL View)
Index Back

AUC Diversity View

Strategic 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