We need to expand the number of ethnicity categories collected on incoming students. There is a business need to expand the categories of ethnicity that are collected via CCCApply and in the International application. The current Student Equity Plan (SEP) guidelines, however, 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.
Excerpts on 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:
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.
/wiki/spaces/PD/pages/640221194
CCCApply and the International application 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. From there, applicants are asked what their race is and they are given limited high level categories to choose from.
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
Attached is a functional excel mockup for how this new layout and functionality should be in both the CCCApply and International Application.
Section 1 Requirements - Hispanic/Latino Section
- The first section should ask the following question: "Are you Hispanic or Latino?"
- If user clicks on the checkbox, then the box next to Hispanic or Latino should become automatically checked and the subgroup list expands and becomes visible to display 19 subcategories (race_ethnicity).
- If user does not click on the checkbox, then the box next to Hispanic or Latino should not systematically expand and the user should not see the 19 subcategories race_ethnicity).
| Race Group (race_group) | Current Value / Mapping | NEW Associated Subgroup (race_ethnicity) | Notes |
|---|
| Hispanic or Latino - New DB Value of 100 | 01 | 100 = New DB Value | Hispanic, Latino - (From ‘Are you Hispanic / Latino?’
drop-down menu selection) |
|
| - Argentinean - New DB Value of 101
- Bolivian - New DB Value of 102
- Chilean - New DB Value of 103
- Colombian - New DB Value of 104
- Costa Rican - New DB Value of 105
- Cuban - New DB Value of 106
- Dominican (Dominican Republic) - New DB Value of 107
- Ecuadorian - New DB Value of 108
- Guatemalan - New DB Value of 109
- Honduran - New DB Value of 110
- Mexican - New DB Value of 111 (Per Craig Hayward 7.19.18, keep this mapped to existing value 02.)
- Nicaraguan - New DB Value of 112
- Panamanian - New DB Value of 113
- Peruvian - New DB Value of 114
- Puerto Rican - New DB Value of 115
- Salvadoran - New DB Value of 116
- Spanish - New DB Value of 117
- Venezuelan - New DB Value of 118
- Other Hispanic or Latino - New DB Value of 119 (New value approved for this one. per "Latino" ethnicity addition
|
|
| Mexican, Mexican-American, Chicano | 02 | - Mexican - New DB Value of 111 (Per Craig Hayward 7.19.18, keep this mapped to existing value 02.)
|
|
| 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 (New value approved for this one. per "Latino" ethnicity addition
|
|
Section 2 Requirements
- The following instructions should fall below the Hispanic/Latino Section.
- Check all of the ethnicity and ancestry groups that you identify with. When you select a major ethnicity group, you will have the option to select more specific ancestry groups. Select all that apply and then click on the button that says "Continue".
- The system should then show the following ethnic groups with a checkbox next to each group:
- Applicants who select one or more of the Ethnic Groups should then see the subset of more detailed associated subgroups. Multiethnic applicants are able to select as many ethnic groups and ethnic subgroups as needed. When a box is checked an accordion expansion should reveal the associated subgroups. When a box is unchecked, the accordion expansion should roll up to no longer show the subgroups.
- The following table shows a breakdown of the subgroups tied to each ethnic group, as well as the DB value associated in parenthesis.
| 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 - New DB Value of 800 |
| 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 |
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.
| Current Database Values | Should Map To |
|---|
| 01: Hispanic, Latino - (From ‘Are you Hispanic / Latino?’) | If there is an in progress application and the student has chosen the DV value of race_group 01, then map to new DB value of race_group of 100. |
| 02: Mexican, Mexican-American, Chicano | If there is an in progress application and the student has chosen the DV value of race_group 02, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
| 03: Central American | If there is an in progress application and the student has chosen the DV value of race_group 03, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
| 04: South American | If there is an in progress application and the student has chosen the DV value of race_group 04, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
| 05: Hispanic: Other | If there is an in progress application and the student has chosen the DV value of race_group 05, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
| 06: Asian: Indian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 06, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 06. |
| 07: Asian: Chinese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 07, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 07. |
| 08: Asian: Japanese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 08, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 08. |
| 09: Asian: Korean | If there is an in progress application and the student has chosen the DV value of race_ethnicity 09, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 09. |
| 10: Asian: Laotian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 10, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 10. |
| 11: Asian: Cambodian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 11, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 11. |
| 12: Asian: Vietnamese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 12, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 12. |
| 13: Asian: Filipino | If there is an in progress application and the student has chosen the DV value of race_ethnicity 13, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 013. |
| 14: Asian: Other | If there is an in progress application and the student has chosen the DV value of race_ethnicity 14, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 14. |
| 15: Black or African American | If there is an in progress application and the student has chosen the DV value of race_ethnicity 15, then it should be mapped to DB value of race_group 500 and map to race_ethnicity DB value of 15. |
| 16: American Indian / Alaskan Native | If there is an in progress application and the student has chosen the DV value of race_ethnicity 16, then it should be mapped to DB value of race_group 300, no mapping race_ethnicity. |
| 17: Pacific Islander: Guamanian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 17, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 17. |
| 18: Pacific Islander: Hawaiian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 18, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 18. |
| 19: Pacific Islander: Samoan | If there is an in progress application and the student has chosen the DV value of race_ethnicity 19, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 19. |
| 20: Pacific Islander: Other | If there is an in progress application and the student has chosen the DV value of race_ethnicity 20, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 20. |
| 21: White | If there is an in progress application and the student has chosen the DV value of race_ethnicity 21, then it should be mapped to DB value of race_group 800 and no mapping to race_ethnicity. |
- 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.
- 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 changed 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.
| Jira Number | Story | Description |
|---|
|
OPENAPPLY-4800
-
Getting issue details...
STATUS
|
|
|