LM_COMP_ACT_VW(SQL View) |
Index Back |
|---|---|
Learner Activity viewview of learner's completed activities |
| SELECT 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 , E.LM_GRADE_LABEL , A.LM_SCORE , A.LM_REQUESTOR_ID , A.LM_ENRLMT_DESCR , C.LM_CS_LONG_NM , A.LM_PASS_VAL_ID , D.LM_PASS_STTS , A.LM_ENRL_DT , A.LM_TARGET_CMPL_DT , A.LM_ADHC_LRN_ID ,%subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRLMT_VW A , PS_LM_CI_ALL_VW C , PS_LM_PASS_SCH_VAL D , PS_LM_GRD_SCH_VAL E WHERE A.LM_STTS IN ('COMP','INCO','WAIV') AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_PASS_VAL_ID = D.LM_PASS_VAL_ID AND A.LM_GRADE_VAL_ID = E.LM_GRADE_VAL_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment 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_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes Y/N Table Edit |
| 6 | 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 |
| 7 | 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 |
| 8 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 9 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 10 | LM_GRADE_VAL_ID | Number(10,0) | DECIMAL(10) NOT NULL | This will uniquely identify the combination of User Label / Grade value. |
| 11 | LM_GRADE_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Grade |
| 12 | LM_SCORE | Character(30) | VARCHAR2(30) NOT NULL | Score for this Enrollment. Score will be passed by Content Vendor. |
| 13 | LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 14 | LM_ENRLMT_DESCR | Long Character(2000) | VARCHAR2(2000) | Comments |
| 15 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 16 | LM_PASS_VAL_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Passing Scheme Value ID
Prompt Table: LM_PASS_SCH_VAL |
| 17 | LM_PASS_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Passing Status
FAIL=Fail NOMK=Not Marked NORQ=Not Required PASS=Pass PEND=Pending |
| 18 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 19 | 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. |
| 20 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 21 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 22 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 23 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 24 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |