Graduate Slate Integration with Banner

100%

Status

Completed [Completed]

100% complete, updated on Fri 8/28/20 2:44 PM by Joan Terrill

Changed Status from In Process to Completed.
Project is 100% complete.

Details

Dates
Fri 2/21/20 - Fri 8/28/20
Acct/Dept
Enrollment Management
Service
Banner / New Integration or Change Request
Type
Software / Hardware / Integration (connecting systems)
Health
Green - On track
Portfolio(s)
Classification
Grow
Requirements
Per Scott Harper, the initial stage on the Graduate Slate integration would involve the following data transfers:
- Slate to Banner: Decision data inserted into SAADCRV (analogous to SZPADSD)
- Slate to Banner: Test data inserted into SOATEST (analogous to SZPADST)
- Banner to Slate: Person level data used to match in Slate and add CWID & PIDM
- Banner to Slate: Application level data used to match in Slate and add application number, priority, residency to a specific application.
- (added 4/6/20) We would like to be able to insert current undergraduate student data into Grad Slate as graduate prospects, including their current undergraduate GPA. I think we will want to add this as a separate data transfer process. Since the relevant data won’t typically be updated but once a semester, it would probably be an infrequent transfer (it maybe is best to simply write a Cognos report and set a calendar reminder to run it after each semester). Perhaps some additional brainstorming would be necessary to decide the best solution. We can, and likely will import all admitted undergraduate students from UG Slate into GR Slate as prospects. However, because that data is frozen at the time of admission, we won’t have updated contact information, and more importantly we won’t have current grades – we are planning to market a guaranteed admission to non-thesis programs if a student has >= 3.0 GPA.

The analogous Banner to Slate files mentioned above are not included in the attached documentation; I do not have a copy of that documentation on hand.
Created
Fri 4/10/20 11:01 AM
Modified
Sun 9/27/20 8:04 AM
Closed
Fri 8/28/20 2:44 PM

New Project Request

How can we help you?
Please provide details regarding your request? Do you have a solution defined or do you need support identifying a solution?
Integrate Graduate Slate with Banner to reduce data entry.
Provide the background of this request.
What events or discussions preceded this request? Have there been previous efforts related to this request? Are you working with a vendor already? What are the benefits of this initiative?
Reduce data entry.
What are the factors driving the desired completion date?
Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?
Integrate Graduate Slate with Banner to reduce data entry.
Any additional information about this request that you would like to include?
Who does this project help? What happens if this project is not completed?
Per Scott Harper, Margaret Bellville and Loni Cramer are most familiar with the integration with Undergraduate Slate, and I have included the most recent documentation on the undergraduate Slate-to-Banner integration that I have as an attachment.

Description

Project will integrate Graduate Slate with Banner for admissions data. There will be a data transfer of at least two data files on a daily basis from Slate to Banner, and two data files on a daily basis from Banner to Slate. It will be directly analogous if not identical in some aspects to the Banner integration with Undergraduate Slate (SZPADSL). The key item to note is that Graduate Slate is its own separate database, requiring connection to it's own separate SFTP.

Systems Affected

  1. Banner

  2. Slate

Manager

Sponsor

Stakeholders (3)

CB
Corrie Bozung
Informed
Enterprise AD
Fri 5/8/20 11:19 AM
LK
Lori Kester
Assoc Provost Enrollment Mgmnt
Accountable
Admissions
Wed 3/11/20 9:47 AM
MS
Monique Sendze
Informed
Awareness of project progress.
Mon 2/17/20 12:27 PM