RESP_HDR_AUC_VW

(SQL View)
 Index Back

Response Header View

Response Header View

SELECT B.BUSINESS_UNIT ,B.AUC_ID ,B.AUC_ROUND ,B.AUC_VERSION ,B.BID_FACTOR_NBR ,B.SETID ,B.BID_FACTOR_CD ,B.BID_FACTOR_TYPE ,B.UNIT_OF_MEASURE ,B.BID_INCREMENT ,B.MIN_QTY ,B.MAX_QTY ,B.IDEAL_QTY ,B.MIN_DT ,B.MAX_DT ,B.IDEAL_DT ,B.IDEAL_TXT ,B.IDEAL_YN ,B.WEIGHTING ,B.AUC_BF_DISPLAY_FLG ,B.AUC_BF_ORIGIN_FLG ,B.REQUIRED_FLAG ,B.IDEAL_REQD ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_STATUS ,A.AUC_ALL_LINES_FLG ,A.MULTIPLE_BIDS_FLG ,A.AUC_DISP_WEIGHTING ,B.AUC_MULTI_SEL_FLG ,B.SEQ_NBR ,B.COMMENTS_2000 FROM PS_AUC_HDR A , PS_AUC_HDR_FACTORS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION

  • 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 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

    Prompt Table: BID_FACTOR_VW

    8 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
    9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    10 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
    11 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
    12 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
    13 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
    14 MIN_DT Date(10) DATE Minimum Date
    15 MAX_DT Date(10) DATE Max Date
    16 IDEAL_DT Date(10) DATE Ideal DateTime
    17 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
    18 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
    19 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    20 AUC_BF_DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Bid factor

    Y/N Table Edit

    Default Value: Y

    21 AUC_BF_ORIGIN_FLG Character(1) VARCHAR2(1) NOT NULL Bid Factor Origin
    A=Bid Factor Added During Award
    C=Bid Factor Added During Create

    Default Value: C

    22 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    23 IDEAL_REQD Character(1) VARCHAR2(1) NOT NULL Mandatory Response

    Y/N Table Edit

    Default Value: N

    24 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    25 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    26 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

    27 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines

    Y/N Table Edit

    Default Value: N

    28 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
    N=Not Allowed
    Y=Allowed

    Y/N Table Edit

    Default Value: Y

    29 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights

    Y/N Table Edit

    Default Value: Y

    30 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections
    31 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    32 AUC_COMMENTS_2000 Long Character(32700) CLOB Question