LM_ENRLMT_WTLT1

(SQL View)
Index Back

Enrollment Waitlist

Enrollment 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