Draft: This document is currently a work-in-progress. Following Go/No Go approval, a formal notice will be sent to viewers and editors. Thank you.
This intend of this document is to provide colleges with a high-level summary of the upcoming 2024 AIAN List Expansion in the Race & Ethnicity section.
Business Need
In cooperation with the CCC Chancellor’s Office, the current list of American Indian/Alaska Natives (AIAN) tribe affiliations in CCCApply is being expanded to meet the full Federal Register of Indian Entities Recognized which contains California and national tribes.
In order to accommodate the expansion of over 450 names to our existing list of AIAN options, the Race & Ethnicity section of the CCCApply Standard application is being enhanced to include a new tribe ‘search and select’ modal and a new optional Other American Indian/Alaska Native “write-in” option and data field to capture up to five tribe names that may not appear in the expanded list.
American Indian or Alaska Native (AIAN)
According to COMIS, a person having origins in any of the original peoples of North and South America (including Central America), and who maintains a tribal affiliation or community attachment.
About the AIAN Expansion
The 2024 Race & Ethnicities enhancement is limited to the AIAN race group (category) and ethnicities (sub-category) in CCCApply. No other race group is being affected by this implementation and 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.
The 2024 AIAN expansion enhancement is being implemented in the CCCApply Standard & Noncredit application first. 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;
Enhance the user interface with a new “search and select” feature, exclusively for the expanded AIAN tribe list;
Implement a new Other American Indian/Alaska Native "write-in" option and data field. capable of capturing up to five “other AIAN” tribe names that may not appear in the 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 List provides 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).
Legends: A mapping legend is provided for each of the updated 2004 Race & Ethnicities lists in each worksheet.
2024 Complete CCCApply Race & Ethnicities List
The 2024 Complete CCCApply Race & Ethnicities List provides 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. 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: The user interface changes implemented pertain to the AIAN race group only. No changes have been made to the display and functionality of the other upper-level race groups, nor the display of their sub-group ethnicities. Multi-ethnic applicants are still able to select multiple race groups and ethnic subgroups, as needed. Furthermore, any 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.
3. New “Other American Indian / Alaska Native” Write-In Field
If a user cannot find their tribe in the new expanded AIAN list, they have the option to identify - or “write-in” - up to five other tribe names and submit them with their application. This new field appears as a text input box if the user clicks on the “Cant find your tribe?” link just below the search modal.
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.
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
Add a new write-in "other AIAN" option that allows the applicant to submit up to five other tribe names that do not appear in the newly expanded list.
This new "write-in" option is also a new data field:
Name: Other American Indian / Alaska Native
Data Field: <race_aian_other_description> - varying text string 1024
Included in the AIAN race group (16) and <race_ethnic_full>=420
Note: This name will not appear to the user, but the backend will deliver the text string with the tribe name(s) and deliver value 420 for the <race_ethnic_full> field.
See more data field details in the Data Fields & Data Delivery section below.
Simple User Flow: Other AIAN “Write-In” 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
Impact on Existing Race & Ethnicity Fields
The 2024 AIAN Expansion includes 464 new tribes/ethnicities that have been added to the existing American Indian/Alaska Natives (AIAN) race group in CCCApply. Each new ethnicity has been assigned a field value (code) that will store in the Race Ethnicity Full data field <race_ethnic_full>. Below is a summary of how each of the fields map to the existing Race & Ethnicity fields. For a complete accounting, see the 2024 CCCApply AIAN Race & Ethnicity List.
Overall, the only change to an existing field is the addition of several hundred new AIAN ethnicity values to the Race Ethnicity Full field <race_ethnic_full>. No other changes will impact the existing fields.
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.
Field Name | Data Field | Value | How AIAN Tribes maps to this field… |
---|---|---|---|
Hispanic | <hispanic> | n/a | N/A. AIAN ethnicities do not map to the <hispanic> race group field. |
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 of the upper-level race group. If an individual AIAN ethnicity is selected by the student, the <race_group> value also = 16. |
Race Ethnicity | <race_ethnic> | 16 | Values for the <race_ethnic> field are strictly used for COMIS SB38 reporting. Individual AIAN ethnicities map to the upper-level race group value; in this case <race_ethnic> = 16. |
Race Ethnicity (International) | <race_ethnicity> | 16 | Values for the <race_ethnicity> field are strictly used for COMIS SB38 reporting. Individual AIAN ethnicities map to the upper-level race group value; in this case <race_ethnic> = 16. Note: This version of the field is used by the International Application only. |
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>. See all values/codes on the 2024 CCCApply AIAN Race & Ethnicity List. |
For complete data element specifications, see the CCCApply Standard & Noncredit Application Data Dictionary (v.2024.3 or later).
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, but rather it is triggered when the student clicks on the “Can’t find your tribe?” link in the list modal. If/when the applicant opts 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.
Breakdown of Race & Ethnicity Fields
Data Element | Format / Example | Maximum Expected Width | 2024 Change | |
---|---|---|---|---|
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). |
The <race_ethnic_full> field is can store up to 800 comma separated values, optionally selected by the applicant in the Race & Ethnicity section.
<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.
<race_ethnic_full> - The only reportable change is the addition of several hundred new AIAN tribe names (values/codes) which will now be included in the field output.
Data Delivery
All race & ethnicity fields will continue to be delivered to college SIS, staging tables, integrated downstream systems (CCCApply Report Center, Data Warehouse Report Server, etc.) via SuperGlue for Apply.
Colleges Using SuperGlue: 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.
In Progress Applications
There will be no database value mappings for In Progress applications. If an application is in-progress and a student made a race/ethnicity selection and their choice is in the list of obsolete values post the release, we will display a server side validation error message during the pre-submission validation that advises them of the following.
Testing & Implementation
Documentation
Document | Link | Format | Last Update |
---|---|---|---|
CCCApply Standard & Noncredit Application Data Dictionary | |||
2024 CCCApply AIAN Race & Ethnicities List | Google Sheet | ||
2024 Complete CCCApply Race & Ethnicities List | Google Sheet | ||
COMIS SB29 | Online / PDF | ||
COMIS SB38 | Online / PDF |