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 |
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 | SELECT '|||||||||||
'||residency groupby,' | '||to_char(sum(case when term='2123' then Hc_confirm end),'99,999')||' | ' "Summer 12",''||to_char(sum(case when term='2133' then Hc_confirm end),'99,999')||' | ' "Summer 13",''||to_char(sum(case when term='2143' then Hc_confirm end),'99,999')||' | ' "Summer 14",''||to_char(sum(case when term='2153' then Hc_confirm end),'99,999')||' | ' "Summer 15",''||to_char(sum(case when term='2163' then Hc_confirm end),'99,999')||' | ' "Summer 16",''||to_char(sum(case when term='2173' then Hc_confirm end),'99,999')||' | ' "Summer 17",''||to_char(sum(case when term='2183' then Hc_confirm end),'99,999')||' | ' "Summer 18",''||to_char(sum(case when term='2193' then Hc_confirm end),'99,999')||' | ' "Summer 19" FROM dm_app WHERE 1=1 and semester(+)='Summer' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier|||||||||||
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 | |||||||||||||
select ' | |||||||||||||||||||
Totals' groupby,' | '||to_char(sum(case when term='2123' then Hc_confirm end),'99,999')||' | ' "Summer 12",''||to_char(sum(case when term='2133' then Hc_confirm end),'99,999')||' | ' "Summer 13",''||to_char(sum(case when term='2143' then Hc_confirm end),'99,999')||' | ' "Summer 14",''||to_char(sum(case when term='2153' then Hc_confirm end),'99,999')||' | ' "Summer 15",''||to_char(sum(case when term='2163' then Hc_confirm end),'99,999')||' | ' "Summer 16",''||to_char(sum(case when term='2173' then Hc_confirm end),'99,999')||' | ' "Summer 17",''||to_char(sum(case when term='2183' then Hc_confirm end),'99,999')||' | ' "Summer 18",''||to_char(sum(case when term='2193' then Hc_confirm end),'99,999')||' | ' "Summer 19" FROM dm_app WHERE 1=1 and semester(+)='Summer' * ERROR at line 2: ORA-00904: "HC_CONFIRM": invalid identifier|||||||||||
Totals | 242 | 223 | 655 | 450 | 353 | 305 | 166 | 595 |
Return to Institutional Summary Index       *Glossary of Terms