SCP_AUC_CAT_VW (SQL View)	Index Back
Bid Category View

SCP_AUC_CAT_VW

(SQL View)

Bid Category View

SELECT A.SETID , A.CATEGORY_ID , 'F' , A.DESCR60 , A.DESCRSHORT ,%CurrentDateTimeOut FROM PS_ITM_CAT_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ITM_CAT_TBL A1 WHERE A1.SETID = A.SETID AND A1.CATEGORY_TYPE = A.CATEGORY_TYPE AND A1.CATEGORY_CD = A.CATEGORY_CD AND A1.CATEGORY_ID = A.CATEGORY_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' UNION SELECT a.setid , a.category ,'R' , a.descr ,'' ,%CurrentDateTimeOut FROM PS_CATEGORY_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_CATEGORY_TBL b WHERE b.effdt <= %CurrentDateIn AND b.eff_status = 'A' AND b.setid = a.setid AND b.category = a.category)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

3 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
3	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.