SUP_PROF_QSTVW(SQL View) |
Index Back |
---|---|
Profile Question View |
SELECT A.QUESTION_ID ,TO_CHAR(COMMENTS_2000) ,B.XLATLONGNAME ,C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A ,PSXLATITEM B ,PSXLATITEM C WHERE A.BID_FACTOR_TYPE = B.FIELDVALUE AND B.FIELDNAME = 'BID_FACTOR_TYPE' AND A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE <> 'S' AND BID_FACTOR_TYPE <> 'M' UNION SELECT A.QUESTION_ID ,TO_CHAR(COMMENTS_2000) ,( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 10320 AND MESSAGE_NBR = 211),C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A,PSXLATITEM C WHERE A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE = 'M' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | QUESTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
3 | BID_FACTOR_TYPE1 | Character(30) | VARCHAR2(30) 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. |
4 | SUP_CONTACT_TYPE1 | Character(30) | VARCHAR2(30) NOT NULL | Question Type |
5 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit |