LM_SES_FIRST_VW (SQL View)	Index Back
Session First Scheduled Selects the first scheduled session date from current date for the ACTIVE class.

LM_SES_FIRST_VW

(SQL View)

Session First Scheduled

Selects the first scheduled session date from current date for the ACTIVE class.

SELECT S.LM_ACT_ID , S.LM_LC_ID , S.LM_SES_ID , S.LM_SES_DT , S.LM_START_TM , S.LM_END_TM , S.TIMEZONE , S.LM_FCLTY_ID , S.LM_ROOM_ID , S.LM_SS_FCLTY_DISP FROM PS_LM_SES S , PS_LM_ACT A WHERE A.LM_ACT_ID = S.LM_ACT_ID AND A.LM_ACT_STATUS = '1' AND S.LM_SES_DT = ( SELECT MIN(X1.LM_SES_DT) FROM PS_LM_SES X1 WHERE X1.LM_ACT_ID = S.LM_ACT_ID AND X1.LM_SES_DT >= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning

3 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID

4 LM_SES_DT Date(10) DATE NOT NULL Session Date

5 LM_START_TM Time(15) TIMESTAMP NOT NULL Start Time

6 LM_END_TM Time(15) TIMESTAMP NOT NULL End Time

7 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

8 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
Prompt Table: LM_FCLTY_SRCH

9 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
Prompt Table: LM_ROOM_SRCH

10 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
3	LM_SES_ID	Number(10,0)	DECIMAL(10) NOT NULL	Session ID
4	LM_SES_DT	Date(10)	DATE NOT NULL	Session Date
5	LM_START_TM	Time(15)	TIMESTAMP NOT NULL	Start Time
6	LM_END_TM	Time(15)	TIMESTAMP NOT NULL	End Time
7	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
8	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Prompt Table: LM_FCLTY_SRCH
9	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID Prompt Table: LM_ROOM_SRCH
10	LM_SS_FCLTY_DISP	Character(1)	VARCHAR2(1) NOT NULL	Display facility through self service Y/N Table Edit Default Value: Y