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 |
| Academic Departments | A list of departments offering courses in the current and next academic year. |
| 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. |
| CatCard: Accounts | A list of every account type in Atrium. Optionally, filter by meal plan or USD accounts. |
| 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 |
| Departments | Gets a list of departments from the Operational Data Store (ODS). 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. |
| 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. |
| Integrations | Lists all integrations in Kuali Build. |
| Kuali: List Apps | Lists all Kuali apps in the environment. |
| Majors | Retrieves a list of all primary and secondary majors from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| Minors | Retrieves a list of all valid minors from DavidsonEnterpriseDataWarehouse.student.DimMajor. Can be filtered by interdisciplinary and non-interdisciplinary minors. |
| 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. |
| Public Safety: Get Valuables by Student ID | Retrieves a subset of documents from the Public Safety: Valuables Inventory Kuali Build app where the submitter school ID matches the currently signed in user. |
| Scholarships | A list of scholarships from DavidsonEnterpriseDataWarehouse.dbo.DimEducationalInvolvement. |
| Sports | A list of all sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. Allows filtering on club, varsity, intramural. |
| Terms | Gets a list of academic terms from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by name. Ordered by name or by code |
| [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] Accounts: Expenses (By Name) | Gets a list of expense accounts from DavidsonEnterpriseDataWarehouse.dbo.DimAccount, ordered by name. |
| [DEPRECATED] CatCard: Accounts (All) | A list of every account type in Atrium. |
| [DEPRECATED] CatCard: Accounts (Meal Plan) | A list of accounts in Atrium with Meal Plan currency type. |
| [DEPRECATED] CatCard: Accounts (USD) | A list of accounts in Atrium with USD currency type. |
| [DEPRECATED] Departments: Org Code | Gets a list of departments by org code from DavidsonEnterpriseDataWarehouse.dbo.DimOrganization. |
| [DEPRECATED] Sports: All | A list of all sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| [DEPRECATED] Sports: Club | A list of Club Sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| [DEPRECATED] Sports: Varsity | A list of Varsity Sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| [DEPRECATED] Subjects: Minors All | Retrieves a list of all minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| [DEPRECATED] Subjects: Minors No Interdisciplinary | Retrieves a list of minors without interdisciplinary minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| [DEPRECATED] Subjects: Minors Only Interdisciplinary | Retrieves a list of only interdisciplinary minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| [DEPRECATED] Terms (By Code) | Gets a list of academic terms from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by code. |
| [DEPRECATED] Terms (By Name) | Gets a list of academic terms from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by name. |
Workflow Integrations
| Name | Description |
| 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 PEAEMPL | Sends the changes for PEAEMPL futured dated data. |
| Kuali + GDrive => Kuali: Covid Testing Notifications Task | Covid Testing Notifications Task |
| Kuali: Clone App to Production | Clones a Kuali app to the production environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| Kuali: Clone App to Sandbox | Clones a Kuali app to the sandbox environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| Kuali: Clone App to Staging | Clones a Kuali app to the staging environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| 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 |
| Public Safety: Delete Valuable | Allows users to delete a valuable item they previously submitted to Public Safety. |
| 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. |
| 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. |
| Update Lost and Found | This integration sends information about lost and found items to snaplogic and ultimately Zendesk. |
| Update Lost and Found - Test | For use in testing addition of "lost in library' table |
Comments
0 comments
Please sign in to leave a comment.