Slingshot Integration Overview

Slingshot Integration Overview

The Slingshot integration is an export from Banner to Slingshot.

Banner sends three files to Slingshot:

  1. Enrollment

  2. Catalog

  3. Customer

Each file contains the information Slingshot needs to generate and maintain their required files.

The file outputs can be found in Argos here:

Campus Store → Slingshot Schedule Daily Files

The files are currently built for the following term range:

202651 through 202713

Any updates to the term range must currently be made manually in the underlying SQL/views.

The Argos reports themselves are simple SELECT * statements from custom Banner views:

select * from bthbanr.v_store_customer_file; select * from bthbanr.v_store_catalog_file; select * from bthbanr.v_store_enrollment_file;

Each view contains custom SQL that builds the file output according to Slingshot’s file requirements and formatting guidelines.

The views are:

bthbanr.v_store_customer_file bthbanr.v_store_catalog_file bthbanr.v_store_enrollment_file

These views should be reviewed and updated whenever Slingshot file logic, term ranges, or business requirements change.