LM_ENRLMT_WTLT1(SQL View) |
Index Back |
---|---|
Enrollment WaitlistEnrollment Waitlist |
SELECT A.LM_ENRLMT_ID , A.LM_CI_ID , A.LM_ACT_ID , A.LM_STTS , A.LM_STTS_CHANGE_DT , A.LM_OLD_STTS , A.LM_PERSON_ID , A.LM_TARGET_CMPL_DT , A.LM_WTLST_NBR , A.LM_ENRL_DT FROM PS_LM_ENRLMT A , PS_LM_ACT B WHERE A.LM_ACT_ID = B.LM_ACT_ID AND LM_START_DT <= %CurrentDateIn |
# | 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_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
3 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
4 | 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 |
5 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |
6 | LM_OLD_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Old Enrollment Status. This field will be loaded with the Actual Enrollment Status whenver the person is marked Completed / Incomplete. Before attendance marking this field will not hold any value.
CANC=Dropped COMP=Completed DECL=Declined ENRL=Enrolled INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval WAIV=Waived WTLT=Waitlisted |
7 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
8 | 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. |
9 | LM_WTLST_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Number on the Waitlist for an Activity. |
10 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |