AUC_SCR_CHT_VW

(SQL View)
 Index Back

Event Score Chart view


SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , D.AUC_FORMAT , D.AUC_STATUS , D.AUC_NAME , D.AUC_DTTM_PREVIEW , D.AUC_DTTM_START , D.AUC_DTTM_FINISH , A.RESP_DTTM_POST , C.CURRENCY_CD , C.RESP_CURRENCY_CD , A.AUC_LN_BF_SCR_TTL , %Round(A.AUC_LN_BF_SCR_TTL, 3) , C.NAME1 , ' ' , ' ' FROM PS_AUC_RESP_TTL_VW A , PS_AUC_AWD_BIDNAME C , PS_AUC_HDR D WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.AUC_ID = A.AUC_ID AND C.AUC_ROUND = A.AUC_ROUND AND C.AUC_VERSION = A.AUC_VERSION AND C.BIDNUM = A.BIDNUM AND C.BIDDER_SETID = A.BIDDER_SETID AND C.BIDDER_ID = A.BIDDER_ID AND C.BIDDER_TYPE = A.BIDDER_TYPE AND C.BIDDER_LOC = A.BIDDER_LOC AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.AUC_ID = A.AUC_ID AND D.AUC_ROUND = A.AUC_ROUND AND D.AUC_VERSION = A.AUC_VERSION AND AUC_LN_BF_SCR_TTL = ( SELECT MAX(AUC_LN_BF_SCR_TTL) FROM PS_AUC_RESP_TTL_VW WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND AUC_ID = A.AUC_ID AND AUC_ROUND = A.AUC_ROUND AND AUC_VERSION = A.AUC_VERSION AND BIDDER_SETID = A.BIDDER_SETID AND BIDDER_ID = A.BIDDER_ID AND BIDDER_TYPE = A.BIDDER_TYPE AND BIDDER_LOC = A.BIDDER_LOC)

  • Parent record: AUC_HDR

    • # 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

    Default Value: 1

    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

    Default Value: 1

    5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
    6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    10 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    11 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
    A=Awarded
    C=Collaborating Event
    D=Collaborating Bid Analysis
    E=Evaluating
    F=RFI Reviewed
    I=Pending RFI Review
    N=Not Awarded
    O=Open
    P=Posted
    Q=Paused
    R=Pending Scheduled Review
    S=Pending Post Approval
    T=Pending Award
    U=Pending Award Approval
    W=Post to Third Party Failed
    X=Cancelled
    Z=Inactive Version
    12 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
    13 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
    14 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
    15 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
    16 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    18 RESP_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    19 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score
    20 AUC_LN_SCR_TTL Number(7,3) DECIMAL(6,3) NOT NULL Line Score
    21 AUC_BID_ID_NUM Character(45) VARCHAR2(45) NOT NULL Bidder ID and Bidnum
    22 AUC_CHT_HINT_DISP Character(65) VARCHAR2(65) NOT NULL Chart Hint Display
    23 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2