LM_DUMMYCATG_VW (SQL View)	Index Back
Dummy category view We intentionally dont want this view to return any rows. It will be used for drop downs that is populated manually and we dont want ptools to fire its automatic query.

LM_DUMMYCATG_VW

(SQL View)

Dummy category view

We intentionally dont want this view to return any rows. It will be used for drop downs that is populated manually and we dont want ptools to fire its automatic query.

SELECT A.lM_CATG_ID , A.LM_CS_LONG_NM FROM PS_LM_CATG_TBL A WHERE A.LM_CATG_ID = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.

2 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category.
2	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object