| 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 | |||||||||||