BID_FACTOR_VW

(SQL View)
 Index Back

Bid Factor View

Bid Factor View, to return active Bid Factor.

SELECT a.setid , a.bid_factor_cd , a.bid_factor_type , a.descr FROM PS_BID_FACTOR_HDR a WHERE a.price_flg <> 'Y' AND a.eff_status = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PS_BID_FACTOR_HDR b WHERE b.setid = a.setid AND b.bid_factor_cd = a.bid_factor_cd AND b.bid_factor_type = a.bid_factor_type AND b.eff_status = 'A' AND b.effdt <= %CurrentDateIn)

  • Related Language Record: BID_FAC_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

    Prompt Table: BID_FACTOR_HDR

    3 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description