LM_AP_SESENR_VW

(SQL View)
 Index Back

Sessions for Enrollment Apprv

This view has the sessions for the enrollment approvals where session date is greater or equal the the current date.

SELECT E.LM_ENRLMT_ID , A.LM_ACT_ID , A.LM_LC_ID , A.LM_SES_ID , %Dttm(A.LM_SES_DT ,A.LM_END_TM) , A.LM_END_TM , ' ' , A.LM_FCLTY_ID , ' ' , A.LM_ROOM_ID , A.LM_SES_DT , A.LM_SS_FCLTY_DISP , ' ' , %Dttm(A.LM_SES_DT ,A.LM_START_TM) , A.LM_START_TM , ' ' , A.TIMEZONE FROM PS_LM_SES A , PS_LM_ENRLMT E WHERE A.LM_ACT_ID = E.LM_ACT_ID AND A.LM_SES_DT >= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment 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_END_DTTM DateTime(26) TIMESTAMP End Time
6 LM_END_TM Time(15) TIMESTAMP End Time
7 LM_END_TM_TEXT Character(11) VARCHAR2(11) NOT NULL End Time
8 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
9 LM_FCLTY_TEXT Character(200) VARCHAR2(200) NOT NULL Location
10 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
11 LM_SES_DT Date(10) DATE Session Date
12 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service
13 LM_START_DT_TEXT Character(100) VARCHAR2(100) NOT NULL Start Date
14 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
15 LM_START_TM Time(15) TIMESTAMP Start Time
16 LM_START_TM_TEXT Character(11) VARCHAR2(11) NOT NULL Start Time
17 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE