Versions Compared

Version Old Version 1 New Version 2
Changes made by

Bryon Vaughn

Bryon Vaughn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

In order to streamline the process of fraud management, a daily fraud report has been created and stored in a central location for sharing across the stakeholders. In addition, a process spirit of sharing and standardization, the following document has been created to import the detected cases back into Slate for use in fraud review processes and reportingallow other schools to implement the same approach to fraud management that is in use at Columbia SPS.


SPS Admissions

Technical Details

Current Release Version: 2022.1.0

Release Date: 


Supporting Documents

Stakeholders


Special Considerations

Dependencies

The existing output from the fraud query that is executed on the Slate platform and exported to the H: drive for sharing is used for the source format import file.

Feed Processing

  • The Fraud Query integration is executed on Daily at 7:15AM
    • All records in the fraud query output are processed with each run
    • Records are processed by Slate whenever a file is available
    • All files are copied to the incoming/processed folder and kept for 30 days on the SFTP server
    • Files that are processed can be viewed in the Slate sources section

Requested Features/Issues

Current Cycle

Release 2022.1.1 [December 2022]

Features to Complete

  • Not started

Features to Consider

  • Not started

Features Ready for Release

  • Not started

Previous Cycles

Release 2022.1.0 [July 2022]

  • Fraud Query (Slate)
    • Updated SQL to remove the metadata checks on the stream table
      • This was done because there were only two matches, and both were cases where the metadata in both check were matching on empty strings
      • Improved run performance and had zero impact on results
    • Added a new column to the output to capture the last update on the fraud records so it would be easy to determine what has been added since the last execution
  • Slate Configuration
    • Add and update the mapping for the Fraud Query Import source format
      • For each matching Ref, add a static tag for 'Fraud Report (Admin)'
    • Add new fields to capture Reason and Date Updated
      • Fraud Query Reasons (app-scoped)
      • Fraud Query Report Date (app-scoped)
  • Integration Server
    • Use Task Scheduler to automate the execution of all processes
      • C:/Scripts/Powershell_scripts/copy_fraud_to_sftp.ps1
        • Copies file from H: drive location back to the Slate incoming/fraud SFTP folder

Release 2021.1.0 [June 2021]

Fraud Query (Slate)
  • Revised the default Slate custom SQL fraud query so that it would run within the system time limits
  • Scheduled a daily run and saved to SFTP
    • Created script to copy the file from Slate SFTP to CU H: drive locationGranted permissions to the file share for the Admissions team

    Data Feeds

    There is a requirement that the exported fraud data from Slate be loaded back into the system. While there are a number of ways to make this happen, SPS is using SFTP to transfer the data to and from an external file share. This is necessary for some external processes that require access to the exported data outside of Slate. If that is something needed by other schools, we can share the details of how the files are transferred as part of the data pipeline; however, for managing the fraud cases completely within Slate, this is not a requirement.

    Configuring the Fraud Query