LM_RTG_PRG_LVW

(SQL View)
 Index Back

Program View for Ratings Rel L

Related language for program view

SELECT PG.LM_PRG_ID , PGLG.LANGUAGE_CD , PGLG.LM_PRG_LONG_NM , PGLG.LM_PRG_DESCR FROM PS_LM_PRG PG , PS_LM_PRG_LANG PGLG WHERE PG.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_LM_PRG X WHERE PG.LM_PRG_ID = X.LM_PRG_ID AND X.EFFDT <= %CurrentDateIn) AND PG.LM_PRG_ID = PGLG.LM_PRG_ID AND PG.EFFDT = PGLG.EFFDT

  • Related Language Record for LM_RTG_PRG_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    4 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description