SCR_VND_RPTL_VW (SQL View)	Index Back
SCR Reporting Elements Supplier Reporting Elements Record

SCR_VND_RPTL_VW

(SQL View)

SCR Reporting Elements

Supplier Reporting Elements Record

SELECT SETID , VENDOR_ID , SEQ_NUM , VNDR_TYPE , WOMEN_OWNED , HUBZONE_PROG , SMALL_DISADV ,OTHER_PREF_PROG , COMMON_PARENT_NAME , COMMON_PARENT_TIN , VETERAN_OWNED , EMERGING_SM_BUS , SMALL_BUS_SIZE , VETERAN_FLG , DISABLED , ETHNICITY2 , ETHNICITY_LNG FROM PS_VNDR_RPT_ELEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: VENDOR.SETID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Default Value: VENDOR.VENDOR_ID

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

4 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

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

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

8 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

9 COMMON_PARENT_NAME Character(30) VARCHAR2(30) NOT NULL COMMON_PARENT_NAME

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

11 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

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

13 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

14 VETERAN_FLG Character(1) VARCHAR2(1) NOT NULL VETERAN flag indicator
N=No
Y=Yes
Y/N Table Edit

15 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

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

17 ETHNICITY_LNG Character(30) VARCHAR2(30) NOT NULL ETHNICITY LONG DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: VENDOR.SETID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR.VENDOR_ID
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
4	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
5	WOMEN_OWNED	Character(1)	VARCHAR2(1) NOT NULL	WOMEN_OWNED N=No Y=Yes
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	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
8	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
9	COMMON_PARENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	COMMON_PARENT_NAME
10	COMMON_PARENT_TIN	Number(9,0)	DECIMAL(9) NOT NULL	Common Parent's TIN
11	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
12	EMERGING_SM_BUS	Character(1)	VARCHAR2(1) NOT NULL	EMERGING_SM_BUS N=No Y=Yes
13	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
14	VETERAN_FLG	Character(1)	VARCHAR2(1) NOT NULL	VETERAN flag indicator N=No Y=Yes Y/N Table Edit
15	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
16	ETHNICITY2	Character(1)	VARCHAR2(1) NOT NULL	Ethnicity A=Asian American B=African American H=Hispanic American N=Native American O=Other
17	ETHNICITY_LNG	Character(30)	VARCHAR2(30) NOT NULL	ETHNICITY LONG DESCR