Overview

The data that feeds from SIS into Slate 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.

Stakeholders

SPS Advising

Special Considerations

Feed Processing

• TODO:
• Slate has been configured to watch for an updated file named "Slate Feed Synchronization Advising.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_advising_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.0.1 [July 2022]

Features to Complete

• CEREPORTS procedure to pull daily file for import into Slate
  • a2_slate_advising_importstudents
    • Population includes all existing students in SIS for MS and MPS degree types
    • Always perform a full pull of data for the population
    • Data to include
      • Personal details
      • Contact informationCUID, UNI, first & last name, birth date, gender, citizenship, email
  • a2_slate_advising_extended
    • Same population
    • Pull only records with updates
    • Data to include
      • Advisor (ADSL_ADVISOR_ADVISEE)
      • Address, phone, additional contact info
  • a2_slate_course_history
    • Same population
    • Use modification dates to pull only recent changes
    • Data to include
      • Current course registrations by term
      • Completed course history
        • Grades

Features to Consider

• None

Features Ready for Release

• None

Previous Cycles

Release 2022.0.0 [July 2022]

• None