LM_ENR_CHART_VW(SQL View) |
Index Back |
|---|---|
Enroll Chart ViewEnroll Chart View |
| SELECT A.LM_PERSON_ID , ( CASE WHEN A.LM_STTS IN ('ENRL' , 'WARN' ,'PEAP' ,'PEPA' ,'PPYA' ,'WTLT' ) THEN 'NOTS' ELSE A.LM_STTS END ) AS LM_STTS , COUNT(*) FROM PS_LM_ENRLMT_VW A WHERE A.LM_ENRL_DT BETWEEN %Coalesce(( SELECT LM_FROM_DT FROM PS_LM_IN_DFLT_TBL), %DateAdd(%CurrentDateIn, - 365) ) AND %Coalesce(( SELECT LM_TO_DT FROM PS_LM_IN_DFLT_TBL), %CurrentDateIn ) AND A.LM_STTS IN ('ENRL', 'WARN', 'INPO', 'COMP','PEAP','PEPA','PPYA','WTLT') GROUP BY A.LM_PERSON_ID, LM_STTS UNION ALL SELECT A.LM_PERSON_ID , ( CASE WHEN A.LM_PRG_STTS IN ('ENRL' , 'WARN' ,'PEAP' ,'PEPA' ,'PPYA' ,'WTLT' ) THEN 'NOTS' ELSE A.LM_PRG_STTS END ) AS LM_STTS , COUNT(*) FROM PS_LM_PRG_REG_VW A WHERE A.LM_ENRL_DT BETWEEN %Coalesce(( SELECT LM_FROM_DT FROM PS_LM_IN_DFLT_TBL), %DateAdd(%CurrentDateIn, - 365) ) AND %Coalesce(( SELECT LM_TO_DT FROM PS_LM_IN_DFLT_TBL), %CurrentDateIn ) AND A.LM_PRG_STTS IN ('ENRL', 'WARN', 'INPO', 'COMP','PEAP','PEPA','PPYA','WTLT') GROUP BY A.LM_PERSON_ID, LM_PRG_STTS |
| # | 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_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 |
| 3 | COUNT1 |
Number(10,0) | DECIMAL(10) NOT NULL | Counter |