This UAT Guide is designed to help colleges understand the changes made to the Race & Ethnicity section in CCCApply implemented in December 2018.
Colleges that want to start downloading the new ethnicity-ancestry responses immediately following the release, should use this guide to add the new data field to their Pilot download file and run a test download job in preparation of the Production release. For release information, please see the Release 6.3.0 Summary Notes.
For detailed information on the approved change request and tech specifications, see 2018-18R: New Race & Ethnicity Implementation 2018. |
The new Race & Ethnicity Implementation is made up of user interface changes (new layout) and a lot of new race and ethnicity response/value checkboxes that display based on the user's selections.
The new values are collected in one new data field ('race_ethnic_full') added to the database to capture all the new race group and ethnicity values; however, we have purposely designed this addition to be seamlessly backwards compatible, which means the field is optional and colleges do not need to make any adjustments to their downloads unless they opt to add the new data field when they are ready.
The objectives for college user testing are:
Colleges that want to collect the new data should add the new Race Ethnicity Full data field to their download files and run (replace) the new transfer-client.jar (v.6.3.0. |
Participating Colleges
College user acceptance testing will be supported across the three main SIS systems. Support is also available for colleges with custom SIS systems. Colleges outreach will begin on Monday, November 19, to solicit volunteer IT and Admissions staff members to conduct testing. Reminder, no changes were made to the existing data fields; therefore colleges are not required to take any action relative to the new implementation.
For the new Race & Ethnicity Implementation 2018, the goals for pre-release user testing are:
All Changes Are Backwards Compatible - No Actions Required: All the front-end changes (user interface upgrades, race/ethnicity layout) and all back-end changes (194 new race/ethnicity response options and new optional "Full" data field) being implemented in this release are designed to be seamlessly backwards compatible. Admissions, Financial Aid, and IT staff can rest assured there is no action required by the colleges in this release. |
Follow the steps below for successful user acceptance testing: add the new Race & Ethnicity Full data field to your CCCApply Format Definitions XML file for both Pilot and Production environments.
Repeat this process for your Production application after the production release on December 7, 2018. |
User acceptance testing and implementation support for colleges in the Pilot Environment can begin on November 20 upon the completion of the Pilot deployment activities.
For detailed data specifications, please refer to the corresponding application Data Dictionary, as well as the breakdown of change specs in: 2018-18R: New Race & Ethnicity Implementation 2018.
Data Field Name | Type | Data Element | Format / Length | Downloadable | Report Center / Admin Rules | Application |
Hispanic / Latino | Existing, unchanged | hispanic | boolean Yes / No / X | Yes | Coming Soon | CCCApply Standard & International |
Race Group | Existing, unchanged | race_group | CSV string | Yes | Coming Soon | CCCApply Standard & International |
Race Ethnicity | Existing, unchanged | race_ethnic | bpchar, 22 | Yes | Coming Soon | CCCApply Standard Only |
Race Ethnicity | Existing, unchanged | race_ethnicity | bpchar, 22 | Yes | Coming Soon | CCCApply International Only |
Race Ethnicity Full | NEW | race_ethnic_full | CSV string, no spaces | Yes (Must be added) | Coming Soon | CCCApply Standard & International |
Race Ethnicity Full | NEW - SuperGlue | raceEthnicFull | CSV string | Yes (Must be added) | Coming Soon | CCCApply Standard & International |
Race Ethnicity Full Data in Glue for Apply The new Race & Ethnicity values included in this release will be passed directly to colleges using the Glue for Apply feature. However, the new full Race & Ethnicity field is not yet available through Glue for Apply at this time. An upcoming release of the SuperGlue College Adaptor will include this new data. |
Data Field: hispanic
Data Element: <hispanic>
Notes: No changes, this field is a boolean true/false field that continues to work as in previous version
Example Format: boolean (true/false/null)
Data Element: <race_group>
Notes: No changes, this field was intentionally left unchanged
Example Format: Apply: "04, 05, 08, 09, 14, 15, 17, 19, 20, 21", International: "04,05,08,09,14,15,17,19,20,21" (note lack of spaces for Intl)
Maximum Expected Width: 78 characters (unchanged) (20 * 2 character long values + 18 commas + 18 spaces + 2 surrounding quote marks for CSV delimiting in the output format)
Data Element: <race_ethnic> (Apply) / <race_ethnicity> (International)
Notes: No changes, this field was intentionally left unchanged
Example Format: YNYNNNNYNNNNNNNNNYNNN
Maximum Expected Width: 22 characters (unchanged) (22 character long string)
Data Element: <race_ethnic_full>
Notes: race_ethnic_full is a new field that will store the CSV separated values for all the ethnicity section selections for both the higher level ethnic groups and the associated sub groups 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: 804 characters (201 * 3 character long values + 199 commas + 2 surrounding quote marks for CSV delimiting in the output format)
For SuperGlue colleges, the new race_ethnic_full data element is called "raceEthnicFull"
To download all the new Race & Ethnicity Full response values in your existing CCCApply download files, you must add the new <race_ethnic_full> field and update the (transfer-client.jar) file for this release (Release 6.3.0).
Please be sure to backup your files before downloading new ones. |
We recommend adding the fields and updating the Download Client Transfer file in the Pilot environment first before updating your Production Download Client with these fields.
In your installed Pilot Download Client directory, replace the following files:
Follow the instructions in the Pilot CCCApply Download Client User Guide.
Technical specifications for the Race Ethnicity Full data field can be found in:
Change Specification: 2018-18R: New Race & Ethnicity Implementation 2018
Data Dictionaries: CCCApply Standard Application Data Dictionary v.2018.2
UAT: Race & Ethnicity Implementation 2018
To update your Download Client Transfer file for the Production environment, the process is the same as the Pilot environment update. The same jar file is used for both environment.
In your installed Production Download Client directory, replace the following files:
Follow the instructions in the CCCApply Download Client User Guide.
Technical data element specifications for the Race & Ethnicity data fields are listed in the CCCApply Standard Application Data Dictionary V.2018.2