LM_SUP_RGLN_LVW

(SQL View)
 Index Back

Suppliment Registered Learning

Supplimental Learning Language View- Registered Waiver Enabled Programs / Enrolled Courses.

SELECT E.LM_PERSON_ID , '10' , E.LM_CI_ID , 0 , E.LANGUAGE_CD , E.LM_CS_LONG_NM FROM PS_LM_ENR_CRS_LVW E UNION SELECT A.LM_PERSON_ID , '20' , 0 , A.LM_PRG_ID , L.LANGUAGE_CD , L.LM_PRG_LONG_NM FROM PS_LM_REG_PRG_VW A , PS_LM_PRG B , PS_LM_PRG_LVW3 L WHERE B.LM_PRG_ID = A.LM_PRG_ID AND A.LM_ENRL_DT BETWEEN B.EFFDT AND B.LM_END_EFFDT AND B.LM_ALLOW_WAIVER = 'Y' AND A.LM_PRG_ID = L.LM_PRG_ID AND B.EFFDT = L.EFFDT

  • Related Language Record for LM_SUP_RGLRN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_LEARN_TYPE Character(2) VARCHAR2(2) NOT NULL Learning Type
    10=Course
    20=Program
    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_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_CATG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object