RESP_SCR_MXL_VW

(SQL View)
Index Back

Response Line

Used to store Response Line details

SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , LINE_NBR , MAX(AUC_LN_BF_SCR_TTL) FROM PS_RESP_TOT_LNW_VW WHERE BID_CNTR_ACTION <> 'W' AND IS_NOBID <> 'Y' GROUP BY BUSINESS_UNIT , AUC_ID , AUC_ROUND , LINE_NBR

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score