LM_ENRL_LRN_VW (SQL View)	Index Back
Activity Enrollment View Activity Enrollment View

LM_ENRL_LRN_VW

(SQL View)

Activity Enrollment View

SELECT A.LM_ACT_ID , B.LM_CS_LONG_NM , 'Activity' , A.LM_STTS , C.XLATLONGNAME , A.LM_INITIATED_DT , A.LM_ENRL_DT , A.LM_COMPL_DT , %DatePart(A.LM_ROW_ADDED_DTTM) , A.LM_DP_DT , A.LM_REQUESTOR_ID , A.LM_PERSON_ID , D.LM_NAME_DISPLAY , A.LM_TARGET_CMPL_DT , A.LM_ENRLMT_ID FROM PS_LM_ENRLMT_VW A LEFT OUTER JOIN PS_LM_PERSON_NAME D ON (D.LM_PERSON_ID = A.LM_REQUESTOR_ID AND D.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT) , PS_LM_ACT_CI_VW B , XLATTABLE_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND C.FIELDNAME = 'LM_STTS' AND C.FIELDVALUE = A.LM_STTS AND A.LM_STTS IN ('PLAN','COMP','INPO','ENRL') AND A.LM_REQUESTOR_ID > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Id

2 LM_PER_TRN_NM Character(254) VARCHAR2(254) NOT NULL Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.

3 LM_LRN_TYPE_DESC Character(15) VARCHAR2(15) NOT NULL Type

4 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

5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

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

7 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

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

9 LM_DATE_ACKNWLDG Date(10) DATE Date Acknowledged

10 LM_DP_DT Date(10) DATE Drop Date

11 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

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

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

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

15 LM_CONFIRM_ID Number(10,0) DECIMAL(10) NOT NULL Confirmation ID for Activity , Program , Adhoc

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Id
2	LM_PER_TRN_NM	Character(254)	VARCHAR2(254) NOT NULL	Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.
3	LM_LRN_TYPE_DESC	Character(15)	VARCHAR2(15) NOT NULL	Type
4	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
5	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
6	LM_INITIATED_DT	Date(10)	DATE	The date on which the course was launched by the student. This applies only for WBT.
7	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
8	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
9	LM_DATE_ACKNWLDG	Date(10)	DATE	Date Acknowledged
10	LM_DP_DT	Date(10)	DATE	Drop Date
11	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
12	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
13	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
14	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.
15	LM_CONFIRM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Confirmation ID for Activity , Program , Adhoc