LM_TEAM_ACT_VW(SQL View) |
Index Back |
|---|---|
My Team Activity ViewUsed in Fluid MSS Team Learning page. |
| SELECT DISTINCT MGR.LM_PERSON_ID ,MGR.OPRID ,MGR.LM_MANAGER_ID ,MGR.LM_NAME_DISPLAY ,LRNR.LM_ACT_ID , LRNR.LM_CI_ID , LRNR.LM_ENRLMT_ID , CI.LM_CS_LONG_NM ,LRNR.LM_STTS ,LRNR.LM_ACT_STATUS ,LRNR.lm_start_dt ,LRNR.LM_END_DT , LRNR.lm_target_cmpl_dt ,LRNR.lm_initiated_dt , LRNR.LM_COMPL_DT , LRNR.LM_ACT_FEE , LRNR.LM_LAUNCHABLE_HIST , LRNR.LM_DM_LONG_NM FROM PS_LM_MGR_TEAM_VW MGR , PS_LM_CURR_ACTD_VW LRNR ,PS_LM_ALL_CI_VW CI WHERE MGR.LM_PERSON_ID = LRNR.LM_PERSON_ID AND LRNR.LM_CI_ID = CI.LM_CI_ID |
| # | 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LM_MANAGER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 4 | LM_NAME_DISPLAY |
Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 5 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 6 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 7 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 8 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 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_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 11 | LM_START_DT | Date(10) | DATE | Start Date |
| 12 | LM_END_DT | Date(10) | DATE | End Date |
| 13 | 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. |
| 14 | LM_INITIATED_DT | Date(10) | DATE | The date on which the course was launched by the student. This applies only for WBT. |
| 15 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 16 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 17 | LM_LAUNCHABLE_HIST | Character(1) | VARCHAR2(1) NOT NULL | Launchable from History |
| 18 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |