LM_SRCH_COMB_VW

(SQL View)
 Index Back

SES: Facility Combined Keys

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 , F.LM_FCLTY , S.LM_ROOM_ID , S.LM_SES_DT , S.LM_START_TM , S.LM_END_TM , S.TIMEZONE , R.LM_REQD_FLAG , F.COUNTRY , C.DESCR , F.STATE , F.CITY , S.LM_SS_FCLTY_DISP FROM 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 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: LM_SRCH_COMBLVW

    • # 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 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
    7 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
    8 LM_SES_DT Date(10) DATE Session Date
    9 LM_START_TM Time(15) TIMESTAMP Start Time
    10 LM_END_TM Time(15) TIMESTAMP End Time
    11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    12 LM_REQD_FLAG Character(1) VARCHAR2(1) NOT NULL Learning Component required? - Blended Learning
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    14 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
    15 STATE Character(6) VARCHAR2(6) NOT NULL State
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service