LM_ACT_IDLM_LC_IDLM_PERSON_IDLM_LC_CMPCNT_VW(SQL View) |
Index Back |
|---|---|
CompletedLC Count for an InstrCompleted LC Count for an Instructor |
| SELECT A.LM_ACT_ID , B.LM_LC_ID , A.LM_PERSON_ID , B.LM_PASS_REQD ,A.LM_START_DT FROM PS_LM_ACT_INS_VW3 A , PS_LM_LC_VW B , PS_LM_LC_ROST_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_ID = C.LM_LC_ID AND ( C.LM_LC_COMP_STTS IN ('COMP', 'INCO') OR C.LM_STTS IN ('COMP', 'INPO')) AND B.LM_LC_TYPE_ID = 2 AND B.LM_BAS_LC_TYPE = '20' GROUP BY A.LM_ACT_ID, B.LM_LC_ID,A.LM_PERSON_ID, B.LM_PASS_REQD,A.LM_START_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_LC_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 3 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 4 | LM_PASS_REQD | Character(1) | VARCHAR2(1) NOT NULL | Passing Required |
| 5 | LM_START_DT | Date(10) | DATE | Start Date |