Learn more about

A higher-education institution needed to transition its HR and payroll operations from ADP (Automatic Data Processing) to Ellucian Banner HR/Payroll SaaS. That migration also required the institution to move its retirement contribution process with TIAA, its retirement recordkeeper, to the new SaaS architecture. Payroll data still had to reach TIAA using the SPARK Data Format, […]

A higher-education institution already relied on an integration between Ellucian Colleague and Symplicity Career Services to supply career-services workflows with current student, faculty, and academic data. As the institution prepared to move to Ellucian Colleague SaaS, that integration also had to be modernized for the new SaaS environment. The modernization had to do more than […]

As it moved to the Ellucian SaaS platform, a higher-education institution needed to modernize its existing Banner-to-TeamDynamix integration so it could continue delivering student data without relying on direct Banner database access. The institution used TeamDynamix to support students through its IT help desk. Student identity, academic, and contact information originated in Banner and was […]

A higher-education institution needed to open module registration for the next academic year before its Exam Boards had made final decisions on student progression, including whether students would advance to the next year. The timing created a specific Ellucian Banner SaaS challenge: students needed the future-term academic state required to see the right module choices, […]

A higher-education institution was moving to Ellucian SaaS while also transitioning its reporting environment from Cognos to Argos. But more than 200 existing reports depended on institution-specific Oracle database objects and data-loading logic. That meant the custom data layer underlying those reports also had to be modernized. The migration scope focused on those customizations rather […]

A higher-education institution relied on a custom Oracle-based Banner payroll process to update maximum annual 403(b) employee elective-deferral limits for active employees, with Fidelity NetBenefits serving as the plan’s primary administrative service provider. As part of its Banner SaaS modernization, that internal payroll process needed to move into Ellucian Data Connect. The engineering work involved […]

A higher-education institution needed to move a custom Banner-to-Fidelity retirement contribution process into a SaaS-compatible operating model without losing the retirement contribution logic and downstream file requirements the process supported. The existing solution prepared employee and employer contribution data for Fidelity to use in retirement plan administration, but that behavior was embedded in institution-specific Oracle […]

As a higher-education institution prepared to move its on-premises Banner environment to Ellucian SaaS, it needed to modernize a custom retirement benefits process that depended on direct Banner operations and a weekly feedback file from Fidelity Plan Sponsor WebStation® (PSW®), its retirement-plan provider portal. The process updated regular and Roth deferrals under a 403(b) retirement […]

A higher-education institution was preparing to move its on-premises Ellucian Banner environment to Ellucian SaaS. As part of that migration, it also needed to modernize a custom enrollment reconciliation process that kept section and cross-list enrollment counts aligned with actual student registrations. The existing process depended heavily on the on-premises Banner database. It read Banner […]

A higher-education institution relied on a custom Banner process to import student immunization compliance data from Point and Click Solutions and manage registration holds. As Banner moved to SaaS, that workflow could no longer depend on its existing Banner Job Submission (JobSub) process, PL/SQL, Oracle’s procedural extension to SQL, direct database access and the Banner […]

A higher-education institution relied on a custom billing process in Ellucian Banner, its higher-education enterprise and student information platform, to calculate student balances, generate statements and distribute them through TouchNet for electronic billing and DATAMATX for paper billing. The customization existed because the delivered Banner integration with TouchNet did not provide the required prior and […]

A higher-education institution was modernizing a custom third-party sponsor billing process for Banner SaaS and Ellucian Data Connect, Ellucian’s integration platform for building and managing data process flows. One requirement extended beyond the billing calculations themselves: the new pipeline still had to produce the sponsor invoice PDFs required by the business process. Those invoices had […]

A higher-education institution relied on a custom third-party sponsor billing process in Ellucian Banner to calculate charges covered by external sponsors and prepare billing output for its TouchNet third-party billing workflow. Moving this capability to Ellucian SaaS required rebuilding the Banner-side billing engine around Ellucian Data Connect, Ellucian’s integration platform for creating and managing data […]

When an Ellucian Spec API written for Oracle calls scalar functions directly from its SELECT list, migrating the query to PostgreSQL can break because those Oracle functions are not available in the PostgreSQL implementation. The SQL still needs to calculate the same value for each Banner record, so the function logic has to be reproduced […]

When an Ellucian Spec API SQL query needs parameter values or criteria based filtering, choosing between ::param:: and %%AND_FILTER%% determines what kind of SQL substitution is required. ::param:: supplies a value at a predefined position in the SQL, while %%AND_FILTER%% represents an optional SQL condition generated from the request criteria. Using the wrong mechanism can […]