Overview

In order to streamline the process of fraud management, the daily fraud report needs to be imported back into Slate to set indicators for processing.

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 [August 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)'
• 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