LM_LPLN_DTL (SQL Table)	Index Back
Learning Plan Detail This is the Learner's Learning Plan table. A learner can have multiple learning plans. This table willlink the learner's programs, enrollments, and supplemental learning that are added on the learning plan.

LM_LPLN_DTL

(SQL Table)

Learning Plan Detail

This is the Learner's Learning Plan table. A learner can have multiple learning plans. This table willlink the learner's programs, enrollments, and supplemental learning that are added on the learning plan.

# 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_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
Default Value: L

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
Default Value: N

10 LM_SCHEDULE_ENRLMT Character(1) VARCHAR2(1) NOT NULL Schedule Enrollment
Default Value: N

11 LM_SCHED_ENRL_FROM Date(10) DATE Schedule Enrollment Date Range

12 LM_SCHED_ENRL_TO Date(10) DATE Schedule Enrollment Date Range

13 LM_TRNG_REG_CD Character(30) VARCHAR2(30) NOT NULL Training Region
Prompt Table: LM_TRNG_REG_TBL

#	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_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 Default Value: L
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 Default Value: N
10	LM_SCHEDULE_ENRLMT	Character(1)	VARCHAR2(1) NOT NULL	Schedule Enrollment Default Value: N
11	LM_SCHED_ENRL_FROM	Date(10)	DATE	Schedule Enrollment Date Range
12	LM_SCHED_ENRL_TO	Date(10)	DATE	Schedule Enrollment Date Range
13	LM_TRNG_REG_CD	Character(30)	VARCHAR2(30) NOT NULL	Training Region Prompt Table: LM_TRNG_REG_TBL