LM_SUPP_LRN_VW (SQL View)	Index Back
Supplemental Enrollment View Supplemental Enrollment View

LM_SUPP_LRN_VW

(SQL View)

Supplemental Enrollment View

SELECT A.LM_ADHC_LRN_ID , A.LM_PER_TRN_NM , 'Supplemental' , A.LM_ADHC_LRN_STTS , B.XLATLONGNAME , A.LM_INITIATED_DT , A.LM_ENRL_DT , A.LM_COMPL_DT , %DatePart(A.LM_ROW_ADDED_DTTM) , A.LM_DROP_DT , A.LM_REQUESTOR_ID , A.LM_PERSON_ID , C.LM_NAME_DISPLAY FROM PS_LM_ADHC_LRN_VW A , XLATTABLE_VW B , PS_LM_PERSON_NAME C WHERE B.FIELDNAME = 'LM_ADHC_LRN_STTS' AND B.FIELDVALUE = A.LM_ADHC_LRN_STTS AND C.LM_PERSON_ID = A.LM_REQUESTOR_ID AND C.LM_DISPLAY_FLAG = 'Y' AND A.LM_ADHC_LRN_STTS <> 'DROP' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT

Related Language Record: LM_SUPP_LRN_LVW

# 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_DROP_DT Date(10) DATE The date on which the Enrollment was dropped.

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

#	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_DROP_DT	Date(10)	DATE	The date on which the Enrollment was dropped.
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