BID_FCTR_CNS_VW

(SQL View)
Index Back

Eligible bid factors for Const


SELECT A.SETID AS BID_FACTOR_SETID , A.BID_FACTOR_CD , A.BID_FACTOR_TYPE , A.DESCR , A.AUC_MULTI_SEL_FLG FROM PS_BID_FACTOR_HDR A WHERE (A.BID_FACTOR_TYPE <> 'T' AND A.BID_FACTOR_TYPE <> 'S') 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.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BID_FACTOR_SETID Character(5) VARCHAR2(5) NOT NULL Bid Factor Setid
2 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
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
5 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections