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 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.
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 AIAN tribal affiliation expansion is limited to the AIAN race group in the Race & Ethnicity section in CCCApply. No other race group is being impacted by this implementation and the impact on the existing race/ethnicity fields is 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.
At this time, the 2024 AIAN expansion has been implemented in the CCCApply Standard/Noncredit application only. Plans to update the International Application is scheduled for a future release.
Change Summary
Expand and update the CCCApply list of AIAN tribes in the AIAN race group
Enhance the user interface in the Race & Ethnicity section with a search modal, allowing the user to find their preferred AIAN tribe(s)
Add a new “write-in” text field to enter a tribe(s) that doesn’t appear in the expanded AIAN list
1. Update and Expand the AIAN Tribe List
The American Indian or Alaska Natives (AIAN) group is one of the 21 upper-level race groups 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-group 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 now includes 585 new and existing options, consisting of:
20 existing tribe names were updated
7 tribe names were deprecated (no longer displayed)
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 were discontinued in the application as they are no longer recognized by the federal list. The deprecated tribes names and their field values will continue to exist in the CCCApply database but will no longer be displayed as an available option in the application. 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 2024 AIAN expansion includes adding 464 new AIAN tribes added to CCCApply comes directly from the Federal Register of Indian Entities Recognized. Every new AIAN tribe/ethnicity is listed on the 2024 AIAN Race & Ethnicities List, along with its new Race Ethnic Full <race_ethnic_full> field value. For more information about the Race & Ethnicity data fields, see Data Fields & Data Delivery section 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).
Legend: A mapping legend is included in each of the 2004 Race & Ethnicities lists.
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. Enhanced 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.
Simple User Flow: Search & Select Your Tribe(s)
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”.
For more information about the AIAN “write-in” field, see New Other AIAN “Write-In” Data Field section below.
3. New Other AIAN “Write-In” Field
If a user cannot find their tribe in the newly expanded AIAN list, they also 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 AIAN Name
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;
See more data field information 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
In this section:
AIAN Data Fields & Mapping
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 AIAN Name
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 AIAN Name | <race_aian_other_ | Text, varying character | 1024 | New data field (2024):
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. However, with the expansion on
<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 |