LM_LC_STATUS_VW (SQL View)	Index Back
Learning Comp status View Shows the status of a Learning Component enrollment

LM_LC_STATUS_VW

(SQL View)

Learning Comp status View

Shows the status of a Learning Component enrollment

SELECT A.LM_ENRLMT_ID , A.LM_LC_ID , B.LM_REQD_FLAG , B.LM_PASS_REQD , C.LM_PASS_STTS , A.LM_LC_COMP_STTS , A.LM_ATT_VAL_ID , A.LM_PASS_VAL_ID , A.LM_GRADE_VAL_ID , A.LM_SCORE , B.LM_BAS_LC_TYPE , B.LM_PASS_PCT , B.LM_ACT_ID , B.LM_COMP_SEQ_ID FROM PS_LM_ENR_LC_VW A , PS_LM_LC_ROUTE_VW B , PS_LM_PASS_SCH_VAL C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND A.LM_LC_ID = B.LM_LC_ID AND A.LM_PASS_VAL_ID = C.LM_PASS_VAL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning

3 LM_REQD_FLAG Character(1) VARCHAR2(1) NOT NULL Learning Component required? - Blended Learning

4 LM_PASS_REQD Character(1) VARCHAR2(1) NOT NULL Passing Required

5 LM_PASS_STTS Character(4) VARCHAR2(4) NOT NULL Passing Status
FAIL=Fail
NOMK=Not Marked
NORQ=Not Required
PASS=Pass
PEND=Pending

6 LM_LC_COMP_STTS Character(4) VARCHAR2(4) NOT NULL Learning Component - Completion Status
CANC=Dropped
COMP=Completed
INCO=Not Completed
INPO=In-Progress
NOAT=Not Attempted

7 LM_ATT_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
Prompt Table: LM_ATT_ALL_VW

8 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
Prompt Table: LM_PASS_SCH_VAL

9 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.

10 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.

11 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey

12 LM_PASS_PCT Number(3,0) SMALLINT NOT NULL this is to store the passing% to be used for compliant courses

13 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

14 LM_COMP_SEQ_ID Number(3,0) SMALLINT NOT NULL Learning Component sequence - Blended Learning

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
2	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
3	LM_REQD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Learning Component required? - Blended Learning
4	LM_PASS_REQD	Character(1)	VARCHAR2(1) NOT NULL	Passing Required
5	LM_PASS_STTS	Character(4)	VARCHAR2(4) NOT NULL	Passing Status FAIL=Fail NOMK=Not Marked NORQ=Not Required PASS=Pass PEND=Pending
6	LM_LC_COMP_STTS	Character(4)	VARCHAR2(4) NOT NULL	Learning Component - Completion Status CANC=Dropped COMP=Completed INCO=Not Completed INPO=In-Progress NOAT=Not Attempted
7	LM_ATT_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely Prompt Table: LM_ATT_ALL_VW
8	LM_PASS_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Passing Scheme Value ID Prompt Table: LM_PASS_SCH_VAL
9	LM_GRADE_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	This will uniquely identify the combination of User Label / Grade value.
10	LM_SCORE	Character(30)	VARCHAR2(30) NOT NULL	Score for this Enrollment. Score will be passed by Content Vendor.
11	LM_BAS_LC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Base Learning Component Type 10=Web-based 20=Sessions 30=Webcast 40=Assignment 50=Test 60=Survey
12	LM_PASS_PCT	Number(3,0)	SMALLINT NOT NULL	this is to store the passing% to be used for compliant courses
13	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
14	LM_COMP_SEQ_ID	Number(3,0)	SMALLINT NOT NULL	Learning Component sequence - Blended Learning