Release Summary
Support for Canvas Data 2 in CCC Data Warehouse
Support for MyPath data in CCC Data WarehouseSupport for CAL-VET reporting in CCC Data Warehouse Report Server
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 the 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 stop support deprecate by the end of the calendar year. Canvas Data 2 supported 89 unique datasets, including learning
outcomes data; and utilizes a relational data schema instead of the star schema from Canvas Data 1. Data supported in Canvas Data 2 are detailed in the data dictionary provided by InstructureUpon 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. |
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 includesconsists of the following tables:
Advisor card reminder data
MyPath reporting data, and
Career Coach data
The MyPath data may be used to:
Retrieve statistics about the aggregate completion status of the advisor cards and tasks as configured
Pull reports on the completion rates for each of the Advisor Cards (i.e. how many users have completed each advisor card, by advisor card name, over the specified time frame)
Retrieve information about specific student progress against the advisor card and tasks that have configured (i.e. enter a CCCID and see the status against each advisor card).
Retrieve statistics about the number of students (visits, non-unique) who access MyPath
Retrieve statistics about the number of notifications/reminders sent across various channels (SMS, email, MyPath Notifications)
Retrieve information about the engagement rate resulting from the notifications/reminders that I am sending
Support for CAL-VET reporting in CCC DW Report Server
A report was introduced to the CCC Data Warehouse Report Server to support CAL-VET reporting. This CSV report was developed to meet reporting requirements and consists of data from submitted applications where the “military_veteran_consent” field is marked as true. This report is not visible to college and district users of the CCC Data Warehouse Report Server.
The report consists of the following data elements:
Full Legal Name (concatenate: firstname, middlename, lastname)
Email Address (email)
Mailing Address (concatenate: permStreetaddress1, permStreetaddress2 permCity, permState, permPostalcode, permZip4
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: