LM_RQ_CTG_UI_VW (SQL View)	Index Back
Category search rec Category search rec

LM_RQ_CTG_UI_VW

(SQL View)

Category search rec

SELECT DISTINCT B.LM_PERSON_ID , A.LM_CATG_ID , A.LM_CS_LONG_NM FROM PS_LM_CATG_TBL A , PS_LM_OPRID_ID_VW B , PS_LM_CATG_SEC_VW C , PS_LM_PERS_LGRP_VW D WHERE A.LM_CATG_ID = C.LM_CATG_ID AND C.LM_LRNR_GROUP_ID = D.LM_LRNR_GROUP_ID AND D.LM_PERSON_ID = B.LM_PERSON_ID

Related Language Record: LM_RQ_CG_UI_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

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

3 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_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
2	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category.
3	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object