LM_LPLN_ADM_SEL (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_SEL

(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 , 'N' , L.LM_LPLN_NAME FROM PS_LM_PERSON_OPRID O , PS_LM_LPLN L WHERE 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: LM_LPLN_ADM_LVW

# 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 LM_LPLN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Learning Plan Default

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	LM_LPLN_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Default
4	LM_LPLN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Learning Plan Code or Title