BIDDER_FPDS

(SQL Table)
Index Back

Bidder Government Sources

Used to store Bidderr Government Sources details

# 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 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

Default Value: X

5 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

Default Value: X

6 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

Default Value: X

7 COMMON_PARENT_NAME Character(30) VARCHAR2(30) NOT NULL COMMON_PARENT_NAME
8 COMMON_PARENT_TIN Number(9,0) DECIMAL(9) NOT NULL Common Parent's TIN
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

Default Value: X

10 EMERGING_SM_BUS Character(1) VARCHAR2(1) NOT NULL EMERGING_SM_BUS
N=No
Y=Yes
11 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

Default Value: X

12 VETERAN_FLG Character(1) VARCHAR2(1) NOT NULL VETERAN flag indicator
N=No
Y=Yes

Y/N Table Edit

Default Value: N

13 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

Y/N Table Edit

Default Value: N

14 VNDR_TYPE Character(1) VARCHAR2(1) NOT NULL VNDR_TYPE
A=Small Disadvantaged Business
B=Other Small Business
C=Large Business
D=JWOD Nonprofit Agency
E=Educational Institution
F=Hospital
G=Nonprofit Organization
H=Reserved
J=Reserved
K=State/Local Government
L=Foreign Contractor
M=Domestic Contractor Outside US
U=Minority Institution
15 ETHNICITY2 Character(1) VARCHAR2(1) NOT NULL Ethnicity
A=Asian American
B=African American
H=Hispanic American
N=Native American
O=Other
16 ETHNICITY_LNG Character(30) VARCHAR2(30) NOT NULL ETHNICITY LONG DESCR