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 ServerSupport forCanvas 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 Advisor usage 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
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
);
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
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: