LM_SRCH_PRG_LVW

(SQL View)
 Index Back

SES view Prog Rel Language

This view is used on query LM_SRCH_PRG_PRNT. This is the related language view.

SELECT ALNG.LM_PRG_ID , ALNG.LANGUAGE_CD , CLNG.XLATLONGNAME , ALNG.LM_PRG_LONG_NM , ALNG.LM_PRG_DESCR , ALNG.LM_PRG_LONG_NM , ALNG.LM_PRG_SHORT_NM , ALNG.LM_PRG_DESCR , ALNG.LM_SRCH_COUNTRY , ALNG.LM_SRCH_STATE , ALNG.LM_SRCH_CITY , ALNG.LM_SRCH_UP_EVENTS FROM PS_LM_PRG_VER_VW A , PS_LM_PRG_VER_LVW ALNG , PSXLATITEM C , PSXLATITEMLANG CLNG WHERE A.LM_PRG_ID = ALNG.LM_PRG_ID AND ALNG.LANGUAGE_CD = CLNG.LANGUAGE_CD AND C.FIELDNAME = CLNG.FIELDNAME AND C.FIELDVALUE = CLNG.FIELDVALUE AND C.EFFDT = CLNG.EFFDT AND %Sql(LM_SRCH_PRG_SQL) UNION SELECT A.LM_PRG_ID , CLNG.LANGUAGE_CD , CLNG.XLATLONGNAME , A.LM_PRG_LONG_NM , A.LM_PRG_DESCR , A.LM_PRG_LONG_NM , A.LM_PRG_SHORT_NM , A.LM_PRG_DESCR , A.LM_SRCH_COUNTRY , A.LM_SRCH_STATE , A.LM_SRCH_CITY , A.LM_SRCH_UP_EVENTS FROM PS_LM_PRG_VER_VW A , PSXLATITEM C , PSXLATITEMLANG CLNG WHERE C.FIELDNAME = CLNG.FIELDNAME AND C.FIELDVALUE = CLNG.FIELDVALUE AND C.EFFDT = CLNG.EFFDT AND %Sql(LM_SRCH_PRG_SQL) AND NOT EXISTS ( SELECT 1 FROM PS_LM_PRG_VER_LVW ALNG WHERE A.LM_PRG_ID = ALNG.LM_PRG_ID AND ALNG.LANGUAGE_CD = CLNG.LANGUAGE_CD) UNION SELECT ALNG.LM_PRG_ID , ALNG.LANGUAGE_CD , C.XLATLONGNAME , ALNG.LM_PRG_LONG_NM , ALNG.LM_PRG_DESCR , ALNG.LM_PRG_LONG_NM , ALNG.LM_PRG_SHORT_NM , ALNG.LM_PRG_DESCR , ALNG.LM_SRCH_COUNTRY , ALNG.LM_SRCH_STATE , ALNG.LM_SRCH_CITY , ALNG.LM_SRCH_UP_EVENTS FROM PS_LM_PRG_VER_VW A , PS_LM_PRG_VER_LVW ALNG , PSXLATITEM C WHERE A.LM_PRG_ID = ALNG.LM_PRG_ID AND %Sql(LM_SRCH_PRG_SQL) AND NOT EXISTS ( SELECT 1 FROM PSXLATITEMLANG CLNG WHERE ALNG.LANGUAGE_CD = CLNG.LANGUAGE_CD AND C.FIELDNAME = CLNG.FIELDNAME AND C.FIELDVALUE = CLNG.FIELDVALUE AND C.EFFDT = CLNG.EFFDT)

  • Related Language Record for LM_SRCH_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_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    4 LM_SRCH_TITLE Character(200) VARCHAR2(200) NOT NULL Search Title
    5 LM_SRCH_DESCR Character(254) VARCHAR2(254) NOT NULL Search Description
    6 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    7 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    8 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    9 LM_SRCH_COUNTRY Character(30) VARCHAR2(30) NOT NULL Country Description
    10 LM_SRCH_STATE Character(30) VARCHAR2(30) NOT NULL State Description
    11 LM_SRCH_CITY Character(30) VARCHAR2(30) NOT NULL City
    12 LM_SRCH_UP_EVENTS Character(100) VARCHAR2(100) NOT NULL Upcoming Events