LM_HIST_CRS_VW(SQL View) |
Index Back |
|---|---|
Current Enrollment ViewCurrent Enrollment View |
| SELECT B.LM_ENRLMT_ID ,B.LM_PERSON_ID ,A.LM_CI_ID ,A.LM_ACT_ID ,A.LM_ACT_CD ,A.LM_CS_LONG_NM ,A.LM_DURN_DAYS ,A.LM_DURN_HRS ,A.LM_DURN_MINS ,A.LM_START_DT ,B.LM_TARGET_CMPL_DT ,B.LM_COMPL_DT ,B.LM_SCORE ,B.LM_STTS ,B.LM_STTS_CHANGE_DT ,B.LM_REQUESTOR_ID ,B.LM_ACT_REQ , A.LM_DM_LONG_NM , A.LM_DMTHD_TYPE_ID ,B.LM_MAND_ENRL_FLG FROM PS_LM_ACT_CI_VW A , PS_LM_ENRLMT B WHERE B.LM_ACT_ID=A.LM_ACT_ID AND B.LM_CI_ID=A.LM_CI_ID AND B.LM_STTS IN ('COMP','INCO','WAIV','CANC','DECL') UNION SELECT B.LM_ENRLMT_ID ,B.LM_PERSON_ID ,A.LM_CI_ID ,0 ,' ' ,A.LM_CS_LONG_NM ,0 ,0 ,0 ,%DateNull ,B.LM_TARGET_CMPL_DT ,B.LM_COMPL_DT ,B.LM_SCORE ,B.LM_STTS ,B.LM_STTS_CHANGE_DT ,B.LM_REQUESTOR_ID ,B.LM_ACT_REQ ,C.MESSAGE_TEXT ,0 ,B.LM_MAND_ENRL_FLG FROM PS_LM_CI_TBL A , PS_LM_ENRLMT B , PSMSGCATDEFN C WHERE B.LM_ACT_ID=0 AND A.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_LM_CI_TBL Y WHERE A.LM_CI_ID = Y.LM_CI_ID AND Y.EFFDT <= %CurrentDateIn) AND B.LM_CI_ID=A.LM_CI_ID AND B.LM_STTS IN ('WAIV') AND C.MESSAGE_SET_NBR = 18094 AND C.MESSAGE_NBR = 607 |
| # | 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_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 4 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 5 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 6 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 7 | LM_DURN_DAYS | Number(4,0) | SMALLINT NOT NULL | Length of Activity in Days |
| 8 | LM_DURN_HRS | Number(3,0) | SMALLINT NOT NULL | Duration - Hours |
| 9 | LM_DURN_MINS | Number(3,0) | SMALLINT NOT NULL | Duration - Minutes |
| 10 | LM_START_DT | Date(10) | DATE | Start Date |
| 11 | 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. |
| 12 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 13 | LM_SCORE | Character(30) | VARCHAR2(30) NOT NULL | Score for this Enrollment. Score will be passed by Content Vendor. |
| 14 | 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 |
| 15 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |
| 16 | LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 17 | LM_ACT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes |
| 18 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 19 | 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 |
| 20 | LM_MAND_ENRL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Mandatory Learning Flag |