LM_HIST_PRG_LVW

(SQL View)
 Index Back

Learner Programs

Lists all programs (any status) associated with a learner. Joins to the program table with the program registration table to bring in all of the program information, selecting the correct effective dated program row based upon the learners registration date.

SELECT A.LM_PERSON_ID ,A.LM_PRG_REG_ID ,A.LM_PRG_ID ,C.LANGUAGE_CD ,C.LM_PRG_LONG_NM FROM PS_LM_PRG_REG_VW A LEFT JOIN PS_LM_LRNR_CERT D ON A.LM_PRG_REG_ID=D.LM_PRG_REG_ID , PS_LM_PRG B , PS_LM_PRG_LVW3 C WHERE A.LM_PRG_ID = B.LM_PRG_ID AND B.LM_PRG_ID = C.LM_PRG_ID AND B.EFFDT = C.EFFDT AND A.LM_ENRL_DT BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_PRG_STTS IN ('COMP','REIS','EXPR','REVK','INCO','CANC','WAIV','DECL')

  • Related Language Record for LM_HIST_PRG_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_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name