| # |
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_RSRV_RM_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Reserve Room ID
|
| 5 |
LM_ENRLMT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Enrollment ID
|
| 6 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
|
| 7 |
LM_INSTR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Instructor ID
|
| 8 |
LM_ROLE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Role ID
|
| 9 |
LM_ACT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
|
| 10 |
LM_STTS |
Character(4) |
VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted
|
| 11 |
LM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Type of the Enrollment. This field for now will have only one value STDD
ADHC=Adhoc
PLAN=Planned
RSRV=Reserved
STDD=Standard
|
| 12 |
LM_FCLTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Facility ID
|
| 13 |
LM_ROOM_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Room ID
|
| 14 |
LM_SS_FCLTY_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display facility through self service
Y/N Table Edit
|
| 15 |
LM_CI_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
|
| 16 |
LM_SES_DT |
Date(10) |
DATE |
Session Date
|
| 17 |
LM_START_TM |
Time(15) |
TIMESTAMP |
Start Time
|
| 18 |
LM_END_TM |
Time(15) |
TIMESTAMP |
End Time
|
| 19 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
|
| 20 |
LM_ENRL_DT |
Date(10) |
DATE |
Enrollment/Registration Date
|
| 21 |
LM_TARGET_CMPL_DT |
Date(10) |
DATE |
The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
|
| 22 |
LM_COMPL_DT |
Date(10) |
DATE |
The date on which this Enrollment was marked Completed / InComplete
|
| 23 |
LM_LAUNCHABLE_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Launchable from History
|
| 24 |
LM_HOST |
Character(1) |
VARCHAR2(1) NOT NULL |
Host
|
| 25 |
LM_BAS_LC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey
|
| 26 |
LM_START_DT |
Date(10) |
DATE |
Start Date
|
| 27 |
LM_END_DT |
Date(10) |
DATE |
End Date
|
| 28 |
LM_DISPLAY_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Options
A=Activity
I=Instructor
L=Location
S=Self
|
| 29 |
LM_ADHC_LRN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Adhoc Learning Id
|
| 30 |
LM_SCORE |
Character(30) |
VARCHAR2(30) NOT NULL |
Score for this Enrollment. Score will be passed by Content Vendor.
|
| 31 |
LM_CERT_EFFDT |
Date(10) |
DATE |
Current Certification Date
|