LM_PLAN_ACTD_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 , 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 , A.LM_EMPL_RCD , A.LM_INITIATED_DT , A.LM_DP_DT , A.LM_ACT_DIF_FLG , A.LM_STTS_CHANGE_DT ,%subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRLMT_VW A , PS_LM_CI_VW C , PS_LM_OPRID_ID_VW D WHERE A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_ACT_ID = 0 |
| # | 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_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 |
| 9 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 10 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 11 | LM_GRADE_VAL_ID | Number(10,0) | DECIMAL(10) NOT NULL | This will uniquely identify the combination of User Label / Grade value. |
| 12 | LM_GRADE_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Grade |
| 13 | LM_SCORE | Character(30) | VARCHAR2(30) NOT NULL | Score for this Enrollment. Score will be passed by Content Vendor. |
| 14 | LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 15 | LM_ENRLMT_DESCR | Long Character(2000) | VARCHAR2(2000) | Comments |
| 16 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 17 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 18 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 19 | LM_INITIATED_DT | Date(10) | DATE | The date on which the course was launched by the student. This applies only for WBT. |
| 20 | LM_DP_DT | Date(10) | DATE | Drop Date |
| 21 | LM_ACT_DIF_FLG | Character(1) | VARCHAR2(1) NOT NULL | DIF Enrollment |
| 22 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |
| 23 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 24 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 25 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 26 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |