LM_LPLN_MAN_VW

(SQL View)
 Index Back

Learning Plan Detail View

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 A.LM_LPLN_ID , A.LM_PERSON_ID , A.LM_ADHC_LRN_ID , A.LM_ENRLMT_ID , A.LM_PRG_REG_ID , A.LM_ASSIGNED_BY , A.LM_PRIORITY , A.LM_TARGET_DATE , A.LM_REQUIRED , A.LM_CS_LONG_NM , A.LM_DM_LONG_NM , A.LM_STTS , A.LM_ACT_REQ , 0 , A.LM_ACT_ID , A.LM_CI_ID , %DateNull FROM PS_LM_LPLN_ENRL_VW A WHERE EXISTS( SELECT 'X' FROM PS_LM_MAND_FL_VW C WHERE A.LM_CI_ID=C.LM_CI_ID AND A.LM_PERSON_ID=C.LM_PERSON_ID) UNION SELECT B.LM_LPLN_ID , B.LM_PERSON_ID , B.LM_ADHC_LRN_ID , B.LM_ENRLMT_ID , B.LM_PRG_REG_ID , B.LM_ASSIGNED_BY , B.LM_PRIORITY , B.LM_TARGET_DATE , B.LM_REQUIRED , B.LM_CS_LONG_NM , ' ' , B.LM_STTS , B.LM_ACT_REQ , 0 , 0 , B.LM_CI_ID , %DateNull FROM PS_LM_LPLN_ACTD_VW B WHERE EXISTS( SELECT 'X' FROM PS_LM_MAND_FL_VW C WHERE B.LM_CI_ID=C.LM_CI_ID AND B.LM_PERSON_ID=C.LM_PERSON_ID)

  • Related Language Record: LM_LPLN_DTL_LVW

    • # 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 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By
    7 LM_PRIORITY Character(1) VARCHAR2(1) NOT NULL Learning Plan Priority
    H=High
    L=Low
    M=Medium

    Default Value: L

    8 LM_TARGET_DATE Date(10) DATE Learning Plan Target Date
    9 LM_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    Default Value: N

    10 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
    11 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
    12 LM_LPLN_DTL_STTS Character(4) VARCHAR2(4) NOT NULL The translate values for this field are derived from the translate values of fields: LM_PRG_STTS, LM_ADHC_LRN_STTS, LM_STTS Also note that new value REGR (Registered) is added. This is used for program registation when status is ENRL. View PS_LM_LPLN_PRG_VW transforms status ENRL to REGR
    CANC=Dropped
    COMP=Completed
    DECL=Denied
    DROP=Dropped
    ENRL=Enrolled
    EXPR=Expired
    INCO=Not Completed
    INPO=In-Progress
    MACT=Moved to New Activity
    PEAP=Pending Approval
    PEPA=Pending Payment
    PLAN=Planned
    PPYA=Payment Approval
    REGR=Registered
    REIS=Reissue
    REVK=Revoked
    RQST=Learning Request
    WAIV=Waived
    WARN=Warning
    WTLT=Waitlisted
    13 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    14 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    15 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    16 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    17 EFFDT Date(10) DATE Effective Date