LM_LPLN_ENRL_VW (SQL View)	Index Back
Learning Plan with Enrollments Learning Plan with Enrollments. The enrollments that have LM_TYPE = PLAN and LM_STTS = CANC are excluded. These enrollments are planned but later drop.

LM_LPLN_ENRL_VW

(SQL View)

Learning Plan with Enrollments

Learning Plan with Enrollments. The enrollments that have LM_TYPE = PLAN and LM_STTS = CANC are excluded. These enrollments are planned but later drop.

SELECT A.LM_LPLN_ID , A.LM_PERSON_ID , A.LM_PRG_REG_ID , A.LM_ENRLMT_ID , A.LM_ADHC_LRN_ID , A.LM_ASSIGNED_BY , A.LM_PRIORITY , A.LM_TARGET_DATE , A.LM_REQUIRED , CI.LM_CS_LONG_NM , ACT.LM_DM_LONG_NM , ENRL.LM_STTS , ENRL.LM_TYPE , ENRL.LM_ACT_REQ , ENRL.LM_ACT_ID , ENRL.LM_CI_ID FROM PS_LM_LPLN_DTL A , PS_LM_ENRLMT ENRL , PS_LM_CI_TBL CI , PS_LM_ACT_PLN_VW ACT WHERE A.LM_ENRLMT_ID = ENRL.LM_ENRLMT_ID AND ENRL.LM_CI_ID = CI.LM_CI_ID AND ENRL.LM_ACT_ID = ACT.LM_ACT_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND CI.LM_CI_STATUS = '10' AND NOT(ENRL.LM_STTS = 'CANC' AND ENRL.LM_TYPE = 'PLAN')

Related Language Record: LM_LPLN_ENRLLVW

# 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_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

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

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

6 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By

7 LM_PRIORITY Character(1) VARCHAR2(1) NOT NULL Learning Plan Priority
H=High
L=Low
M=Medium

8 LM_TARGET_DATE Date(10) DATE Learning Plan Target Date

9 LM_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required
Y/N Table Edit

10 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

11 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type

12 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted

13 LM_TYPE Character(4) VARCHAR2(4) NOT NULL Type of the Enrollment. This field for now will have only one value STDD
ADHC=Adhoc
PLAN=Planned
RSRV=Reserved
STDD=Standard

14 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
N=No
Y=Yes

15 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

16 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

#	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_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
4	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
5	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
6	LM_ASSIGNED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By
7	LM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Priority H=High L=Low M=Medium
8	LM_TARGET_DATE	Date(10)	DATE	Learning Plan Target Date
9	LM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit
10	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
11	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
12	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
13	LM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Type of the Enrollment. This field for now will have only one value STDD ADHC=Adhoc PLAN=Planned RSRV=Reserved STDD=Standard
14	LM_ACT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Activity Required N=No Y=Yes
15	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
16	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item