From OPENAPPLY-9891
Update the Existing AIAN Group List in CCCApply
Maintain all existing race_ethnic_full values - regardless of the changes noted below
Discontinue use (remove from display) of the following existing tribes/ethnicities from displaying in the American Indian/Alaska Native group in the Race/Ethnicity section.
KEEP their existing <race_ethnic_full> db field values/codes.At submission, if one of the deprecated codes is still present then the application will fail validation and the user will have to return to the Demographics page to re-enter codes.
At navigating to the Demographics page, if one of the deprecated codes is still present then the application, then the entry will not appear in the “Your Selected Tribe(s)” list.
Existing AIAN Tribe Name | Existing | Change |
|---|---|---|
Aztec or Mixtec | 304 | Discontinue display in application(s) - keep value in DB |
Sheep Ranch Rancheria of Me-Wuk Indians | 394 | Discontinue display in application(s) - keep value in DB |
Sioux | 397 | Discontinue display in application(s) - keep value in DB |
Upper Lake Band of Pomo Indians | 410 | Discontinue display in application(s) - keep value in DB |
Zapotec | 417 | Discontinue display in application(s) - keep value in DB |
Other American Indian | 418 | Discontinue display in application(s) - keep value in DB. |
Other Alaska Native | 419 | Discontinue display in application(s) - keep value in DB. |
These existing tribe names need to be updated KEEP their existing db values in <race_ethnic_full>:
The following existing Tribe names should be updated to align to the Federal Register of Recognized Indian Entities.
Existing Tribe Name | Existing DB Value | Change/Update Name to… |
|---|---|---|
Bishop Paiute Tribe (previously listed as Paiute-Shoshone Indians of the Bishop Community of the Bishop Colony, California) | 311 | Bishop Paiute Tribe |
Cabazon Band of Mission Indians, California | 315 | Cabazon Band of Cahuilla Indians (previously listed as Cabazon Band of Mission Indians, California) |
Cahto Indian Tribe of the Laytonville Rancheria | 318 | Cahto Tribe of the Laytonville Rancheria |
Cherokee | 325 | Cherokee Nation |
Chippewa | 327 | Chippewa Cree Indians of the Rocky Boy's Reservation, Montana |
Colorado River Indian Tribes of the Colorado River Indian Reservation (Arizona and California) | 330 | Colorado River Indian Tribes of the Colorado River Indian Reservation, Arizona and California |
Cortina Indian Rancheria of Wintun Indians of California | 331 | Kletsel Dehe Wintun Nation of the Cortina Rancheria (previously listed as Kletsel Dehe Band of Wintun Indians) |
Death Valley Timbi-Sha Shoshone Tribe | 333 | Timbisha Shoshone Tribe [previously listed as Death Valley Timbi-sha Shoshone] |
Dry Creek Rancheria of Pomo Indians | 334 | Dry Creek Rancheria Band of Pomo Indians, California |
Fort Mojave Indian Tribe (Arizona, California and Nevada) | 342 | Fort Mojave Indian Tribe of Arizona, California and Nevada |
Morongo Band of Cahuilla Mission Indians, California | 367 | Morongo Band of Mission Indians, California |
Navajo | 368 | Navajo Nation, Arizona, New Mexico & Utah |
Pala Band of Luiseño Mission Indians of the Pala Reservation | 370 | Pala Band of Mission Indians [previously listed as Pala Band of Luiseno Mission Indians of the Pala Reservation, California] |
Pechanga Band of Luiseño Mission Indians | 373 | Pechanga Band of Indians (previously listed as Pechanga Band of Luiseno Mission Indians of the Pechanga Reservation, California) |
Potter Valley Tribe (formerly the Potter Valley Rancheria of Pomo Indians of California) | 377 | Potter Valley Tribe, California |
San Manual Band of Serrano Mission Indians of the San Maual Reservation | 387 | Yuhaaviatam of San Manuel Nation (previously listed as San Manuel Band of Mission Indians, California) |
Santa Rosa Band of Cahuilla Indians (formerly the Santa Rosa Band of Cahuilla Mission Indians of the Santa Rosa Reservation) | 390 | Santa Rosa Band of Cahuilla Indians, California (formerly the Santa Rosa Band of Cahuilla Mission Indians of the Santa Rosa Reservation) |
Lipay Nation of Santa Ysabel (Previously listed as the Santa Ysabel Band of Diegueño Mission Indians of the Santa Ysabel Reservation) | 392 | Iipay Nation of Santa Ysabel, California [previously listed as Santa Ysabel Band of Diegueno Mission Indians of the Santa Ysabel Reservation] |
Sycuan Band of the Kumeyaay Nation (formerly the Sycuan Band of Diegueno Mission Indians of California) | 401 | Sycuan Band of the Kumeyaay Nation |
Washoe Tribe (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community and Washoe Ranches) (California and Nevada) | 412 | Washoe Tribe of Nevada & California (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community, & Washoe Ranches) |
Wiyot Tribe (formerly the Table Bluff Reservation-Wiyot Tribe) | 414 | Wiyot Tribe, California |
Table Mountain Rancheria of California | 402 | Table Mountain Rancheria |
Additional Updates to Existing Tribal Names
Make all other name changes in the list of existing Tribe names (approximately 54) with the word “, California” at the end of each name. These are identified and itemized on 2024: Updated Tribal Affiliation List
(Example: Big Lagoon Rancheria - should be updated to: Big Lagoon Rancheria, California)
Add New Tribes/Values to Apply
(Per list submitted from AIAN group and cross-checked with federal list, add all remaining/missing tribes/nations from the Federal Register of Recognized Indian Entities to our existing ethnicities in CCCApply). 2024: Updated Tribal Affiliation List
Add tribal names and assign new codes/values to the existing field: <race_ethnic_full> in CCCApply Standard/Noncredit db. The displayed names should appear in alphabetical order by default in the (new UI search/display functionality) when the student selects the “American Indian/Alaskan Native” race group in the Race/Ethnicity section.
NOTE: The approved Tribe name (and proper spellings) are listed in Column F. These full names/spelling should be displayed In the application.
See 2024: Updated Tribal Affiliation List :: FINAL FedRecognizedTribes :: column FNew Tribe values should be added to the <race_ethnic_full> field
No change to the existing format (comma separated codes) same field length, etc.
Add new tribe that is combination of deprecated (per discussion 2/2724):
Other American Indian / Other Alaska N. tive | 420 | Other American Indian / Other Alaska Native | New, used to identify Write In name |
Tribe 420 will not appear on valid values as possible selection, but will added to the race_ethnic_full behind the scenes (code) when the user enters a manual write-in/custom tribal name.
Reference: Data Field Information
Add all new tribal codes/values to the existing database column named <race_ethnic_full> which saves all the values the user selects in the UI.
All new Tribe codes should follow the existing formats for the American Indian/Alaskan Native sections in:
Name/Field | Change / Action |
|---|---|
Race Ethnic Full <race_ethnic_full> | No expected change to the max. expected field width/length Notes: This is the column race_ethnic_full that stores all new and existing CSV separated values for all the ethnicity selections (both the higher level race groups and the ethnicity sub groups). 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: No change expected. 805 characters (201 * 3 character long values + 200 commas + 2 surrounding quote marks for CSV delimiting in the output format) |
Race Group <race_group> | No changes to this field. This field was intentionally left unchanged. Example Format: Apply: "04, 05, 08, 09, 14, 15, 17, 19, 20, 21", 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 Ethnic <race_ethnic> INTL: | No changes to this field. All new & existing Tribe codes continue to map to <race_ethnic>=position16 Tthis field was intentionally left unchanged Example Format: YNYNNNNYNNNNNNNNNYNNN Maximum Expected Width: 22 characters (unchanged) (22 character long string) |
Note: Ensure that the data stored in "hispanic", "race_group", and "race_ethnic" (Apply)/"race_ethnicity" (Intl) remains unchanged.
NOTE: Until COMIS SB39 is updated to capture all new db values, all new codes added to <race_ethnic_full> will map to Other American Indian or Other Alaskan Native on the college’s side for <race_ethnic>. They will get all the new 3-digit codes/values we are adding in <race_ethnic_full> but they will have to manually map these to existing Other positions in SB39.
Database Storage Scheme
Leave the database storage scheme the same for race_group, race_ethnic, hispanic, race_ethnic_full
Store the mapped record and exact format that is in place today so that colleges don't have to adjust their imports and so that MIS can still get the format that is in place today.
Keep all existing codes (db values) for existing Tribes; assign and add new codes for each new Tribe being added (see full list)
No changes are being made to existing race/ethnicity data fields/formats - other than updating for list of names and codes.
Update DED with new and updated Tribes and data codes/values