SUP_PROF_QST_VW(SQL View) |
Index Back |
---|---|
Profile Questions |
SELECT A.QUESTION_ID ,B.SEQ_NBR ,A.SUP_CONTACT_TYPE ,A.BID_FACTOR_TYPE ,A.COMMENTS_2000 ,A.REQUIRED_FLG ,B.SUP_OB_TEMPLATE_ID ,B.SUPOB_REG_OPT_TYPE ,A.UNIT_OF_MEASURE ,A.FULL_USR_ACCESS FROM PS_SUP_PROFILE_QST A , PS_SUP_REG_PROFQST B WHERE A.QUESTION_ID=B.QUESTION_ID AND B.SELECTED_FLAG='Y' |
# | 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 |
7 | SUP_OB_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Supplier On boarding template Id |
8 | SUPOB_REG_OPT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
On boarding manage invite options
AD=Ad-hoc Tasks NB=Register New Bidders NS=Register New Suppliers NU=Register New User Accounts PC=Profile Change Request RB=Request Change for Bidder RS=Request Supplier Change |
9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
10 | FULL_USR_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Grant Full Access
N=No Y=Yes |