AUC_AGRMNT_VW (SQL View)	Index Back
Sourcing Bid Factor Agreements

AUC_AGRMNT_VW

(SQL View)

Sourcing Bid Factor Agreements

SELECT SETID , CS_RESULT_TYPE , CS_AGREE_CD , DESCR60 FROM PS_CS_AGREE WHERE EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CS_AGREE B WHERE B.SETID = PS_CS_AGREE.SETID AND B.CS_AGREE_CD = PS_CS_AGREE.CS_AGREE_CD AND B.EFFDT <= %CurrentDateIn) AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 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

3 CS_AGREE_CD Character(18) VARCHAR2(18) NOT NULL Agreement Code for Supplier Contract Managment

4 DESCR60 Character(60) VARCHAR2(60) 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_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
3	CS_AGREE_CD	Character(18)	VARCHAR2(18) NOT NULL	Agreement Code for Supplier Contract Managment
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description