LM_SRCH_COMBLVW

(SQL View)
 Index Back

SES: Facility Combined Keys

This is the related language view. Facility and location data for Activities and Session data. Also, it is possible that there are sessions without facility data. This view will select all sessions with or without facility.

SELECT E.LM_CI_ID , S.LM_ACT_ID , S.LM_LC_ID , S.LM_SES_ID , S.LM_FCLTY_ID , CL.LANGUAGE_CD , CL.DESCR FROM PS_COUNTRYTBL_LANG CL , PS_LM_ACT E , PS_LM_ACT_ROUTES R , PS_LM_SES S LEFT OUTER JOIN PS_LM_FCLTY_TBL F ON S.LM_FCLTY_ID = F.LM_FCLTY_ID LEFT OUTER JOIN PS_COUNTRY_TBL C ON F.COUNTRY = C.COUNTRY LEFT OUTER JOIN PS_STATE_TBL D ON (F.STATE = D.STATE AND F.COUNTRY = D.COUNTRY) WHERE C.COUNTRY = CL.COUNTRY AND R.LM_ACT_ID = S.LM_ACT_ID AND R.LM_LC_ID = S.LM_LC_ID AND S.LM_ACT_ID = E.LM_ACT_ID AND (E.LM_END_DT IS NULL OR (%CurrentDateIn <= E.LM_END_DT AND E.LM_END_DT IS NOT NULL))

  • Related Language Record for LM_SRCH_COMB_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    4 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
    5 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description