Release Summary
SupportSupport for Canvas Data 2 in CCC Data WarehouseSupport for MyPath data in CCC Data Warehouse
Support for Canvas Data 2 in CCC Data Warehouse
With the release of CCC Data 2.6 Canvas data (utilizing the Canvas Data 2 API) will be available in the CCC Data Warehouse. In order to have Canvas data included in the CCC Data Warehouse, the college or district must opt-in by contacting their College Relationship Manager and providing their Canvas Data API key to the CCC Technology Center.
Canvas Data 2 supports 89 unique datasets, including Learning Outcomes data; the full set of data supported in Canvas Data 2 are detailed in the data dictionary provided by Instructure. Once migrated to the CCC Data Warehouse, Canvas data may be accessed by college or district researchers through a direct (ODBC/JDBC) connection to the CCC Data Warehouse secured through a site-to-site VPN.
The deployment of Canvas Data 2 will replace support for the prior Canvas Data API which Instructure intends to deprecate by the end of the calendar year.
Upon the release of CCC Data 2.6, pilot testing will be conducted on support for Canvas Data 2 in the CCC Data Warehouse. Upon the conclusion of the pilot testing the CCC Tech Center will notify colleges and districts of the option to include their Canvas data in the CCC Data Warehouse through Canvas Data 2.
Notice: Action Required for Canvas Support
| Panel | ||
|---|---|---|
| ||
Districts or colleges may opt-in to have their Canvas data supported in the CCC Data Warehouse by contacting their College Relationship Manager at crms@ccctechcenter.org. |
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 |
Documentation
Instructure has made the following data dictionary available for Canvas Data 2 (v. 4.2.9).
Other related documentation:
CCCApply Data DictionariesBi-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.