LM_LWCSES_HSTVW(SQL View) |
Index Back |
|---|---|
Webcast SessionWebcast Session |
| SELECT PSARCH_ID , PSARCH_BATCHNUM , 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_HST A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
| 2 | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number | |
| 3 | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID | |
| 4 | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning | |
| 5 | Number(10,0) | DECIMAL(10) NOT NULL | Session ID | |
| 6 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (1)
Y/N Table Edit Default Value: N |
|
| 7 | LM_LELW_OPT_10 | Character(1) | VARCHAR2(1) NOT NULL |
Options Label (10)
Y/N Table Edit Default Value: N |
| 8 | LM_LELW_OPT_11 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (11)
Y/N Table Edit Default Value: N |
| 9 | LM_LELW_OPT_12 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (12)
Y/N Table Edit Default Value: N |
| 10 | LM_LELW_OPT_13 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (13)
Y/N Table Edit Default Value: N |
| 11 | LM_LELW_OPT_14 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (14)
Y/N Table Edit Default Value: N |
| 12 | LM_LELW_OPT_15 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (15)
Y/N Table Edit Default Value: N |
| 13 | LM_LELW_OPT_16 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (16)
Y/N Table Edit Default Value: N |
| 14 | LM_LELW_OPT_17 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (17)
Y/N Table Edit Default Value: N |
| 15 | LM_LELW_OPT_18 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (18)
Y/N Table Edit Default Value: N |
| 16 | LM_LELW_OPT_19 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (19)
Y/N Table Edit Default Value: N |
| 17 | LM_LELW_OPT_2 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (2)
Y/N Table Edit Default Value: N |
| 18 | LM_LELW_OPT_20 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (20)
Y/N Table Edit Default Value: N |
| 19 | LM_LELW_OPT_21 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (21)
Y/N Table Edit Default Value: N |
| 20 | LM_LELW_OPT_22 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (22)
Y/N Table Edit Default Value: N |
| 21 | LM_LELW_OPT_23 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (23)
Y/N Table Edit Default Value: N |
| 22 | LM_LELW_OPT_24 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (24)
Y/N Table Edit Default Value: N |
| 23 | LM_LELW_OPT_25 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (25)
Y/N Table Edit Default Value: N |
| 24 | LM_LELW_OPT_26 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (26)
Y/N Table Edit Default Value: N |
| 25 | LM_LELW_OPT_27 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (27)
Y/N Table Edit Default Value: N |
| 26 | LM_LELW_OPT_28 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (28)
Y/N Table Edit Default Value: N |
| 27 | LM_LELW_OPT_29 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (29)
Y/N Table Edit Default Value: N |
| 28 | LM_LELW_OPT_3 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (3)
Y/N Table Edit Default Value: N |
| 29 | LM_LELW_OPT_30 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (30)
Y/N Table Edit Default Value: N |
| 30 | LM_LELW_OPT_4 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (4)
Y/N Table Edit Default Value: N |
| 31 | LM_LELW_OPT_5 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (5)
Y/N Table Edit Default Value: N |
| 32 | LM_LELW_OPT_6 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (6)
Y/N Table Edit Default Value: N |
| 33 | LM_LELW_OPT_7 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (7)
Y/N Table Edit Default Value: N |
| 34 | LM_LELW_OPT_8 | Character(1) | VARCHAR2(1) NOT NULL |
Options Default (8)
Y/N Table Edit Default Value: N |
| 35 | LM_LELW_OPT_9 | Character(1) | VARCHAR2(1) NOT NULL |
Options Label (9)
Y/N Table Edit Default Value: N |
| 36 | LM_LELW_SSTR_1 | Character(254) | VARCHAR2(254) NOT NULL | Short String (1) |
| 37 | LM_LELW_SSTR_2 | Character(254) | VARCHAR2(254) NOT NULL | Short String (2) |
| 38 | LM_LELW_SSTR_3 | Character(254) | VARCHAR2(254) NOT NULL | Short String 3 |
| 39 | LM_LELW_LSTR_1 | Long Character(2000) | VARCHAR2(2000) | Long String |
| 40 | LM_LELW_PHONE | Character(12) | VARCHAR2(12) NOT NULL | Phone No. |
| 41 | LM_LELW_VND_MTG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Vendor Meeting ID |
| 42 | LM_LELW_NBR_1 | Number(10,0) | DECIMAL(10) NOT NULL | Number (1) |
| 43 | LM_LELW_NBR_2 | Number(10,0) | DECIMAL(10) NOT NULL | Number (2) |
| 44 | LM_LELW_MTG_TYP_ID | Number(10,0) | DECIMAL(10) NOT NULL | Meeting Type ID |
| 45 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 46 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 47 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 48 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |