LM_RTG_PRG_VW

(SQL View)
Index Back

Program View for Ratings

Program View for Ratings

SELECT PG.LM_PRG_ID , PG.LM_PRG_LONG_NM , PG.LM_PRG_DESCR FROM PS_LM_PRG PG 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)

  • Related Language Record: LM_RTG_PRG_LVW
  • # 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 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    3 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description