LM_ENR_LC_TD_VW (SQL View)	Index Back
Learning Component - Enrlmt Learning Component - Enrollment View This view returns the total duration for all student enrolled to a Learning Component - exceluded canceled and not-attended sessions

LM_ENR_LC_TD_VW

(SQL View)

Learning Component - Enrlmt

Learning Component - Enrollment View This view returns the total duration for all student enrolled to a Learning Component - exceluded canceled and not-attended sessions

SELECT A.LM_ACT_ID , A.LM_LC_ID , SUM(B.LM_TOTAL_DUR_HRS) FROM PS_LM_ENR_LC_TBL A , PS_LM_ENR_LC_DUR B , PS_LM_ENRLMT C WHERE %Join(COMMON_KEYS, LM_ENR_LC_TBL A, LM_ENR_LC_DUR B) AND %Join(COMMON_KEYS, LM_ENR_LC_TBL A, LM_ENRLMT C ) AND EXISTS ( SELECT 'X' FROM PS_LM_STD_CST_UPDT R , PS_LM_ACT S WHERE S.LM_ACT_ID = C.LM_ACT_ID AND S.LM_ACT_TYPE = R.LM_ACT_TYPE AND C.LM_STTS = R.LM_STTS) GROUP BY A.LM_ACT_ID, A.LM_LC_ID

# 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_TOTAL_DUR_HRS Number(10,3) DECIMAL(9,3) NOT NULL Total Duration

#	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_TOTAL_DUR_HRS	Number(10,3)	DECIMAL(9,3) NOT NULL	Total Duration