| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Business Need
In cooperation between the AIAN Group and the CCCCO, the current list of American Indian/Alaska Natives (AIAN) tribal affiliations is being expanded in CCCApply to include the full Federal Register of Indian Entities Recognized which contains roughly 800 California state and national tribes.
To accommodate the addition of over 500+ names to our existing list of nearly 400 AIAN options, an enhancement to the user interface with a new “look-up” modal and optional “write-in” field will be made to the AIAN section of the Race & Ethnicity section of the Standard application.
About the AIAN Expansion
The 2024 AIAN expansion enhancement is limited to the AIAN group; no other race group is being touched in this implementation and the impacts to existing data fields and delivery is minimal. , with no changes to existing data fields Existing list of names (pre-expansion) will need some updating/archiving, and the large set of additional entities will need to be added and mapped correctly to existing race/ethnicity data field(s). New UI implementation is needed to allow for easier search and selection of AIAN tribes, and the ability for students to “write-in” a tribe or nation that doesn’t appear will be added.
| Info |
|---|
The 2024 AIAN expansion has been implemented in the CCCApply Standard/Noncredit application. The implementation is scheduled for the International Application in a future release. |
Change Summary
Expand and update the CCCApply list of AIAN tribes in the AIAN race group
Enhance the UI in the Race & Ethnicity section to allow user’s to “search and select” up to five AIAN tribes
Add new “write-in” data field to capture a tribe(s) that doesn’t exist in the updated AIAN list
2024 AIAN Expansion Enhancement
Expand the list of AIAN tribal affiliations in the Race & Ethnicities section of the CCCApply Standard/Noncredit application:
Update/correct the existing list of American Indian/Alaskan Native (AIAN) ethnicities (correct names, remove duplicates, discontinue tribes that are no longer recognized)
Add/expand the list of the AIAN ethnicities with the full Federal Register of Indian Entities Recognized into the AIAN ethnicities
Implement the ability for students to “write-in” up to 5 tribal names that do not appear in the expanded list
Enhance the Race & Ethnicities section with new search & select modal for new and existing AIAN ethnicities.:
Implement ability for students to search, display, and select multiple AIAN ethnicities from the large expanded list
Changes pertain to the AIAN section of the Race/Ethnicity section (race group = 16 = AIAN)
Update the Race & Ethnicity data fields to include the vast number of AIAN tribes:
Maintain all existing <race_ethnic_full> data values in DB, and add & document new values
Add new AIAN tribes and codes to the existing <race_ethnic_full> field
Add new “write-in” field(s) to DED
Minimal changes to existing data fields; minimal impact to colleges is critical
1. Expand and Update the AIAN Tribe List in CCCApply
The American Indian/Alaska Natives race group is one of the upper-level race groups listed in the Race & Ethnicity section in CCCApply. As with the other race groups, the American Indian/Alaska Natives (AIAN) group includes a number of sub-group entities, or ethnicities, that display if the upper-level AIAN group is selected. Prior to this expansion, the AIAN group included over 300 individual entities. Following the expansion, the group includes over 570 individual AIAN options.
Updated & Deprecated AIAN Tribes
Part of the expansion implementation included updating some existing AIAN tribal names to match their listing in the federal registry, and deprecating a few tribes that are no longer part of the list. Deprecated tribes will continue to exist in the CCCApply database, but will no longer display in the application. In the 2024 Complete CCCApply AIAN Race & Ethnicity List, the names that have been updated are color-coded in orange, and the names that have been deprecated, or no longer in use, are color-coded in yellow.
New AIAN Tribes
Every new AIAN tribe added to CCCApply comes directly from the Federal Register of Indian Entities Recognized. Each entity has been assigned a unique code/value for the Race Ethnicity Full data field <race_ethnic_full>, as does every other existing race group ethnicity in CCCApply. The <race_ethnic_full> field is can store up to 800 comma separated values, optionally selected by the applicant in the Race & Ethnicity section. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section below).
2024: Complete CCCApply AIAN Race & Ethnicities List
The 2024: Complete CCCApply AIAN Race & Ethnicities Listprovides a complete color-coded list of all new and existing American Indian/Alaska Natives (AIAN)tribes and field values across each of the four race and ethnicity data fields. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section below).| bgColor | #FFFAE6 |
|---|
Legend for AIAN List
2024: All CCCApply Race & Ethnicities List
The 2024: All CCCApply Race & Ethnicities Listprovides the complete list of every race group and individual ethnicity in the CCCApply Race & Ethnicity section, showing corresponding field values across each of the four race and ethnicity data fields. This spreadsheet will replace the previous table in the CCCApply Standard & Noncredit Application Data Dictionary. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section below).2. User Interface Enhancements for the AIAN Expansion
To feasibly accommodate the large number of new AIAN tribe options in CCCApply, the existing user interface has been enhanced to allow the applicant to search for their tribe in a new “look-up” modal and select multiple tribes as part of their response. The new look-up modal will display only if the applicant selects the upper-level American Indian/Alaska Natives race group; otherwise the modal is not displayed to the user.
More images
After selecting the American Indian or Alaska Native race group, a modal appears with the
Search for your tribe search bar.
Search and select up to five individual tribes using the Search for your tribe function.
3. New Other AIAN “Write-In” Data Field
Implement a new Other AIAN: Write-In field to capture tribes that aren’t in the list
Mock Ups for AIAN UI Enhancements
Attached is a functional excel mockup for how this new layout and functionality should be in both the CCCApply and International Application.
Change Specs
CHANGES TO THE UI & User FlowUpdated & Expanded AIAN Tribes:
A series of updates/changes have been made to the existing American Indian/Alaska Natives (AIAN) race group section the Demographic Info page. These changes are to accommodate the very large list of additional AIAN ethnicities (tribal affiliations) being added to the American Indian/Alaskan Native race group ONLY. See breakdown of changes to existing tribes here:
Several hundred additional AIAN tribes have been added to the AIAN Race Group in CCCApply. These align to the Federal Register of Recognized Indian Entities. Each AIAN tribe added has been assigned a <race_ethnic_full> code/value, which will be added to the existing <race_ethnic_full> field values. The <race_ethnic_full> field length and format have not changed; however, the number of values stored will be limited to 5 codes - a restriction added and validated in the system.
New UI Design:
If student selects the race group = American Indian / Alaska Natives <race_group = 16> then a
New searchable modal and display functionality is being implemented in the AIAN Race Group section of the Race/Ethnicity section of the Demographic Info page ONLY. These changes are to accommodate the very large list of additional AIAN ethnicities (tribal affiliations) being added to the American Indian/Alaskan Native race group ONLY.
IF/when applicant selects the American Indian/Alaskan Native (AIAN) race group checkbox, a new two part Search & Display name finder modal will appear - allowing students to view and select all AIAN names (listed alphabetically by default) and a Search field, allowing the student to find a tribe by typing in the name (similar to the way the High School Finder works today).
Each AIAN tribe name selected in the Search & Find box will then appear in a second Search Results box.
The applicant can select up to 5 tribes using the Search & Find feature.
If the applicant cannot find one or more of their tribes in the existing AIAN list, the student can opt to “write-in” up to 5 additional tribe names (not found within the existing list).
NOT CHANGING with this implementation
The ability for the applicant to select one or more, or none, of the existing Race groups that they identify with. When selection of a major ethnicity group is made, all existing sub-group ethnicities will display - allowing the student to drill down and select one or more specific ancestry groups. Select all that apply."
No Change to Display of Existing Race Groups: The system will continue to display the current set of Race Groups with checkboxes next to them (with all sub-group ethnicities hidden until the checkbox is selected).
Hispanic/Latino (under the Hispanic question)
Asian
American Indian or Alaska Native
Black or African American
Native Hawaiian or Other Pacific Islander
Middle Eastern or North African
White
No Change to Display of other Race Sub-Groups (Ethnicities): Applicants who select one or more of the Race 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.
Existing Data Field Changes: No changes are being made to the following Race/Ethnicity data fields shown below.
<hispanic> No changes are being made to the Hispanic field.
<race_group> No changes are being made to the Race Group data field; all values and formats will not change.
<race_ethnic> No changes are being made to the Race Ethnic field in this release. Existing YN values and formats have not changed.
| Info |
|---|
Note: The only field being modified is the <race_ethnic_full> field - with 450+ additional AIAN tribal codes/values (see details in section above). |
| Note |
|---|
Table Legend Race Group Name: This column depicts only existing race group names |
Updates to Existing AIAN Tribal Names & Codes
Race Group Name
Race Group Value <race_group>
Race Ethnic MIS Position
<race_ethnic>
Race/Ethnicity Full Value
<race_ethnic_full>
Race/Ethnicity Name
Status
Hispanic, Latino
01
1
100
Mexican, Mexican-American, Chicano
02
2
111
Mexican, Mexican-American, Chicano Group
Central American
03
3
03
Central American Group
03
3
105
Costa Rican
03
3
109
Guatemalan
03
3
110
Honduran
03
3
112
Nicaraguan
03
3
113
Panamanian
03
3
116
Salvadoran
South American
04
4
04
04
4
101
Argentinean
04
4
102
Bolivian
04
4
103
Chilean
04
4
104
Colombian
04
4
108
Ecuadorian
04
4
114
Peruvian
04
4
118
Venezuelan
Hispanic: Other
05
5
05
05
5
106
Cuban
05
5
107
Dominican (Dominican Republic)
05
5
115
Puerto Rican
05
5
117
Spanish
05
5
119
Other Hispanic or Latino
Asian
06
6
200
06
6
201
Afghan
06
6
202
Bangladeshi
06
6
203
Burmese/Myanmar
06
6
06
Indian
Stays (06)
06
6
206
Pakistani
06
6
207
Sri Lankan
Asian: Chinese
07
7
07
Chinese
Asian: Japanese
08
8
08
Japanese
Asian: Korean
09
9
09
Korean
Asian: Laotian
10
10
10
Laotian
Asian: Cambodian
11
11
11
Cambodian
Asian: Vietnamese
12
12
12
Vietnamese
Asian: Filipino
13
13
13
Filipino
Asian: Other
14
14
14
Asian: Other
14
14
204
Hmong
14
14
205
Indonesian
14
14
208
Taiwanese
14
14
209
Thai
American Indian or Alaska Native
16
16
300
301 - 417
See list of existing, pre-2024 AIAN expansion here.
16
16
418
Other: American Indian
16
16
419
Other: Alaska Native
16
16
420
Other: AIAN
combined
Black or African American
15
15
500
15
15
501
Subsaharan African: Ethiopian
15
15
502
Subsaharan African: Kenyan
15
15
503
Subsaharan African: Nigerian
15
15
504
Subsaharan African: Somali
15
15
505
Subsaharan African: South African
15
15
506
Subsaharan African: Other Subsaharan African
15
15
507
West Indian: Belizean
15
15
508
West Indian: Haitian
15
15
509
West Indian: Jamaican
15
15
510
West Indian: Other West Indian
Native Hawaiian or Other Pacific Islander
20
20
600
Other Pacific Islander
20
20
601
Fijian
Pacific Islander: Guamanian
17
17
17
Guamanian or Chamorro
Pacific Islander: Hawaiian
18
18
18
Native Hawaiian
Pacific Islander: Samoan
19
19
19
Samoan
19
19
602
Tongan
Middle Eastern or North African
21
21
700
Middle Eastern or North African is a NEW Race Group added in 2018. All ethnicity subgroup responses in this section roll up to "White" = 21
21
21
701
Assyrian, Syriac or Chaldean
21
21
702
Egyptian
21
21
703
Iranian or Persian
21
21
704
Iraqi
21
21
705
Israeli
21
21
706
Jordanian
21
21
707
Lebanese
21
21
708
Moroccan
21
21
709
Palestinian
21
21
710
Syrian
21
21
711
Turkish
21
21
712
Other Middle Eastern
21
21
713
Other North African
White
21
21
800
All White ethnicity subgroups map back to DB value of 21.
21
21
801
Armenian
21
21
802
Australian
21
21
803
Basque
21
21
804
British Isles (UK or Ireland)
21
21
805
Canadian
21
21
806
European
21
21
807
Russian
21
21
808
Ukrainian
21
21
809
Other White
New AIAN Tribal Names & Codes (Added 2024)
New Other AIAN “Write-In” Field
Field Name: <race_aian_other_description>
Glue Name: <raceAianOtherDescription>
See detailed field specs: /wiki/spaces/PMO/pages/3267297281
Data Fields & Data Delivery
Changes to allowable selections in the AIAN section only affects the number of associated values/codes appear in the <race_ethnic_full> field. No change has been made to that field length or any race/ethnicity field length.
Race & Ethnicity Data Fields
Hispanic
Data Element: <hispanic>
Notes: No changes, this field is a boolean true/false field that continues to work as it does today.
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, 16, 17, 19, 20, 21", International: "04,05,08,09,14,15,17,19,20,21" (note lack of spaces for Intl)
Maximum Expected Width: 80 characters (unchanged) (20 * 2 character long values + 19 commas + 19 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 is intentionally left unchanged (until COMIS changes are specified)
Example Format: YNYNNNNYNNNNNNNNNYNNN
Maximum Expected Width: 22 characters (unchanged) (22 character long string)
Race Ethnicity Full
Data Element: <race_ethnic_full>
Notes: This field currently stores the CSV separated values for all user selections for both the “upper-level” race group values and all ethnicities values 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: 805 characters (201 * 3 character long values + 200 commas + 2 surrounding quote marks for CSV delimiting in the output format)
Data Delivery
All existing fields will continue to be delivered to college SIS, staging tables, downstream systems, Report Center, Report Server, via SuperGlue for Apply
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_ethnic_full. Once the new value is chosen, we will need to store the new value.
2024 Dev Requirements & Change Specifications
Jira Ticket
Story Brief
NOTES
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
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)
Race Group Name
Race Group Value <race_group>
Race/Ethnicity Full Value
<race_ethnic_full>
Race/Ethnicity Name
Status
American Indian or Alaska Native
16
300
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
15
500
501
Subsaharan African: Ethiopian
502
Subsaharan African: Kenyan
503
Subsaharan African: Nigerian
504
Subsaharan African: Somali
505
Subsaharan African: South African
506
Subsaharan African: Other Subsaharan African
507
West Indian: Belizean
508
West Indian: Haitian
509
West Indian: Jamaican
510
West Indian: Other West Indian
Native Hawaiian or Other Pacific Islander
20
600
Other Pacific Islander
601
Fijian
Pacific Islander: Guamanian
17
17
Guamanian or Chamorro
Pacific Islander: Hawaiian
18
18
Native Hawaiian
Pacific Islander: Samoan
19
19
Samoan
601
Tongan
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
701
Assyrian, Syriac or Chaldean
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
2018: Previous Development References
Jira Number
Story
Description
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
As a college researcher, I need the ability to disaggregate race and ethnicity demographical data collected in CCCApply and International application so the data is captured in a more detailed manner for federal IPEDs reporting on ethnicity data.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Change it so that the race_group column stores the sames values for both Apply and Intl as it did previously to the change done in OPENAPPLY-4800.
2018: Other Docs. & Pages
Document
Description
Stakeholder
Change Request 2018-18R: Expand Race & Ethnicity Section with New Categories
Change Request information
External - Colleges - CCCCO
2019-05: Add Field to Race & Ethnicity Section for "Other: Write In"
2018 Internal development requirements
Internal
Ethnicity/Ancestry Expansion Proposal
| Panel | ||
|---|---|---|
| ||
This page provides summary details of the 2024 AIAN Expansion enhancement implemented in the Race & Ethnicity section of the CCCApply Standard & Noncredit Application (April 2024). |
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Business Need
Feedback received from systemwide stakeholders in collaboration with the CCC Chancellor’s Office and consultants requests that the current system of American Indian Alaska Natives (AIAN) in CCCApply offer a more expansive selection of Tribal names, many of which were overly general, such as “Chippewa” or “Sioux.” Recognizing the inadequacy of this approach in respecting the sovereignty of Tribal nations, we've proposed an expansion to the list to include all 574 Federally Recognized Tribes as detailed in the U.S. Federal Register. Additionally, we've introduced an option for students to specify their Tribal affiliations through a write-in feature, to also include and capture those students affiliated with Tribes not currently listed on the Federal Register. Our aim is to foster an environment that is both inclusive and respectful towards all American Indian Alaska Native Tribal students.
| Info |
|---|
American Indian or Alaska Native (AIAN) |
About the AIAN Expansion Enhancement
The scope of the enhancement in CCCApply from the development perspective is limited to the AIAN race group (category) and ethnicities (sub-category) in the existing Race & Ethnicity UI and data fields. No other race group is being affected by this implementation and the impact on the existing race/ethnicity data fields is very minimal. The expansion adds a large number of AIAN tribes/entities to the existing AIAN race group, as well as a handful of name updates and deprecations. A revision to the user interface was made to allow users to search for and select their preferred AIAN tribes, with the added ability for the user to “write-in” a tribe name that doesn’t appear in the search results.
| Panel | ||
|---|---|---|
| ||
At this time, the 2024 AIAN expansion enhancement has been implemented in the CCCApply Standard & Noncredit application only. Plans to update the International Application is scheduled for a future release. |
Changes Summary
Update and expand the list of available AIAN tribes/ethnicities in CCCApply
Add new Other American Indian/Alaska Native "write-in" option and data field capable of capturing up to five “other” tribe names that may not appear in the list
Enhance the user interface with a new “search and select” feature, exclusively for the expanded AIAN tribe list
1. Update and Expand the AIAN Tribe List
The American Indian or Alaska Natives (AIAN) group is one of 21 upper-level race group categories in the Race & Ethnicity section in CCCApply. Like the other race groups, the American Indian or Alaska Natives (AIAN) group includes a number of sub-category entities - or ethnicities - that display when the upper-level group is selected by the applicant. Prior to this 2024 expansion, the AIAN group included approximately 120 individual entities. Following this expansion, the AIAN group will include 585 new and existing options. In addition:
20 existing tribe names were corrected or updated
7 tribe names were deprecated (remains in database but no longer displays)
464 new tribes were added
Updated & Deprecated AIAN Tribes
As part of the AIAN expansion, 20 existing AIAN tribe names were updated to match the listing in the federal registry, and 7 names have been discontinued. The discontinued/deprecated names and their field values will continue to exist in the CCCApply database but will no longer display as an available option as they are no longer recognized in the federal list. Both sets of changes are identified (color-coded) in the 2024 CCCApply AIAN Race & Ethnicity List, with updated names highlighted in orange and discontinued names highlighted in yellow. No changes were made to their corresponding data field values (codes) in the Race Ethnic Full <race_ethnic_full> data field.
New AIAN Tribes
The bulk of the expansion includes adding 464 new AIAN tribes to CCCApply to align with the 2024 Federal Register of Indian Entities Recognized. Along with the existing list of AIAN tribes, each new entity has been assigned a field value for the Race Ethnic Full data field <race_ethnic_full>. The complete list of new and existing AIAN names and values are itemized in 2024 CCCApply AIAN Race & Ethnicity List.
464 new (additional) AIAN tribes/ethnicities were added to the current list, bringing the total number of tribes/ethnicities in the AIAN race group to 585. (currently there are 120+ tribes in that group).
Each new tribe/ethnicity has been assigned a value (code) for the existing <race_ethnic_full> field.
One of these new values is for the new Other American Indian / Alaska Native "write-in" option <race_ethnic_full> = 420 (described even further below).
2024 CCCApply AIAN Race & Ethnicities List
The 2024 CCCApply AIAN Race & Ethnicities Listprovides a complete color-coded list of all new and existing American Indian/Alaska Natives (AIAN)tribes and field values across each of the four race and ethnicity data fields. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section below).
| Panel | ||
|---|---|---|
| ||
Legends: A mapping legend is provided for each of the two 2024 updated lists. |
2024 Complete CCCApply Race & Ethnicities List
The 2024 Complete CCCApply Race & Ethnicities Listprovides the complete list of every race group and individual ethnicity in the CCCApply Race & Ethnicity section, showing corresponding field values across each of the four race and ethnicity data fields. This spreadsheet will replace the previous table in the CCCApply Standard & Noncredit Application Data Dictionary. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section below).
2. New “Other American Indian/Alaska Native” Write-In Field
One of the new options added to the expanded list, Other American Indian/Alaska Native, is both an option with a value/code in the Race Ethnic Full data field <race_ethnic_full>, and a new write-in/text input data field, <race_aian_other_description>. Complete data specs are provided below.
The way it works: If the applicant cannot find their tribe in expanded list they can click the “Can't find your tribe?” link that appears just below the main search modal. If clicked on, the user interface changes, and a text input field appears - allowing the applicant the option to “write-in” up to five other tribe names and submit them with their application. If an other tribe is submitted, a value of 420 is stored in the Race Ethnic Full <race_ethnic_full> field.
Dictionary Name: Other American Indian/Alaska Native
Data Element: <race_aian_other_description>
Format/Type: Text input, varying character 1024
Conditions: Conditional display; Optional response; Allows Null; Stores up to five tribe names, comma separated
Note: This option is one of 585 ethnicities under the AIAN race group (16) with a <race_ethnic_full> value=420.
For colleges, this new data field has been added to the CCCApply submitted application database and delivered via Glue for Apply to your staging table or SIS.
| Panel | ||
|---|---|---|
| ||
See a more detailed summary in the Data Fields & Data Deliverysection below. Fields will not appear in the CCCApply Data Dictionary until they are released to pilot or production servers. |
3. Enhance the User Interface to Support AIAN List Expansion
To feasibly accommodate the large number of new AIAN tribe options in CCCApply, the existing user interface has been enhanced to allow the applicant to search for their tribe in a new “look-up” modal and select multiple tribes as part of their response. The new look-up modal will display only if the applicant selects the upper-level American Indian/Alaska Natives race group; otherwise the modal is not displayed to the user.
| Note |
|---|
Note: The user interface changes pertain to the AIAN race group only. No changes have been made to the display or functionality of the other upper-level race groups (categories), nor the display of their ethnicities (sub-categories). Multi-ethnic applicants are still able to select as many race groups and ethnicities as needed. Furthermore, a selection in the Race & Ethnicity section remains optional. |
Simple User Flow: “Search for your tribe”
In the Race/Ethnicity section in CCCApply, if the applicant selects “American Indian or Alaska Native” race group, the new “Search for your tribe” modal appears. The applicant has the option to do nothing or drill-down to find their specific AIAN tribe by entering the full or partial tribe name in the “Search for your tribe” search field.
If their tribe is found, they can confirm the results in “Search results” window or not. If the tribe is selected, they click the “Add Selected Tribe(s)” button to save the selected tribe. The applicant can repeat the process if they want to select additional tribes. Alternately, to remove the tribe from the search results window, click the “Remove Selected Tribe(s)” button to clear.
After selecting the American Indian or Alaska Native race group, the Search for your tribe modal is displayed. The user can search for a tribe typing in the tribe’s name or related city.
If your tribe is found it will appear in the Search Results box. Place a checkmark next to the tribe(s) you want to submit, then click the Add Selected Tribe(s) button.
Simple User Flow: Enter Other “Write-In” Tribe Name
If the applicant cannot locate their tribe using the “Search for your tribe” finder, they have the option to “write-in” a tribe name of their choice.
To add a new tribe name, the applicant clicks on the “Can’t find your tribe?” link and enter a tribe name in the empty text field.
To submit a tribe, enter your tribe’s name in the text input box.
Once your tribe name is entered, click the “Add Your Tribe” button to see your tribes in the “Your Selected Tribes” box. Place a checkmark next to each tribe you want to submit, then click “Continue”.
Data Fields & Data Delivery
New Data Field: Other American Indian/Alaska Native
As specified in a section above, a new data field is being added to CCCApply for the Other American Indian/Alaska Native write-in option.
Dictionary Name: Other American Indian/Alaska Native
Data Element: <race_aian_other_description>
Format/Type: Text, varying character 1024
Notes: Conditional display; Optional response; Allows Null; Stores up to five tribe names, comma separated;
NOTE: The new Other American Indian/Alaska Native <race_aian_other_description> field aligns to one of the new options added in 2024 AIAN expansion. The name Other American Indian/Alaska Native is never displayed in the application list, it is triggered if the applicant clicks the “Can’t find your tribe?” link below the list tribe search modal.
If the applicant opts to write-in/submit an other tribe name (up to five), then:
the new Other American Indian/Alaska Native data field <race_aian_other_description> is populated; and
the value = 420 is stored in the <race_ethnic_full> field.
Reference: Summary of Race & Ethnicity Data Field Specifications (2024)
Below is a summary of all CCCApply Race & Ethnicity fields specs following the 2024 AIAN expansion. For a complete accounting, see the 2024 CCCApply AIAN Race & Ethnicity List.
Data Element | Format / Example | Maximum Expected Width | 2024 Changes | |
|---|---|---|---|---|
Hispanic | <hispanic> | boolean / true/false/null | No changes to this existing field, values, or UI display. | |
Race Group | <race_group> | "04, 05, 08, 09, 14, 15, 16, 17, 19, 20, 21" | 80 characters (unchanged) (20 * 2 character long values + 19 commas + 19 spaces + 2 surrounding quote marks for CSV delimiting in the output format) | No changes to this existing field, values, or UI display. |
Race Ethnicity | <race_ethnic> | Example: YNYNNNNYNNNNNNNNNYNNN | 22 characters (unchanged) (22 character long string) | No change to this existing field, format, and values.
|
Race Ethnicity (International) | <race_ethnicity> | Example: YNYNNNNYNNNNNNNNNYNNN | 22 characters, string (unchanged) | No changes to this field. This is the CCCApply International application version of this field name. All other data specs are the same. |
Race Ethnicity Full | <race_ethnic_full> | "100,101,117,118,200,205,08,09,500,15,600,601,17,19,602,700,701,713,800,802,803" | 805 characters (201 * 3 character long values + 200 commas + 2 surrounding quote marks for CSV delimiting in the output format) length is truncated | Minor changes to be aware of:
|
Other American Indian / Alaska Native | <race_aian_other_ | Text, varying character | 1024 | New data field (2024):
NOTE: If the applicant selects to write-in/submit an (up to five) “Other American Indian/Alaska Native” tribe, the <race_ethnic_full> includes a value = 420. This will signify to the college that the student entered up to five other tribes that did not appear in the new expanded list. Coming: See the CCCApply Standard & Noncredit Application Data Dictionary for complete data field specifications (Version 2024.3 or later). |
<hispanic> No changes are being made to the Hispanic field.
<race_group> No changes were made to the Race Group data field; all values and formats will not change.
<race_ethnic> No changes were made to the Race Ethnic and Race Ethnicity (International) fields in this release. Existing YN values and formats have not changed.
<race_ethnic_full> - The only reportable change is the addition of several hundred new AIAN tribe names and field values for the Race Ethnicity Full list
Database Storage Scheme
The database storage scheme remains the same for race_group, race_ethnic, hispanic, race_ethnic_full
No changes were made to existing data fields/formats - other than updating for list of names and codes.
No changes were made to storage of the mapped record and exact format in place prior to 2024 AIAN expansion to ensure colleges don't have to adjust their imports and MIS can still get the existing formats.
Keep all existing codes (db values) for existing Tribes, even deprecated values
Race & Ethnicity MIS Data Elements
The two primary MIS data elements related to Race & Ethnicity reporting are:
SB29 - Student-Multi-Ethnicity
SB38 - Student-Expanded Ethnicity
Below is a summary of how the two race & ethnicity-related MIS fields may/may not be affected by the 2024 AIAN expansion, including the new Other American Indian/Alaska Native write-in field.
SB29 - STUDENT-MULTI-ETHNICITY
There should be no impact on SB29 from the 2024 AIAN expansion implementation. All existing race & ethnicity fields remain unchanged intentionally.
The CCCApply data fields that map to COMIS SB29 are:
Hispanic <hispanic>
Race Group <race_group>
Race Ethnicity <race_ethnic>
Race Ethnicity (International App) <race_ethnicity_full>
SB38: STUDENT-EXPANDED-ETHNICITY
The CCCApply data field that maps directly to SB38 is the existing Race Ethnicity Full <race_ethnic_full> field.
For the most part this field has not changed and will continue to deliver colleges a string of values/codes representing the individual race group(s) and ethnicity selections submitted by the student.
The potential impact to SB38 is the new 464 AIAN tribes/ethnicities and their values that are not yet part of the SB38 data element at the time of the initial release.
Table: Summary of Race & Ethnicity Fields Mapping to MIS
Below is a summary of how the AIAN group maps to/relates to the existing Race & Ethnicity fields. For a complete accounting, see the 2024 CCCApply AIAN Race & Ethnicity List.
Field Name | Data Field | Value | How AIAN Tribes relate to this field… | MIS Mapping |
|---|---|---|---|---|
Hispanic | <hispanic> | n/a | N/A. AIAN ethnicities do not map to the <hispanic> race group field. | SB29 |
Race Group | <race_group> | 16 | The American Indian or Alaska Native (AIAN) race group has a value = 16. (Note: AIAN ethnicities are the sub-group (or sub-category) of the upper-level race group (category). If an individual AIAN ethnicity is selected by the student, the <race_group> value is also = 16. | SB29 |
Race Ethnicity | <race_ethnic> | 16 | Values for the <race_ethnic> field are used for mapping to COMIS SB38. Individual AIAN ethnicities map to the upper-level race group value; in this case (AIAN) <race_ethnic> = 16. | SB29 |
Race Ethnicity (International) | <race_ethnicity> | 16 | International Application ONLY: Values for the <race_ethnicity> field are used for mapping to COMIS SB38. Individual AIAN ethnicities map to the upper-level race group value; in this case <race_ethnicity> = 16. | SB29 |
Race Ethnicity Full | <race_ethnic_full> | <unique code> | Each AIAN ethnicity has a unique value/code for the Race Ethnicity Full field <race_ethnic_full> - including the 464 new tribes/ethnicities. See all tribe names and values/codes on the 2024 CCCApply AIAN Race & Ethnicity List. Note: Changes to allowable selections in the AIAN section only affect the number of associated values/codes that appear in the <race_ethnic_full> field. No change has been made to that field length or any race/ethnicity field length. | SB38 |
Other American Indian/Alaska Native | <race_aian_other_description> | text | New field in 2024. If populated, stores value=420 in <race_ethnic_full> | SB38 |
Some additional notes:
The AIAN group continues to map to <race_group>=(16).
Each new tribe/ethnicity has been assigned a value (code) for the existing <race_ethnic_full> field (maps to SB38).
The bulk of new tribes being added are national tribes (aligned to the Federal Register of Indian Entities Recognized), while the existing AIAN tribes (in place now in SB38) are mostly California AIAN entities.
| Info |
|---|
For complete data element specifications, see the CCCApply Standard & Noncredit Application Data Dictionary (v.2024.3 or later). |
Data Access & Delivery
As new features and functionality are developed for CCCApply and other systemwide technology applications, it is necessary for colleges to upgrade their existing Superglue College Adaptor schema to the version capable of delivering the new enhancements and data fields. This release includes a new data field that requires such an update. To get the latest College Adaptor schema version, please contact your College Experience Manager at Enabling Services for assistance.
| Note |
|---|
Superglue for Apply: This release requires a schema version update for the College Adaptor. Please contact your College Experience Manager through the CCCTC Enabling Services to expedite this process. |
Data Warehouse Access
All new and existing data fields are stored in the CCC Data Warehouse and can be accessed directly through Data Warehouse Direct Connect or, for authorized staff, through the Data Warehouse Report Server.
| Panel | ||
|---|---|---|
| ||
CCCApply Admin Tools |
In Progress Applications
There will be no database value mappings for In Progress applications. If an application is paused by the applicant after selecting one of the deprecated AIAN tribe names,the selection will fail validation upon submisison and the student will have to the Demographics page to either repeat their selection or click Continue to resave the page.
Documentation
Document | Link | Format | Last Update |
|---|---|---|---|
CCCApply Standard & Noncredit Application Data Dictionary | Pilot release 4.05.24 | ||
CC Promise Grant Online Application Data Dictionary | Pilot release 4.05.24 | ||
2024 CCCApply AIAN Race & Ethnicities List | Google Sheet | ||
2024 Complete CCCApply Race & Ethnicities List | Google Sheet | ||
COMIS SB29 | Online / PDF | ||
COMIS SB38 | Online / PDF |