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 |
Return to Institutional Summary Index       *Glossary of Terms