About DROP

Home > About DROP

---

Discrepancy Report on Payments

DROP automates the manual process of finding and reporting discrepancies between the ministry line of business transactions and Provincial Treasury’s bank and cash management deposit files.

Payment-transaction data from the line-of-business represents one half of the data and is received via STFP.

Deposit data from Provincial Treasury of the Province of British Columbia is also obtained via SFTP and comes in three formats:

• TDI34 files - In-person point-of-sale (POS) transactions
• TDI17 files - Cash & cheque deposits made to the banks
• TDI34 Daily Download Files (DDF) - Online card transactions (PayBC and ICE Pay)

Files are pushed to SFTP and transferred to S3 which triggers a lambda to parse the data into the db. This triggers a subsequent lambda which runs the job of searching for discrepancies in the data and updating the “status” of each row item. After this process has completed, another lambda is triggered to generate and output a report to another S3 bucket.

There is also an alerting and notification lambda which notifies users if data files are missing, or if there are errors in the files during parsing.