Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 6 Current »

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.


Technical Details

Current Release Version: 2022.1.0

Release Date: 


Supporting Documents


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 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
  • No labels