LM_SCACHE_VW

(SQL View)
 Index Back

Webcast Session Cache

Caches information about webcast session that need to be updated on the vendor. Used to avoid losing critical information before sending the message (i.e. Remove Session)

SELECT LM_LELW_VNDR_ID , LM_ACT_ID , LM_SES_ID , LM_LC_ID , LM_CI_ID , LM_START_DTTM , LM_END_DTTM , TIMEZONE , LM_CS_LONG_NM , LM_ACT_CD , LM_LC_LONG_NM , LM_START_DT , LM_END_DT , LM_LELW_VND_MTG_ID FROM PS_LM_LELW_SCACHE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_LELW_VNDR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
3 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
4 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
7 LM_END_DTTM DateTime(26) TIMESTAMP End Time
8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
9 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
10 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
11 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
12 LM_START_DT Date(10) DATE Start Date
13 LM_END_DT Date(10) DATE End Date
14 LM_LELW_VND_MTG_ID Number(10,0) DECIMAL(10) NOT NULL Vendor Meeting ID