LM_SCACHE_HSTVW

(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 PSARCH_ID , PSARCH_BATCHNUM , 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_LELWSCAS_HST

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