LM_LPLN_ADM_LVW (SQL View)	Index Back
Admin Learning Plan Selection This view is used by administrator to select the learning plans. The OPRID is checked to make sure it has role 'LMLELM_Enrollment_Admin'.

LM_LPLN_ADM_LVW

(SQL View)

Admin Learning Plan Selection

This view is used by administrator to select the learning plans. The OPRID is checked to make sure it has role 'LMLELM_Enrollment_Admin'.

SELECT DISTINCT O.OPRID , L.LM_LPLN_ID , PL.LANGUAGE_CD , PL.LM_LPLN_NAME FROM PS_LM_PERSON_OPRID O , PS_LM_LPLN L , PS_LM_LPLN_LNG PL WHERE L.LM_LPLN_ID = PL.LM_LPLN_ID AND O.OPRID IN ( SELECT R.OPRID FROM PSROLEUSER_VW R WHERE R.ROLENAME = 'LMLELM_Enrollment_Admin') AND NOT EXISTS ( SELECT 1 FROM PS_LM_LPLN_LRN R WHERE L.LM_LPLN_ID = R.LM_LPLN_ID AND R.LM_LPLN_DEFAULT = 'Y' )

Related Language Record for LM_LPLN_ADM_SEL

# 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_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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_LPLN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Plan ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_LPLN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Learning Plan Code or Title