BID_FACTOR_VW2 (SQL View)	Index Back
Bid Factor View for Groups Bid Factor View, to return active Bid Factor.

BID_FACTOR_VW2

(SQL View)

Bid Factor View for Groups

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.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)

# 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

#	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