LM_ML_ENRLMT_VW(SQL View) |
Index Back |
|---|---|
EnrollmentEnrollment Record |
| SELECT A.LM_ENRLMT_ID , A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_CI_ID , A.LM_LRNR_GROUP_ID , A.LM_STTS , A.LM_REQUESTOR_ID , A.LM_COMPL_DT , A.LM_TARGET_CMPL_DT , A.LM_EMPL_RCD , A.LM_MAND_ENRL_FLG FROM PS_LM_ENRLMT A WHERE A.LM_MAND_ENRL_FLG='Y' AND A.LM_ENRLMT_ID=( SELECT MAX(LM_ENRLMT_ID) FROM PS_LM_ENRLMT B WHERE A.LM_PERSON_ID=B.LM_PERSON_ID AND A.LM_ACT_ID=B.LM_ACT_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 2 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 3 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 4 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 5 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 6 | 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 |
| 7 | LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 8 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 9 | 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. |
| 10 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 11 | LM_MAND_ENRL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Mandatory Learning Flag |