LM_CAL_SES_VW1

(SQL View)
Index Back

Calendar Sessions Sub Record

Calendar Session(s) Sub Record

SELECT E1.LM_PERSON_ID ,S1.LM_ACT_ID , S1.LM_LC_ID , S1.LM_SES_ID , 0 , E1.LM_ENRLMT_ID , S1.LM_FCLTY_ID , S1.LM_ROOM_ID , S1.LM_SS_FCLTY_DISP , E1.LM_CI_ID , S1.LM_SES_DT , S1.LM_START_TM , S1.LM_END_TM , S1.TIMEZONE ,%Dttm(S1.LM_SES_DT ,S1.LM_START_TM) ,%Dttm(S1.LM_SES_DT ,S1.LM_END_TM) , L1.LM_BAS_LC_TYPE ,L1.LM_LAUNCH_URL FROM PS_LM_SESALL_FC_VW S1 , PS_LM_ENRLMT E1 , PS_LM_LC L1 , PS_LM_ACT A1 WHERE A1.LM_ACT_ID = L1.LM_ACT_ID AND A1.LM_ACT_ID = E1.LM_ACT_ID AND L1.LM_ACT_ID = S1.LM_ACT_ID AND L1.LM_LC_ID = S1.LM_LC_ID AND %Dttm(S1.LM_SES_DT ,S1.LM_END_TM) >= %CurrentDateTimeIn AND E1.LM_STTS IN ('ENRL','INPO') AND L1.LM_BAS_LC_TYPE IN ('20','30')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
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_RSRV_RM_ID Number(10,0) DECIMAL(10) NOT NULL Reserve Room ID
6 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
7 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
8 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
9 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service

Y/N Table Edit

10 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
11 LM_SES_DT Date(10) DATE Session Date
12 LM_START_TM Time(15) TIMESTAMP Start Time
13 LM_END_TM Time(15) TIMESTAMP End Time
14 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
15 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
16 LM_END_DTTM DateTime(26) TIMESTAMP End Time
17 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey
18 LM_LAUNCH_URL Long Character(2000) VARCHAR2(2000) URL or File path - Holds the URL or File Path name for an activity.