LM_LPLN_PRG_VW (SQL View)	Index Back
Learning Plan with Prog Reg Learning Plan with Program Registrations The status ENRL is changed to REGR. The translate value for REGR is use on field LM_LPLN_DTL_STTS as Registered.

LM_LPLN_PRG_VW

(SQL View)

Learning Plan with Prog Reg

Learning Plan with Program Registrations The status ENRL is changed to REGR. The translate value for REGR is use on field LM_LPLN_DTL_STTS as Registered.

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 , PG.LM_PRG_LONG_NM , PG.LM_PRG_TYPE , CASE WHEN PR.LM_PRG_STTS = 'ENRL' THEN 'REGR' ELSE PR.LM_PRG_STTS END , PG.LM_PRG_ID , PG.EFFDT FROM PS_LM_LPLN_DTL A , PS_LM_PRG_REG PR , PS_LM_PRG PG WHERE A.LM_PRG_REG_ID = PR.LM_PRG_REG_ID AND PR.LM_PRG_ID = PG.LM_PRG_ID AND PR.LM_ENRL_DT BETWEEN PG.EFFDT AND PG.LM_END_EFFDT

Related Language Record: LM_LPLN_PRG_LVW

# 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_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

11 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

12 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning

13 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

14 EFFDT Date(10) DATE Effective Date

#	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_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
11	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
12	LM_PRG_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Reg Status CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning
13	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
14	EFFDT	Date(10)	DATE	Effective Date