Release Summary
Support for Canvas Data 2 in CCC Data Warehouse
Support for MyPath data in CCC Data Warehouse
Support 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 Canvas Data API key to the CCC Technology Center.
The deployment of Canvas Data 2 will replace support for the prior Canvas Data API which Instructure intends to stop support 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 Instructure.
Notice: Action Required for Canvas Support
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 includes:
Advisor card 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
Fields in mypath:
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
);
Collapse
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
Mobile Telephone Number (mainphone)
Documentation
Instructure has made the following data dictionary available for Canvas Data 2 (v. 4.2.9).
Other related documentation: