LM_LPLN_MTD_VW (SQL View)	Index Back
Learning Plan View This view will get a count for a learner's programs, enrollments, and supplemental learnings that are in the learning plan for My To Do List pagelet. It looks for required and not completed plans.

LM_LPLN_MTD_VW

(SQL View)

Learning Plan View

This view will get a count for a learner's programs, enrollments, and supplemental learnings that are in the learning plan for My To Do List pagelet. It looks for required and not completed plans.

SELECT A.LM_LPLN_ID , A.LM_PERSON_ID , A.LM_ADHC_LRN_ID , A.LM_ENRLMT_ID , A.LM_PRG_REG_ID , A.LM_REQUIRED , LR1.LM_LPLN_STATUS FROM PS_LM_LPLN_ENRL_VW A , PS_LM_LPLN_LRN LR1 WHERE LR1.LM_LPLN_ID = A.LM_LPLN_ID AND LR1.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_REQUIRED = 'Y' AND LR1.LM_LPLN_STATUS <> 'C' AND A.LM_STTS NOT IN ('COMP', 'CANC') UNION SELECT B.LM_LPLN_ID , B.LM_PERSON_ID , B.LM_ADHC_LRN_ID , B.LM_ENRLMT_ID , B.LM_PRG_REG_ID , B.LM_REQUIRED , LR2.LM_LPLN_STATUS FROM PS_LM_LPLN_ACTD_VW B , PS_LM_LPLN_LRN LR2 WHERE LR2.LM_LPLN_ID = B.LM_LPLN_ID AND LR2.LM_PERSON_ID = B.LM_PERSON_ID AND B.LM_REQUIRED = 'Y' AND LR2.LM_LPLN_STATUS <> 'C' AND B.LM_STTS NOT IN ('COMP', 'CANC') UNION SELECT C.LM_LPLN_ID , C.LM_PERSON_ID , C.LM_ADHC_LRN_ID , C.LM_ENRLMT_ID , C.LM_PRG_REG_ID , C.LM_REQUIRED , LR3.LM_LPLN_STATUS FROM PS_LM_LPLN_PRG_VW C , PS_LM_LPLN_LRN LR3 WHERE LR3.LM_LPLN_ID = C.LM_LPLN_ID AND LR3.LM_PERSON_ID = C.LM_PERSON_ID AND C.LM_REQUIRED = 'Y' AND LR3.LM_LPLN_STATUS <> 'C' AND C.LM_PRG_STTS NOT IN ('COMP', 'CANC') UNION SELECT D.LM_LPLN_ID , D.LM_PERSON_ID , D.LM_ADHC_LRN_ID , D.LM_ENRLMT_ID , D.LM_PRG_REG_ID , D.LM_REQUIRED , LR4.LM_LPLN_STATUS FROM PS_LM_LPLN_ADHC_VW D , PS_LM_LPLN_LRN LR4 WHERE LR4.LM_LPLN_ID = D.LM_LPLN_ID AND LR4.LM_PERSON_ID = D.LM_PERSON_ID AND D.LM_REQUIRED = 'Y' AND LR4.LM_LPLN_STATUS <> 'C' AND D.LM_ADHC_LRN_STTS NOT IN ('COMP', 'DROP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

3 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id

4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

5 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

6 LM_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required
Y/N Table Edit
Default Value: N

7 LM_LPLN_STATUS Character(1) VARCHAR2(1) NOT NULL Learning Plan Status
A=Active
C=Complete
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LPLN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Plan ID
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
4	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
5	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
6	LM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit Default Value: N
7	LM_LPLN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Status A=Active C=Complete I=Inactive