RESP_HD_ERR_VW

(SQL View)
Index Back

Response Header View

Response Error Header View

SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , BID_FACTOR_NBR , SETID , BID_FACTOR_CD , BID_FACTOR_TYPE , UNIT_OF_MEASURE , BID_INCREMENT , MIN_QTY , MAX_QTY , IDEAL_QTY , MIN_DT , MAX_DT , IDEAL_DT , IDEAL_TXT , IDEAL_YN , WEIGHTING , AUC_BF_DISPLAY_FLG , AUC_BF_ORIGIN_FLG , REQUIRED_FLAG , IDEAL_REQD , AUC_FORMAT , AUC_TYPE , AUC_STATUS , AUC_ALL_LINES_FLG , MULTIPLE_BIDS_FLG , AUC_DISP_WEIGHTING , AUC_MULTI_SEL_FLG , SEQ_NBR , AUC_COMMENTS_2000 ,AUC_ERR_DESCR , AUC_VIEWDETAIL_PB , AUC_EDIT_PB,AUC_FIELD_NAME,AUC_RECORD_NAME FROM PS_RESP_HDR_ERRFL

  • 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
    33 AUC_ERR_DESCR Long Character(32700) CLOB Error Message
    34 AUC_VIEWDETAIL_PB Character(1) VARCHAR2(1) NOT NULL View Detail push button
    35 AUC_EDIT_PB Character(1) VARCHAR2(1) NOT NULL Edit Event
    36 AUC_FIELD_NAME Character(150) VARCHAR2(150) NOT NULL Event ID
    37 AUC_RECORD_NAME Character(60) VARCHAR2(60) NOT NULL Event ID