QUESTION_IDA=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
N=No
Y=Yes
Prompt Table: SUP_POFLST_RS_V
AUC_BID_SUP_PQ(SQL Table) |
Index Back |
|---|---|
Profile Question Srch Criteria |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QUESTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 2 | 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 |
| 3 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | COMMENTS_2000 | Long Character | CLOB | Comment Text |
| 5 | RESP_BID_VALUE_TXT | Long Character(2000) | VARCHAR2(2000) | Bid Response |
| 6 | RESP_BID_VALUE_YN | Character(1) | VARCHAR2(1) NOT NULL |
Bid Value Yes/no
N=No Y=Yes |
| 7 | RESP_BID_VALUE_NTX | Character(30) | VARCHAR2(30) NOT NULL | Response Bid Value Numeric Text |
| 8 | RESP_BID_VALUE_DT | Date(10) | DATE | Bid Response Date |
| 9 | RESP_BID_VALUE_QTY | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Numeric |
| 10 | AUC_BF_LIST_PB | Character(3) | VARCHAR2(3) NOT NULL |
Bid Factor List Items
Prompt Table: SUP_POFLST_RS_V |
| 11 | AUC_DATE | Date(10) | DATE | Collaboration Due Date |
| 12 | RESP_BID_VAL_NTX1 | Character(30) | VARCHAR2(30) NOT NULL | Response Bid Value Numeric Text |
| 13 | RESP_BID_VAL_QTY1 | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Numeric |