LM_LWCSES_VW(SQL View) |
Index Back |
---|---|
Webcast SessionWebcast 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 |