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

SELECT '' "Spring 2017",'' "Spring 2018",'' "Spring 2019",'' "Spring 2020",'' "Spring 2021",'' "Spring 2022",'' "Spring 2023",'' "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 select '' "Spring 2017",'' "Spring 2018",'' "Spring 2019",'' "Spring 2020",'' "Spring 2021",'' "Spring 2022",'' "Spring 2023",'' "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
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
'||program groupby,''||to_char(sum(case when term='2172' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2182' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2192' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2202' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2212' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2222' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2232' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2242' then hc_confirm end),'99,999')||'
Administrative Services 1 1 1
Art 1
English 1 1
Mild/Moderate Disabilities 1 1
Multiple Subject 1 1
Totals' groupby,''||to_char(sum(case when term='2172' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2182' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2192' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2202' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2212' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2222' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2232' then hc_confirm end),'99,999')||''||to_char(sum(case when term='2242' then hc_confirm end),'99,999')||'
Totals 2 2 1 2 3

Return to Institutional Summary Index       *Glossary of Terms