Applicants Report Options
Time frame To-date     Final
Semester Fall     Spring     Summer     Academic year
Redirects All     Excluding Redirected     Redirected
Cohort Applicants     Admits     Active Admits     Confirmed     Registered     Self-registered
Rows by Applicant type     by Residency     by Origin     by Ethnicity

SELECT '' "Summer 12",'' "Summer 13",'' "Summer 14",'' "Summer 15",'' "Summer 16",'' "Summer 17",'' "Summer 18",'' "Summer 19" FROM dm_app WHERE 1=1 and semester(+)='Summer' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier select '' "Summer 12",'' "Summer 13",'' "Summer 14",'' "Summer 15",'' "Summer 16",'' "Summer 17",'' "Summer 18",'' "Summer 19" FROM dm_app WHERE 1=1 and semester(+)='Summer' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier
Final Summer Confirmed by Residency
report generated: 09-DEC-23
Residency Summer 12 Summer 13 Summer 14 Summer 15 Summer 16 Summer 17 Summer 18 Summer 19
'||residency groupby,''||to_char(sum(case when term='2123' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2133' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2143' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2153' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2163' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2173' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2183' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2193' then Hc_confirm end),'99,999')||'
American Indian 4 5 8 13 11 9 5 14
African American 26 16 75 35 34 33 20 45
Hispanic/Latino 74 89 280 179 131 108 68 254
Asian American 7 9 63 23 14 9 7 24
Pacific Islander 2 2 4 2 3 2 2 7
Two or More Races 30 23 50 51 24 24 15 51
White 94 77 157 135 122 102 43 176
Unknown 5 2 15 9 12 9 4 15
Nonresident Alien 3 3 2 9 2 9
Totals' groupby,''||to_char(sum(case when term='2123' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2133' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2143' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2153' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2163' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2173' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2183' then Hc_confirm end),'99,999')||''||to_char(sum(case when term='2193' then Hc_confirm end),'99,999')||'
Totals 242 223 655 450 353 305 166 595

Return to Institutional Summary Index       *Glossary of Terms