| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
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.
|
| 3 |
LM_PRG_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Program ID is a unique identifier for curriculum and certification Programs.
|
| 4 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
|
| 5 |
LM_PRG_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
|
| 6 |
LM_ENRL_DT |
Date(10) |
DATE |
Enrollment/Registration Date
|
| 7 |
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.
|
| 8 |
LM_START_DT |
Date(10) |
DATE |
Start Date
|
| 9 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 10 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 11 |
LM_CERT_EFFDT |
Date(10) |
DATE |
Current Certification Date
|