LM_PRG_LVW2

(SQL View)
Index Back

Program View2

Program View2

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

  • Related Language Record for LM_PRG_VW2
  • # 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.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    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
    5 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    6 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description