LM_LPLN_ADHC_VW

(SQL View)
 Index Back

Learning Plan with Adhoc Enrl

Learning Plan with Adhoc enrollments

SELECT A.LM_LPLN_ID , A.LM_PERSON_ID , A.LM_PRG_REG_ID , A.LM_ENRLMT_ID , A.LM_ADHC_LRN_ID , A.LM_ASSIGNED_BY , A.LM_PRIORITY , A.LM_TARGET_DATE , A.LM_REQUIRED , L.LM_PER_TRN_NM , T.LM_ADHC_TYPE , L.LM_ADHC_LRN_STTS , T.LM_ADHC_ID FROM PS_LM_LPLN_DTL A , PS_LM_ADHC_LRN_TBL L , PS_LM_ADHC_TBL T WHERE L.LM_ADHC_ID = T.LM_ADHC_ID AND L.LM_ENRL_DT BETWEEN T.EFFDT AND T.LM_END_EFFDT AND A.LM_ADHC_LRN_ID = L.LM_ADHC_LRN_ID AND A.LM_PERSON_ID = L.LM_PERSON_ID

  • Related Language Record: LM_LPLN_ADHCLVW

    • # 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_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    5 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    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
    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

    10 LM_PER_TRN_NM Character(254) VARCHAR2(254) NOT NULL Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.
    11 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    12 LM_ADHC_LRN_STTS Character(4) VARCHAR2(4) NOT NULL Adhoc Learning Status
    COMP=Completed
    DECL=Denied
    DROP=Dropped
    INPO=In-Progress
    PEAP=Pending Approval
    PLAN=Planned
    13 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id