bcgov / bcgov/entity

FAS - New reporting payment job for auto refund

Open
#25,455 4 comments 0 reactions 0 assignees View on GitHub
On Hold Pay
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

SBC FIN would like a list of FAS auto refunds monthly - including the date, client names, and amounts

select * from routing_slips rs join refunds r on r.routing_slip_id = rs.id where status = 'REFUND_PROCESSED';

Email report to: BCROSRev@gov.bc.ca

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the existing auto-refund or payment-job entry point and verifying the routing_slips and refunds tables against the query in the issue. Done means a monthly report lists the refund date, client names, and amounts for REFUND_PROCESSED records and is emailed to BCROSRev@gov.bc.ca.

Written by the indexing model from the issue text.

Assessment

Tech stack
flask, postgresql, python
Domain
backend, databases, payments
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.