LM_PRG_VER_LVW

(SQL View)
 Index Back

Program SES View Rel Language

Program related language view (Multi-Language). The related language for message set number 18088 and message numbers 300, 301, 302, and 307 must exists. All message set numbers must be translated for this view.

SELECT B1LNG.LM_PRG_ID , B1LNG.LANGUAGE_CD , B1LNG.LM_PRG_LONG_NM , B1LNG.LM_PRG_SHORT_NM , B1LNG.LM_PRG_DESCR , M300LNG.MESSAGE_TEXT , M301LNG.MESSAGE_TEXT , M302LNG.MESSAGE_TEXT , M307LNG.MESSAGE_TEXT FROM PS_LM_PRG A1 , PS_LM_PRG_LANG B1LNG LEFT OUTER JOIN PSMSGCATLANG M300LNG ON M300LNG.MESSAGE_SET_NBR = 18088 AND M300LNG.MESSAGE_NBR = 300 LEFT OUTER JOIN PSMSGCATLANG M301LNG ON M301LNG.MESSAGE_SET_NBR = 18088 AND M301LNG.MESSAGE_NBR = 301 LEFT OUTER JOIN PSMSGCATLANG M302LNG ON M302LNG.MESSAGE_SET_NBR = 18088 AND M302LNG.MESSAGE_NBR = 302 LEFT OUTER JOIN PSMSGCATLANG M307LNG ON M307LNG.MESSAGE_SET_NBR = 18088 AND M307LNG.MESSAGE_NBR = 307 WHERE B1LNG.LANGUAGE_CD = M300LNG.LANGUAGE_CD AND B1LNG.LANGUAGE_CD = M301LNG.LANGUAGE_CD AND B1LNG.LANGUAGE_CD = M302LNG.LANGUAGE_CD AND B1LNG.LANGUAGE_CD = M307LNG.LANGUAGE_CD AND %CurrentDateIn BETWEEN A1.EFFDT AND A1.LM_END_EFFDT AND (A1.LM_EXPR_DT >= %CurrentDateIn OR A1.LM_EXPR_DT IS NULL) AND A1.LM_PRG_ID = B1LNG.LM_PRG_ID UNION SELECT A2.LM_PRG_ID , M300LNG.LANGUAGE_CD , A2.LM_PRG_LONG_NM , A2.LM_PRG_SHORT_NM , A2.LM_PRG_DESCR , M300LNG.MESSAGE_TEXT , M301LNG.MESSAGE_TEXT , M302LNG.MESSAGE_TEXT , M307LNG.MESSAGE_TEXT FROM PS_LM_PRG A2 LEFT OUTER JOIN PSMSGCATLANG M300LNG ON M300LNG.MESSAGE_SET_NBR = 18088 AND M300LNG.MESSAGE_NBR = 300 LEFT OUTER JOIN PSMSGCATLANG M301LNG ON M301LNG.MESSAGE_SET_NBR = 18088 AND M301LNG.MESSAGE_NBR = 301 LEFT OUTER JOIN PSMSGCATLANG M302LNG ON M302LNG.MESSAGE_SET_NBR = 18088 AND M302LNG.MESSAGE_NBR = 302 LEFT OUTER JOIN PSMSGCATLANG M307LNG ON M307LNG.MESSAGE_SET_NBR = 18088 AND M307LNG.MESSAGE_NBR = 307 WHERE M300LNG.LANGUAGE_CD = M301LNG.LANGUAGE_CD AND M300LNG.LANGUAGE_CD = M302LNG.LANGUAGE_CD AND M300LNG.LANGUAGE_CD = M307LNG.LANGUAGE_CD AND %CurrentDateIn BETWEEN A2.EFFDT AND A2.LM_END_EFFDT AND (A2.LM_EXPR_DT >= %CurrentDateIn OR A2.LM_EXPR_DT IS NULL) AND NOT EXISTS ( SELECT 1 FROM PS_LM_PRG_LANG A2LNG WHERE A2.LM_PRG_ID = A2LNG.LM_PRG_ID AND A2.EFFDT = A2LNG.EFFDT AND A2LNG.LANGUAGE_CD = M300LNG.LANGUAGE_CD AND A2LNG.LANGUAGE_CD = M301LNG.LANGUAGE_CD AND A2LNG.LANGUAGE_CD = M302LNG.LANGUAGE_CD AND A2LNG.LANGUAGE_CD = M307LNG.LANGUAGE_CD )

  • Related Language Record for LM_PRG_VER_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_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    5 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    6 LM_SRCH_COUNTRY Character(30) VARCHAR2(30) NOT NULL Country Description
    7 LM_SRCH_STATE Character(30) VARCHAR2(30) NOT NULL State Description
    8 LM_SRCH_CITY Character(30) VARCHAR2(30) NOT NULL City
    9 LM_SRCH_UP_EVENTS Character(100) VARCHAR2(100) NOT NULL Upcoming Events