LM_LPLN_MGR_SEL (SQL View)	Index Back
Mgr Learning Plan Selection This view is used by managers to select the learning plans.

LM_LPLN_MGR_SEL

(SQL View)

Mgr Learning Plan Selection

This view is used by managers to select the learning plans.

SELECT DISTINCT M.OPRID , M.LM_MANAGER_ID , L.LM_LPLN_ID , L.LM_LPLN_NAME FROM PS_LM_LPLN L , PS_LM_MGR_SRCH_VW M WHERE M.LM_MANAGER_ID = L.LM_LPLN_CREATED_BY AND NOT EXISTS ( SELECT 1 FROM PS_LM_LPLN_LRN R WHERE L.LM_LPLN_ID = R.LM_LPLN_ID AND (R.LM_ASSIGNED_BY = R.LM_PERSON_ID OR R.LM_LPLN_DEFAULT = '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 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

3 LM_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID

4 LM_LPLN_NAME Character(30) VARCHAR2(30) NOT NULL Learning Plan Code or Title

#	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	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
3	LM_LPLN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Plan ID
4	LM_LPLN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Learning Plan Code or Title