LM_LWCSES_VW

(SQL View)
Index Back

Webcast Session

Webcast Session

SELECT LM_ACT_ID , LM_LC_ID , LM_SES_ID , LM_LELW_OPT_1 , LM_LELW_OPT_10 , LM_LELW_OPT_11 , LM_LELW_OPT_12 , LM_LELW_OPT_13 , LM_LELW_OPT_14 , LM_LELW_OPT_15 , LM_LELW_OPT_16 , LM_LELW_OPT_17 , LM_LELW_OPT_18 , LM_LELW_OPT_19 , LM_LELW_OPT_2 , LM_LELW_OPT_20 , LM_LELW_OPT_21 , LM_LELW_OPT_22 , LM_LELW_OPT_23 , LM_LELW_OPT_24 , LM_LELW_OPT_25 , LM_LELW_OPT_26 , LM_LELW_OPT_27 , LM_LELW_OPT_28 , LM_LELW_OPT_29 , LM_LELW_OPT_3 , LM_LELW_OPT_30 , LM_LELW_OPT_4 , LM_LELW_OPT_5 , LM_LELW_OPT_6 , LM_LELW_OPT_7 , LM_LELW_OPT_8 , LM_LELW_OPT_9 , LM_LELW_SSTR_1 , LM_LELW_SSTR_2 , LM_LELW_SSTR_3 , LM_LELW_LSTR_1 , LM_LELW_PHONE , LM_LELW_VND_MTG_ID , LM_LELW_NBR_1 , LM_LELW_NBR_2 , LM_LELW_MTG_TYP_ID , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_LWC_SES A

# 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_LELW_OPT_1 Character(1) VARCHAR2(1) NOT NULL Options Default (1)

Y/N Table Edit

Default Value: N

5 LM_LELW_OPT_10 Character(1) VARCHAR2(1) NOT NULL Options Label (10)

Y/N Table Edit

Default Value: N

6 LM_LELW_OPT_11 Character(1) VARCHAR2(1) NOT NULL Options Default (11)

Y/N Table Edit

Default Value: N

7 LM_LELW_OPT_12 Character(1) VARCHAR2(1) NOT NULL Options Default (12)

Y/N Table Edit

Default Value: N

8 LM_LELW_OPT_13 Character(1) VARCHAR2(1) NOT NULL Options Default (13)

Y/N Table Edit

Default Value: N

9 LM_LELW_OPT_14 Character(1) VARCHAR2(1) NOT NULL Options Default (14)

Y/N Table Edit

Default Value: N

10 LM_LELW_OPT_15 Character(1) VARCHAR2(1) NOT NULL Options Default (15)

Y/N Table Edit

Default Value: N

11 LM_LELW_OPT_16 Character(1) VARCHAR2(1) NOT NULL Options Default (16)

Y/N Table Edit

Default Value: N

12 LM_LELW_OPT_17 Character(1) VARCHAR2(1) NOT NULL Options Default (17)

Y/N Table Edit

Default Value: N

13 LM_LELW_OPT_18 Character(1) VARCHAR2(1) NOT NULL Options Default (18)

Y/N Table Edit

Default Value: N

14 LM_LELW_OPT_19 Character(1) VARCHAR2(1) NOT NULL Options Default (19)

Y/N Table Edit

Default Value: N

15 LM_LELW_OPT_2 Character(1) VARCHAR2(1) NOT NULL Options Default (2)

Y/N Table Edit

Default Value: N

16 LM_LELW_OPT_20 Character(1) VARCHAR2(1) NOT NULL Options Default (20)

Y/N Table Edit

Default Value: N

17 LM_LELW_OPT_21 Character(1) VARCHAR2(1) NOT NULL Options Default (21)

Y/N Table Edit

Default Value: N

18 LM_LELW_OPT_22 Character(1) VARCHAR2(1) NOT NULL Options Default (22)

Y/N Table Edit

Default Value: N

19 LM_LELW_OPT_23 Character(1) VARCHAR2(1) NOT NULL Options Default (23)

Y/N Table Edit

Default Value: N

20 LM_LELW_OPT_24 Character(1) VARCHAR2(1) NOT NULL Options Default (24)

Y/N Table Edit

Default Value: N

21 LM_LELW_OPT_25 Character(1) VARCHAR2(1) NOT NULL Options Default (25)

Y/N Table Edit

Default Value: N

22 LM_LELW_OPT_26 Character(1) VARCHAR2(1) NOT NULL Options Default (26)

Y/N Table Edit

Default Value: N

23 LM_LELW_OPT_27 Character(1) VARCHAR2(1) NOT NULL Options Default (27)

Y/N Table Edit

Default Value: N

24 LM_LELW_OPT_28 Character(1) VARCHAR2(1) NOT NULL Options Default (28)

Y/N Table Edit

Default Value: N

25 LM_LELW_OPT_29 Character(1) VARCHAR2(1) NOT NULL Options Default (29)

Y/N Table Edit

Default Value: N

26 LM_LELW_OPT_3 Character(1) VARCHAR2(1) NOT NULL Options Default (3)

Y/N Table Edit

Default Value: N

27 LM_LELW_OPT_30 Character(1) VARCHAR2(1) NOT NULL Options Default (30)

Y/N Table Edit

Default Value: N

28 LM_LELW_OPT_4 Character(1) VARCHAR2(1) NOT NULL Options Default (4)

Y/N Table Edit

Default Value: N

29 LM_LELW_OPT_5 Character(1) VARCHAR2(1) NOT NULL Options Default (5)

Y/N Table Edit

Default Value: N

30 LM_LELW_OPT_6 Character(1) VARCHAR2(1) NOT NULL Options Default (6)

Y/N Table Edit

Default Value: N

31 LM_LELW_OPT_7 Character(1) VARCHAR2(1) NOT NULL Options Default (7)

Y/N Table Edit

Default Value: N

32 LM_LELW_OPT_8 Character(1) VARCHAR2(1) NOT NULL Options Default (8)

Y/N Table Edit

Default Value: N

33 LM_LELW_OPT_9 Character(1) VARCHAR2(1) NOT NULL Options Label (9)

Y/N Table Edit

Default Value: N

34 LM_LELW_SSTR_1 Character(254) VARCHAR2(254) NOT NULL Short String (1)
35 LM_LELW_SSTR_2 Character(254) VARCHAR2(254) NOT NULL Short String (2)
36 LM_LELW_SSTR_3 Character(254) VARCHAR2(254) NOT NULL Short String 3
37 LM_LELW_LSTR_1 Long Character(2000) VARCHAR2(2000) Long String
38 LM_LELW_PHONE Character(12) VARCHAR2(12) NOT NULL Phone No.
39 LM_LELW_VND_MTG_ID Number(10,0) DECIMAL(10) NOT NULL Vendor Meeting ID
40 LM_LELW_NBR_1 Number(10,0) DECIMAL(10) NOT NULL Number (1)
41 LM_LELW_NBR_2 Number(10,0) DECIMAL(10) NOT NULL Number (2)
42 LM_LELW_MTG_TYP_ID Number(10,0) DECIMAL(10) NOT NULL Meeting Type ID
43 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
44 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
45 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
46 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid