| Request No. | 2018-18 |
|---|---|
| Date of Request | April 26, 2018 |
| Requester | CCCCO / Craig Hayward |
| Application(s) | CCCApply Standard / International |
| Section / Page | Race & Ethnicity / Demographic Information |
| Proposed Change to Download File | Yes - Adjustments & New Data Field |
| Proposed Change to Residency Logic | N/A |
| Table of Contents |
|---|
Problem and Business Need
Research conducted over the past two years by the Student Equity Planning workgroup and the Chancellor's Vision for Success has resulted in a system-wide focus on closing equity gaps. Historical MIS data sets, however, do not include all ethnic groups that are relevant for the diverse and distinct communities served by the 115 California community colleges.
There is a business need to expand the categories of race and ethnicity that are collected via CCCApply and in the International application. The current Student Equity Plan (SEP) guidelines do not include all ethnic groups that are relevant for distinct and diverse local communities served by the 114 colleges. For example, State Center College has a sizable Hmong population in its service area. However, their ability to conduct research, identify equity gaps, and direct resources in ways that will effectively close those gaps has been impeded because “Hmong” is not an ethnicity category that is collected on the standard application. We need to expand the ethnicity group data collected via the standard CCC application (CCCApply) in CCCApply and make that data available via the statewide MIS.
| Info |
|---|
This is an approved change request coming from the Chancellor's Office to revise the overall layout and expand the race and ethnicity values to better provide disaggregated data for research. UAT checklist and detailed implementation steps are published in the CCCApply public documentation section. |
Additional Information
Ethnicity/Ancestry Expansion Proposal
"Currently, the CCC system collects information on 21 distinct ethnicity or ancestry categories. For comparison purposes, consider that the CSU system collects data on 113 categories while the UC system collects data on 73 categories. CCCApply collects ethnicity information by first asking applicants if they are Hispanic or Latino. Respondents who select “Yes” then see an expanded set of more specific options to choose from. This the same mechanism that the proposed expansion will use to ensure that the collection of the additional, more specific ethnic groups is minimally disruptive to the application process."
Ethnicity-Ancestry Expansion Proposal Digest-Draft v 1.4.docx
Additional Information: https://www.diffen.com/difference/Ethnicity_vs_Race
Additional Info: SSSP Memo Excerpt
Excerpts from Student Success and Support Program re Student Equity SEC. 6. Article 1.5 (commencing with Section 78220) is added to Chapter 2 of Part 48 of Division 7 of Title 3 of the Education Code, to read:
| Expand | ||
|---|---|---|
| ||
Article 1.5. Student Equity Plans 78220. (a) As a condition for receiving Student Success and Support Program funding, and in order to ensure equal educational opportunities and to promote student success for all students, regardless of race, gender, age, disability, or economic circumstances, the governing board of each community college district shall maintain a student equity plan that includes all of the following for each community college in the community college district: (1) Campus-based research as to the extent of student equity by gender and for each of the following categories of students: (A) Current or former foster youth. (B) Students with disabilities. (C) Low-income students. (D) Veterans. (E) Students in the following ethnic and racial categories, as they are defined by the United States Census Bureau for the 2010 Census for reporting purposes: (i) American Indian or Alaska Native. (ii) Asian. (iii) Black or African American. (iv) Hispanic or Latino. (v) Native Hawaiian or other Pacific Islander. (vi) White. (vii) Some other race. (viii) More than one race. |
Proposed Solution
Update the Race & Ethnicity section of the Demographic Information page to include an enhanced, expanded layout, with conditional expand/collapse formatting to hide certain sub-categories until a student selects the high level category.
Proposed by Craig Hayward, Bakersfield College, on April 26, 2018:
This is a proposal for expanding the categories of ethnicity that are collected via CCCApply. The idea is to add one additional high-level category (Middle Eastern/North African) which would roll up into "White" for federal IPEDS reporting (as it currently does). The other groups would only be made visible if someone selected a high level group like "Asian"; then they would see all of the possible sub-categories for Asian. Work on this proposal has been ongoing with various stakeholder groups around the state for the past year or so.
General Requirements
- Implements all new data fields & formats as close to the original formats as possible for minimal impact on the colleges
- Ensures that the <race_ethnic> field is particularly unchanged; this is the field that aligns to the MIS reporting requirement
- Rolls up all the new data values, especially the new race groups & ethnicities values (over 200 in all) into one new, additional field - that colleges can choose to add to their downloads or not;
- Encourages all colleges to add the new Race Ethnicity Full data field and fully update their download files, making all necessary adjustments to existing fields and run the new Download Client Jar file
Functional Mock Up for Proposed New Design
Attached is a functional Excel spreadsheet mockup for how this new layout and functionality should be in both the CCCApply and International Applications.
Click here: Ancestry proposal 2.43.xlsx
Current Design and Functionality
CCCApply Standard and International applications collect race and ethnicity information by first asking applicants if they are Hispanic or Latino. Respondents who select “Yes” then see an expanded set of more specific options to choose from. From there, applicants are asked what their race is and they are given limited high level categories to choose from.
Race & Ethnicity Section in Standard Application Today
(Before new Race & Ethnicity implementation - 6.3.0)
In the International Application Today
(before new Race & Ethnicity implementation - 6.3.0)
Current Database Values
(Before new Race & Ethnicity implementation 6.3.0)
Hispanic/Latino (hispanic_latino):
Race Group (race_group):
01: Hispanic, Latino - (From ‘Are you Hispanic / Latino?’
drop-down menu selection)
02: Mexican, Mexican-American, Chicano
03: Central American
04: South American
05: Hispanic: Other
Race Ethnicity (race_ethnicity):
06: Asian: Indian
07: Asian: Chinese
08: Asian: Japanese
09: Asian:
This system-wide need to close the equity gaps was the impetus for the Ethnicity-Ancestry Expansion Project 2018, and the foundation of this change request.
Proposed Solution
In summary this proposal will expand the categories of ethnicity/ancestry collected in CCCApply, and includes a detailed set of requirements for a redesign to the layout and the specific ethnicity values and race groups that should be added.
According to one of the authors of the proposal, Craig Hayward, Dean of Institutional Research at Bakersfield College:
The idea is to add one additional high-level category (Middle Eastern/North African) which would roll up into "White" for federal IPEDS reporting (as it currently does). The other groups would only be made visible if someone selected a high level group like "Asian"; then they would see all of the possible sub-categories for Asian. Work on this proposal has been ongoing with various stakeholder groups around the state for the past year or so.
Responding to the ethnicity question (will remain) optional, and the expanded number of categories will be unobtrusive as the detailed subgroups will only be seen when one of the higher-level categories is selected first. This proposal is compliant with federal reporting requirements as all subgroups can be easily rolled up into the required federal ethnicity and race reporting categories. For example, the new high-level group, Middle Eastern and North African (MENA) rolls up into the “White” category for federal reporting purposes. Most importantly, information gathered from the expanded categories will allow colleges and districts to identify equity gaps and work to alleviate them by allowing for enhanced targeting of resources and services—thereby empowering CCC stakeholders to rise the challenge, laid out in the Vision for Success, of reducing and eventually closing all equity gaps by 2027.
Click here: Ancestry proposal 2.43.xlsx
| Info |
|---|
Approval InformationThis proposal was reviewed by the Chancellor’s Office Data, Evaluation and Research (CODER) group, which includes representatives from the Chancellor’s Office MIS and research units as well as other stakeholders from the Research and Planning Group, Education Results Partnership, and the Workforce and Economic Development Division of the Chancellor’s Office. The proposal was favorably reviewed and APPROVED to be advanced for adoption. One area of particular focus was the discussion of how students feel a sense of belonging when they see their ethnic background represented as an option. In particular, the discussion focused on whether to include all Native American tribes that are recognized by the state of California and if not, where to draw the line. |
Additional Information
Ethnicity/Ancestry Expansion Proposal
This proposal was approved by the Chancellor's Office based on over two years of research and dialogue by the Student Equity Planning workgroup and the Chancellor's Vision for Success. The proposal is clearly explained in the "Ethnicity-Ancestry Expansion Proposal". See an excerpt below.
"Currently, the CCC system collects information on 21 distinct ethnicity or ancestry categories. For comparison purposes, consider that the CSU system collects data on 113 categories while the UC system collects data on 73 categories. CCCApply collects ethnicity information by first asking applicants if they are Hispanic or Latino. Respondents who select “Yes” then see an expanded set of more specific options to choose from. This the same mechanism that the proposed expansion will use to ensure that the collection of the additional, more specific ethnic groups is minimally disruptive to the application process."
Additional Info: SSSP Memo Excerpt
Excerpts from Student Success and Support Program re Student Equity SEC. 6. Article 1.5 (commencing with Section 78220) is added to Chapter 2 of Part 48 of Division 7 of Title 3 of the Education Code, to read:
| Expand | ||
|---|---|---|
| ||
Article 1.5. Student Equity Plans 78220. (a) As a condition for receiving Student Success and Support Program funding, and in order to ensure equal educational opportunities and to promote student success for all students, regardless of race, gender, age, disability, or economic circumstances, the governing board of each community college district shall maintain a student equity plan that includes all of the following for each community college in the community college district: (1) Campus-based research as to the extent of student equity by gender and for each of the following categories of students: (A) Current or former foster youth. (B) Students with disabilities. (C) Low-income students. (D) Veterans. (E) Students in the following ethnic and racial categories, as they are defined by the United States Census Bureau for the 2010 Census for reporting purposes: (i) American Indian or Alaska Native. (ii) Asian. (iii) Black or African American. (iv) Hispanic or Latino. (v) Native Hawaiian or other Pacific Islander. (vi) White. (vii) Some other race. (viii) More than one race. |
Legacy Design and Functionality
CCCApply Standard and International applications collect race and ethnicity information by first asking applicants if they are Hispanic or Latino. Respondents who select “Yes” then see an expanded set of more specific options to choose from. From there, applicants are asked what their race is and they are given limited high level categories to choose from.
Race & Ethnicity Section Legacy - Before 6.3.0
| CCCApply Standard Application | Current Database Values | International Application |
|---|---|---|
| (Before new Race & Ethnicity implementation - 6.3.0) | (Before new Race & Ethnicity implementation 6.3.0) | (Before new Race & Ethnicity implementation - 6.3.0) |
 | Hispanic/Latino (hispanic_latino): 01: Hispanic, Latino - (From ‘Are you Hispanic / Latino?’ |
17: Pacific Islander: Guamanian
18: Pacific Islander: Hawaiian
19: Pacific Islander: Samoan
20: Pacific Islander: Other
21: White
Native |  |
General Requirements
- Backward Compatibility - No change to data downloads: Implement the new expanded race and ethnicity categories without changing the existing formats and data output; keeping the download files unchanged and seamlessly backwards compatible.
- Minimal impact on colleges: Ensures that the <race_ethnic> field is particularly unchanged; this is the field that aligns to the MIS reporting requirement
- Rolls up all the new data values, especially the new race groups & ethnicities values (over 200 in all) into one new, additional field - that colleges can choose to add to their downloads or not;
- Encourages all colleges to add the new Race Ethnicity Full data field and fully update their download files, making all necessary adjustments to existing fields and run the new Download Client Jar file
Functional Mock Up for Proposed New Design
Attached is a functional Excel spreadsheet mockup for how this new layout and functionality should be in both the CCCApply and International Applications.
Click here: Ancestry proposal 2.43.xlsx
Screenshots: New Layout Design
| Expand | ||
|---|---|---|
| ||
New Hispanic Question & Race Groups - Auto-populated
New Hispanic Question Expanded
Asian Category Expanded
More Groups Expanded
|
- Hispanic/Latino Question Auto-populated
- Hispanic/Latino Question Expanded Showing All Hispanic/Latino Subcategory Values
- Asian Race Group Expanded Showing All Asian Subcategory Values
- More Race Groups Expanded Showing Subcategory Values
New Race/Ethnicity Section
Zoom Demo: New Race & Ethnicity Layout
| Info | ||
|---|---|---|
| ||
New Race & Ethnicity Changes - User Interface Demo Zoom recording 09.14.18: https://cccconfer.zoom.us/recording/play/rJbSJXM0v3OcWtJaPncPnvSBB1LB7J_dxsSBF7JoEj4OdMLGWgT8hXWidv_LNxSz?continueMode=true |
Change Specifications: New Layout Design and Database Values
Consistent with the original version, the new Race & Ethnicity section includes two sub-sections: 1) Hispanic/Latino section, which includes a Yes/No question: "Are you Hispanic or Latino?" question, which also serves as the high-level race group, and a sub-set of more specific ethnicities to choose from, and 2) Six high-level race groups, which when selected expand to display a set of more specific options, or ethnicities, to choose from.
Race/Ethnicity Section Header
The Race & Ethnicity section heading label is Race/Ethnicity that displays above the Hispanic/Latino ssection on the "Demographic Information" page. This did not change from the original (legacy) layout.
Hispanic/Latino Section
The following instruction text appears above the Hispanic/Latino Yes/No question. Respondents that answer Yes will see an expanded set of 19 Hispanic/Latino ethnicities to choose from. Many of these ethnicity options are new and can be downloaded in the new field: <race_ethnic_full>
"Per U.S. Department of Education guidelines, colleges are required to collect this racial and ethnic data.Check the box below if you identify as Hispanic or Latino. If you indicate that you are Hispanic or Latino, you will have the option to select more specific ancestry groups."
Hispanic/Latino Database Values
There is no change to the Hispanic/Latino database values or data format.
Name & Value
(race_group)
(race_ethnic_full)
Response to question "Are you Hispanic or Latino?"
- Argentinean - should map back to DB value of 04
- Bolivian - should map back to DB value of 04
- Chilean - should map back to DB value of 04
- Colombian - should map back to DB value of 04
- Costa Rican - should map back to DB value of 03
- Cuban - should map back to DB value of 05
will see an expanded set of 19 Hispanic/Latino ethnicities to choose from. Many of these ethnicity options are new and can be downloaded in the new field: <race_ethnic_full>
"Per U.S. Department of Education guidelines, colleges are required to collect this racial and ethnic data.
Check the box below if you identify as Hispanic or Latino. If you indicate that you are Hispanic or Latino, you will have the option to select more specific ancestry groups."
Hispanic/Latino Database Values
There is no change to the Hispanic/Latino database values or data format. Response to question "Are you Hispanic or Latino?"
New Race Group Name & Value (race_group) | Legacy Race Group Value | New Race Group Value | New Race Ethnicity Full Values (race_ethnic_full) | Add metadata to the new race_group and race_ethnicity that will map/aligns to the legacy race/ethnicities |
|---|---|---|---|---|
| Hispanic, Latino | 01 | 100 | Response to question "Are you Hispanic or Latino?" = 100 | |
| Mexican, Mexican-American, Chicano | 02 |
| ||
| Central American | 03 |
| ||
| South American | 04 |
| ||
| Hispanic: Other | 05 |
|
Section 2: Race Groups & Ethnicities
Below the Hispanic/Latino section, display the following additional instructive text and display the following set of high-level Race Groups adjacent to corresponding checkboxes.
"Check all of the ethnicity and ancestry groups that you identify with. When you select a major ethnicity group, you will have the option to select more specific ancestry groups. Select all that apply."
- Asian
- American Indian or Alaska Native
- Black or African American
- Native Hawaiian or Other Pacific Islander
- Middle Eastern or North African
- White
Respondents who select one or more of the Race Groups checkboxes will then see the expanded associated subgroups. Respondents may select as many race groups and ethnicity subgroups as needed. When a box is checked an accordion expansion should reveal the associated subgroups. When a box is unchecked, the accordion expansion should roll up to no longer show the subgroups.
Race Groups & Ethnicities Database Values
The following table shows a breakdown of the subgroups tied to each ethnic group, as well as the DB value associated in parenthesis.
Legacy Race Group Name | Legacy Race Group Value (race_group) | New Race Group Value in Race Ethnicity Full | New Race Ethnicity Full Name & Values (race_ethnic_full) | Mapping Notes: |
|---|
Asian
- Afghan - New DB Value of 201
- Bangladeshi - New DB Value of 202
- Burmese/Myanmar - New DB Value of 203
- Indian - ((Stays as 06)
- Pakistani - New DB Value of 206
- Sri Lankan - New DB Value of 207
The following ethnicity subgroups should map back to DB value = 06
- Afghan
- Bangladeshi
- Burmese/Myanmar
- Indian
- Pakistani
- Sri Lankan
Asian | 06 | 200 |
| |
| Asian: Chinese | 07 |
| ||
| Asian: Japanese | 08 |
| ||
| Asian: Korean | 09 |
| ||
| Asian: Laotian | 10 |
| ||
| Asian: Cambodian | 11 |
| ||
| Asian: Vietnamese | 12 |
| ||
| Asian: Filipino | 13 |
| ||
| Asian: Other | 14 |
| ||
American Indian or Alaska Native | 16 | 300 |
|
|
Black or African American | 15 | 500 |
|
|
Native Hawaiian or Other Pacific Islander | 600 | |||
| Pacific Islander: Other | 20 |
| ||
| Pacific Islander: Guamanian | 17 |
| ||
| Pacific Islander: Hawaiian | 18 |
| ||
| Pacific Islander: Samoan | 19 |
| ||
Middle Eastern or North African | 700 |
|
|
| |||
| White - New DB Value of 800 | 21 | 800 |
|
|
|
Release Information for Colleges
The Race & Ethnicity Implementation 2018 is a significant revision to the current, highly-regulated Race & Ethnicity section in CCCApply which is protected by federal law, the Office of Civil Rights, and aligns to various MIS (SB29) and IPEDs (STD10) reporting requirements. The new implementation will be in place before the MIS requirements are updated in Fall 2019.
CCCApply's objective for this implementation is twofold:
- Provide colleges with the same data fields and formats they were getting in the original (legacy) implementation.
- Provide a new field with all the new race groups and ethnicity/ancestry subcategories collected in the new layout and disaggregation categories.
We understand that several of the existing race & ethnicity fields (race_group; race_ethnic) align to MIS data elements (and other derived data elements) and colleges have configured data files to map to those MIS requirements. Throughout this implementation, we made it a priority to maintain the existing data output formats and leave these fields unchanged for this purpose.
In-Progress Applications
For In-Progress applications, there will be no database value mappings. If an application is in-progress at the time of release - and a student had already selected a race/ethnicity, the user will be presented with a client-side error validation message upon resuming that application that advises them of the following:
The Race and/or Ethnicity you have selected is no longer valid. Please go back to the Demographic Information tab and select a new value.
The user should not be able to submit the Apply or International application unless they have chosen a valid database value(s) for race_group and race_ethnicities. Once the new value is chosen, we will store the new value.
Data Formats & Downloads
The new Race & Ethnicity implementation (layout and data) is designed so as to not require colleges to make any changes to their jar file/download client and should be seamlessly backwards compatible.
The current database is set up to support 21 specific race groups and race ethnicities. With the addition of more and new race_groups and race_categories, we needed to assign new database values to the new race groups and race ethnicities while maintaining the integrity of the existing race_group and race_ethnicity values.
The fields "hispanic", "race_group", and "race_ethnic" (Apply)/"race_ethnicity" (Intl) will remain unchanged. We are adding an additional database column called "race_ethnic_full" which will store the values the user selects for both higher level ethnic groups and the associated sub groups presented in the new UI and in the chart above. From From a download file perspective, colleges should only have to touch their download files if they want to add the new field <race_ethnic_full>, capturing all the new groups and sub-category values.
The fields "hispanic", "race_group", and "race_ethnic"(Apply)/"race_ethnicity" (Intl) are calculated from the user's selections and made available to the college using the same format as previous versions of the applications.
Detailed Field Notes
hispanic
Notes: No changes, this field is a boolean true/false field that continues to work as in previous version
Example Format: boolean (true/false/null)
race_group
Notes: No changes, this field was intentionally left unchanged
Example Format: Apply: "04, 05, 08, 09, 14, 15, 17, 19, 20, 21", International: "04,05,08,09,14,15,17,19,20,21" (note lack of spaces for Intl)
Maximum Expected Width: 78 characters (unchanged) (20 * 2 character long values + 18 commas + 18 spaces + 2 surrounding quote marks for CSV delimiting in the output format)
race_ethnic (Apply) / race_ethnicity (International)
Notes: No changes, this field was intentionally left unchanged
Example Format: YNYNNNNYNNNNNNNNNYNNN
Maximum Expected Width: 22 characters (unchanged) (22 character long string)
race_ethnic_full
Notes: race_ethnic_full is a new field that will store the CSV separated values for all the ethnicity section selections for both the higher level ethnic groups and the associated sub groups as listed above in the chart.
Example Format: "100,101,117,118,200,205,08,09,500,15,600,601,17,19,602,700,701,713,800,802,803"
Maximum Expected Width: 804 characters (201 * 3 character long values + 199 commas + 2 surrounding quote marks for CSV delimiting in the output format)
College Adaptor Data Element
For SuperGlue colleges, the new race_ethnic_full data element is called "raceEthnicFull"
Changes by Section
| Section | Field | Original Implementation | Original Backend | Change to UI | Change to Back-End | What colleges need to do |
|---|---|---|---|---|---|---|
| Hispanic / Latino Question | hispanic | Yes / No radio buttons | Boolean Y/N or T/F (Note - corresponds to (01) | None | None | Nothing, No Change |
| Race Group | race_group | Pertains only to Hispanic / Latino Checkboxes | Varying length In-Progress Side: Stored the Hispanic/Latino checked values in CSV Submitted Side: Stored the raw values in CSV for both the Hispanic/Latino section as well as the Ethnicities section | Changed to map to the Ethnicity Groups, new options | Now stores the Ethnic Group data in CSV Format | Account for the different meaning of the data coming through, also adjust fixed-width delimited download client format as needed |
| Race / Ethnicity | race_ethnic (Apply) / race_ethnicity (Intl) | Checkboxes | Varying length In-Progress Side: Stored the Ethnicities section checked values in CSV Submitted Side: stored the YNX MIS Reporting format | UI no longer maps directly to this field | Now a calculated value that always stores the MIS Reporting format (both in-progress and submitted side) | Nothing, No Change |
| Race / Ethnicity Full | race_ethnic_full | N/A | N/A | Added new Ethnicity subgroup options, changed to map subgroups to this column | Now stores the values for all subgroups in CSV (combines Hispanic/Latino section and other Ethnicities) | New Download Client Column, optional for the colleges if they want to download these values |
| Values that weren't a clear a one-to-one map, we had to change | ||||||
| The only option to keeping the columns the same would be to have implemented ALL 190+ race ethnicities and groups with the same formatting as the odd logic as before (combined use of YN) | ||||||
MIS Data Elements
MIS Data Element | MIS Derived Data Element | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SB29 - Multi-Ethnicity | STD10 - Student -Ethnicity (Derived Data Element) Used for IPEDs reporting | ||||||||||||
|
|
Updated Data Dictionary Tables
Hispanic/Latino
Data Element: | hispanic |
Description: | Applicant’s response to ‘Are you Hispanic or Latino?’ |
Format, Length: | boolean, 1 |
Values: | 1 = True/Yes, 0 = False/No If Null, the value will appear as blank in the downloads and Report Center. |
Allows Null: | Yes (see above) |
Default: | None |
Usage: | New 12.07.18: This element and "race_group' are used to derive 'race_ethnic" (Apply) and 'race_ethnicity' (International), which is still used for MIS (SB29) reporting. NOTE: MIS will update SB29 to match new configuration in Fall 2019. |
Notes: | Ethnicity is sensitive information, protected by federal law and the Office of Civil Rights. Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights. |
This information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes. | |
Xap Field: | hispanicLatino |
Revision Log: | December 2018 (v.6.3.0) |
Question Text: | Are you Hispanic or Latino? Yes [radio button, clearable] No [radio button, clearable] |
Conditions: | Always |
Additional Text: | "Per U.S. Department of Education guidelines, colleges are required to collect this racial and ethnic data. Check the box below if you identify as Hispanic or Latino. If you indicate that you are Hispanic or Latino, you will have the option to select more specific ancestry groups." |
Response Options: | Yes No or X = No response |
Pop-Up Help: | None |
Field Error Check: | None |
Page Error Check: | None; optional response per IPEDS and CCCCO. |
Notes: | Ethnicity is sensitive information, protected by federal law and the Office of Civil Rights. Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights. This information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes. |
Data Element: | hispanic |
Race/Ethnicity
Data Element: | race_ethnic (CCCApply Standard) | |
Description: | Combination of responses to legacy Hispanic/Latino question and ethnicities, and all original race groups and ethnicities, as per MIS (SB29) reporting requirements. | |
Format, Length: | bpchar, 22 No changes were made to this field, it was intentionally left unchanged. Null is allowed in first character position to represent Hispanic/Latino question response. Example Format: | |
bpchar, 22
No changes were made to this field, it was intentionally left unchanged. Null is allowed in first character position to represent Hispanic/Latino question response.
Example Format: XNYNNNNYNNNNNNNNNYNNNXNYNNNNYNNNNNNNNNYNNN Maximum Expected Width: 22 characters (22 character long string) race_ethnic (Apply) / race_ethnicity (International)Notes: No changes, this field was intentionally left unchanged Example Format: YNYNNNNYNNNNNNNNNYNNN Maximum Expected Width: 22 characters (unchanged) (22 character long string) | ||
Values: | See Table | |
Allows Null: | No | |
Default: | None | |
Usage: | Correlates to MIS SB29. Ethnicity is used primarily by agencies affiliated with state reporting and evaluation of educational programs. This set of questions/data was based on specifications by the U.S. Dept. of Education in effect for all applicants beginning with the Summer 2009 term. | |
Notes: | 2018: This field is intentionally left unchanged for MIS SB29 reporting purposes | |
Example Format: YNYNNNNYNNNNNNNNNYNNN
Maximum Expected Width: 22 characters (22 character long string)
Note: Regarding new Race & Ethnicity implementation (v.6.3. |
This field remains dedicated to the original (legacy) combined format. Per CCCCO Management Information Systems Division, SB29 will be revised to align with the new race and ethnicity values in Fall 2019. All the new Ethnicities added in December 2018 (v.6.3.0) are available in the new field <race_ethnic_full>. Ethnicity is sensitive information, protected by federal law and the Office of Civil Rights. Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights. This information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes. The basic two-question format, the Hispanic ethnicity and race categories, and certain other aspects such as not requiring responses are IPEDS requirements. Any changes to race groups (categories) or ethnicities (sub-categories) implemented in the new implementation will map back to the original values specified by MIS at the Chancellor's Office (data element SB29). | ||
Revision Log: | December 2018 | |
Char | Race Group/Ethnicity | Values |
1 | Hispanic, Latino | From ‘Are you Hispanic / Latino?’ radio button format: ‘Y’ if ‘Yes’; ‘N’ if ‘No’; otherwise ‘X’ |
2 | Mexican, Mexican-American, Chicano | ‘Y’ if box is checked; otherwise ‘N’ |
3 | Central American | ‘Y’ if box is checked; otherwise ‘N’ |
4 | South American | ‘Y’ if box is checked; otherwise ‘N’ |
5 | Hispanic Other | ‘Y’ if box is checked; otherwise ‘N’ |
6 | Asian Indian | ‘Y’ if box is checked; otherwise ‘N’ |
7 | Asian Chinese | ‘Y’ if box is checked; otherwise ‘N’ |
8 | Asian Japanese | ‘Y’ if box is checked; otherwise ‘N’ |
9 | Asian Korean | ‘Y’ if box is checked; otherwise ‘N’ |
10 | Asian Laotian | ‘Y’ if box is checked; otherwise ‘N’ |
11 | Asian Cambodian | ‘Y’ if box is checked; otherwise ‘N’ |
12 | Asian Vietnamese | ‘Y’ if box is checked; otherwise ‘N’ |
13 | Asian Filipino | ‘Y’ if box is checked; otherwise ‘N’ |
14 | Asian Other | ‘Y’ if box is checked; otherwise ‘N’ |
15 | Black or African American | ‘Y’ if box is checked; otherwise ‘N’ |
16 | American Indian / Alaskan Native | ‘Y’ if box is checked; otherwise ‘N’ |
17 | Pacific Islander Guamanian | ‘Y’ if box is checked; otherwise ‘N’ |
18 | Pacific Islander Hawaiian | ‘Y’ if box is checked; otherwise ‘N’ |
19 | Pacific Islander Samoan | ‘Y’ if box is checked; otherwise ‘N’ |
20 | Pacific Islander Other | ‘Y’ if box is checked; otherwise ‘N’ |
21 | White | ‘Y’ if box is checked; otherwise ‘N’ |
Race Group
Data Element: | race_group |
Description: | Combination of all responses to the new race groups (high-level categories) implemented in December 2018. |
Format, Length: |
Maximum Expected Width: 78 characters (unchanged) (20 * 2 character long values + |
18 commas + 18 spaces + 2 surrounding quote marks for CSV delimiting in the output format) |
Database stores as text string Notes: |
Now, the 'race_group' field stores only the new Race Group mappings as CSV content with no spaces, as opposed to the old format which stored the raw values for the Ethnicity choices separated by a comma and a space (e.g. "02, 05, 06, 07, 21").
No longer saves spaces between comma separated values.
Example Format: “100,200,300,500,600,700,800”No changes made in 2018; this field was intentionally left unchanged Example Format: Apply: "04, 05, 08, 09, 14, 15, 17, 19, 20, 21", International: "04,05,08,09,14,15,17,19,20,21" (note lack of spaces for Intl) | |
Values: | String of codes indicating all new race group checkboxes that are checked, delimited by |
commas | |
100 – Hispanic or Latino 200 – Asian 300 – American Indian or Alaskan Native 500 – Black or African American 600 – Native Hawaiian or Other Pacific Islander 700 – Middle Eastern or North African 800 - White | |
Allows Null: | Yes |
Default: | None |
Usage: | This data element was repurposed in the new Race & Ethnicity implementation of 2018. The element now only stores the new high-level race groups (categories), including Hispanic/Latino. It is no longer used to derive the ‘race_ethnic’ data (which is still used as the primary element for MIS SB29 reporting). |
Notes: | Ethnicity is sensitive information, protected by federal law and the Office of Civil Rights. Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights. This information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes. The basic two-question format, the Hispanic ethnicity and race categories, and certain other aspects such as not requiring responses are IPEDS requirements.. 12.07.18: This field has been repurposed as part of the new Race & Ethnicity implementation of 2018; however remains mostly the same as the legacy format. Now, user interface shows all the unchanged and new high-level race groups in checkboxes. The format now saves the new race group values (hispanic and non-hispanic groups). Added additional options in checkboxes as subgroups |
Xap Field: | raceGroup |
Revision Log: | 12.07.18 (v.6.3.0) |
Question Text: | "Check all of the ethnicity and ancestry groups that you identify with. When you select a major ethnicity group, you will have the option to select more specific ancestry groups. Select all that apply." [checkbox] Asian |
Conditions: | Always |
Response Options: | Any combination of checkboxes can be checked, from none to all. · Asian · American Indian or Alaska Native · Black or African American · Native Hawaiian or Other Pacific Islander · Middle Eastern or North African · White |
Field Error Check: | None |
Page Error Check: | None; optional response per IPEDS and CCCCO. |
Notes: | See note for Hispanic/Latino (previous table). |
Data Element: | race_group |
Race & Ethnicity Full
Data Element: | race_ethnic_full |
Description: | Combination of all responses of new ethnicities (subcategories) added in 2018 implementation. |
Format, Length: | Stores CSV separated values of all selected ethnicities (subcategories). Maximum Expected Width: 776 characters (194 * 3 character long values + 192 commas + 2 surrounding quote marks for CSV delimiting in the output format) Example Format: "101,102,203,07,392,394,401,15,503,601,17,701,713,801,809" |
Values: | String of codes indicating all new ethnicity checkboxes that are checked, delimited by commas with no spaces between each code. See table of full ethnicity values below. |
Allows Null: | Yes |
Default: | None |
Usage: | New data field added to collect all new ethnicities (subcategories) implemented in 2018. Colleges that want to collect and download these new values must add this field to their Format XML file and run the new Download Client v.6.3.0 jar file. |
Notes: | Ethnicity is sensitive information, protected by federal law and the Office of Civil Rights. Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights. This information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes. |
Revision Log: | New 12.07.18 (v.6.3.0) |
Question Text: | "Check all of the ethnicity and ancestry groups that you identify with. When you select a major ethnicity group, you will have the option to select more specific ancestry groups. Select all that apply." |
Conditions: | Always |
Response Options: | Any combination of checkboxes can be checked, from none to all. See full list of ethnicities in table below. Complete list of ethnicities are displayed (expand) when race group category is selected. |
Field Error Check: | None |
Page Error Check: | None; optional response per IPEDS and CCCCO. |
Notes: | New data field to capture full combination of all new ethnicity values (subcategories). There are a total of 194 possible values for the data field. Each race group contains one or more ethnicities, which are displayed as checkboxes when selected by a respondent. |
Data Element: | race_ethnic_full |
Story
As a college researcher, I need the ability to disaggregate API data of the college/system race and ethnicity demographical data collected in CCCApply and International application so the data is captured in a more detailed manner for federal IPEDs reporting on ethnicity data.