LM_ENR_SELF_LVW

(SQL View)
 Index Back

Learning Component View

Basic Learning Component View

SELECT DISTINCT G.LM_ENRLMT_ID ,D.LM_PERSON_ID ,A.LM_CI_ID ,A.LM_ACT_ID ,LVW.LANGUAGE_CD , LVW.LM_DM_LONG_NM FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B , PS_LM_ACT_SEC C , PS_LM_PERS_LGRP_VW D , PS_LM_ENRLMT G , PS_LM_ACT_CI_LVW LVW WHERE A.LM_ACT_STATUS='1' AND A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_ACT_ID = LVW.LM_ACT_ID AND C.LM_LRNR_GROUP_ID=D.LM_LRNR_GROUP_ID AND (A.LM_END_DT>=%CurrentDateIn OR A.LM_END_DT IS NULL) AND G.LM_ACT_ID=A.LM_ACT_ID AND G.LM_CI_ID=A.LM_CI_ID AND G.LM_PERSON_ID=D.LM_PERSON_ID AND G.LM_STTS IN ('ENRL','INPO','PEAP','PEPA','PPYA','WTLT', 'COMP','INCO') AND NOT EXISTS( SELECT 'X' FROM PS_LM_LC_VW E WHERE E.LM_ACT_ID=B.LM_ACT_ID AND E.LM_BAS_LC_TYPE IN('20','30')) AND B.LM_LC_ID=( SELECT MAX(F.LM_LC_ID) FROM PS_LM_LC_VW F WHERE A.LM_ACT_ID=F.LM_ACT_ID)

  • Related Language Record for LM_ENR_SELF_VW

    • # 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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    4 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type