LM_LPLN_PRG_LVW

(SQL View)
Index Back

Learning Plan with Prog Reg

Related language for Learning Plan with Program Registrations The status ENRL is changed to REGR. The translate value for REGR is use on field LM_LPLN_DTL_STTS as Registered.

SELECT A1.LM_LPLN_ID , A1.LM_PERSON_ID , A1.LM_PRG_REG_ID , A1.LM_ENRLMT_ID , A1.LM_ADHC_LRN_ID , PGLG1.LANGUAGE_CD , PGLG1.LM_PRG_LONG_NM FROM PS_LM_LPLN_DTL A1 , PS_LM_PRG_REG PR1 , PS_LM_PRG PG1 , PS_LM_PRG_LANG PGLG1 WHERE A1.LM_PRG_REG_ID = PR1.LM_PRG_REG_ID AND PR1.LM_PRG_ID = PG1.LM_PRG_ID AND PR1.LM_ENRL_DT BETWEEN PG1.EFFDT AND PG1.LM_END_EFFDT AND PG1.LM_PRG_ID = PGLG1.LM_PRG_ID AND PG1.EFFDT = PGLG1.EFFDT

  • Related Language Record for LM_LPLN_PRG_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_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name