| Warning |
|---|
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. |
| Note |
|---|
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. |
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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…
| Info |
|---|
Student Parents with Dependents in CCPG and CCCApply |
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
more
CCPG
XXXX
CCCApply
XXX
| Note |
|---|
Note: CCPG question includes dates that pertain to the student parent’s response. The CCCApply question does not include the dates. |
2.
...
Add new 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
CCPG
XXX
CCCApply
XXXXX
CCPG
XXX
CCCApply
XXX
| Info |
|---|
For more information about the new Number of Dependents data fields, see section below. |
3. New Fields
...
Data Fields & Data Delivery
In this section:
New Data Fields: Number of Dependents Under/Over 18
Two new data fields have been added to both the CC Promise Grant database and the Apply submitted applications database. These fields have the field data specifications; they are just stored in different databases.
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.
Number of Dependents Under 18
Dictionary Name
...
: Number of Dependents Under 18 Yrs
Data Element: <student_deps_under18>
Format/Type:
Notes: Conditional
Number of Dependents Over 18
Dictionary Name: Number of Dependents Under 18 Yrs
Data Element:
...
<student_
...
deps_
...
under18>
Format/Type:
...
Notes: Conditional
...
| Panel | ||
|---|---|---|
| ||
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.
| Info |
|---|
For complete data element specifications, see the CCCApply Standard & Noncredit Application Data Dictionary (v.2024.3 or later). |
...
New Data Field: Other AIAN Name
...
Data
...
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.
This field was intentionally left unchanged.
...
Race Ethnicity
...
<race_ethnic>
...
Example:
YNYNNNNYNNNNNNNNNYNNN
...
22 characters (unchanged) (22 character long string)
...
No change to this existing field, format, and values.
Existing YN values and formats have not changed.
This is a backend field used for COMIS reporting only.
This field was intentionally left unchanged (until COMIS changes are specified).
See COMIS SB29 for COMIS data element specs.
...
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:
...
Field length remains unchanged, thus responses will be truncated if the user selects every race group and ethnicity available.
...
See the CCCApply DED (v.2024.3 or later) for complete data field specifications.
...
Other AIAN Name
...
<race_aian_other_
description>
...
Text, varying character
...
1024
...
New data field (2024):
Conditional display; Allows Null
Optional response;
Stores up to five tribe names, comma separated;
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.
...
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.
| Note |
|---|
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.
...
Documentation
Document | Link | Doc Version | Format | Last Update |
|---|---|---|---|---|
2024-2025 CC Promise Grant Online Application Data Dictionary | 2024-2025 | |||
CCCApply Standard & Noncredit Application Data Dictionary |
...
...
2024 CCCApply AIAN Race & Ethnicities List
...
Google Sheet
...
2024 Complete CCCApply Race & Ethnicities List
...
2024 Complete CCCApply Race & Ethnicities List
...
Google Sheet
...
COMIS SB29
...
...
Online / PDF
...
COMIS SB38
...
SB38: STUDENT-EXPANDED-ETHNICITY
...
v.2024.3 | ||||