VNDR_RPT_VW (SQL View)	Index Back
Supplier Reporting Elements

VNDR_RPT_VW

(SQL View)

Supplier Reporting Elements

SELECT A.SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , C.STD_ID_NUM_QUAL , C.STD_ID_NUM , A.VNDR_TYPE , A.WOMEN_OWNED , B.HUB_ZONE , A.HUBZONE_PROG , A.SMALL_DISADV , A.OTHER_PREF_PROG , A.COMMON_PARENT_NAME , A.COMMON_PARENT_TIN , A.VETERAN_OWNED , A.EMERGING_SM_BUS , A.SMALL_BUS_SIZE FROM PS_VNDR_RPT_ELEM A , PS_VENDOR B , PS_VENDOR_ID_NBRS C WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.VENDOR_ID = C.VENDOR_ID AND STD_ID_NUM_QUAL IN ('DNS','TIN')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

4 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number

5 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number

6 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

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

8 HUB_ZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone
N=No
Y=Yes

9 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

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 COMMON_PARENT_NAME Character(30) VARCHAR2(30) NOT NULL COMMON_PARENT_NAME

13 COMMON_PARENT_TIN Number(9,0) DECIMAL(9) NOT NULL Common Parent's TIN

14 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

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

16 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
4	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
5	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number
6	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
7	WOMEN_OWNED	Character(1)	VARCHAR2(1) NOT NULL	WOMEN_OWNED N=No Y=Yes
8	HUB_ZONE	Character(1)	VARCHAR2(1) NOT NULL	HUB Zone N=No Y=Yes
9	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
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	COMMON_PARENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	COMMON_PARENT_NAME
13	COMMON_PARENT_TIN	Number(9,0)	DECIMAL(9) NOT NULL	Common Parent's TIN
14	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
15	EMERGING_SM_BUS	Character(1)	VARCHAR2(1) NOT NULL	EMERGING_SM_BUS N=No Y=Yes
16	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