| Applicants by Major Report Options | |
|---|---|
| Semester | Fall Spring |
| Redirects | All Excluding Redirected Redirected |
| Applicant type | Undergraduate First-time Undergraduate Lower-division Transfer Upper-division Transfer Masters Credential |
| Status | Applicants Admitted Confirmed Enrolled |
| Spring Credential Confirmed Major program
report generated: 09-DEC-23 | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Major program | Spring 2017 | Spring 2018 | Spring 2019 | Spring 2020 | Spring 2021 | Spring 2022 | Spring 2023 | Spring 2024 | SELECT '|||||||||||
| '||program groupby,' | '||to_char(sum(case when term='2172' then hc_confirm end),'99,999')||' | ' "Spring 2017",''||to_char(sum(case when term='2182' then hc_confirm end),'99,999')||' | ' "Spring 2018",''||to_char(sum(case when term='2192' then hc_confirm end),'99,999')||' | ' "Spring 2019",''||to_char(sum(case when term='2202' then hc_confirm end),'99,999')||' | ' "Spring 2020",''||to_char(sum(case when term='2212' then hc_confirm end),'99,999')||' | ' "Spring 2021",''||to_char(sum(case when term='2222' then hc_confirm end),'99,999')||' | ' "Spring 2022",''||to_char(sum(case when term='2232' then hc_confirm end),'99,999')||' | ' "Spring 2023",''||to_char(sum(case when term='2242' then hc_confirm end),'99,999')||' | ' "Spring 2024" FROM dm_app WHERE 1=1 and semester(+)='Spring' and pbcred(+)='Y' and last8app(+)='Y' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier|||||||||||
| Administrative Services | 1 | 1 | 1 | ||||||||||||||||
| Art | 1 | ||||||||||||||||||
| English | 1 | 1 | |||||||||||||||||
| Mild/Moderate Disabilities | 1 | 1 | |||||||||||||||||
| Multiple Subject | 1 | 1 | select ' | ||||||||||||||||
| Totals' groupby,' | '||to_char(sum(case when term='2172' then hc_confirm end),'99,999')||' | ' "Spring 2017",''||to_char(sum(case when term='2182' then hc_confirm end),'99,999')||' | ' "Spring 2018",''||to_char(sum(case when term='2192' then hc_confirm end),'99,999')||' | ' "Spring 2019",''||to_char(sum(case when term='2202' then hc_confirm end),'99,999')||' | ' "Spring 2020",''||to_char(sum(case when term='2212' then hc_confirm end),'99,999')||' | ' "Spring 2021",''||to_char(sum(case when term='2222' then hc_confirm end),'99,999')||' | ' "Spring 2022",''||to_char(sum(case when term='2232' then hc_confirm end),'99,999')||' | ' "Spring 2023",''||to_char(sum(case when term='2242' then hc_confirm end),'99,999')||' | ' "Spring 2024" FROM dm_app WHERE 1=1 and semester(+)='Spring' and pbcred(+)='Y' and last8app(+)='Y' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier|||||||||||
| Totals | 2 | 2 | 1 | 2 | 3 | ||||||||||||||