AUC_RES_HD_FLVW

(SQL View)
 Index Back

Response Header View

Response Header View

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.AUC_DTTM_FINISH ,A.AUC_NAME ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_STATUS FROM PS_AUC_HDR A

  • 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
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
    6 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
    7 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    8 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    9 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

    Default Value: O