CCCData v3.2.0 includes the following updates:

• Added the atriculation_counts table to aid in filtering for reports.

• The Snapshot database now refreshes from T1 instead of the datalake to improve performance.

• Several updates were made to enable ZeroETL, which enables queries to run in near real-time.

• A new schema deployment was implemented to enhance our migration tools to better communicate with the Redshift database.

• Made a change to the Courses table in the COCI database to accommodate changes happening with the COCI 4.4.2 release.

• Five new views have been added to the Student Journey database that returns the resolved Apply MIS association for each (ccc_id, student_key) and identifies the strongest match criteria so that reporting and pipelines can rely on a single consistent mapping. This replaces old methods of correlating student data through multiple joins such as firstname+sssn4+cccid or birthdate+cccid, and helps identify fraudulent accounts. The new views are titled:

  • correlation__birthdate_ccid_vw

  • correlation__birthdate_ssn_vw

  • correlation__firstname_ccid_vw

  • correlation__firstname_ssn4_ccid_vw

  • correlation__ssn4_ccid_vw
    For more information on the Student Correlation Views, see CCC Data Warehouse - Student Journey User Guide | Using the Student Correlation ViewsPreview.
    To learn how to create a direct connection to the data warehouse, see CCC Data Warehouse - Direct Access User GuidePreview.

• There are no known issues in this release.

• CCC Data Warehouse - Student Journey User Guide | Using the Student Correlation ViewsPreview

• CCC Data Warehouse - Direct Access User GuidePreview

• COCI 4.4.2 Release Notes (Draft)Preview