LM_LELW_LBAT_LG (SQL View)	Index Back
Learning Component Batch RL

LM_LELW_LBAT_LG

(SQL View)

Learning Component Batch RL

SELECT DISTINCT F.LM_LC_ID , B.LANGUAGE_CD , B.LM_CS_LONG_NM , F.LM_LC_LONG_NM FROM PS_LM_ACT_VW A , PS_LM_CI_VW_LNG B , PS_LM_SES_VW C , PS_LM_LELW_SES_BAT D , PS_LM_LELW_ENR_BAT E , PS_LM_LC_LVW F WHERE A.LM_CI_ID=B.LM_CI_ID AND A.LM_ACT_ID=C.LM_ACT_ID AND C.LM_LC_ID=F.LM_LC_ID AND B.LANGUAGE_CD=F.LANGUAGE_CD AND (C.LM_SES_ID=D.LM_SES_ID OR C.LM_SES_ID=E.LM_SES_ID)

Related Language Record for LM_LELW_LBAT_PT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

4 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
4	LM_LC_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Learning Component Long Name