LM_TEAM_CAT_VW(SQL View) |
Index Back |
|---|---|
My Team Catalog ViewUsed in Fluid MSS Team Learning page. |
| SELECT MGR.LM_PERSON_ID , MGR.OPRID , MGR.LM_MANAGER_ID , MGR.LM_NAME_DISPLAY , LRNR.LM_CI_ID , LRNR.LM_ENRLMT_ID , LRNR.LM_LPLN_DTL_TITLE , LRNR.LM_LPLN_DTL_STTS , LRNR.LM_PRG_REG_ID , LRNR.LM_ACT_ID ,LRNR.LM_ADHC_LRN_ID ,LRNR.LM_LPLN_ID FROM PS_LM_MGR_TEAM_VW MGR , PS_LM_LPLN_DTL_VW LRNR WHERE MGR.LM_PERSON_ID = LRNR.LM_PERSON_ID AND LRNR.LM_ACT_ID = 0 AND LM_CI_ID > 0 |
| # | 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_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 6 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 7 | LM_LPLN_DTL_TITLE | Character(254) | VARCHAR2(254) NOT NULL | This field is used to for the Learning Plan Learners Detail. The title from Enrollments, Program Registrations and Adhoc Enrollments: PS_LM_CI_TBL.LM_CS_LONG_NM PS_LM_PRG.LM_PRG_LONG_NM, PS_LM_ADHC_TBL.LM_PER_TRN_NM are placed on this field for display |
| 8 | LM_LPLN_DTL_STTS | Character(4) | VARCHAR2(4) NOT NULL |
The translate values for this field are derived from the translate values of fields: LM_PRG_STTS, LM_ADHC_LRN_STTS, LM_STTS
Also note that new value REGR (Registered) is added. This is used for program registation when status is ENRL. View PS_LM_LPLN_PRG_VW transforms status ENRL to REGR
CANC=Dropped COMP=Completed DECL=Denied DROP=Dropped ENRL=Enrolled EXPR=Expired INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REGR=Registered REIS=Reissue REVK=Revoked RQST=Learning Request WAIV=Waived WARN=Warning WTLT=Waitlisted |
| 9 | LM_PRG_REG_ID | Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 10 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 11 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 12 | LM_LPLN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Plan ID |