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 page is to provide an overview of the changes made to the Student Parent questions in CC Promise Grant and CCCApply applications.
Business Need
To align with the changes mandated in the 2024-2025 CC Promise Grant application, the system will collect more information from self-identified Student Parents by identifying the number of their dependents under and over the age of 18 years. This change will help…
Student Parents with Dependents in CCPG and CCCApply
Both Applications more info, more info, maybre.
Changes Summary
Update the existing Student Parent question language for consistency between the applications
Implement new conditional question and ability to capture total number of dependents from student parents
Add new data fields for collecting number of dependents under and over age 18
Ensure new data fields are added to all downstream delivery and reporting systems
1. Update Student Parent Questions Text
The Student Parent questions added in 2023 have been updated
Note: CCPG question includes dates that pertain to the student parent’s response. The CCCApply question does not include the dates.
2. Implement conditional question to collect Number of Dependents
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
For more information about the new Number of Dependents data fields, see section below.
3. New Fields
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.
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 |