| Info |
|---|
See previous implementation change docs for this section: INTERNAL = /wiki/spaces/OPENAPPLY/pages/692486171and EXTERNAL change request = 2018-18R: New Race & Ethnicity Section Implementation 2018 |
| 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
Expand and Update the AIAN
TribeTribal List
in CCCApplyThe American Indian /or Alaska Natives race (AIAN) group is one of the upper-level race groups listed in the Race & Ethnicity section in CCCApply. As with Like the other race groups in the application, the American Indian /or Alaska Natives (AIAN) group includes a number of sub-group entities , - or ethnicities , - that display if displays when the upper-level AIAN group is selected by the applicant. 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).
| Panel | ||
|---|---|---|
| ||
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).
User Interface
EnhancementsEnhancement for the 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.
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.
1..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.
Simple User Flow: “Enter your tribe’s name”
If the applicant cannot locate their tribe using the “Search for your tribe:” process, 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.
Can’t find your tribe?
Click the “Add Your Tribe” button.
| Info |
|---|
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”
DataField
Implement a new Other AIAN: Write-In field to capture tribes that aren’t in the listFor applicants who cannot find their tribe in the new Search for your tribe” list, a new “write-in” field has been added to the CCCApply database. The text input field is a
This optional field appears if the applicant clicks on the “Cant find your tribe?” link in the new AIAN search modal.
CHANGES TO THE UI & User Flow
Updated & 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).
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). |
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.
What’s changing in this release?
Race/Ethnicity fields breakdown
New AIAN Write-In field
| Note |
|---|
Table Legend Race Group Name: This column depicts only existing race group names |
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.
New Other AIAN “Write-In” Field
Field Name: <race_aian_other_description>
Glue Name: <raceAianOtherDescription>