LM_SRCHLSTRUNVW (SQL View)	Index Back
Upcoming Events/Last Run This is used for the select the upcoming events based from the date the search index was successfully ran..

LM_SRCHLSTRUNVW

(SQL View)

Upcoming Events/Last Run

This is used for the select the upcoming events based from the date the search index was successfully ran..

%Sql(LM_SRCH_LAST_RUN_EVENT_SQL,7,<=) UNION %Sql(LM_SRCH_LAST_RUN_EVENT_SQL,30,<=) UNION %Sql(LM_SRCH_LAST_RUN_EVENT_SQL,60,<=) UNION %Sql(LM_SRCH_LAST_RUN_EVENT_SQL,90,<=) UNION %Sql(LM_SRCH_LAST_RUN_EVENT_SQL,90,>=)

# 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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

3 LM_SES_DT Date(10) DATE Session Date

4 LM_UPCOMING_DAYS Number(3,0) SMALLINT NOT NULL Upcoming Days

#	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_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
3	LM_SES_DT	Date(10)	DATE	Session Date
4	LM_UPCOMING_DAYS	Number(3,0)	SMALLINT NOT NULL	Upcoming Days