LM_LPLN_DTL_LVW

(SQL View)
 Index Back

Learning Plan Detail VW Rel Lg

Related Language. A learner can have multiple learning plans. This view will show the link of the learner's programs, enrollments, and supplemental learnings that are added on the learning plan.

SELECT A1.LM_LPLN_ID , A1.LM_PERSON_ID , A1.LM_ADHC_LRN_ID , A1.LM_ENRLMT_ID , A1.LM_PRG_REG_ID , ALG1.LANGUAGE_CD , ALG1.LM_CS_LONG_NM , ALG1.LM_DM_LONG_NM FROM PS_LM_LPLN_ENRL_VW A1 , PS_LM_LPLN_ENRLLVW ALG1 WHERE A1.LM_LPLN_ID = ALG1.LM_LPLN_ID AND A1.LM_PERSON_ID = ALG1.LM_PERSON_ID AND A1.LM_PRG_REG_ID = ALG1.LM_PRG_REG_ID AND A1.LM_ENRLMT_ID = ALG1.LM_ENRLMT_ID AND A1.LM_ADHC_LRN_ID = ALG1.LM_ADHC_LRN_ID UNION SELECT B1.LM_LPLN_ID , B1.LM_PERSON_ID , B1.LM_ADHC_LRN_ID , B1.LM_ENRLMT_ID , B1.LM_PRG_REG_ID , BLG1.LANGUAGE_CD , BLG1.LM_CS_LONG_NM , ' ' FROM PS_LM_LPLN_ACTD_VW B1 , PS_LM_LPLN_ACTDLVW BLG1 WHERE B1.LM_LPLN_ID = BLG1.LM_LPLN_ID AND B1.LM_PERSON_ID = BLG1.LM_PERSON_ID AND B1.LM_PRG_REG_ID = BLG1.LM_PRG_REG_ID AND B1.LM_ENRLMT_ID = BLG1.LM_ENRLMT_ID AND B1.LM_ADHC_LRN_ID = BLG1.LM_ADHC_LRN_ID UNION SELECT C1.LM_LPLN_ID , C1.LM_PERSON_ID , C1.LM_ADHC_LRN_ID , C1.LM_ENRLMT_ID , C1.LM_PRG_REG_ID , CLG1.LANGUAGE_CD , CLG1.LM_PRG_LONG_NM , C1.LM_PRG_TYPE FROM PS_LM_LPLN_PRG_VW C1 , PS_LM_LPLN_PRG_LVW CLG1 WHERE C1.LM_LPLN_ID = CLG1.LM_LPLN_ID AND C1.LM_PERSON_ID = CLG1.LM_PERSON_ID AND C1.LM_PRG_REG_ID = CLG1.LM_PRG_REG_ID AND C1.LM_ENRLMT_ID = CLG1.LM_ENRLMT_ID AND C1.LM_ADHC_LRN_ID = CLG1.LM_ADHC_LRN_ID UNION SELECT D1.LM_LPLN_ID , D1.LM_PERSON_ID , D1.LM_ADHC_LRN_ID , D1.LM_ENRLMT_ID , D1.LM_PRG_REG_ID , DLG1.LANGUAGE_CD , DLG1.LM_PER_TRN_NM , DLG1.LM_ADHC_TYPE FROM PS_LM_LPLN_ADHC_VW D1 , PS_LM_LPLN_ADHCLVW DLG1 WHERE D1.LM_LPLN_ID = DLG1.LM_LPLN_ID AND D1.LM_PERSON_ID = DLG1.LM_PERSON_ID AND D1.LM_PRG_REG_ID = DLG1.LM_PRG_REG_ID AND D1.LM_ENRLMT_ID = DLG1.LM_ENRLMT_ID AND D1.LM_ADHC_LRN_ID = DLG1.LM_ADHC_LRN_ID

  • Related Language Record for LM_LPLN_DTL_VW LM_LPLN_MAN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    5 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 LM_LPLN_DTL_TITLE Character(254) VARCHAR2(254) NOT NULL This field is used to for the Learning Plan Learners Detail. The title from Enrollments, Program Registrations and Adhoc Enrollments: PS_LM_CI_TBL.LM_CS_LONG_NM PS_LM_PRG.LM_PRG_LONG_NM, PS_LM_ADHC_TBL.LM_PER_TRN_NM are placed on this field for display
    8 LM_LPLN_DTL_TYPE Character(200) VARCHAR2(200) NOT NULL This field is used for the Learning Plan Detail Page. The TYPE will be derived values from the following tables: PS_LM_ADHC_TBL.LM_ADHC_TYPE PS_LM_PRG.LM_PRG_TYPE PS_LM_ACT_PLN_VW.LM_DM_LONG_NM