LM_PRG_CD_SRLVW

(SQL View)
 Index Back

Program Search View


SELECT A.LM_PRG_ID , B.LANGUAGE_CD , B.LM_PRG_LONG_NM FROM PS_LM_PRG A , PS_LM_PRG_LANG B WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

  • Related Language Record for LM_PRG_CD_SRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

    Prompt Table: LM_PRG_VW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name