LM_PRGRE_MG_VW2 (SQL View)	Index Back
Manager Program Registration Manager Program Registration

LM_PRGRE_MG_VW2

(SQL View)

Manager Program Registration

SELECT A.LM_PERSON_ID , A.LM_PRG_REG_ID , C.FIRST_NAME , C.LAST_NAME , A.LM_PRG_ID , D.LM_PRG_LONG_NM , D.LM_PRG_TYPE , A.LM_TYPE , A.LM_PRG_STTS , A.LM_ENRL_DT , A.LM_COMPL_DT , A.LM_TARGET_CMPL_DT , A.LM_DP_DT , A.LM_CEU , C.LM_NAME_DISPLAY , A.LM_CERT_EFFDT , A.LM_INITIATED_DT , A.LM_STTS_CHANGE_DT , A.LM_MAND_ENRL_FLG FROM PS_LM_PRG_REG_VW A , PS_LM_PERS_NAME_VW C , PS_LM_PRG D WHERE A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_PRG_ID = D.LM_PRG_ID AND A.LM_ENRL_DT BETWEEN D.EFFDT AND D.LM_END_EFFDT

Related Language Record: LM_PRGREG2_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field

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

6 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

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

8 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

9 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

10 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

11 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete

12 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.

13 LM_DP_DT Date(10) DATE Drop Date

14 LM_CEU Number(8,2) DECIMAL(7,2) NOT NULL Continuing Education Units

15 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

16 LM_CERT_EFFDT Date(10) DATE Current Certification Date

17 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.

18 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date

19 LM_MAND_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	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.
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name field
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name Field
5	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
6	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
7	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
8	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
9	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
10	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
11	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
12	LM_TARGET_CMPL_DT	Date(10)	DATE	The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
13	LM_DP_DT	Date(10)	DATE	Drop Date
14	LM_CEU	Number(8,2)	DECIMAL(7,2) NOT NULL	Continuing Education Units
15	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
16	LM_CERT_EFFDT	Date(10)	DATE	Current Certification Date
17	LM_INITIATED_DT	Date(10)	DATE	The date on which the course was launched by the student. This applies only for WBT.
18	LM_STTS_CHANGE_DT	Date(10)	DATE	Status Chage Date
19	LM_MAND_ENRL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mandatory Learning Flag