Race & Ethnicity / Demographic Information
Info |
---|
This is an approved change request coming from the Chancellor's Office to revise, expand, and add conditional formatting to the Race & Ethnicity section in both CCCApply and the International Application. See Change Request 2018-18: Expand Race & Ethnicity Section with New Categories |
Table of Contents |
---|
Current Problem and Business Need
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) and make that data available via the statewide MIS.
Per 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 is 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.
Supporting Documentation
Ethnicity/Ancestry Expansion Proposal
View file | ||||
---|---|---|---|---|
|
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. |
Current Race/Ethnicity 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.
CCCApply Application Today
(Before new Race & Ethnicity implementation - 6.3.0)
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):
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: Korean
10: Asian: Laotian
11: Asian: Cambodian
12: Asian: Vietnamese
13: Asian: Filipino
14: Asian: Other
15: Black or African American
16: American Indian / Alaskan Native
17: Pacific Islander: Guamanian
18: Pacific Islander: Hawaiian
19: Pacific Islander: Samoan
20: Pacific Islander: Other
21: White
Proposed Solution
Update the Race & Ethnicity section of the Demographic Information page to include a new section and revise the conditional formatting functionality to hide certain sub-categories until a student selects the high level category.
Note: If a new category is added to the response options for the Race & Ethnicity download field(s), colleges will be required to implement the changes to absorb the new options and replace their DLC jar file.
General Requirements
- Requirements below apply to both the Apply and international applications.
- Data Dictionary for both Apply and International applications should be updated to reflect new Database values and mappings.
- No changes to the current DB size limit.
Functional Mock Up for New Design and Functionality
Attached is a functional excel mockup for how this new layout and functionality should be in both the CCCApply and International Application.
View file | ||||
---|---|---|---|---|
|
Info | ||
---|---|---|
| ||
New Race & Ethnicity Changes - User Interface Demo Zoom recording 09.14.18: https://cccconfer.zoom.us/recording/play/rJbSJXM0v3OcWtJaPncPnvSBB1LB7J_dxsSBF7JoEj4OdMLGWgT8hXWidv_LNxSz?continueMode=true |
NEW Layout Screenshots
New Hispanic Question & Race Groups Collapsed
New Hispanic Question & Race Groups - Auto-populated
New Hispanic Question Expanded
New Groups Expanded
More Groups Expanded
Requirements for New Design and Functionality
Section 1 Requirements - Hispanic/Latino Section- The first section should ask the following question: "Are you Hispanic or Latino?"
- If user clicks on the checkbox, then the box next to Hispanic or Latino should become automatically checked and the subgroup list expands and becomes visible to display 19 subcategories (race_ethnicity).
- If user does not click on the checkbox, then the box next to Hispanic or Latino should not systematically expand and the user should not see the 19 subcategories race_ethnicity).
100 = New DB Value
Expand | ||
---|---|---|
| ||
|
Hispanic, Latino - (From ‘Are you Hispanic / Latino?’
drop-down menu selection)
Check the box to open the sub-ethnicities
10.12.18: Per Craig Hayward, Brazil is not included on purpose.
- Mexican - New DB Value of 111 (Per Craig Hayward 7.19.18, keep this mapped to existing value 02.)
- Costa Rican - New DB Value of 105
- Guatemalan - New DB Value of 109
- Honduran - New DB Value of 110
- Nicaraguan - New DB Value of 112
- Panamanian - New DB Value of 113
- Salvadoran - New DB Value of 116
- Argentinean - New DB Value of 101
- Bolivian - New DB Value of 102
- Chilean - New DB Value of 103
- Colombian - New DB Value of 104
- Ecuadorian - New DB Value of 108
- Peruvian - New DB Value of 114
- Venezuelan - New DB Value of 118
10.12.18: Per Craig Hayward, Brazil is not included on purpose.
- Cuban - New DB Value of 106
- Dominican (Dominican Republic) - New DB Value of 107
- Puerto Rican - New DB Value of 115
- Spanish - New DB Value of 117
- Other Hispanic or Latino - New DB Value of 119 (New value approved for this one. per "Latino" ethnicity addition
- The following instructions should fall below the Hispanic/Latino Section.
- 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 and then click on the button that says "Continue".
- The system should then show the following ethnic groups with a checkbox next to each group:
- Asian
American Indian or Alaska Native
- Black or African American
- Native Hawaiian or Other Pacific Islander
- Middle Eastern or North African
- White
- Applicants who select one or more of the Ethnic Groups should then see the subset of more detailed associated subgroups. Multiethnic applicants are able to select as many ethnic groups and ethnic 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.
- The following table shows a breakdown of the subgroups tied to each ethnic group, as well as the DB value associated in parenthesis.
Asian
- Afghan - New DB Value of 201
- Bangladeshi - New DB Value of 202
- Burmese/Myanmar - New DB Value of 203
EastIndian (Remove "East" and leave it mapped to original "06")- Pakistani - New DB Value of 206
- Sri Lankan - New DB Value of 207
- Chinese - (Stays as 07)
- Japanese - (Stays as 08)
- Korean - (Stays as 09)
- Laotian - (Stays as 10)
- Cambodian - (Stays as 11)
- Vietnamese - (Stays as 12)
- Filipino - (Stays as 13)
- Hmong - New DB Value of 204
- Indonesian - New DB Value of 205
- Other Asian - (Stays as 14)
- Taiwanese - New DB Value of 208
- Thai - New DB Value of 209
NOTE: All the new American Indian / Alaskan Native responses will map back to original DB value "16"
- Agua Caliente Band of Cahuilla Indians of the Agua Caliente Indian Reservation - New DB Value of 301
- Alturas Indian Rancheria - New DB Value of 302
- Augustine Band of Cahuilla Indians - New DB Value of 303
- Aztec or Mixtec - New DB Value of 304
- Bear River Band of the Rohnerville Rancheria - New DB Value of 305
- Berry Creek Rancheria of Maidu Indians of California - New DB Value of 306
- Big Lagoon Rancheria - New DB Value of 307
- Big Pine Band Paiute Tribe of the Owens Valley - New DB Value of 308
- Big Sandy Rancheria of Western Mono Indians of California - New DB Value of 309
- Big Valley Band of Pomo Indians of the Big Valley Rancheria - New DB Value of 310
- Bishop Pauite Tribe (previously listed as Paiute-Shoshone Indians of the Bishop Community of the Bishop Colony) - New DB Value of 311
- Blue Lake Rancheria - New DB Value of 312
- Bridgeport Indian Colony - New DB Value of 313
- Buena Vista Rancheria of Me-Wuk Indians of California - New DB Value of 314
- Cabazon Band of Mission Indians - New DB Value of 315
- Cachil DeHe Band of Wintun Indians of the Colusa Indian Community of the Colusa Rancheria - New DB Value of 316
- Cahuilla Band of Mission Indians of the Cahuilla Reservation - New DB Value of 317
- Cahto Indian Tribe of the Laytonville Rancheria - New DB Value of 318
- California Valley Miwok Tribe - New DB Value of 319
- Campo Band of Diegueño Mission Indians of the Campo Indian Reservation - New DB Value of 320
- Capitan Grande Band of Diegueño Mission Indians of California:Barona Group of Capitan Grande Band of Mission Indians of the Barona Reservation; Viejas (Baron Long) Group of Capitan Grande Band of Mission Indians of the Viejas Reservation - New DB Value of 321
- Cedarville Rancheria - New DB Value of 322
- Chemehuevi Indian Tribe of the Chemehuevi Reservation - New DB Value of 323
- Cher-Ae Heights Indian Community of the Trinidad Rancheria - New DB Value of 324
- Cherokee - New DB Value of 325
- Chicken Ranch Rancheria of Me-Wuk Indians of California - New DB Value of 326
- Chippewa - New DB Value of 327
- Cloverdale Rancheria of Pomo Indians of California - New DB Value of 328
- Cold Springs Rancheria of Mono Indians of California - New DB Value of 329
- Colorado River Indian Tribes of the Colorado River Indian Reservation (Arizona and California) - New DB Value of 330
- Cortina Indian Rancheria of Wintun Indians of California - New DB Value of 331
- Coyote Valley Band of Pomo Indians of California - New DB Value of 332
- Death Valley Timbi-Sha Shoshone Tribe - New DB Value of 333
- Dry Creek Rancheria of Pomo Indians - New DB Value of 334
- Elem Indian Colony of Pomo Indians of the Sulphur Bank Rancheria - New DB Value of 335
- Elk Valley Rancheria - New DB Value of 336
- Enterprise Rancheria of Maidu Indians of California - New DB Value of 337
- Ewiiaapaayp Band of Kumeyaay Indians - New DB Value of 338
- Federated Indians of Graton Rancheria - New DB Value of 339
- Fort Bidwell Indian Community of the Fort Bidwell Reservation of California - New DB Value of 340
- Fort Independence Indian Community of Paiute Indians of the Fort Independence Reservation - New DB Value of 341
- Fort Mojave Indian Tribe (Arizona, California and Nevada) - New DB Value of 342
- Greenville Rancheria - New DB Value of 343
- Grindstone Indian Rancheria of Wintun-Wailaki Indians of California - New DB Value of 344
- Guidiville Rancheria of California - New DB Value of 345
- Habematolel Pomo of Upper Lake - New DB Value of 346
- Hoopa Valley Tribe - New DB Value of 347
- Hopland Band of Pomo Indians - New DB Value of 348
- Inaja Band of Diegueño Mission Indians of the Inaja and Cosmit Reservation - New DB Value of 349
- Ione Band of Miwok Indians of California - New DB Value of 350
- Jackson Band of Miwuk Indians - New DB Value of 351
- Jamul Indian Village of California - New DB Value of 352
- Karuk Tribe - New DB Value of 353
- Kashia Band of Pomo Indians of the Stewart’s Point Rancheria - New DB Value of 354
- Koi Nation of Northern California - New DB Value of 355
- La Jolla Band of Luiseño Indians - New DB Value of 356
- La Posta Band of Diegueño Mission Indians of the La Posta Indian Reservation - New DB Value of 357
- Lone Pine Paiute-Shoshone Tribe - New DB Value of 358
- Los Coyotes Band of Cahuilla & Cupeno Indians - New DB Value of 359
- Lytton Rancheria of California - New DB Value of 360
- Manchester Band of Pomo Indians of the Manchester Rancheria - New DB Value of 361
- Manzanita Band of Diegueño Mission Indians of the Manzanita Reservation - New DB Value of 362
- Mechoopda Indian Tribe of Chico Rancheria - New DB Value of 363
- Mesa Grande Band of Diegueño Mission Indians of the Mesa Grande Reservation - New DB Value of 364
- Middletown Rancheria of Pomo Indians of California - New DB Value of 365
- Mooretown Rancheria of Maidu Indians of California - New DB Value of 366
- Morongo Band of Cahuilla Mission Indians - New DB Value of 367
- Navajo - New DB Value of 368
- Northfork Rancheria of Mono Indians of California - New DB Value of 369
- Pala Band of Luiseño Mission Indians of the Pala Reservation - New DB Value of 370
- Paskenta Band of Nomlaki Indians of California - New DB Value of 371
- Pauma Band of Luiseño Mission Indians of the Pauma & Yuima Reservation - New DB Value of 372
- Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation - New DB Value of 373
- Picayune Rancheria of Chukchansi Indians of California - New DB Value of 374
- Pinoleville Pomo Nation (formerly the Pinoleville Rancheria of Pomo Indians of California) - New DB Value of 375
- Pit River Tribe (includes XL Ranch, Big Bend, Likely, Lookout, Montgomery Creek and Roaring Creek Rancherias) - New DB Value of 376
- Potter Valley Tribe (formerly the Potter Valley Rancheria of Pomo Indians of California) - New DB Value of 377
- Quartz Valley Indian Community of the Quartz Valley Reservation of California - New DB Value of 378
- Quechan Tribe of the Fort Yuma Indian Reservation (Arizona and California) - New DB Value of 379
- Ramona Band of Cahuilla - New DB Value of 380
- Redding Rancheria - New DB Value of 381
- Redwood Valley or Little River Band of Pomo Indians of the Redwood Valley Rancheria California - New DB Value of 382
- Resighini Rancheria - New DB Value of 383
- Rincon Band of Luiseño Mission Indians of the Rincon Reservation - New DB Value of 384
- Robinson Rancheria - New DB Value of 385
- Round Valley Indian Tribes, Round Valley Reservation - New DB Value of 386
- San Manual Band of Serrano Mission Indians of the San Maual Reservation - New DB Value of 387
- San Pasqual Band of Diegueño Mission Indians of California - New DB Value of 388
- Santa Rosa Indian Community of the Santa Rosa Rancheria - New DB Value of 389
- Santa Rosa Band of Cahuilla Indians (formerly the Santa Rosa Band of Cahuilla Mission Indians of the Santa Rosa Reservation) - New DB Value of 390
- Santa Ynez Band of Chumash Mission Indians of the Santa Ynez Reservation - New DB Value of 391
- Lipay Nation of Santa Ysabel (Previously listed as the Santa Ysabel Band of Diegueño Mission Indians of the Santa Ysabel Reservation) - New DB Value of 392
- Scotts Valley Band of Pomo Indians of California - New DB Value of 393
- Sheep Ranch Rancheria of Me-Wuk Indians - New DB Value of 394
- Sherwood Valley Rancheria of Pomo Indians of California - New DB Value of 395
- Shingle Springs Band of Miwok Indians, Shingle Springs Rancheria (Verona Tract) - New DB Value of 396
- Sioux - New DB Value of 397
- Soboba Band of Luiseño Indians - New DB Value of 398
- Susanville Indian Rancheria - New DB Value of 399
- Sycuan Band of the Kumeyaay Nation (formerly the Sycuan Band of Diegueno Mission Indians of California) - New DB Value of 401
- Table Mountain Rancheria of California - New DB Value of 402
- Tejon Indian Tribe - New DB Value of 403
- Tolowa Dee-ni' Nation - New DB Value of 404
- Torres-Martinez Desert Cahuilla Indians - New DB Value of 405
- Tule River Indian Tribe of the Tule River Reservation - New DB Value of 406
- Tuolumne Band of Me-Wuk Indians of the Tuolumne Rancheria of California - New DB Value of 407
- Twenty-Nine Palms Band of Mission Indians of California - New DB Value of 408
- United Auburn Indian Community of the Auburn Rancheria of California - New DB Value of 409
- Upper Lake Band of Pomo Indians - New DB Value of 410
- Utu Utu Gwaitu Paiute Tribe of the Benton Paiute Reservation - New DB Value of 411
- Washoe Tribe (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community and Washoe Ranches) (California and Nevada) - New DB Value of 412
- Wilton Rancheria - New DB Value of 413
- Wiyot Tribe (formerly the Table Bluff Reservation-Wiyot Tribe) - New DB Value of 414
- Yocha Dehe Wintun Nation - New DB Value of 415
- Yurok Tribe of the Yurok Reservation - New DB Value of 416
- Zapotec - New DB Value of 417
- Other American Indian - New DB Value of 418
- Other Alaska Native - New DB Value of 419
Note: All of these responses will map back to the original value for Black or AfricanAmerican = 15
- African American - Stays as 15
- Subsaharan African: Ethiopian - New DB Value of 501
- Subsaharan African: Kenyan - New DB Value of 502
- Subsaharan African: Nigerian - New DB Value of 503
- Subsaharan African: Somali - New DB Value of 504
- Subsaharan African: South African - New DB Value of 505
- Subsaharan African: Other Subsaharan African - New DB Value of 506
- West Indian: Belizean - New DB Value of 507
- West Indian: Haitian - New DB Value of 508
- West Indian: Jamaican - New DB Value of 509
- West Indian: Other West Indian - New DB Value of 510
Pacific Islander: Guamanian
- Guamanian or Chamorro - Stays as 17
- Native Hawaiian - Stays as 18
- Samoan - Stays as 19
- Tongan - New DB Value of 602
- Fijian - New DB Value of 601
- Other Pacific Islander - Stays as 20
Note: All of these new responses will map to the original value for White = 21
- Assyrian, Syriac or Chaldean - New DB Value of 701
- Egyptian - New DB Value of 702
- Iranian or Persian - New DB Value of 703
- Iraqi - New DB Value of 704
- Israeli - New DB Value of 705
- Jordanian - New DB Value of 706
- Lebanese - New DB Value of 707
- Moroccan - New DB Value of 708
- Palestinian - New DB Value of 709
- Syrian - New DB Value of 710
- Turkish - New DB Value of 711
- Other Middle Eastern - New DB Value of 712
- Other North African - New DB Value of 713
- Armenian - New DB Value of 801
- Australian - New DB Value of 802
- Basque - New DB Value of 803
- British Isles (UK or Ireland) - New DB Value of 804
- Canadian - New DB Value of 805
- European - New DB Value of 806
- Russian - New DB Value of 807
- Ukrainian - New DB Value of 808
- Other White - New DB Value of 809
In Progress Applications
There will be no database value mappings for In Progress applications. If an application is in-progress and a student selected a race/ethnicity and their choice is in the list of obsolete values post the release, we should display a server side validation error message during the pre-submission validation 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 need to store the new value.
Release Information To Colleges (Updated Oct. 25th 2018)
Backwards Compatibility
If a user has added Race/Ethnicity data on their in-progress application before this update goes live, then the system attempts to map it to data in the new set. However, if the user has un-mappable choices (such as the old "South American" choice now being split out among many individual countries), then the user will receive a validation message upon attempting to submit the application that will direct them back to the Demographic Page to update their Race/Ethnicity choices. This should be fairly seamless to the colleges and should cause no backwards compatibility issues.
New Data Formats
Colleges should be able to continue using their old format file with no issues; however, colleges using a fixed-width output format may need to adjust their race_group column width to account for the way this data is being used now. Originally, this would store the raw data mappings in CSV format for both the Hispanic sections and the other Race Ethnicity choices, so it would download as a format like : "02, 05, 06, 07, 21" and so on. This is now changing to map only the Ethnic Group values, so that will store values such as "100,200,300,500,600,700,800".
The actual data stored in these fields is changing as follows:
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: race_group now stores only the Ethnic Group mappings as CSV content with no spaces, as opposed to the old format which was the raw values for the Ethnicity choices separated by a comma and a space (e.g. "02, 05, 06, 07, 21").
Example Format: "100,200,300,500,600,700,800"
Maximum Expected Width: 30 characters (7 * 3 character long values + 6 commas + 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 (22 character long string)
race_ethnic_full
Notes: race_ethnic_full in a new field that will store the CSV separated values of the subgroups. Colleges will need to add this to their format file and the download client to receive this field.
Example Format: "101,102,203,07,392,394,401,15,503,601,17,701,713,801,809"
Maximum Expected Width: 776 characters (194 * 3 character long values + 192 commas + 2 surrounding quote marks for CSV delimiting in the output format)
Articulating Changes by Section
(Note - corresponds to (01)
Checkboxes
Varying length
Storing actual value
In-progress side, race_group would only save the 02, 03, 04, 05
Submitted side, race_group stored ALL values (hispanic and non-hispanic choices)
Duplicate use of values
Storing the YNX block (YNNNNYN)
Release Information To Colleges
- The system does not store names; maps to numerical values. DB is a text field which has unlimited length. When we store the choice user makes, we save code value - no names are stored.
- Colleges will need to absorb the new options and replace their DLC jar file for the categories added to the response options for the Race & Ethnicity download field(s).
- No changes are needed to the Download client from Unicon's side. Colleges will need to adjust their format file. If a college is using a fix width columns, they may need to adjust based on a student selecting multiple groups and ethnicities.
Backwards Compatibility
If a user has added Race/Ethnicity data on their in-progress application before this update goes live, then those users will receive a validation message upon attempting to submit that will force them to return to the Demographic Page and update their choices. The end user will not be able to submit their application until they have returned to the Demographic Page and saved their updated data. For the colleges, this means there will be a sharp divide between old and new data, and they should not encounter a time when they can expect to receive both formats. So once this update is deployed, then they can immediately switch to whatever process they put into place to accept the new data into their systems.
New Data Formats
From a download client perspective, colleges using a fixed-width output will need to update their format file for the possible output of the new Race Ethnicity selections, and the new usages of the race_group and race_ethnicity fields.
'race_group' used to store the Hispanic Race Group choices, but it would store them in a comma delimited format with the values, such as "02, 03, 04". 'race_ethnicity' stored the chosen values of both the Hispanic and the original Race Ethnicity in a block of values such as "XNNNNNYYYYNN..." with each character denoting the individual checked or unchecked answer in series.
Now, race_group is being re-purposed to store the value of the "super groups" such as Asian, American Indian or Alaska Native etc., and race_ethnicity is storing the values for the "sub groups" of these choices. Colleges will need to be aware of these new uses and adjust how they process this data into the final destination for these submitted applications.
If a college is using a delimited output for their format file, then they should not need to change their format file. While there will be a greater number of values the user can choose, since it is a delimited output it will simply print the values out as it always has between the chosen delimiter.
If the college is using a fixed width output, they will need to adjust their format file to compensate for the new number of values that can possibly be output.
race_group has up to 8 values a user can choose, and is output as "100, 200, 300...(etc.)". The colleges will need to adjust their fixed width output to accept 36 characters for the race_group field (8 values * 3 characters per value + 6 commas + 6 spaces = 36 characters)
race_ethnicity has up to 194 values the user can choose, and is output as "101, 102, 103, 201, 202, 306...(etc.)".
The colleges will need to adjust their fixed width output to accept 966 characters for the race_ethnicity field (194 values * 3 characters each + 192 commas + 192 spaces = 966 characters)
Articulating Changes by Section
Same question language displayed
Changed format from Y/N radio button to a boolean checkbox
Yes / No radio buttons
Boolean Y/N or T/F
(Note - corresponds to (01)
From ‘Are you Hispanic / Latino?’ drop-down menu selection:
This is the original logic: ‘Y’ if ‘Yes’; ‘N’ if ‘No’; otherwise ‘X’
Pertains only to Hispanic / Latino
Checkboxes
Varying length
Storing actual value
In-progress side, race_group would only save the 02, 03, 04, 05
Submitted side, race_group stored ALL values (hispanic and non-hispanic choices)
Checkbox
Duplicate use of values
Storing the YNX block (YNNNNYN)
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 screwed up logic as before (combined use of YN
Below are the OLD/existing Race & Ethnicity field values/specifications (before 6.3.0)
Race/Ethnicity
Data Element:
race_ethnic
Description:
Combination of all responses to Ethnicity and Race questions
Format, Length:
bpchar, 21
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:
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. The race subcategories such as 'Asian: Chinese' and 'Pacific Islander: Hawaiian' are defined by MIS at the Chancellor's Office (data element SB29).
personal_info table
Xap Field:
raceEthnicity
Revision Log:
~~
Char
Race/Ethnicity
Values
1
Hispanic, Latino
From ‘Are you Hispanic / Latino?’ drop-down menu selection:
‘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
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’
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
Allows Null:
No
Default:
None
Usage:
This element and ‘race_group’ are used to derive ‘race_ethnic’, which is used for MIS 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.
personal_info table
Xap Field:
hispanicLatino
Revision Log:
~~
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.
Hispanic - A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race.
Response Options:
Yes No
(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:
personal_info: hispanic
Also used for part of personal_info: race_ethnic, which correlates to MIS SB29.
Race Group
Data Element:
race_group
Description:
Combination of all responses to Ethnicity and Race questions except ‘Are you Hispanic or
Latino?’
Format, Length:
varchar, 78
Database currently has ‘text, 2147483647’
Values:
String of codes indicating all checkboxes that are checked, delimited by comma and space between each code. Codes are:
02 = Mexican, Mexican-American, Chicano
03 = Central American
04 = South American
05 = Hispanic Other
06 = Asian Indian
07 = Asian Chinese
08 = Asian Japanese
09 = Asian Korean
10 = Asian Laotian
11 = Asian Cambodian
Allows Null:
No
Default:
None
Usage:
This element and ‘hispanic’ are used to derive ‘race_ethnic’, which is used for MIS 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. The race subcategories such as 'Asian: Chinese' and 'Pacific Islander: Hawaiian' are defined by MIS at the Chancellor's Office (data element SB29).
personal_info table
Xap Field:
raceGroup
Revision Log:
~~
Question Text:
What is your race? Check one or more:
[checkbox] Asian: Indian [checkbox] Asian: Chinese [checkbox] Asian: Japanese [checkbox] Asian: Korean [checkbox] Asian: Laotian [checkbox] Asian: Cambodian [checkbox] Asian: Vietnamese [checkbox] Asian: Filipino [checkbox] Asian: Other
[checkbox] Black or African American [checkbox] American Indian / Alaskan Native
[checkbox] Pacific Islander: Guamanian [checkbox] Pacific Islander: Hawaiian [checkbox]
Pacific Islander: Samoan [checkbox] Pacific Islander: Other [checkbox] White
Conditions:
Always
Additional Text:
Asian -- A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian Subcontinent.
Black or African American -- A person having origins in any of the black racial groups of Africa.
American Indian / Alaskan Native -- A person having origins in any of the original peoples of North and South America (including Central America) who maintains cultural identification through tribal affiliation or community attachment.
Pacific Islander -- A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.
White -- A person having origins in any of the original peoples of Europe, the Middle East, or North Africa.
Response Options:
Any combination of checkboxes can be checked, from none to all.
Pop-Up Help:
Field Error Check:
None
Page Error Check:
None; optional response per IPEDS and CCCCO.
Notes:
See note for Hispanic/Latino (previous table).
Data Element:
personal_info: race_group
Also used for part of personal_info: race_ethnic, which correlates to MIS SB29Request 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. 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 in CCCApply and make that data available via the statewide MIS.
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 InformationThe proposal was favorably reviewed and approved for adoption by the Chancellor’s Office Data, Evaluation and Research (CODER) group, which includes representatives from MIS and research units as well as other stakeholders from the RP Group, Education Results Partnership, and the Workforce and Economic Development Division of the Chancellor’s Office. |
Additional Information
Ethnicity/Ancestry Expansion Proposal
This proposal is 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 currently 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 given limited high level categories to choose from. The original implementation, which aligns to historic MIS requirements, has not been updated in many years and the data sets do not include all ethnic groups that are relevant for the diverse and distinct communities served by the 115 California community colleges.
Current Race & Ethnicity Section - 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?’ |
General Requirements
In addition to the requirements expressed in the Ethnicity-Ancestry Expansion Proposal, it was also important that these changes incur no impact on the colleges, particularly with regards to their existing MIS reporting processes.
Objectives:
Backward Compatibility - No change to existing 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: Ensure that the Race Ethnicity field <race_ethnic> specifically is unchanged; this is the field that most closely aligns to the MIS requirement (SB29).
Optional New Data Field: Ensure that all new data values, including new race groups & ethnicities are collected in one new field that colleges can choose if and when to add to their downloads or not;
Mock Up & 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 Screenshot
Proposed Functional Mock Up 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
Zoom Demo: New Race & Ethnicity Layout
Info |
---|
New UI Layout DemoNew Race & Ethnicity Changes - User Interface Demo Zoom recording: New Race & Ethnicity User Interface Layout - Recorded Zoom Demo |
Change Specifications: Layout & 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 section on the "Demographic Information" page. This did not change from the original (legacy) layout.
Hispanic/Latino Section
The following 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."
Note |
---|
Table Legend Race Group Name: This column depicts both new and legacy race group names |
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?"
Race Group Name | Legacy Race Group Value | New Race Group Value | New Race Ethnicity Full - Name & Value | Mapping Notes |
---|---|---|---|---|
Hispanic, Latino | 01 | 100 | Response to question "Are you Hispanic or Latino?" = 100 | The Hispanic/Latino question remains unchanged and the Y/N/X response value is still mapped to the first character in Race Ethnicity <race_ethnic> response |
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.
Note |
---|
Table Legend Race Group Name: This column depicts both new and legacy race group names |
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.
Race Group Name | Legacy Race Group Value | New Race | New Race Ethnicity Full - Name & Value |
---|---|---|---|
Asian | 06 | 200 | 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 |
Asian: Chinese | 07 | Chinese - (Stays as 07) | |
Asian: Japanese | 08 | Japanese - (Stays as 08) | |
Asian: Korean | 09 | Korean - (Stays as 09) | |
Asian: Laotian | 10 | Laotian - (Stays as 10) | |
Asian: Cambodian | 11 | Cambodian - (Stays as 11) | |
Asian: Vietnamese | 12 | Vietnamese - (Stays as 12) | |
Asian: Filipino | 13 | Filipino - (Stays as 13) | |
Asian: Other | 14 | Hmong - New DB Value of 204 Indonesian - New DB Value of 205 Taiwanese - New DB Value of 208 Thai - New DB Value of 209 Other Asian - (Stays as 14) | |
American Indian or Alaska Native All new American Indians and Alaskan Native ethnicity sub-groups should map back to legacy American Indian / Alaskan Native value of 16. | 16 | 300 | Agua Caliente Band of Cahuilla Indians of the Agua Caliente Indian Reservation - New Value of 301 Alturas Indian Rancheria - New DB Value of 302 Augustine Band of Cahuilla Indians - New DB Value of 303 Aztec or Mixtec - New DB Value of 304 Bear River Band of the Rohnerville Rancheria - New DB Value of 305 Berry Creek Rancheria of Maidu Indians of California - New DB Value of 306 Big Lagoon Rancheria - New DB Value of 307 Big Pine Band Paiute Tribe of the Owens Valley - New DB Value of 308 Big Sandy Rancheria of Western Mono Indians of California - New DB Value of 309 Big Valley Band of Pomo Indians of the Big Valley Rancheria - New DB Value of 310 Bishop Pauite Tribe (previously listed as Paiute-Shoshone Indians of the Bishop Community of the Bishop Colony) - New DB Value of 311 Blue Lake Rancheria - New DB Value of 312 Bridgeport Indian Colony - New DB Value of 313 Buena Vista Rancheria of Me-Wuk Indians of California - New DB Value of 314 Cabazon Band of Mission Indians - New DB Value of 315 Cachil DeHe Band of Wintun Indians of the Colusa Indian Community of the Colusa Rancheria - New DB Value of 316 Cahuilla Band of Mission Indians of the Cahuilla Reservation - New DB Value of 317 Cahto Indian Tribe of the Laytonville Rancheria - New DB Value of 318 California Valley Miwok Tribe - New DB Value of 319 Campo Band of Diegueño Mission Indians of the Campo Indian Reservation - New DB Value of 320 Capitan Grande Band of Diegueño Mission Indians of California:Barona Group of Capitan Grande Band of Mission Indians of the Barona Reservation; Viejas (Baron Long) Group of Capitan Grande Band of Mission Indians of the Viejas Reservation - New DB Value of 321 Cedarville Rancheria - New DB Value of 322 Chemehuevi Indian Tribe of the Chemehuevi Reservation - New DB Value of 323 Cher-Ae Heights Indian Community of the Trinidad Rancheria - New DB Value of 324 Cherokee - New DB Value of 325 Chicken Ranch Rancheria of Me-Wuk Indians of California - New DB Value of 326 Chippewa - New DB Value of 327 Cloverdale Rancheria of Pomo Indians of California - New DB Value of 328 Cold Springs Rancheria of Mono Indians of California - New DB Value of 329 Colorado River Indian Tribes of the Colorado River Indian Reservation (Arizona and California) - New DB Value of 330 Cortina Indian Rancheria of Wintun Indians of California - New DB Value of 331 Coyote Valley Band of Pomo Indians of California - New DB Value of 332 Death Valley Timbi-Sha Shoshone Tribe - New DB Value of 333 Dry Creek Rancheria of Pomo Indians - New DB Value of 334 Elem Indian Colony of Pomo Indians of the Sulphur Bank Rancheria - New DB Value of 335 Elk Valley Rancheria - New DB Value of 336 Enterprise Rancheria of Maidu Indians of California - New DB Value of 337 Ewiiaapaayp Band of Kumeyaay Indians - New DB Value of 338 Federated Indians of Graton Rancheria - New DB Value of 339 Fort Bidwell Indian Community of the Fort Bidwell Reservation of California - New DB Value of 340 Fort Independence Indian Community of Paiute Indians of the Fort Independence Reservation - New DB Value of 341 Fort Mojave Indian Tribe (Arizona, California and Nevada) - New DB Value of 342 Greenville Rancheria - New DB Value of 343 Grindstone Indian Rancheria of Wintun-Wailaki Indians of California - New DB Value of 344 Guidiville Rancheria of California - New DB Value of 345 Habematolel Pomo of Upper Lake - New DB Value of 346 Hoopa Valley Tribe - New DB Value of 347 Hopland Band of Pomo Indians - New DB Value of 348 Inaja Band of Diegueño Mission Indians of the Inaja and Cosmit Reservation - New DB Value of 349 Ione Band of Miwok Indians of California - New DB Value of 350 Jackson Band of Miwuk Indians - New DB Value of 351 Jamul Indian Village of California - New DB Value of 352 Karuk Tribe - New DB Value of 353 Kashia Band of Pomo Indians of the Stewart’s Point Rancheria - New DB Value of 354 Koi Nation of Northern California - New DB Value of 355 La Jolla Band of Luiseño Indians - New DB Value of 356 La Posta Band of Diegueño Mission Indians of the La Posta Indian Reservation - New DB Value of 357 Lone Pine Paiute-Shoshone Tribe - New DB Value of 358 Los Coyotes Band of Cahuilla & Cupeno Indians - New DB Value of 359 Lytton Rancheria of California - New DB Value of 360 Manchester Band of Pomo Indians of the Manchester Rancheria - New DB Value of 361 Manzanita Band of Diegueño Mission Indians of the Manzanita Reservation - New DB Value of 362 Mechoopda Indian Tribe of Chico Rancheria - New DB Value of 363 Mesa Grande Band of Diegueño Mission Indians of the Mesa Grande Reservation - New DB Value of 364 Middletown Rancheria of Pomo Indians of California - New DB Value of 365 Mooretown Rancheria of Maidu Indians of California - New DB Value of 366 Morongo Band of Cahuilla Mission Indians - New DB Value of 367 Navajo - New DB Value of 368 Northfork Rancheria of Mono Indians of California - New DB Value of 369 Pala Band of Luiseño Mission Indians of the Pala Reservation - New DB Value of 370 Paskenta Band of Nomlaki Indians of California - New DB Value of 371 Pauma Band of Luiseño Mission Indians of the Pauma & Yuima Reservation - New DB Value of 372 Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation - New DB Value of 373 Picayune Rancheria of Chukchansi Indians of California - New DB Value of 374 Pinoleville Pomo Nation (formerly the Pinoleville Rancheria of Pomo Indians of California) - New DB Value of 375 Pit River Tribe (includes XL Ranch, Big Bend, Likely, Lookout, Montgomery Creek and Roaring Creek Rancherias) - New DB Value of 376 Potter Valley Tribe (formerly the Potter Valley Rancheria of Pomo Indians of California) - New DB Value of 377 Quartz Valley Indian Community of the Quartz Valley Reservation of California - New DB Value of 378 Quechan Tribe of the Fort Yuma Indian Reservation (Arizona and California) - New DB Value of 379 Ramona Band of Cahuilla - New DB Value of 380 Redding Rancheria - New DB Value of 381 Redwood Valley or Little River Band of Pomo Indians of the Redwood Valley Rancheria California - New DB Value of 382 Resighini Rancheria - New DB Value of 383 Rincon Band of Luiseño Mission Indians of the Rincon Reservation - New DB Value of 384 Robinson Rancheria - New DB Value of 385 Round Valley Indian Tribes, Round Valley Reservation - New DB Value of 386 San Manual Band of Serrano Mission Indians of the San Maual Reservation - New DB Value of 387 San Pasqual Band of Diegueño Mission Indians of California - New DB Value of 388 Santa Rosa Indian Community of the Santa Rosa Rancheria - New DB Value of 389 Santa Rosa Band of Cahuilla Indians (formerly the Santa Rosa Band of Cahuilla Mission) - New DB Value of 390 Santa Ynez Band of Chumash Mission Indians of the Santa Ynez Reservation - New DB Value of 391 Lipay Nation of Santa Ysabel (Previously listed as the Santa Ysabel Band of Diegueño Mission Indians) - New DB Value of 392 Scotts Valley Band of Pomo Indians of California - New DB Value of 393 Sheep Ranch Rancheria of Me-Wuk Indians - New DB Value of 394 Sherwood Valley Rancheria of Pomo Indians of California - New DB Value of 395 Shingle Springs Band of Miwok Indians, Shingle Springs Rancheria (Verona Tract) - New DB Value of 396 Sioux - New DB Value of 397 Soboba Band of Luiseño Indians - New DB Value of 398 Susanville Indian Rancheria - New DB Value of 399 Sycuan Band of the Kumeyaay Nation (formerly the Sycuan Band of Diegueno Mission Indians of California) - New DB Value of 401 Table Mountain Rancheria of California - New DB Value of 402 Tejon Indian Tribe - New DB Value of 403 Tolowa Dee-ni' Nation - New DB Value of 404 Torres-Martinez Desert Cahuilla Indians - New DB Value of 405 Tule River Indian Tribe of the Tule River Reservation - New DB Value of 406 Tuolumne Band of Me-Wuk Indians of the Tuolumne Rancheria of California - New DB Value of 407 Twenty-Nine Palms Band of Mission Indians of California - New DB Value of 408 United Auburn Indian Community of the Auburn Rancheria of California - New DB Value of 409 Upper Lake Band of Pomo Indians - New DB Value of 410 Utu Utu Gwaitu Paiute Tribe of the Benton Paiute Reservation - New DB Value of 411 Washoe Tribe (Carson Colony, Dresslerville Colony, Woodfords Comm., Stewart Comm. and Washoe Ranches CA & NV) - New DB Value of 412 Wilton Rancheria - New DB Value of 413 Wiyot Tribe (formerly the Table Bluff Reservation-Wiyot Tribe) - New DB Value of 414 Yocha Dehe Wintun Nation - New DB Value of 415 Yurok Tribe of the Yurok Reservation - New DB Value of 416 Zapotec - New DB Value of 417 Other American Indian - New DB Value of 418 Other Alaska Native - New DB Value of 419 |
Black or African American All Black or African American ethnicity subgroups should map back to Black or African American which has a current DB value of 15. | 15 | 500 | African American - Stays as 15 Subsaharan African: Ethiopian - New DB Value of 501 Subsaharan African: Kenyan - New DB Value of 502 Subsaharan African: Nigerian - New DB Value of 503 Subsaharan African: Somali - New DB Value of 504 Subsaharan African: South African - New DB Value of 505 Subsaharan African: Other Subsaharan African - New DB Value of 506 West Indian: Belizean - New DB Value of 507 West Indian: Haitian - New DB Value of 508 West Indian: Jamaican - New DB Value of 509 West Indian: Other West Indian - New DB Value of 510 |
Native Hawaiian or Other Pacific Islander | 600 | ||
Pacific Islander: Other | 20 | Fijian - New DB Value of 601 Other Pacific Islander - Stays as 20 | |
Pacific Islander: Guamanian | 17 | Guamanian or Chamorro - Stays as 17 | |
Pacific Islander: Hawaiian | 18 | Native Hawaiian - Stays as 18 | |
Pacific Islander: Samoan | 19 |
| |
Middle Eastern or North African Middle Eastern or North African is a NEW Race Group value - was not in the legacy section. Therefore, all responses in this section roll up to "White" = 21 All Middle Eastern or North African ethnicity subgroups should map back to DB value of 21. | 700 | Assyrian, Syriac or Chaldean - New DB Value of 701 Egyptian - New DB Value of 702 Iranian or Persian - New DB Value of 703 Iraqi - New DB Value of 704 Israeli - New DB Value of 705 Jordanian - New DB Value of 706 Lebanese - New DB Value of 707 Moroccan - New DB Value of 708 Palestinian - New DB Value of 709 Syrian - New DB Value of 710 Turkish - New DB Value of 711 Other Middle Eastern - New DB Value of 712 Other North African - New DB Value of 713 | |
White All White ethnicity subgroups map back to DB value of 21. | 21 | 800 | Armenian - New DB Value of 801 Australian - New DB Value of 802 Basque - New DB Value of 803 British Isles (UK or Ireland) - New DB Value of 804 Canadian - New DB Value of 805 European - New DB Value of 806 Russian - New DB Value of 807 Ukrainian - New DB Value of 808 Other White - New DB Value of 809 |
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 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
Data Element: <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
Data Element: <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 Ethnicity
Data Element: <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 Ethnicity Full
Data Element: <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 GLUE, the new race_ethnic_full data element is called "raceEthnicFull"
Note |
---|
The new Race & Ethnicity values included in this release will be passed directly to colleges using the Glue for Apply feature. However, the new full Race & Ethnicity field is not yet available through Glue for Apply at this time. An upcoming release of the SuperGlue College Adaptor will include this new data. |
Changes by Section
Section | Field | Legacy Implementation | Legacy 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 | None | None | Nothing, No Change |
Race Group | race_group | Pertains only to Hispanic / Latino | 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) |
Reference: MIS Data Elements
MIS Data Element | MIS Derived Data Element | ||||||||
---|---|---|---|---|---|---|---|---|---|
SB29 - Multi-Ethnicity | STD10 - Student -Ethnicity (Derived Data Element) | ||||||||
|
|
Updated Data Dictionary Tables
Race/Ethnicity
Data Element: | race_ethnic (CCCApply Standard) race_ethnicity (International) | |
Description: | Combination of responses to legacy Hispanic/Latino question and ethnicities, and all original race groups and ethnicity values only, as per MIS (SB29) reporting requirements. | |
Format, Length: | bpchar, 22 No changes were made to this format (2018), it was intentionally left unchanged. Null is allowed in first character position to represent Hispanic/Latino question response. Example Format: XNYNNNNYNNNNNNNNNYNNN Maximum Expected Width: 22 characters (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. 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 2018 implementation will map back to the original values specified by MIS at the Chancellor's Office (data element SB29). Note: Regarding new Race & Ethnicity implementation 2018 (v.6.3.0), colleges should continue to use this field as it was originally formatted to comply with the legacy MIS SB29 reporting requirements 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> | |
Revision Log: | Layout revised in December 2018. Data values and format intentionally left unchanged. | |
Char | Race/Ethnicity | Values |
1 | Hispanic, Latino | ‘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’ |
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 ‘hispanic’ 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. | |
Revision Log: | Layout revised in December 2018. Data values and format intentionally left unchanged. |
Onscreen 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 or 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 Group
Data Element: | race_group |
Description: | Legacy data field indicating the combination of original (pre-2018) Race Group (categories) and Ethnicity (subcategories) responses to all questions except ‘Are you Hispanic or Latino?’ |
Format, Length: | Varchar, 80 characters (unchanged) (20 * 2 character long values + 19 commas + 19 spaces + 2 surrounding quote marks for CSV delimiting in the output format) Database stores as text string Example Format: "04, 05, 08, 09, 14, 15, 17, 19, 20, 21"
Notes: No changes, this field was intentionally left unchanged |
Values: | String of combined original (pre-2018) codes are stored only, delimited by comma and spaces between each code. |
In order to keep this field unchanged from its original format (pre-2018) ONLY the original race and ethnicities values are stored in this field in the database. | |
Allows Null: | Yes |
Default: | None |
Usage: | This data element continues to store the original (legacy) race and ethnicity values only, including Hispanic/Latino, for compliance with historical MIS reporting requirements. No changes made during the 2018 implementation; this field was intentionally left unchanged. |
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. |
Revision Log: | Layout revised in December 2018. Data values and format intentionally left unchanged. |
2018 Onscreen Question Text Only: | "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 Stored Only: | Any combination of the following (legacy) checkboxes can be checked, from none to all. Mexican, Mexican-American, Chicano (2018: displayed as subcategory under Hispanic/Latino) Central American (2018: displayed as subcategory under Hispanic/Latino) South American (2018: displayed as subcategory under Hispanic/Latino) Hispanic Other (2018: displayed as subcategory under Hispanic/Latino) Asian Indian (2018: displayed as subcategory under Asian race group) Asian Chinese (2018: displayed as subcategory under Asian race group) Asian Japanese (2018: displayed as subcategory under Asian race group) Asian Korean (2018: displayed as subcategory under Asian race group) Asian Laotian (2018: displayed as subcategory under Asian race group) Asian Cambodian (2018: displayed as subcategory under Asian race group) Asian: Vietnamese (2018: displayed as subcategory under Asian race group) Asian: Filipino (2018: displayed as subcategory under Asian race group) Asian: Other (2018: displayed as subcategory under Asian race group) Black or African American (2018: displayed as same race group category) American Indian / Alaskan Native (2018: displayed as same race group category) Pacific Islander: Guamanian (2018: displayed as subcategory under Native Hawaiian or Other Pacific Islander) Pacific Islander: Hawaiian (2018: displayed as subcategory under Native Hawaiian or Other Pacific Islander) Pacific Islander: Samoan (2018: displayed as subcategory under Native Hawaiian or Other Pacific Islander) Pacific Islander: Other (2018: displayed as subcategory under Native Hawaiian or Other Pacific Islander) White (2018: displayed as same race group category) |
Field Error Check: | None |
Page Error Check: | None; optional response per IPEDS and CCCCO. |
Notes: | This field left intentionally unchanged (2018). See note for Hispanic/Latino (previous table). |
Data Element: | race_group |
Race & Ethnicity Full
Data Element: | race_ethnic_full |
Description: | New data field added in 2018 to collect full combination of all responses of all new race groups and ethnicities (subcategories) values in 2018 implementation. |
Format, Length: | Stores CSV separated values of all selected onscreen checkbox responses of new 2018 race groups (categories) and ethnicities (subcategories). Maximum Expected Width: 805 characters (201 * 3 character long values + 200 commas + 2 surrounding quote marks for CSV delimiting in the output format)
|
Values: | String of all new 2018 expanded race group and ethnicity-ancestry checkbox values that are checked, delimited by commas with no spaces between each code. See table breakdown of full 2018 race & ethnicity names and values below. |
Allows Null: | Yes |
Default: | None |
Usage: | New data field added in 2018 to collect full combination of all responses of all new race groups and ethnicities (subcategories) values added in Ethnicity-Ancestry Expansion of 2018. Does not align to current MIS data elements. Used for research and student equity purposes. |
Onscreen 2018 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: | See full list of 2018 race group (categories) and ethnicity-ancestry (sub-categories) checkboxes / response options in table below. There are a total of 194 possible values for the data field. Any combination of checkboxes can be checked, from none to all. |
Field Error Check: | None |
Page Error Check: | None; optional response per IPEDS and CCCCO. |
Legal 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. New data field added to collect all new race groups (categories) and ethnicities (subcategories) as part of the Ethnicity-Ancestry Expansion of 2018. |
Field Notes: | 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. |
Revision Log: | New 12.07.18 (v.6.3.0) |
Data Element: | race_ethnic_full |
Table: Breakdown of Race & Ethnicity Full Names and Values
Legacy Race Group Names (race_group) | Legacy Race Group Values | New Race Group Values in Race Ethnicity FULL | NEW Ethnicity Names & Values |
Hispanic or Latino | 01 | 100 | |
Mexican, Mexican-American, Chicano | 02 | Mexican - New value = 111 | |
Central American | 03 | Costa Rican - New value = 105 Guatemalan - New value = 109 Honduran - New value = 110 Nicaraguan - New value = 112 Panamanian - New value = 113 Salvadoran - New value = 116 | |
South American | 04 | Argentinean - New value = 101 Bolivian - New value = 102 Chilean - New value = 103 Colombian - New value = 104 Ecuadorian - New value = 108 Peruvian - New value = 114 Venezuelan - New value = 118 | |
Hispanic, Other | 05 | Cuban - New value = 106 (Dominican Republic) - New value = 107 Puerto Rican - New value = 115 Spanish - New value = 117 Other Hispanic / Latino - New value = 119 | |
Asian | 200 | (This is a new Race Group) | |
Asian: Indian | 06 | Afghan - New value = 201 Bangladeshi - New value = 202 Burmese/Myanmar - New value = 203 Indian – (Stays = 06) Pakistani - New value = 206 Sri Lankan - New value = 207 | |
Asian: Chinese | 07 | Chinese - (Stays = 07) | |
Asian: Japanese | 08 | Japanese - (Stays = 08) | |
Asian: Korean | 09 | Korean - (Stays = 09) | |
Asian: Laotian | 10 | Laotian - (Stays = 10) | |
Asian: Cambodian | 11 | Cambodian - (Stays = 11) | |
Asian: Vietnamese | 12 | Vietnamese - (Stays = 12) | |
Asian: Filipino | 13 | Filipino - (Stays = 13) | |
Asian: Other | 14 | Hmong - New value = 204 Indonesian - New value = 205 Other Asian - (Stays = 14) Taiwanese - New value = 208 | |
American Indian | 16 | 300 | |
All of the Native American Indian / Alaskan Native Tribes & Nations will map back to value = "16" | Agua Caliente Band of Cahuilla Indians - New value = 301 Alturas Indian Rancheria - New value = 302 Augustine of Cahuilla - New value = 303 Aztec or Mixtec - New value = 304 Bear River Rohnerville - New value = 305 Berry Creek Ranch Maidu - New value = 306 Big Lagoon Rancheria - New value = 307 Big Pine Band Paiute - New value = 308 Big Sandy Rancheria - New value = 309 Big Valley Pomo Indians - New value = 310 Bishop Pauite Tribe - New value = 311 Blue Lake Rancheria - New value = 312 Bridgeport Indian Colony - New value = 313 Buena Vista of Me-Wuk - New value = 314 Cabazon Band Indians - New value = 315 Cachil DeHe Band of Wintun Indians - New value = 316 Cahuilla Band of Mission Indians - New value = 317 Cahto Indian Tribe Laytonville Rancheria - New value = 318 California Valley Miwok Tribe - New value = 319 Campo Band of Diegueño Mission Indians - New value = 320 Capitan Grande of Diegueño Mission - New value = 321 Cedarville Rancheria - New value = 322 Chemehuevi Indian Tribe Reservation - New value = 323 Cher-Ae Heights Indian Trinidad Rancheria - New value = 324 Cherokee - New value = 325 Chicken Ranch Rancheria of Me-Wuk - New value = 326 Chippewa - New value = 327 Cloverdale Rancheria of Pomo of California - New value = 328 Cold Springs of Mono Indians of California - New value = 329 Colorado River Indian Tribes (AZ and CA) - New value = 330 Cortina Indian Ranch of Wintun Indians - New value = 331 Coyote Valley Band of Pomo Indians of CA - New value = 332 Death Valley Timbi-Sha Shoshone Tribe - New value = 333 Dry Creek Rancheria of Pomo Indians - New value = 334 Elem Indian Colony of Pomo Sulphur Bank - New value = 335 Elk Valley Rancheria - New value = 336 Enterprise Rancheria of Maidu of Calif - New value = 337 Ewiiaapaayp Band of Kumeyaay Indians - New value = 338 Federated Indians of Graton Rancheria - New value = 339 Fort Bidwell Indian Community of CA – New value = 340 Ft Independence Indian Comm of Paiute - New value = 341 Fort Mojave Indian Tribe (AZ, CA, and NV) - New value = 342 Greenville Rancheria - New value = 343 Grindstone Indians Wintun-Wailaki of CA - New value = 344 Guidiville Rancheria of California - New value = 345 Habematolel Pomo of Upper Lake - New value = 346 Hoopa Valley Tribe - New value = 347 Hopland Band of Pomo Indians - New value = 348 Inaja Band of Diegueño Mission - New value = 349 Ione Band of Miwok Indians of California - New value = 350 Jackson Band of Miwuk Indians - New value = 351 Jamul Indian Village of California - New value = 352 Karuk Tribe - New value = 353 Kashia Band of Pomo of Stewart’s Point - New value = 354 Koi Nation of Northern California - New value = 355 La Jolla Band of Luiseño Indians - New value = 356 La Posta Band of Diegueño Mission - New value = 357 Lone Pine Paiute-Shoshone Tribe - New value = 358 Los Coyotes of Cahuilla & Cupeno Indians - New value = 359 Lytton Rancheria of California - New value = 360 Manchester Band of Pomo Indians - New value = 361 Manzanita Band of Diegueño Mission - New value = 362 Mechoopda Indian Tribe of Chico - New value = 363 Mesa Grande Band of Diegueño Mission - New value = 364 Middletown Rancheria of Pomo Indians CA - New value = 365 Mooretown Rancheria of Maidu Indians - New value = 366 Morongo Band of Cahuilla Mission Indians - New value = 367 Navajo - New value = 368 Northfork Rancheria of Mono Indians - New value = 369 Pala Band of Luiseño Mission Indians - New value = 370 Paskenta Band of Nomlaki Indians of CA - New value = 371 Pauma Band of Luiseño Mission Indians - New value = 372 Pechanga Band of Luiseño Mission Indians - New value = 373 Picayune Rancheria of Chukchansi Indians - New value = 374 Pinoleville Pomo Nation - New value = 375 Pit River Tribe - New value = 376 Potter Valley Tribe - New value = 377 Quartz Valley Indian Community - New value = 378 Quechan Tribe of the Fort Yuma Indian - New value = 379 Ramona Band of Cahuilla - New value = 380 Redding Rancheria - New value = 381 Redwood Valley Little River Band of Pomo - New value = 382 Resighini Rancheria - New value = 383 Rincon Band of Luiseño Mission Indians - New value = 384 Robinson Rancheria - New value = 385 Round Valley Indian Tribes, Round Valley - New value = 386 San Manual Band Serrano Mission Indians - New value = 387 San Pasqual Band of Diegueño Mission - New value = 388 Santa Rosa Indian Community - New value = 389 Santa Rosa Band of Cahuilla Indians) - New value = 390 Santa Ynez Band of Chumash Mission - New value = 391 Lipay Nation of Santa Ysabel - New value = 392 Scotts Valley Band of Pomo Indians of CA - New value = 393 Sheep Ranch of Me-Wuk Indians - New value = 394 Sherwood Valley Rancheria of Pomo - New value = 395 Shingle Springs Band of Miwok Indians - New value = 396 Sioux - New value = 397 Soboba Band of Luiseño Indians - New value = 398 Susanville Indian Rancheria - New value = 399 Sycuan Band of the Kumeyaay Nation - New value = 401 Table Mountain Rancheria of California - New value = 402 Tejon Indian Tribe - New value = 403 Tolowa Dee-ni' Nation - New value = 404 Torres-Martinez Desert Cahuilla Indians - New value = 405 Tule River Indian Tribe of the Tule River - New value = 406 Tuolumne Band of Me-Wuk Indians - New value = 407 Twenty-Nine Palms Band of Mission - New value = 408 United Auburn Indian of the Auburn - New value = 409 Upper Lake Band of Pomo Indians - New value = 410 Utu Utu Gwaitu Paiute Tribe Benton Paiute - New value = 411 Washoe Tribe ((California and Nevada) - New value = 412 Wilton Rancheria - New value = 413 Wiyot Tribe (formerly the Table Bluff) - New value = 414 Yocha Dehe Wintun Nation - New value = 415 Yurok Tribe of the Yurok Reservation - New value = 416 Zapotec - New value = 417 Other American Indian - New value = 418 | ||
Black or African American | 15 | 500 | |
Note: All of the following ethnicity responses will map back to the legacy value for "Black or African American" = 15 | 15 | African American - (Stays = 15) Subsaharan African: Ethiopian - New value = 501 Subsaharan African: Kenyan - New value = 502 Subsaharan African: Nigerian - New value = 503 Subsaharan African: Somali - New value = 504 Subsaharan African: South African - New value = 505 Subsaharan African: Other Subsaharan - New value = 506 West Indian: Belizean - New value = 507 West Indian: Haitian - New value = 508 West Indian: Jamaican - New value = 509 | |
Native Hawaiian or | 600 | (This is a new Race Group) | |
Pacific Islander: Guamanian | 17 | Guamanian or Chamorro - (Stays = 17) | |
Pacific Islander: Hawaiian | 18 | Native Hawaiian - (Stays = 18) | |
Pacific Islander: Samoan | 19 | Samoan - (Stays = 19) Tongan - New value = 602 | |
Pacific Islander: Other | 20 | Fijian - New value = 601 Other Pacific Islander - (Stays = 20) | |
Middle Eastern or North African | 700 | (This is a new Race Group) | |
Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 21 | Assyrian, Syriac or Chaldean - New value = 701 Egyptian - New value = 702 Iranian or Persian - New value = 703 Iraqi - New value = 704 Israeli - New value = 705 Jordanian - New value = 706 Lebanese - New value = 707 Moroccan - New value = 708 Palestinian - New value = 709 Syrian - New value = 710 Turkish - New value = 711 Other Middle Eastern - New value = 712 Other North African - New value = 713 | ||
White | 21 | 800 | |
Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 21 | Armenian - New value = 801 Australian - New value = 802 Basque - New value = 803 British Isles (UK or Ireland) - New value = 804 Canadian - New value = 805 European - New value = 806 Russian - New value = 807 Ukrainian - New value = 808 Other White - New value = 809 |