LM_PRG_ENRL_LVW

(SQL View)
 Index Back

Enrollment for Program


SELECT B.LM_PRG_REG_ID , D.LM_PRG_ID , D.LANGUAGE_CD , D.LM_PRG_LONG_NM FROM PS_LM_PRG A , PS_LM_PRG_REG B , PS_LM_ENRLMT_PYMT C , PS_LM_PRG_LANG D WHERE C.LM_ENRLMT_TYPE <>'ACT' AND C.LM_ENRLMT_ID = B.LM_PRG_REG_ID AND A.LM_PRG_ID = B.LM_PRG_ID AND D.LM_PRG_ID = A.LM_PRG_ID AND D.EFFDT = A.EFFDT AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

  • Related Language Record for LM_PRG_ENRL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name