PV_VNDR_ATTR_VW (SQL View)	Index Back
Supplier Attributes View

PV_VNDR_ATTR_VW

(SQL View)

Supplier Attributes View

SELECT A.SETID , A.VENDOR_ID , B.DISABLED , B.EMERGING_SM_BUS , B.ETHNICITY2 , B.HUBZONE_PROG , B.OTHER_PREF_PROG , B.SMALL_BUS_SIZE , B.SMALL_DISADV , A.VENDOR_CLASS , B.VETERAN_FLG , B.VETERAN_OWNED , B.VNDR_TYPE ,B.WOMEN_OWNED FROM PS_VENDOR A LEFT OUTER JOIN PS_VNDR_RPT_ELEM B ON A.SETID=B.SETID AND A.VENDOR_ID=B.VENDOR_ID AND B.SEQ_NUM=1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 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

4 EMERGING_SM_BUS Character(1) VARCHAR2(1) NOT NULL EMERGING_SM_BUS
N=No
Y=Yes

5 ETHNICITY2 Character(1) VARCHAR2(1) NOT NULL Ethnicity
A=Asian American
B=African American
H=Hispanic American
N=Native American
O=Other

6 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

7 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

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

10 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
A=Attorney
E=Employee
H=HCM
R=Outside Party

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

12 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

13 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

14 WOMEN_OWNED Character(1) VARCHAR2(1) NOT NULL WOMEN_OWNED
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	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
4	EMERGING_SM_BUS	Character(1)	VARCHAR2(1) NOT NULL	EMERGING_SM_BUS N=No Y=Yes
5	ETHNICITY2	Character(1)	VARCHAR2(1) NOT NULL	Ethnicity A=Asian American B=African American H=Hispanic American N=Native American O=Other
6	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
7	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
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	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
10	VENDOR_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Vendor Classification A=Attorney E=Employee H=HCM R=Outside Party
11	VETERAN_FLG	Character(1)	VARCHAR2(1) NOT NULL	VETERAN flag indicator N=No Y=Yes
12	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
13	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
14	WOMEN_OWNED	Character(1)	VARCHAR2(1) NOT NULL	WOMEN_OWNED N=No Y=Yes