Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 8 Next »

Overview

The data that feeds from Slate into SIS needs to conform to specific standards for proper processing. This document will cover the synchronization feed that has been configured, including the detailed file specifications, use cases, and development cycles.


Technical Details

Current Release Version: 2022.1.0

Release Date: 



Stakeholders

SPS Admissions

Special Considerations

Feed Processing

  • Slate has been configured to watch for an updated file named "Slate Feed Synchronization.csv" in the "incoming" SFTP folder and then process the records using the "SIS Data Synchronization" source format.
    • The CSV file is generated nightly through a scheduled Crystal Report that uses a procedure called "a2_slate_import_pbi" on the CEREPORTS server.
      • The file is saved on the H: drive in the following location: H:\Systems and Data Analysis\DATA_EXPORTS\SIS_to_Slate.
      • The file is transferred nightly to the Slate SFTP folder using a script on the AIS terminal server.

Requested Features/Issues

Current Cycle

Release 2022.1.1 [April 2022]

Features to Complete

  • Not Started

Features to Consider

  • None

Features Ready for Release

  • None

Previous Cycles

Release 2022.1.0 [February 2022]

  • Add a field in Slate to store any registration holds on the applicant's account in SIS and keep it up to date with the daily sync
    • App-Scoped: SIS Registration Holds (sis_reg_holds)
    • Add the new field to the SIS form for viewing and clearing (for cloned apps)
  • Updated source format settings to replace the previous day's import file instead of saving every file forever

Release 2021.1.0 [February 2021]

  • SIS → Slate sync process updates
    • Add a check to the STUD check process to look for a REG-GRP indicator (STUD_STUDENT.Registration_Group_Code)
      • If present, sync the code back to an application-scoped field in Slate
        • SIS Registration Group (sis_reg_group)
    • Add a check for any registered courses for the APPL entering term and store them in an application-scoped field in Slate (comma delimited list of course identifiers)
      • SIS Registered Courses (sis_reg_courses)
    • Update the sync source format to add the new fields

Release 2020.2.4 [October 2020]

  • The Slate sync process needs to be updated to include an indicator of whether the student has a valid STUD record in SIS
    • Create a new field in Slate to store Y/N for the STUD presence
    • Include the value in the SIS to Slate export file and add to the source format for inclusion into SIS
  • No labels