| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
LM_SEQ_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
Sectioin Sequence Number in Educational Assessment Report
|
| 3 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
|
| 4 |
LM_NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Name Display field
|
| 5 |
LM_CS_LONG_NM |
Character(200) |
VARCHAR2(200) NOT NULL |
Long Name - Describes the long name of an object
|
| 6 |
LM_DMTHD_TYPE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Delivery Method Type ID - This is a unique identifier for each delivery method type
|
| 7 |
LM_DM_LONG_NM |
Character(200) |
VARCHAR2(200) NOT NULL |
Long Name - the long name of a Delivery Method Type
|
| 8 |
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
|
| 9 |
LM_PRG_STTS |
Character(4) |
VARCHAR2(4) NOT NULL |
Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning
|
| 10 |
LM_STATUS1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Status
|
| 11 |
LM_ACTION_DT |
Date(10) |
DATE |
Action/Reason Date
|
| 12 |
LM_START_DT |
Date(10) |
DATE |
Start Date
|
| 13 |
LM_COMPL_DT |
Date(10) |
DATE |
The date on which this Enrollment was marked Completed / InComplete
|
| 14 |
LM_SES_DT |
Date(10) |
DATE |
Session Date
|
| 15 |
LM_STTS_CHANGE_DT |
Date(10) |
DATE |
Status Chage Date
|
| 16 |
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.
|
| 17 |
LM_ACT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Activity ID
|
| 18 |
LM_PRG_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Program ID is a unique identifier for curriculum and certification Programs.
|
| 19 |
LM_CI_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
|
| 20 |
LM_ENRLMT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Enrollment ID
|
| 21 |
LM_PRG_REG_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Program Registration ID is a unique identifier for a learner's program enrollment.
|
| 22 |
LM_ADHC_LRN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Adhoc Learning Id
|
| 23 |
LM_PRG_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Program Type
CE=Certification
CU=Curriculum
|
| 24 |
LM_PRG_TYP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Program Type Description
|
| 25 |
LM_ENRL_DT |
Date(10) |
DATE |
Enrollment/Registration Date
|
| 26 |
LM_SCORE |
Character(30) |
VARCHAR2(30) NOT NULL |
Score for this Enrollment. Score will be passed by Content Vendor.
|
| 27 |
LM_CERT_EFFDT |
Date(10) |
DATE |
Current Certification Date
|
| 28 |
LM_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Description
|
| 29 |
LM_DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Work description field used to hold any description value sized at 50 characters.
|
| 30 |
LM_DESCR90 |
Character(100) |
VARCHAR2(100) NOT NULL |
Description
|
| 31 |
LM_DESCRSHORT |
Character(20) |
VARCHAR2(20) NOT NULL |
Short Description
|
| 32 |
LM_CATG_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Category Label for Fluid Learning Category
|
| 33 |
LM_LRN_TYPE_ICON |
Image Reference(30) |
VARCHAR2(30) |
Learning Type
|