Release 2023.SuperGlue.4.7.0

Schedule

Release 2023.SuperGlue.4.7.0 deploys:

  • To pilot environment: May 4, 2023

  • To production: May 18, 2023

A schema version update is required to receive the data delivered in this release via the SuperGlue College Adaptor. See User Implementation below for more information.

Release Summary

  • New Student Parent data field added to SuperGlue for Apply delivery has been updated to deliver the data from the new Student Parent with Dependent Children questions that are being added to the CC Promise Grant Online Application and the CCCApply Standard & Noncredit Application (CCCApply release v.6.13).

  • More previously released OpenCCC Account 2.0 fields are now available via the College Adaptor to the CC Promise Grant & the CCCApply International staging tables. See list of fields added below.

  • Data integration with Banner, Colleague, PeopleSoft, and MS SqL staging tables


New Student Parent Data Available for CCCApply & CC Promise Grant Applications

Two new questions have been added to the CCCApply data sets supporting Assembly Bill 2881: Student Parents With Dependents Under 18 YRS. Data specifications for these new questions can be found in the CCCApply Standard & Noncredit Data Dictionary, and the 2023-2024 CC Promise Grant Application data dictionary.

These two new data fields have been added to the CCC Data Warehouse products and services, and are now deliverable via the College Adaptor to college staging tables, as well as Banner, Colleague, PeopleSoft and MS SqL platforms.

High-level specs for the new Student Parent data fields are shown below;

Application

Data Element

Type

Application

Data Element

Type

CCCApply Standard/Noncredit

student_parent

boolean

CC Promise Grant Application

student_parent

boolean

Full data specifications for the new fields, including the form definitions for the new questions, are documented in the CCCApply v.6.13 release notes, as well as the corresponding data dictionaries.

The CCCApply 6.13 version was released to Pilot environment on May 23, 2023. The production release is scheduled for Tuesday, May 30, 2023. See the CCCApply v.6.13 Release Notes for details.

 

More Previously Released Account Fields Are Delivered

The SuperGlue product team continues to backfill the delivery of OpenCCC Account 2.0 data fields for the CCCApply International Application and the CC Promise Grant Online Applications that had not been delivered at the time of the initial release. The College Adaptor will now deliver the following fields to college staging tables:

Application

Data Element / Type

Application

Data Element / Type

CC Promise Grant Application

  • accepted_terms (boolean)

  • accepted_terms_timestamp (date timestamp)

  • ip_address_at_account_creation (character varying 40)

  • ip_address_at_app_creation (character varying 40)

  • phone_type (character varying 10)

CCCApply International Application

  • accepted_terms (boolean)

  • accepted_terms_timestamp (date timestamp)

  • ip_address_at_account_creation (character varying 40)

  • ip_address_at_app_creation (character varying 40)

  • phone_type (character varying 10)

Note: Fields are now also accessible via the Data Warehouse Report Server and Data Warehouse Direct Connect.


User Implementation

SuperGlue releases are backwards compatible; however each time new data fields are added to one of the CCC Data sets the SuperGlue College Adaptor will need to be updated with the latest schema version to receive these additional fields. To update your schema version, please contact the CCCTC Enabling Services implementation team at crms@ccctechcenter.org.

For other help, please visit our online support community http://CCCTechnology.info or contact CCCTC Support Services directly at staffsupportccctc@openccc.zendesk.com.


Documentation

All data field descriptions and technical specifications have been added to the CCCApply data dictionaries, published here: CCCApply Data Dictionaries.