| # |
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_CRS_FILEID |
Character(128) |
VARCHAR2(128) NOT NULL |
CRS File ID
|
| 4 |
LM_AU_FILEID |
Character(128) |
VARCHAR2(128) NOT NULL |
AU File ID
|
| 5 |
LM_CST_FILEID |
Character(128) |
VARCHAR2(128) NOT NULL |
CST File ID
|
| 6 |
LM_DES_FILEID |
Character(128) |
VARCHAR2(128) NOT NULL |
DES File ID
|
| 7 |
LM_COMPL_TYPE |
Character(254) |
VARCHAR2(254) NOT NULL |
LM_COMPL_TYPE
|
| 8 |
LM_CORS_CREATR |
Character(254) |
VARCHAR2(254) NOT NULL |
Course creator
|
| 9 |
LM_EXT_CORS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
A Course id external to ELM
|
| 10 |
LM_CORS_SYSTEM |
Character(254) |
VARCHAR2(254) NOT NULL |
Course System
|
| 11 |
LM_CORS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
A common name given to the Course
|
| 12 |
LM_COMPLX_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Complexity Level
1
2
3
3a
3b
|
| 13 |
LM_MAX_FLDS_CST |
Character(3) |
VARCHAR2(3) NOT NULL |
Max CST fields
|
| 14 |
LM_MAX_FLDS_ORT |
Character(3) |
VARCHAR2(3) NOT NULL |
Max ORT fields
|
| 15 |
LM_TOT_SCO |
Character(4) |
VARCHAR2(4) NOT NULL |
Total SCOs
|
| 16 |
LM_TOT_BLOCKS |
Character(3) |
VARCHAR2(3) NOT NULL |
Total Blocks
|
| 17 |
LM_TOT_OBJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Total Objectives
|
| 18 |
LM_TOT_COMP_OBJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Total Complex Objectives
|
| 19 |
LM_CORS_VER |
Character(7) |
VARCHAR2(7) NOT NULL |
Course CMI Revision numbr
|
| 20 |
LM_MAX_NORMAL |
Character(2) |
VARCHAR2(2) NOT NULL |
Lesson Behavior
|
| 21 |
LM_CORS_DESCR |
Long Character(5000) |
CLOB |
Course Description
|