Assist in reconciling BCOL deposits

[seeker25]

Met with Patty, saw how she did it in excel, wrote a simple query.
She also went over the disbursements, but we'll address those at a later time.

We're trying to get the Piranha files to store in the DW.

select date_applied::date, To_Char(date_applied::date, 'Day') as weekday, count(*), -sum(total_amt) as total_amt from bconline_billing_record bbr where fee_code in ('EFT') group by date_applied::date

Went over disbursements for BCOL as well, for the future.

fee_code type:
EFT -> Deposits
OLBPYMT -> Partner disbursements

Rajandeep is building this into a DW view

[Jun 16, 10:20:46] - TOTAL DEPOSITS: [$167215.96] from [194] customers' FI accounts. <--