SUP_PROF_QST_V (SQL View)	Index Back
Profile Factors Date Initials Reference # Description 09/17/2007 PKL 1692921002 Modified Record to sort the bid questions in sequence order

SUP_PROF_QST_V

(SQL View)

Profile Factors

Date Initials Reference # Description 09/17/2007 PKL 1692921002 Modified Record to sort the bid questions in sequence order

SELECT QUESTION_ID ,SEQ_NBR ,SUP_CONTACT_TYPE ,BID_FACTOR_TYPE ,COMMENTS_2000 ,REQUIRED_FLG FROM PS_SUP_PROFILE_QST

Related Language Record: SUP_PROF_Q_V_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

3 SUP_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type
A=Both
B=Business
I=Individual

4 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No

5 COMMENTS_2000 Long Character CLOB NOT NULL Comment Text

6 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	QUESTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	SUP_CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Question Type A=Both B=Business I=Individual
4	BID_FACTOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's. A=Attachment C=Monetary D=Date L=List N=Numeric S=Separator T=Text Y=Yes/No
5	COMMENTS_2000	Long Character	CLOB NOT NULL	Comment Text
6	REQUIRED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag Y/N Table Edit