Coursedog has built a tight, bi-directional integration to both GET and POST schedule planning data into PowerCampus.
For a reference on this process, feel free to contact one of our PowerCampus customers at Laguna College: Laura Patrick, lpatrick@lcad.edu
Overview
We have built a PowerCampus integration to pull data into Coursedog for:
Rooms
Buildings
Faculty
Terms
Courses
We have built a bi-directional (POST) integration to PowerCampus for:
Sections
Rooms & Buildings
For rooms & buildings, we GET the following information
Room ID
Name
Display Name
Capacity
Features
Building ID
Building Name
Note: We do not get Room Status, but your institution may use that field so we set it as a "Coursedog owned" field in their environment.
Faculty
We are getting the following fields from faculty
ID
First Name
Last Name
Department(s)
Terms
We are getting the following fields
Term Name
Term Year
Term Start Date
Term End Date
Term Code
Parts of Term
N2N SQL Filters: None
Courses
We are getting courses separated by term (i.e. to get courses, you have to pass a term code). The courses returned are all active courses hat have at least one section assigned to them - this is done as a proxy to determine all courses that are available for a certain term.
We are getting the following fields
ID
Code
Name
Description
College Code
Status
Sections - GET
We are getting the following fields
ID
Section Number
Call Number
Course Id
Section Type
Grade Mode
Campus
Credit Hours
Status
Notse
Max Enrollment
Preferred Room Features (LCAD only)
Preferred Room Type (LCAD only)
Preferred Room Capacity (LCAD only)
Preferred Building (LCAD only)
Academic Session
Subject Type
Professors
Professor Role
Professor Percentage
Times
Rooms
Some institutions may have additional fields because they have a custom room constraint table in PC that we are pulling from.
On the Coursedog side, we filter returned data to only show active sections.
Sections - POST
We are only updating existing sections - currently we do not have the ability to Create new sections or delete existing sections. However, for our next integration patch within the next few months, we will be able to create new sections and delete sections.
In POSTing section updates, we are able to update the following fields
Meeting Times
Meeting Days
Meeting Room
Instructors
Instructor Percentage
By default, we auto-calculate the instructor percentages so if there are 3 instructors, the percentages are 33,33, and 34.
Additionally, we require the following fields to exist to execute a POST transcation
Course Id
Section Numbeer
Call Number
Academic Session
Subject Type
Avoiding Duplicates
In order to avoid duplicate records we have added the following filters in our integration:
FacultyList - We are using s specific condition for Each client to pull the Faculty members. For Laguna, we are using PEOPLE_TYPE='FAC' whereas in SEBTS we are using ACADEMIC_SESSION='
For a link to a forwardable slide deck detailing the SIS integration architecture, go here.
For additional info on the Gateway/Dataport, see the following article detailing setup and configuration of the IIG. For HECVAT on the Gateway, see here.