RESP_SCORE_VW(SQL View) |
Index Back |
|---|
| SELECT C.BUSINESS_UNIT ,C.AUC_ID ,C.AUC_ROUND ,C.AUC_VERSION ,C.LINE_NBR ,C.GRP_LINE_NBR ,C.BID_FACTOR_NBR ,C.BID_FACTOR_CD ,H.AUC_FORMAT ,H.AUC_TYPE ,H.AUC_START_PRC_RL ,H.AUC_BID_SCORE_OPT ,H.AUC_EVENT_BASE ,L.WEIGHTING ,C.WEIGHTING AS BF_WEIGHTING ,C.PRICE_FLG ,L.QTY_AUC ,L.QTY_AUC_MAX ,L.QTY_AUC_MIN ,C.MAX_QTY ,C.MIN_QTY ,C.MIN_QTY AS BID_ST_PRICE_DISP ,C.MIN_QTY AS BID_ST_PRICE_EVENT ,C.MIN_QTY AS BID_ST_PRICE_SCORE ,C.MIN_QTY AS BID_ST_PRICE_EDIT ,C.BID_INCREMENT , L.AUC_LINE_TYPE FROM PS_AUC_HDR H , PS_AUC_LINE L , PS_AUC_LN_BID_FCTR C WHERE C.BUSINESS_UNIT = H.BUSINESS_UNIT AND C.AUC_ID = H.AUC_ID AND C.AUC_ROUND = H.AUC_ROUND AND C.AUC_VERSION = H.AUC_VERSION AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.AUC_ID = L.AUC_ID AND H.AUC_ROUND = L.AUC_ROUND AND H.AUC_VERSION = L.AUC_VERSION AND L.BUSINESS_UNIT = C.BUSINESS_UNIT AND L.AUC_ID = C.AUC_ID AND L.AUC_ROUND = C.AUC_ROUND AND L.AUC_VERSION = C.AUC_VERSION AND L.LINE_NBR = C.LINE_NBR AND C.GRP_LINE_NBR = 0 AND C.PRICE_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_ROUND |
Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | GRP_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Group Line Number |
| 7 | BID_FACTOR_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 8 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL | Bid Factor Code |
| 9 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
| 10 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
| 11 | AUC_START_PRC_RL | Character(1) | VARCHAR2(1) NOT NULL |
Start Price
D=Display - Not Required to Beat N=Do Not Display Y=Display and Also Must Beat |
| 12 | AUC_BID_SCORE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Bid Score Optimization
B=Own Bid W=Winning Bid |
| 13 | AUC_EVENT_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Event Base
P=Price Based S=Score Based |
| 14 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 15 | BF_WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilization totals |
| 16 | PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Price Flag
N=No Y=Yes |
| 17 | QTY_AUC | Number(16,4) | DECIMAL(15,4) NOT NULL | Event Quantity |
| 18 | QTY_AUC_MAX | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Max |
| 19 | QTY_AUC_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Event Quantity |
| 20 | MAX_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Maximum Quantity |
| 21 | MIN_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 22 | BID_ST_PRICE_DISP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 23 | BID_ST_PRICE_EVENT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 24 | BID_ST_PRICE_SCORE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 25 | BID_ST_PRICE_EDIT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 26 | BID_INCREMENT | Number(13,2) | DECIMAL(12,2) NOT NULL | Bid Increment |
| 27 | AUC_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Line Type
G=Group Line L=Line Item |