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 has been created to import the detected cases back into Slate for use in fraud review processes and reporting.

Stakeholders

SPS Admissions

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 2023.1.0 [February 2023]

• Fraud Query (Slate)
  • Updated SQL to restrict the number of days to look back when pulling the fraud data
    • Improves run time, and reduces the amount of duplicate data that is loaded nightly
    • Query can now be run on-demand if needed due to shortened run time
    • Default is seven days of history

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 location
    • Granted permissions to the file share for the Admissions team