--- title: "Integration via Ellucian Tables" slug: "integration-via-ellucian-tables" updated: 2026-10-19T18:57:33Z published: 2026-10-19T18:57:33Z canonical: "documentation.decisions.com/integration-via-ellucian-tables" --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Integration via Ellucian Tables While Ellucian Ethos is the recommended integration approach for Ellucian Banner, it is not uncommon for Ethos to be unavailable. In these situations, ProcessMaker TCE can integrate directly with Ellucian Banner database tables. The following sections describe the database tables and fields that ProcessMaker TCE requires access to. This information can be used to create a dedicated database user profile with restricted permissions that align with organizational security and compliance requirements. ### Authentication The following settings and credentials are required to access the Ellucian Banner database. These credentials ensure secure and authorized interaction with the API, enabling seamless data exchange and integration with third-party systems (here, ProcessMaker TCE). | Parameter | Description | | --- | --- | | **Database Host** | The Ellucian Banner database hostname, URL, or IP address. | | **Database Port** | The Ellucian Database listener port. If not modified, this typically uses the Oracle default port of 1521. | | **Listener/Service Name** | The Ellucian Database listener or service name. | | **Username** | The username created for ProcessMaker TCE. | | **Password** | The password created for ProcessMaker TCE. | ### Required Tables and Fields #### Student Management | Table | Description | Purpose | | --- | --- | --- | | SPRIDEN | Person records registered in Ellucian Banner | Retrieve person information such as first name, last name, and Banner ID | | SGBSTDN | Student records registered in Ellucian Banner | Validate whether a person is a student | | GOREMAL | Email addresses by person | Retrieve student email addresses | | STVTERM | Administrative periods associated with students | Query administrative periods for students | | STVSTYP | Student types | Resolve student type information | #### Query — Retrieve Student by Banner ID ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421693581.png) #### Query — Retrieve Student Email ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421708484.png) #### Query — Retrieve Student by Email Address ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421717792.png) #### Query — Retrieve Student by Name ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421732719.png) #### Query — Retrieve Attached Administrative Periods ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421743484.png) #### Course Management | Table | Description | Purpose | | --- | --- | --- | | SCBCGID | Course UUIDs | Retrieve UUID information for courses | | SCBCRSE | Courses registered in Ellucian Banner | Retrieve course records | | SCBDESC | Course descriptions | Retrieve detailed course descriptions | | STVTERM | Course administrative periods | Query course administrative periods | #### Query — Retrieve the List of Courses ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421934762.png) #### Query — Retrieve Course Description ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421942979.png) #### Query — Retrieve Administrative Periods per Course ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421952966.png) #### Administrative Periods | Table | Description | Purpose | | --- | --- | --- | | STVTERM | Administrative periods registered in Ellucian Banner | Retrieve administrative periods | #### Query — Retrieve Administrative Periods ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421964054.png) #### External Institutions | Table | Description | Purpose | | --- | --- | --- | | STVSBGI | External institutions registered in Ellucian Banner | Retrieve external institution records | #### Query — Retrieve External Institutions ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421976139.png) #### Course Equivalency | Table | Description | Purpose | | --- | --- | --- | | SHBTATC | External courses | Retrieve external course records | | SHRTATC | Internal courses | Retrieve internal course records | #### Query — Retrieve Courses ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792421989574.png) #### Course Articulation | Table | Description | Purpose | | --- | --- | --- | | SHRTRIT | Transfer Institution Number | Retrieve transfer institution information | | SHRTRAM | Attendance Period | Retrieve attendance period information | | SHRTRAM | Transfer Maintenance | Create transfer maintenance records (write access required) | | SHRTRIT | External Institution Records | Create external institution records (write access required) | | SHRTRCR | External Course Articulations | Retrieve and save external articulations (write access required) | | SHRTRCE | Internal Course Articulations | Retrieve and save internal articulations (write access required) | #### Query — Transfer Institution Number By Student PIDM and Sequence Number #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422096685.png) #### Query — Attendance Period By Student PIDM and Sequence Number #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422104895.png) #### Query — Create Transfer Maintenance #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422114467.png) #### Query — Create an external institution record #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422123933.png) #### Query — Get previous articulations (external) #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422131886.png) #### Query — Get previous articulations (internal) #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422145861.png) #### Query — Save external course articulation #### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422153584.png) #### Query — Save internal course articulation ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1792422161286.png) ## Checklist The following checklist includes all information and actions required to set up the ProcessMaker TCE and Ellucian Banner integration. ### Ellucian Banner without Ethos ☐ Provide the Ellucian Banner database hostname, URL, or IP address. ☐ Provide the Ellucian Database listener port. ☐ Provide the Ellucian Database listener/service name. ☐ Perform firewall and database security modifications- ☐ Whitelist the ProcessMaker development and production environment IP addresses. ☐ Create a ProcessMaker-specific database user. ☐ Assign permissions to all required tables listed above. ☐ Provide the database username and password.