FO_USRHOTCAT_VW (SQL View)	Index Back
HotList Categories by User

FO_USRHOTCAT_VW

(SQL View)

HotList Categories by User

SELECT OPRID , CATEGORY_ID , DESCR15 , SELECT_FLAG , NUMBER1 , LASTUPDDTTM FROM PS_FO_USRHOTCAT_TL WHERE SELECT_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

3 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description

4 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes

5 NUMBER1 Number(10,0) DECIMAL(10) NOT NULL Number

6 LASTUPDDTTM 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
3	DESCR15	Character(15)	VARCHAR2(15) NOT NULL	Short Description
4	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
5	NUMBER1	Number(10,0)	DECIMAL(10) NOT NULL	Number
6	LASTUPDDTTM	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.