LM_LC_TOTCNT_VW (SQL View)	Index Back
Tota LC Count for an Instr Total LC Count for an Instructor

LM_LC_TOTCNT_VW

(SQL View)

Tota LC Count for an Instr

Total LC Count for an Instructor

SELECT A.LM_ACT_ID , B.LM_LC_ID , A.LM_PERSON_ID , C.LM_LC_COMP_STTS , COUNT(B.LM_LC_ID) , B.LM_PASS_REQD FROM PS_LM_ACT_INS_VW3 A , PS_LM_LC_VW B , PS_LM_LC_ROST_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_ID = C.LM_LC_ID AND B.LM_LC_TYPE_ID = 2 AND B.LM_BAS_LC_TYPE = '20' GROUP BY A.LM_ACT_ID, B.LM_LC_ID,A.LM_PERSON_ID, C.LM_LC_COMP_STTS, B.LM_PASS_REQD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 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

5 LM_COUNT Number(10,0) DECIMAL(10) NOT NULL Field to keep track of the count of id fields

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	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
5	LM_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Field to keep track of the count of id fields
6	LM_PASS_REQD	Character(1)	VARCHAR2(1) NOT NULL	Passing Required