Request help
What are integrations?
Kuali Build lets you integrate data from other systems like Banner, the Davidson Enterprise Data Warehouse, Blackbaud, Atrium, etc. Below is a list of available integrations with a short description about the data the integration retrieves.
We've split these integrations into two sections:
Form Integrations populate data into a form, like auto-filling certain form fields with user information or creating a dropdown list of options (e.g. campus buildings, departments, etc).
Workflow Integrations send form data to another system. So if you need to upload your data to a PowerBI report or update data in Banner.
Form Integrations
| Name | Description |
| Accounts: Expenses | Gets a list of expense accounts from DavidsonEnterpriseDataWarehouse.dbo.DimAccount, ordered by code. Allows for ordering by name or by code |
| Buildings | Lists all of the buildings in EMS by description. |
| Course Roster | Retrieves a list of students within a given course. |
| Courses | Look up course information using the following filters: Enrolled Student Banner ID, Instructor Banner ID, Term Code, CRN, Subject Code, Course Number, Section |
| Courses, from API | https://api.davidson.edu/api/v1/courses. A searchable list of all Davidson courses. |
| Departments, from API | Retrieves a list of departments from https://api.davidson.edu/api/v1/departments |
| Departments: Code and Number | Gets a list of departments from the Davidson College api departments endpoint. Returns department code and name. The list can be ordered by Name or Organization Code |
| Departments: Name | Gets a list of departments from the Davidson College api departments endpoint. Returns department names. The list can be ordered by Name or Organization Code |
| Google Sheets | API integration to grab google sheets data |
| HR: Employee Benefit Category | Retrieves a list of all Benefit Categories in PTRBCAT that are active. |
| HR: Employee Class | Retrieves a list of all HR employee class codes and description from Banner PTRECLS. |
| HR: Employee Group | Retrieves a list of all Employee groups codes in PTVEGRP. |
| HR: Employee Leave Category | Retrieves a list of all Benefit Categories in PTVLCAT that are active. |
| HR: Employee Leave Reason | Retrieves a list of leave reasons codes from Banner.(PTLREA) |
| HR: Employee Organization | Retrieves a list of all Finance Organizations in FTVORGN that are active. |
| HR: Employee Termination Codes | Retrieves a list of all termination codes in PTRTREA. |
| HR: Get Positions by Division | Retrieves a list of all active positions by org code and division from NBBPOSN and NBRPTOT |
| HR: Position Group | Retrieves a list of all HR position group codes and description from Banner PTRPGRP. |
| HR: Position Reports To | Get position numbers reports |
| HR: Position Salary Grades | Retrieves all salary grades codes and description from table NTRSALB. Salary grades are composed of table-year-grade. |
| HR: Position Standard Occupation Category | Retrieves a list of all HR position standard occupation category codes and description from Banner PTRESOC. |
| Integrations | Lists all integrations in Kuali Build. |
| Kuali: List Apps | Lists all Kuali apps in the environment. |
| Majors | Gets a list of all majors from the Davidson API |
| Microservice: Music Courses | Queries Redis cache to retrieve all applied music courses for the upcoming semester |
| Microservice: Music Ensembles | Queries Redis cache to retrieve all music ensembles for the upcoming semester |
| Microservice: Music Instructors | Queries a list of music instructors/instrument from a Redis cache |
| Microservice: Tutor Center Topics | Queries Redis cache to retrieve Tutoring Center Topics from the WebApps db filtered by Center and Topic Category (dbo.tutor_topics_covered) |
| Microservice: Tutoring Centers | Queries Redis cache to retrieve all Tutoring Centers. Centers are synced from the WebApps server (dbo.tutor_centers) |
| Microservice: Tutors | Queries Redis cache to retrieve all Tutors. Tutors are synced from the WebApps server (dbo.tutor_centers) Optionally filtered by Tutoring Center |
| Minors | Retrieves a list of all valid minors from Davidson College API |
| Payroll: Deductions | Retrieves a list of optional payroll deduction codes of type 43 from Banner PTRBDCA. Employees may assign a one-time or recurring gift to any of these codes, which include organizations and initiatives such as WDAV, Lula Bell's Resource Center, and Friends of the Arts. |
| Persons, From API (Search) | A list of Davidson users that includes current employees and students from the Davidson College API. This version allows for searching and filtering. |
| Programs | Retrieves a list of academic programs, majors, and minors. |
| Short.io: Get Domains | Gets a list of available Short.io domains |
| Short.io: Get Links | Returns a list of Short.io links given creator ID and a domain ID |
| Sports | A list of all sports from the Davidson College API sports endpoint. Pulls data from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. Allows filtering on club, varsity, intramural. |
| Stripo: List Weekly Covid Update Emails | Retrieves the list of emails from the Weekly Covid Update project in Stripo. |
| Subjects | Retrieves a list of subjects and their respective associated programs of study, administering department, and primary subject chair. |
| Teaching Rewards Program - Query | Queries the current teaching reward point value and available redemption options for a given faculty member by ID |
| Terms | https://api.davidson.edu/api/v1/terms. A list of all academic terms. |
| [DEPRECATED] Deparments: Name | Gets a list of departments by name from DavidsonEnterpriseDataWarehouse.dbo.DimOrganization. |
| [DEPRECATED] Accounts: Expenses (By Code) | Gets a list of expense accounts from DavidsonEnterpriseDataWarehouse.dbo.DimAccount, ordered by code. |
| [DEPRECATED] Sports: Varsity | A list of Varsity Sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| [DEPRECATED] Terms | Gets a list of academic terms from the Davidson College API, with data from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by name. |
Workflow Integrations
| Name | Description |
| ATH:NCAA_Integration | Updates NCAA with EDW information. |
| Broughton Application Workflow | Writes formID, reference materials including recommendation letter, to office-only fields on Broughton application form |
| COVID symptoms delete (DEV) | Deletes any accidental submissions |
| Covid-19: Populate Attendance Database | Inserts select fields from the Covid-19 test attendance tracker into the stg_Kuali_COVID19_TestCheckIn in wildcatODS. |
| Covid_reconciliation_core | The integration for starting the covid testing data reconciliation process. |
| Dev Covid Testing Reconciliation | A testing version of the Covid Testing Reconciliation Process |
| HR: Futured Dated Changes NBAPOSN | Sends the data for futured dated changes to Banner |
| HR: Futured Dated Changes PEAEMPL | Sends the changes for PEAEMPL futured dated data. |
| HR: Student Hire form | Sends the information to Banner for Student Hire |
| Insert into Tutorial Services DB | Inserts a tutoring session into the tutorial services database. |
| Kuali + GDrive => Kuali: Covid Testing Notifications Task | Covid Testing Notifications Task |
| Kuali => Snaplogic: Music Registration | Sends Music Registration data to Snaplogic where it is written to the Applied_Music table in Webapps |
| Kuali=>Smartsheet:Compliance Task | Triggers the warnings and compliance process to update smartsheet |
| Kuali=>SnapLogic: Residence Reconciliation | Sends .csv file to SnapLogic for Residence Reconciliation |
| Odyssey: Gear | Updates gear request for Davidson Outdoors Odyssey |
| Odyssey: Registration | Updates Davidson Outdoors Odyssey registration |
| Odyssey: Travel | Updates Davidson Outdoors Odyssey Travel Plans |
| SMTP: Send Contact Update Notification | Sends an email notification to a user who fills out the contact update form. |
| SMTP: Send T&I Mailer | Sends an HTML formatted email as ti@davidson.edu. |
| Send Data Elements to SmartSheet | Sends data elements submitted by the the Data Catalog working group for review by the Data Governance group. |
| Send Integration Request to Smartsheet | Sends an integration request to smartsheet as a new row |
| Send an E-Card | Sends one of 10 different e-cards to someone. |
| Short.io: Create Short Link | Uses SnapLogic to call the Short.io API, creating a new link |
| Short.io: Edit Links | Edits Short.io links |
| Short.io: Get Statistics | Calls the Short.io Statistics API to get domain or link-level statistics |
| Stripo: Send Email | Sends an email based on a Stripo template. |
| T&I Zendesk - COVID Faculty Hardware Request | Creates a zendesk ticket for a COVID faculty hardware request |
| T&I: Zendesk - CAB Ticket | Creates a change execution ticket in the T&I Change Advisory Board Zendesk group. Yay. |
| Teaching Rewards Program - Patch | Patches a TRP Points document with the URL to view submission |
| Teaching Rewards Program - Update | Updates Teaching Rewards Program Smartsheet with a new point value for a specific faculty member |
| Update Lost and Found | This integration sends information about lost and found items to snaplogic and ultimately Zendesk. |
| Update Meal Plan by Id | Updates a student meal plan |
Comments
0 comments
Please sign in to leave a comment.