LM_LWC_IB_VW

(SQL View)
 Index Back

Webcast Session

Webcast Session

SELECT A.LM_SES_ID , A.LM_ACT_ID , C.HRS_VENDOR_ID , A.LM_LELW_VND_MTG_ID , A.LM_LELW_MTG_TYP_ID , C.LM_LELW_ADMIN_ID , C.LM_LELW_ADMIN_PWD , D.LM_LC_LONG_NM , %Dttm(E.LM_SES_DT ,E.LM_START_TM) , %Dttm(E.LM_SES_DT ,E.LM_END_TM) , E.TIMEZONE , A.LM_LELW_OPT_1 , A.LM_LELW_OPT_2 , A.LM_LELW_OPT_3 , A.LM_LELW_OPT_4 , A.LM_LELW_OPT_5 , A.LM_LELW_OPT_6 , A.LM_LELW_OPT_7 , A.LM_LELW_OPT_8 , A.LM_LELW_OPT_9 , A.LM_LELW_OPT_10 , A.LM_LELW_OPT_11 , A.LM_LELW_OPT_12 , A.LM_LELW_OPT_13 , A.LM_LELW_OPT_14 , A.LM_LELW_OPT_15 , A.LM_LELW_OPT_16 , A.LM_LELW_OPT_17 , A.LM_LELW_OPT_18 , A.LM_LELW_OPT_19 , A.LM_LELW_OPT_20 , A.LM_LELW_OPT_21 , A.LM_LELW_OPT_22 , A.LM_LELW_OPT_23 , A.LM_LELW_OPT_24 , A.LM_LELW_OPT_25 , A.LM_LELW_OPT_26 , A.LM_LELW_OPT_27 , A.LM_LELW_OPT_28 , A.LM_LELW_OPT_29 , A.LM_LELW_OPT_30 , C.LM_LELW_ACTIVE_1 , C.LM_LELW_ACTIVE_2 , C.LM_LELW_ACTIVE_3 , C.LM_LELW_ACTIVE_4 , C.LM_LELW_ACTIVE_5 , C.LM_LELW_ACTIVE_6 , C.LM_LELW_ACTIVE_7 , C.LM_LELW_ACTIVE_8 , C.LM_LELW_ACTIVE_9 , C.LM_LELW_ACTIVE_10 , C.LM_LELW_ACTIVE_11 , C.LM_LELW_ACTIVE_12 , C.LM_LELW_ACTIVE_13 , C.LM_LELW_ACTIVE_14 , C.LM_LELW_ACTIVE_15 , C.LM_LELW_ACTIVE_16 , C.LM_LELW_ACTIVE_17 , C.LM_LELW_ACTIVE_18 , C.LM_LELW_ACTIVE_19 , C.LM_LELW_ACTIVE_20 , C.LM_LELW_ACTIVE_21 , C.LM_LELW_ACTIVE_22 , C.LM_LELW_ACTIVE_23 , C.LM_LELW_ACTIVE_24 , C.LM_LELW_ACTIVE_25 , C.LM_LELW_ACTIVE_26 , C.LM_LELW_ACTIVE_27 , C.LM_LELW_ACTIVE_28 , C.LM_LELW_ACTIVE_29 , C.LM_LELW_ACTIVE_30 , A.LM_LELW_SSTR_1 , A.LM_LELW_SSTR_2 , A.LM_LELW_SSTR_3 , C.LM_LELW_SSTR_ACT_1 , C.LM_LELW_SSTR_ACT_2 , C.LM_LELW_SSTR_ACT_3 , A.LM_LELW_LSTR_1 , C.LM_LELW_LSTR_ACT , A.LM_LELW_NBR_1 , A.LM_LELW_NBR_2 , C.LM_LELW_NBR_ACT_1 , C.LM_LELW_NBR_ACT_2 FROM PS_LM_LWC_SES A , PS_LM_LC_LWC B , PS_LM_VENDOR_EXTD C , PS_LM_LC D , PS_LM_SES E , PS_HRS_VENDOR F WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_LC_ID=B.LM_LC_ID AND B.LM_LELW_VNDR_ID=C.HRS_VENDOR_ID AND F.HRS_VENDOR_STATUS='10' AND A.LM_LC_ID=D.LM_LC_ID AND A.LM_SES_ID=E.LM_SES_ID AND F.HRS_VENDOR_ID = C.HRS_VENDOR_ID AND F.HRS_VERSION = ( SELECT MAX(Z.HRS_VERSION) FROM PS_LM_VENDOR_EXTD Z WHERE Z.HRS_VENDOR_ID = F.HRS_VENDOR_ID) AND F.HRS_VERSION = C.HRS_VERSION

  • Related Language Record: LM_LWC_IB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
    2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_LELW_VNDR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
    4 LM_LELW_VND_MTG_ID Number(10,0) DECIMAL(10) NOT NULL Vendor Meeting ID
    5 LM_LELW_MTG_TYP_ID Number(10,0) DECIMAL(10) NOT NULL Meeting Type ID
    6 LM_LELW_ADMIN_ID Character(30) VARCHAR2(30) NOT NULL Admin User ID
    7 LM_LELW_ADMIN_PWD Character(30) VARCHAR2(30) NOT NULL Admin Password
    8 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
    9 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
    10 LM_END_DTTM DateTime(26) TIMESTAMP End Time
    11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    12 LM_LELW_OPT_1 Character(1) VARCHAR2(1) NOT NULL Options Default (1)
    13 LM_LELW_OPT_2 Character(1) VARCHAR2(1) NOT NULL Options Default (2)
    14 LM_LELW_OPT_3 Character(1) VARCHAR2(1) NOT NULL Options Default (3)
    15 LM_LELW_OPT_4 Character(1) VARCHAR2(1) NOT NULL Options Default (4)
    16 LM_LELW_OPT_5 Character(1) VARCHAR2(1) NOT NULL Options Default (5)
    17 LM_LELW_OPT_6 Character(1) VARCHAR2(1) NOT NULL Options Default (6)
    18 LM_LELW_OPT_7 Character(1) VARCHAR2(1) NOT NULL Options Default (7)
    19 LM_LELW_OPT_8 Character(1) VARCHAR2(1) NOT NULL Options Default (8)
    20 LM_LELW_OPT_9 Character(1) VARCHAR2(1) NOT NULL Options Label (9)
    21 LM_LELW_OPT_10 Character(1) VARCHAR2(1) NOT NULL Options Label (10)
    22 LM_LELW_OPT_11 Character(1) VARCHAR2(1) NOT NULL Options Default (11)
    23 LM_LELW_OPT_12 Character(1) VARCHAR2(1) NOT NULL Options Default (12)
    24 LM_LELW_OPT_13 Character(1) VARCHAR2(1) NOT NULL Options Default (13)
    25 LM_LELW_OPT_14 Character(1) VARCHAR2(1) NOT NULL Options Default (14)
    26 LM_LELW_OPT_15 Character(1) VARCHAR2(1) NOT NULL Options Default (15)
    27 LM_LELW_OPT_16 Character(1) VARCHAR2(1) NOT NULL Options Default (16)
    28 LM_LELW_OPT_17 Character(1) VARCHAR2(1) NOT NULL Options Default (17)
    29 LM_LELW_OPT_18 Character(1) VARCHAR2(1) NOT NULL Options Default (18)
    30 LM_LELW_OPT_19 Character(1) VARCHAR2(1) NOT NULL Options Default (19)
    31 LM_LELW_OPT_20 Character(1) VARCHAR2(1) NOT NULL Options Default (20)
    32 LM_LELW_OPT_21 Character(1) VARCHAR2(1) NOT NULL Options Default (21)
    33 LM_LELW_OPT_22 Character(1) VARCHAR2(1) NOT NULL Options Default (22)
    34 LM_LELW_OPT_23 Character(1) VARCHAR2(1) NOT NULL Options Default (23)
    35 LM_LELW_OPT_24 Character(1) VARCHAR2(1) NOT NULL Options Default (24)
    36 LM_LELW_OPT_25 Character(1) VARCHAR2(1) NOT NULL Options Default (25)
    37 LM_LELW_OPT_26 Character(1) VARCHAR2(1) NOT NULL Options Default (26)
    38 LM_LELW_OPT_27 Character(1) VARCHAR2(1) NOT NULL Options Default (27)
    39 LM_LELW_OPT_28 Character(1) VARCHAR2(1) NOT NULL Options Default (28)
    40 LM_LELW_OPT_29 Character(1) VARCHAR2(1) NOT NULL Options Default (29)
    41 LM_LELW_OPT_30 Character(1) VARCHAR2(1) NOT NULL Options Default (30)
    42 LM_LELW_ACTIVE_1 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE

    Y/N Table Edit

    43 LM_LELW_ACTIVE_2 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (2)

    Y/N Table Edit

    44 LM_LELW_ACTIVE_3 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (3)

    Y/N Table Edit

    45 LM_LELW_ACTIVE_4 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (4)

    Y/N Table Edit

    46 LM_LELW_ACTIVE_5 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (5)

    Y/N Table Edit

    47 LM_LELW_ACTIVE_6 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (6)

    Y/N Table Edit

    48 LM_LELW_ACTIVE_7 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (7)

    Y/N Table Edit

    49 LM_LELW_ACTIVE_8 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (8)

    Y/N Table Edit

    50 LM_LELW_ACTIVE_9 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (9)

    Y/N Table Edit

    51 LM_LELW_ACTIVE_10 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (10)

    Y/N Table Edit

    52 LM_LELW_ACTIVE_11 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (11)

    Y/N Table Edit

    53 LM_LELW_ACTIVE_12 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (12)

    Y/N Table Edit

    54 LM_LELW_ACTIVE_13 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (13)

    Y/N Table Edit

    55 LM_LELW_ACTIVE_14 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (14)

    Y/N Table Edit

    56 LM_LELW_ACTIVE_15 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (15)

    Y/N Table Edit

    57 LM_LELW_ACTIVE_16 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (16)

    Y/N Table Edit

    58 LM_LELW_ACTIVE_17 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (17)

    Y/N Table Edit

    59 LM_LELW_ACTIVE_18 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (18)

    Y/N Table Edit

    60 LM_LELW_ACTIVE_19 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (19)

    Y/N Table Edit

    61 LM_LELW_ACTIVE_20 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (20)

    Y/N Table Edit

    62 LM_LELW_ACTIVE_21 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (21)

    Y/N Table Edit

    63 LM_LELW_ACTIVE_22 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (22)

    Y/N Table Edit

    64 LM_LELW_ACTIVE_23 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (23)

    Y/N Table Edit

    65 LM_LELW_ACTIVE_24 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (24)

    Y/N Table Edit

    66 LM_LELW_ACTIVE_25 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (25)

    Y/N Table Edit

    67 LM_LELW_ACTIVE_26 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (26)

    Y/N Table Edit

    68 LM_LELW_ACTIVE_27 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (27)

    Y/N Table Edit

    69 LM_LELW_ACTIVE_28 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (28)

    Y/N Table Edit

    70 LM_LELW_ACTIVE_29 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (29)

    Y/N Table Edit

    71 LM_LELW_ACTIVE_30 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (30)

    Y/N Table Edit

    72 LM_LELW_SSTR_1 Character(254) VARCHAR2(254) NOT NULL Short String (1)
    73 LM_LELW_SSTR_2 Character(254) VARCHAR2(254) NOT NULL Short String (2)
    74 LM_LELW_SSTR_3 Character(254) VARCHAR2(254) NOT NULL Short String 3
    75 LM_LELW_SSTR_ACT_1 Character(1) VARCHAR2(1) NOT NULL Short String Active 1

    Y/N Table Edit

    76 LM_LELW_SSTR_ACT_2 Character(1) VARCHAR2(1) NOT NULL Short String Active 2

    Y/N Table Edit

    77 LM_LELW_SSTR_ACT_3 Character(1) VARCHAR2(1) NOT NULL Short String Active 3

    Y/N Table Edit

    78 LM_LELW_LSTR_1 Long Character(2000) VARCHAR2(2000) Long String
    79 LM_LELW_LSTR_ACT Character(1) VARCHAR2(1) NOT NULL Long String Active

    Y/N Table Edit

    80 LM_LELW_NBR_1 Number(10,0) DECIMAL(10) NOT NULL Number (1)
    81 LM_LELW_NBR_2 Number(10,0) DECIMAL(10) NOT NULL Number (2)
    82 LM_LELW_NBR_ACT_1 Character(1) VARCHAR2(1) NOT NULL Number Active 1

    Y/N Table Edit

    83 LM_LELW_NBR_ACT_2 Character(1) VARCHAR2(1) NOT NULL Number Active 2

    Y/N Table Edit