LM_LC_ROST_LVW

(SQL View)
 Index Back

Learning Comp Roster Lang View

Learning Component Roster Language View

SELECT A.LM_ENRLMT_ID , A.LM_LC_ID ,B.LANGUAGE_CD , B.LM_ORG_DESCR , B.LM_ORG_SDESCR , C.LM_LC_LONG_NM , C.LM_LC_TYPE_LONG , %Cast(A.LM_ENRLMT_DESCR,Long,Character) FROM PS_LM_ENR_LC_TBL A , PS_LM_PERS_DTL_LVW B , PS_LM_LC_ROUTE_LVW C , PS_LM_ENRLMT D WHERE A.LM_ENRLMT_ID = D.LM_ENRLMT_ID AND D.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_LC_ID = C.LM_LC_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_ACT_ID = D.LM_ACT_ID AND D.LM_STTS IN ('COMP', 'ENRL', 'INCO', 'INPO') AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.LM_ENRLMT_ID , A.LM_LC_ID ,C.LANGUAGE_CD , B.LM_ORG_DESCR , B.LM_ORG_SDESCR , C.LM_LC_LONG_NM , C.LM_LC_TYPE_LONG , %Cast(A.LM_ENRLMT_DESCR,Long,Character) FROM PS_LM_ENR_LC_TBL A , PS_LM_PERS_DTL_VW B , PS_LM_LC_ROUTE_LVW C , PS_LM_ENRLMT D WHERE A.LM_ENRLMT_ID = D.LM_ENRLMT_ID AND D.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_LC_ID = C.LM_LC_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_ACT_ID = D.LM_ACT_ID AND D.LM_STTS IN ('COMP', 'ENRL', 'INCO', 'INPO') AND NOT EXISTS ( SELECT 'X' FROM PS_LM_PERS_DTL_LVW E WHERE E.LM_PERSON_ID = B.LM_PERSON_ID AND E.LANGUAGE_CD = C.LANGUAGE_CD) UNION SELECT A.LM_ENRLMT_ID , A.LM_LC_ID ,B.LANGUAGE_CD , B.LM_ORG_DESCR , B.LM_ORG_SDESCR , C.LM_LC_LONG_NM , C.LM_LC_TYPE_LONG , %Cast(A.LM_ENRLMT_DESCR,Long,Character) FROM PS_LM_ENR_LC_TBL A , PS_LM_PERS_DTL_LVW B , PS_LM_LC_ROUTE_VW C , PS_LM_ENRLMT D WHERE A.LM_ENRLMT_ID = D.LM_ENRLMT_ID AND D.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_LC_ID = C.LM_LC_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_ACT_ID = D.LM_ACT_ID AND D.LM_STTS IN ('COMP', 'ENRL', 'INCO', 'INPO') AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LC_ROUTE_LVW E WHERE E.LM_ACT_ID = C.LM_ACT_ID AND E.LM_LC_ID = C.LM_LC_ID AND E.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for LM_LC_ROST_S_VW LM_LC_ROST_VW LM_LC_RST_FL_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_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    5 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    6 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
    7 LM_LC_TYPE_LONG Character(200) VARCHAR2(200) NOT NULL Learning Component Type Long Name
    8 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments