LM_MYLRN_ACT_VW(SQL View) |
Index Back |
|---|---|
Learner Activity viewview of learner's current activities |
| SELECT D.OPRID , A.LM_PERSON_ID , A.LM_ENRLMT_ID , A.LM_CI_ID , A.LM_ACT_ID , A.LM_ACT_REQ , A.LM_TYPE , %NumToChar(E.LM_DMTHD_TYPE_ID) , A.LM_STTS , A.LM_ACT_FEE , A.LM_COMPL_DT , A.LM_GRADE_VAL_ID , ' ' , A.LM_SCORE , A.LM_REQUESTOR_ID , A.LM_ENRLMT_DESCR , C.LM_CS_LONG_NM , A.LM_ENRL_DT , E.LM_DMTHD_TYPE_ID , E.LM_DM_LONG_NM , E.LM_START_DT , A.LM_EMPL_RCD , A.LM_INITIATED_DT , E.LM_DISP_DATES , %DateNull , 0 , A.LM_DP_DT , A.LM_TARGET_CMPL_DT , E.LM_LAUNCHABLE_HIST , E.LM_END_DT , E.LM_ACT_STATUS , A.LM_ACT_DIF_FLG , A.LM_STTS_CHANGE_DT , %DateNull ,%subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRLMT_VW A , PS_LM_CI_VW2 C , PS_LM_OPRID_ID_VW D , PS_LM_ACT_PLN_VW E , ( SELECT A.LM_ENRLMT_ID FROM PS_LM_ENRLMT A WHERE A.LM_STTS_CHANGE_DT=( SELECT MAX(A1.LM_STTS_CHANGE_DT) FROM PS_LM_ENRLMT A1 WHERE A.LM_PERSON_ID=A1.LM_PERSON_ID AND A.LM_CI_ID=A1.LM_CI_ID) AND A.LM_ENRLMT_ID=( SELECT MAX(A2.LM_ENRLMT_ID) FROM PS_LM_ENRLMT A2 WHERE A.LM_PERSON_ID=A2.LM_PERSON_ID AND A.LM_CI_ID=A2.LM_CI_ID AND A.LM_STTS_CHANGE_DT=A2.LM_STTS_CHANGE_DT)) B WHERE A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_ACT_ID = E.LM_ACT_ID AND A.LM_ENRLMT_ID=B.LM_ENRLMT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment 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_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 6 | LM_ACT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes Y/N Table Edit |
| 7 | LM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Type of the Enrollment. This field for now will have only one value STDD
ADHC=Adhoc PLAN=Planned RSRV=Reserved STDD=Standard |
| 8 | LM_TYPE_10 | Character(10) | VARCHAR2(10) NOT NULL | LM_TYPE_10 |
| 9 | 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 |
| 10 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 11 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 12 | LM_GRADE_VAL_ID | Number(10,0) | DECIMAL(10) NOT NULL | This will uniquely identify the combination of User Label / Grade value. |
| 13 | LM_GRADE_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Grade |
| 14 | LM_SCORE | Character(30) | VARCHAR2(30) NOT NULL | Score for this Enrollment. Score will be passed by Content Vendor. |
| 15 | LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 16 | LM_ENRLMT_DESCR | Long Character(2000) | VARCHAR2(2000) | Comments |
| 17 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 18 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 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_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 21 | LM_START_DT | Date(10) | DATE | Start Date |
| 22 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 23 | LM_INITIATED_DT | Date(10) | DATE | The date on which the course was launched by the student. This applies only for WBT. |
| 24 | LM_DISP_DATES | Character(1) | VARCHAR2(1) NOT NULL | Use Display Dates |
| 25 | LM_CERT_EFFDT | Date(10) | DATE | Current Certification Date |
| 26 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 27 | LM_DP_DT | Date(10) | DATE | Drop Date |
| 28 | 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. |
| 29 | LM_LAUNCHABLE_HIST | Character(1) | VARCHAR2(1) NOT NULL | Launchable from History |
| 30 | LM_END_DT | Date(10) | DATE | End Date |
| 31 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 32 | LM_ACT_DIF_FLG | Character(1) | VARCHAR2(1) NOT NULL | DIF Enrollment |
| 33 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |
| 34 | LM_EXPR_DT | Date(10) | DATE | Certification Expiration Date is a fixed, preset date when the certification will expire. |
| 35 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 36 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 37 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 38 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |