LM_MGR_CERT_VW(SQL View) |
Index Back |
|---|---|
Manager CertificationsLists all Certifications (any status) for a learner associated with a Manager. Joins to the program table to bring in the program long name. |
| SELECT D.OPRID , D.LM_MANAGER_ID , A.LM_PRG_REG_ID , A.LM_PERSON_ID , A.LM_PRG_ID , C.LM_PRG_LONG_NM , E.FIRST_NAME , E.LAST_NAME , C.LM_PRG_TYPE , A.LM_ENRL_DT , A.LM_PRG_STTS , A.LM_COMPL_DT , A.LM_TARGET_CMPL_DT , A.LM_DP_DT , B.LM_CERT_DT , B.LM_EXPR_DT , B.LM_GRACE_EXPR_DT , B.LM_RECERT_DT , C.LM_CERT_ID , E.LM_NAME_DISPLAY , A.LM_CERT_EFFDT , A.LM_STTS_CHANGE_DT FROM PS_LM_PRG_REG_VW A , PS_LM_LRNR_CERT_VW B , PS_LM_PRG C , PS_LM_MGR_SRCH_VW D , PS_LM_PERS_NAME_VW E WHERE A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_PERSON_ID = E.LM_PERSON_ID AND A.LM_PRG_ID = C.LM_PRG_ID AND A.LM_PRG_REG_ID = B.LM_PRG_REG_ID AND C.LM_PRG_TYPE = 'CE' AND A.LM_CERT_EFFDT BETWEEN C.EFFDT AND C.LM_END_EFFDT |
| # | 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_MANAGER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 3 | 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. |
| 4 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 5 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 6 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 7 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 9 | LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type
CE=Certification CU=Curriculum |
| 10 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 11 | LM_PRG_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Program Reg Status
CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning |
| 12 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 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_DP_DT | Date(10) | DATE | Drop Date |
| 15 | LM_CERT_DT | Date(10) | DATE | Certification Date |
| 16 | LM_EXPR_DT | Date(10) | DATE | Certification Expiration Date is a fixed, preset date when the certification will expire. |
| 17 | LM_GRACE_EXPR_DT | Date(10) | DATE | Grace Period Expiration Date |
| 18 | LM_RECERT_DT | Date(10) | DATE | Recertification Date |
| 19 | LM_CERT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Certification ID |
| 20 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 21 | LM_CERT_EFFDT | Date(10) | DATE | Current Certification Date |
| 22 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |