...
| Ethnic Group (race_group) | Current Value / Mapping | NeW Associated Subgroup (race_ethnicity) | Notes |
|---|
Asian |
| 200 - - New DB Value of 200 |
|
| Asian: Indian | 06 | - 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 responses from this group will map back to the original value for "Asian: Indian" = 06 |
| Asian: Chinese | 07 | |
|
| Asian: Japanese | 08 | |
|
| Asian: Korean | 09 | |
|
| Asian: Laotian | 10 | |
|
| Asian: Cambodian | 11 | - Cambodian - (Stays as 11)
|
|
| Asian: Vietnamese | 12 | - Vietnamese - (Stays as 12)
|
|
| Asian: Filipino | 13 | |
|
| Asian: Other | 14 | - 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 |
|
| 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)
- Sioux - New DB Value of 396
- Soboba Band of Luiseño Indians - New DB Value of 397
- Susanville Indian Rancheria - New DB Value of 398
- Sycuan Band of the Kumeyaay Nation (formerly the Sycuan Band of Diegueno Mission Indians of California) - New DB Value of 399
- Table Mountain Rancheria of California - New DB Value of 400
- Tejon Indian Tribe - New DB Value of 401
- Tolowa Dee-ni' Nation - New DB Value of 402
- Torres-Martinez Desert Cahuilla Indians - New DB Value of 403
- Tule River Indian Tribe of the Tule River Reservation - New DB Value of 404
- Tuolumne Band of Me-Wuk Indians of the Tuolumne Rancheria of California - New DB Value of 405
- Twenty-Nine Palms Band of Mission Indians of California - New DB Value of 406
- United Auburn Indian Community of the Auburn Rancheria of California - New DB Value of 407
- Upper Lake Band of Pomo Indians - New DB Value of 408
- Utu Utu Gwaitu Paiute Tribe of the Benton Paiute Reservation - New DB Value of 409
- Washoe Tribe (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community and Washoe Ranches) (California and Nevada) - New DB Value of 410
- Wilton Rancheria - New DB Value of 411
- Wiyot Tribe (formerly the Table Bluff Reservation-Wiyot Tribe) - New DB Value of 412
- Yocha Dehe Wintun Nation - New DB Value of 413
- Yurok Tribe of the Yurok Reservation - New DB Value of 414
- Zapotec - New DB Value of 415
- Other American Indian - New DB Value of 416
- Other Alaska Native - New DB Value of 417
| NOTE: All new American Indian / Alaskan Native responses will map back to original DB value "16" |
| Black or African American |
| 500 -- New DB Value of 500 |
|
| 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 these responses will map back to the original value for Black or AfricanAmerican = 15 |
| Native Hawaiian or Other Pacific Islander |
| 600 - - New DB Value of 600 |
|
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
|
|
| Pacific Islander: Other | 20 | - Fijian - New DB Value of 601
- Other Pacific Islander - Stays as 20
|
|
| Middle Eastern or North African |
| 700 - - New DB Value of 700 |
|
| 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 responses will map to the original value for White = 21 |
| White |
| 800 - - New DB Value of 800 |
|
| 21 | - 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 responses will map to the original 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.
General Requirements
- Requirements above 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.
...
Release Information To Colleges
...
| Section | Field | New Implementation | Original Backend Implementation | Original Backend | What Colleges Need to Do |
|---|
| Hispanic / Latino Question | hispanic_latino | 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’ | Boolean Y/N or T/F | (Note - corresponds to (01)
|
| Race Group | race_group |
| 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) |
|
| Race / Ethnicity | race_ethnic |
| Checkbox Duplicate use of values Storing the YNX block (YNNNNYN) |
|
| Race / Ethnicity Full | race_ethnic_full |
|
|
|
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 |
In Progress Application Mapping Requirements
| Warning |
|---|
Requirements Update: After the new R&E values have been added, there may be in-progress applications. For the applicants who answered the R&E question (it's optional) and resume an in-progress application, display a client-side pop-up message to inform them that 1) the Personal Information page has been renamed to Demographic Information and is in a new position in the application; and 2) new Ethnicity options have been added to the applications. Please review your previous response for accuracy. |
...
| title | Click here to see declined mapping specifications for reference... |
|---|
7.19.18: The following mapping requirements were proposed and declined. User will be directed to update their previous response, if applicable, instead.
...
- Requirements above 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.
...
Below are the OLD/existing Race & Ethnicity field values/specifications (before 6.3.0)
| Expand |
|---|
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’ |
|
|
|
|
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. |
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 SB29 |
|