...
Note |
---|
...
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: The new Number of Dependents question & data fieldswill appear in both the 2024-2025California College Promise Grant Online Application and the CCCApply Standard & Noncredit Application. |
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Business Need
To align with the changes mandated in the 2024-2025
...
California College 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 |
...
The changes summarized below pertain to an enhancement to the new Student Parent question that was added last fall 2023 in both the CC Promise Grant online application and the CCCApply Standard/Noncredit application. Other than the specific time frame (annual date range) that data is being collected for in the CC Promise Grant application, the new Number of Dependents question and data fields being implemented in this release are basically identical in both applications. The data elements are documented in the data dictionaries for both applications. |
Changes Summary
Update and match the existing Student Parent question
...
text in the CCCApply and California College Promise Grant applications, for consistency
...
purposes
Add a new conditional question
...
in both applications that collects the total number of dependents from student parents by age group
Add two new data fields
...
to each application to store the number of dependents under
...
/over age 18
...
Add new data fields
...
to all downstream admin, reporting, and delivery
...
systems
1. Update the Student Parent
...
The Student Parent questions added in 2023 have been updated
Note |
---|
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
...
Info |
---|
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;
...
bgColor | #FFFAE6 |
---|
...
Question in the California College Promise Grant and CCCApply Applications
This is a simple update to ensure the language in both Student Parent questions are consistent. Other than the date range that is specified - and updated annually - in the CC Promise Grant application, both questions should match.
CC Promise Grant Application
Panel | ||
---|---|---|
| ||
Dates specified in the CC Promise Grant application pertain to the 2024-2025 CCPG academic year. |
CCCApply Standard & Noncredit Application
2. Add new conditional display question in both applications to collect the number of dependents by age group
If the applicant has identified as a student parent with dependents (i.e., the student has answered Yes to the Student Parent question described above) then two new menus will appear to collect the number of dependents in two age groups: 1) dependents age 17 years and younger, and 2) dependents age 18 years and older. If displayed the applicant will be required to make a selection in each age group, otherwise an error message will display.
Info |
---|
Note: Other than the annual date range specified in the CC Promise Grant application, the Number of Dependents question and data being collected is basically identical in both applications. |
CC Promise Grant Application
In the online application, the Student Parent question appears in the Dependency section. If the applicant selects Yes both Number of Dependents fields appear.
IIf displayed, a response is required for each Number of Dependents dropdown menu.
CCCApply Standard & Noncredit Application
In the CCCApply Standard application, the Student Parent question appears on the Demographic Information page under the Dependents heading. If the applicant selects Yes both Number of Dependents fields appear.
If displayed, a response is required for each Number of Dependents dropdown menu.
Panel | ||
---|---|---|
| ||
Per COMIS SB39, if the number of dependents in either age group should exceed 9, the applicant should select “9+”. |
Info |
---|
For data field specifications around the new Number of Dependents fields, see the Data Fields & Data Deliverysection below. |
Data Fields & Data Delivery
In this section:
...
...
Impact on Existing Race & Ethnicity Fields
...
New Data Fields: Number of Dependents
Along with the Number of Dependents question enhancement, two new data fields have been added to the
...
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>
...
CC Promise Grant (BOGFW) and the CCCApply submitted applications databases. Both sets of fields have the same data specifications and each set is delivered separately from either or both application databases. As explained
Number of Dependents Under Age 18
Dictionary Name: Number of Dependents Under Age 18 (Note: 17 yrs and younger)
Data Element: <student_deps_under18>
Format/Type: menu selection / smallint
Display Conditions: Conditional / Required if Displayed
Number of Dependents Age 18 & Over
Dictionary Name: Number of Dependents Age 18 & Older
Data Element: <student_deps_18over>
Format/Type: menu selection / smallint
Display Conditions: Conditional / Required if Displayed
Note |
---|
Important: New data fields reequires a schema version update for your College Adaptor. Contact your College Experience Manager at Enabling Services to upgrade today. |
Info |
---|
For complete data |
...
field specifications, |
...
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.
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.
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.
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.
Testing & Implementation
Documentation
...
Document
...
Link
...
Format
...
Last Update
...
2024 Complete CCCApply Race & Ethnicities List
...
2024 Complete CCCApply Race & Ethnicities List
...
Google Sheet
...
COMIS SB29
...
...
Online / PDF
...
COMIS SB38
...
SB38: STUDENT-EXPANDED-ETHNICITY
...
get the latest application data dictionaries here: CCCApply Data Dictionaries. |
Data Access & Delivery
As new features and functionality are developed for CCCApply and other systemwide technology applications, it is necessary for colleges to upgrade their existing Superglue College Adaptor schema to the version capable of delivering the new enhancements and data fields. This release includes new data fields that require such an update.
To get the latest College Adaptor schema version, please contact your College Experience Manager at Enabling Services for assistance.
Panel | ||
---|---|---|
| ||
CCCApply Admin Tools |
Data Warehouse Access
All new and existing data fields are stored in the CCC Data Warehouse and can be accessed directly through Data Warehouse Direct Access Connect or, for authorized staff, through the Data Warehouse Report Server.
Documentation
Document | Link | Doc Version | Format | Last Update |
---|---|---|---|---|
2024-2025 CC Promise Grant Online Application Data Dictionary | 2024-2025 | March 2024 - Release v.6.14.4 | ||
CCCApply Standard & Noncredit Application Data Dictionary |
...
...
2024 CCCApply AIAN Race & Ethnicities List
...
Google Sheet
v.2024.3 | March 2024 - Release v.6.14.4 | |||
SB39 - STUDENT-DEPENDENTS | Summer 2023 |