Release 2024.CCCData.2.7.0

Schedule

CCCData 2.7.0 will be deployed:

  • To pilot environment: February 13, 2024

  • To production: February 27, 2024

Release Summary

  • Support for MyPath data in CCC Data Warehouse

  • Bi-directional fraud data in the DWRS


Support for MyPath data in CCC Data Warehouse

Data from MyPath was added to the CCC Data Warehouse. As with other data in the CCC Data Warehouse, MyPath data is segmented by MIS code to assure that colleges may access data associated with their college, while districts may access data associated with their colleges.

MyPath data consists of the following tables:

  • Advisor card reminder data

  • Advisor usage data

  • Audit table

advisorcard_reminders Table

reminder2statustime

TIMESTAMP

reminder3status

VARCHAR

miscode

VARCHAR

reminder3statustime

TIMESTAMP

reminder1status

VARCHAR

reminder1statustime

TIMESTAMP

id

bigint

completed_timestamp

TIMESTAMP

reminder2status

VARCHAR

advisorcard_usage Table

id

bigint

state

VARCHAR

timestamp

TIMESTAMP

username

VARCHAR

createdby

VARCHAR

miscode

VARCHAR

card_title

VARCHAR

task_title

VARCHAR

card_order

INTEGER

task_order

INTEGER

has_reminder

BOOLEAN

audit Table

event_type

varchar

miscode

varchar

created_timestamp

timestamp

originator

varchar

target

varchar


Bi-directional Fraud Data in CCC Data Warehouse Report

Support for bi-directional fraud data in the CCC Data Warehouse. This supports ad-hoc reporting of fraud reports made by a college or district to the CCC Tech Center.

This includes the MIS code of the reporting college (or district), CCCID and AppID reported, and date/time stamp of the report.


Documentation