Request No. 2018-18Date of RequestApril 26, 2018 RequesterCCCCO / Craig Hayward Application(s)CCCApply Standard / InternationalSection / Page

Race & Ethnicity / Demographic Information

Steering Hearing DateTBD Proposed Change to Download FileSee Notes Proposed Change to Residency LogicN/A

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

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 Information: https://www.diffen.com/difference/Ethnicity_vs_Race

Supporting Documentation

Ethnicity/Ancestry Expansion Proposal

Ethnicity-Ancestry Expansion Proposal Digest-Draft v 1.4.docx

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

title	Click here to read Article 1.5. Student Equity Plans 78220....

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)

Image Removed

International Application Today

(before new Race & Ethnicity implementation - 6.3.0)

Image Removed

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

name	Ancestry proposal 2.43.xlsx
height	400

Zoom Demo

Info

title	New UI Layout Demo

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

Image Removed

New Hispanic Question & Race Groups - Auto-populated

Image Removed

New Hispanic Question Expanded

Image Removed

New Groups Expanded

Image Removed

More Groups Expanded

Image Removed

Specifications for the New Layout Design and Database Values

Section 1: Hispanic/Latino Section

Similar to the current version, the new Race & Ethnicity implementation layout has two sections: 1) The 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.

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

Race Group (race_group)Legacy Race Ethnicity Value / MappingNEW Associated Ethnicities Subgroups ValuesNotesHispanic or Latino - New DB Value of 10001

100 = New DB Value

‘Are you Hispanic / Latino?’

Select Yes to open the sub-categories of Hispanic / Latino ethnicities.

Mexican, Mexican-American, Chicano02

Mexican - New DB Value of 111 (Per Craig Hayward 7.19.18, keep this mapped to existing value 02.)

Central American03

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

South American04

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, Bakersfield College - Brazil is intentionally omitted from this implementation.

Hispanic, Other05

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

Section 2: Race Ethnicities

Below the Hispanic/Latino section, the following instructive text is displayed and a set of high-level Race Groups with checkboxes are displayed.

"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 & Ethnicity 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 Groups (race_group)Current (Legacy) Value MappingNEW Associated Ethnicities/Nations Subgroups (race_ethnicity) ValuesNotes

Asian

200 - - New DB Value of 200Asian: Indian06

Afghan - New DB Value of 201
Bangladeshi - New DB Value of 202
Burmese/Myanmar - New DB Value of 203
~~East~~ Indian (Remove "East" and leave it mapped to original "06")
Pakistani - New DB Value of 206
Sri Lankan - New DB Value of 207

Note: All of the following Asian: Indian ethnicity responses from this group will map back to the legacy value for "Asian: Indian" = 06Asian: Chinese07

Chinese - (Stays as 07)

Asian: Japanese08

Japanese - (Stays as 08)

Asian: Korean09

Korean - (Stays as 09)

Asian: Laotian10

Laotian - (Stays as 10)

Asian: Cambodian11

Cambodian - (Stays as 11)

Asian: Vietnamese12

Vietnamese - (Stays as 12)

Asian: Filipino13

Filipino - (Stays as 13)

Asian: Other14

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

American Indian or Alaska Native 300 -- New DB Value of 300

NOTE: All of the following Native American Indian / Alaskan Native nations responses will map back to the legacy database value = "16"

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 the following Native American Indian / Alaskan Native nations responses will map back to the legacy database value = "16"Black or African American 15500 -- New DB Value of 500

Note: All of the following ethnicity responses will map back to the legacy value for "Black or AfricanAmerican" = 15

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

Note: All of the following ethnicity responses will map back to the legacy value for "Black or AfricanAmerican" = 15Native Hawaiian or Other Pacific Islander 600 - - New DB Value of 600

Pacific Islander: Guamanian

17

Guamanian or Chamorro - Stays as 17

Pacific Islander: Hawaiian18

Native Hawaiian - Stays as 18

Pacific Islander: Samoan19

Samoan - Stays as 19
Tongan - New DB Value of 602

Pacific Islander: Other20

Fijian - New DB Value of 601
Other Pacific Islander - Stays as 20

Middle Eastern or North African700 - - New DB Value of 700

Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 21

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

Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 21White800 - - New DB Value of 800Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 2121

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

Note: All of these new ethnicity responses will be mapped to the legacy value for "White" = 21

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.

Compatibility After Release
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.

Release Information To Colleges

The new Race & Ethnicity Disaggregation implementation is a new layout

revision to the existing, highly regulated, Race & Ethnicity section in CCCApply which is protected by federal law and the Office of Civil Rights and aligns to MIS reporting requirements (SB29). The new implementation will be in place before the MIS requirements, which will align closely to these changes but will not be instituted until Fall 2019. Therefore our goal for this roll-out is twofold: 1) implement the new layout, race groups and extensive ethnicity values so that researchers can start collecting data in this area; and 2) but provide colleges with a smooth transition relative to data collection by giving them the same download formats they are getting now in addition to the new data, by way of a new data field (race_ethnic_full).

Colleges that want to collect the new data should add the new data field to their download files and update the download jar file.

Database Values and In Progress Application Mapping Requirements
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 need 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.

Add and assign the new race_groups, race_ethnicities and database values based on the breakdown here: https://cccnext.jira.com/wiki/spaces/OPENAPPLY/pages/692486171/Race+Ethnicity+Section+-+Expand+With+New+Options+and+Conditional+Formatting
For In Progress applications In Progress Applications, there will be no database value mappings. 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.

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)

Historical Notes: 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).

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)

(the college's parsing library should make this possible - but they do need to remove the spaces between the values - which is consistent with other CSV formats)

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

SectionFieldOriginal ImplementationOriginal BackendChange to UIChange to Back-End What colleges need to doHispanic / Latino QuestionhispanicYes / No radio buttonsBoolean Y/N or T/F
(Note - corresponds to (01)NoneNoneNothing, No ChangeRace Grouprace_groupPertains only to Hispanic / Latino
Checkboxes

Varying length

Storing actual value

Changed to map to the Ethnicity Groups rather than just the Hispanic/Latino optionsNow stores the Ethnic Group data in CSV FormatAccount for the different meaning of the data coming through, also adjust fixed-width delimited download client format as neededrace_ethnic

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)

Added additional options in checkboxes as subgroupsStores the YNNNYNNYN... formatNothing, No ChangeRace / Ethnicityrace_ethnicCheckbox

Duplicate use of values

Storing the YNX block (YNNNNYN)

Race / Ethnicity Fullrace_ethnic_fullN/AN/AMaps from the same checkboxes as the race_ethnic fieldStores the raw value for each of the Ethnic Subgroups selected on the pageNew Download Client Column, optional for the colleges if they want to download these fieldsValues that weren't a clear one-to-one map, we had to changeThe 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)

NOTE: If the college does nothing - they don't update their Download Format file (XML) then:
hispanic will give them the same as getting now

CHANGE: race_group will give them the new values regardless of whether they update the downloads or not Doesn't require a jar file update

But the Race Group will come down with the new values - still comma separated values but map to the new super groups

But the individual

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.

3 Existing Fields =

Hispanic

race_group (repurposed - no commas)

CCCApply: race_ethnic (giving the college this same field) still has the MIS format - no change

IA: race_ethnicity (now)
IA: race_ethnic_full (future)

NEW full version - Adding - race_ethnic_full (the new format)

Data Formats & Changes to Downloads

Though the goal of the new implementation is to give colleges the same output formats they are getting now for the existing Race & Ethnicity fields, there are some small changes they need to be aware of.

In order to maintain this output format for your MIS reporting, and still be able to benefit from the new race groups and ethnicities being added in this implementation, we have added a new field that will provide all the new response values. Again, this is an additional field showing all the new values. Colleges will still get the legacy values in the existing fields (hispanic, race_group, race_ethnic) as well as the new field (race_ethnic_full).

From a download client perspective, colleges using a fixed-width output now will need to update their format files for the output of the new Race Ethnicity selections, and the new usages of the race_group and race_ethnicity fields.

'race_group' is 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_ethnic' 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.

Adjustments to the CCCApply Format Definition XML Files

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)

From Tyler 11.07.18

If the colleges want to have the new race_ethnic_full column, they will need to download a 6.3.0 version of the transfer-client.jar file which we will build and release along with the other 6.3.0 artifacts later this month.

If the colleges keep their old transfer clients in place and do not upgrade, then they will be fine with regard to the R/E update. Since we are keeping the race_ethnic column the same, no changes are necessary for that. Since we are re-purposing the data in the race_group column, however, the colleges, regardless of any download client changes, will start receiving the repurposed data since that is what is now being stored in that column.

Image Removed

Updated Data Dictionary Elements & Data Field Information

Expand below to see the OLD and the NEW Data Dictionary data field tables for Race & Ethnicity Section. (before 6.3.0)

Expand

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.

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

maxLevel	2

Postman can be used to get database values.

The UI can be used for testing.

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 Information

The 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

title	Click here to read Article 1.5. Student Equity Plans 78220....

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)

Image Added

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

Image Added

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

title	Click here to see more screenshots of the new Race/Ethnicity layout designs:

New Hispanic Question & Race Groups - Auto-populated

Image Added

New Hispanic Question Expanded

Image Added

Asian Category Expanded

Image Added

More Groups Expanded

Image Added

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

Image Added

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 Demo

New 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
Legacy Race Group Value: This column shows the value that will continue to download in your Race Group <race_group> field.
New Race Group Value: This column shows the new Race Group name (high-level category) and corresponding value that will map in the new Race Ethnicity Full field <race_ethnic_full>.
New Race Ethnicity Full Name & Value: This column shows the new ethnicity name (next to a checkbox) in the new layout and the corresponding new value that aligns to it.

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 (race_group)	Legacy Race Group Value	New Race Group Value	New Race Ethnicity Full - Name & Value (race_ethnic_full)	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		Mexican - New DB Value of 111
Central American	03		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
South American	04		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
Hispanic: Other	05		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

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
Legacy Race Group Value: This column shows the value that will continue to download in your Race Group <race_group> field.
New Race Group Value: This column shows the new Race Group name (high-level category) and corresponding value that will map in the new Race Ethnicity Full field <race_ethnic_full>.
New Race Ethnicity Full Name & Value: This column shows the new ethnicity name (next to a checkbox) in the new layout and the corresponding new value that aligns to it.

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 (race_group)	Legacy Race Group Value (race_group)	New Race Group Value (race_ethnic_full)	New Race Ethnicity Full - Name & Value (race_ethnic_full)
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		Samoan - Stays as 19 Tongan - New DB Value of 602
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 (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)

Reference: MIS Data Elements

MIS Data Element

MIS Derived Data Element

SB29 - Multi-Ethnicity

STD10 - Student -Ethnicity (Derived Data Element)
Used for IPEDs reporting

View file

name	SB29 - Multi-Ethnicity.pdf

View file

name	MIS STD10 IPEDS Ethnicity.pdf

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" (Note: International: "04,05,08,09,14,15,17,19,20,21" (note lack of spaces for Intl)) 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. 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 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
	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 [checkbox] American Indian or Alaska Native [checkbox] Black or African American [checkbox] Native Hawaiian or Other Pacific Islander [checkbox] Middle Eastern or North African [checkbox] White
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) Example Format: "100,101,117,118,200,205,08,09,500,15,600,601,17,19,602,700,701,713,800,802,803"
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.

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