bcgov / bcgov/entity

Query - create a spreadsheet to use for the mail out

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

Description

We want to send the following email to everyone currently using Online Banking:
https://www.figma.com/design/eRPbcgyiL2ViPPKyyTdLm5/Auth---Product-and-Payment-Updates?node-id=6630-677&t=IdNIgeRgPSd3pt3y-0

The OCM team is able to use GCNotify to send the emails, driven from a spreadsheet.

For this ticket, please create a spreadsheet with the admin emails and CFS account number for each BCROS account that is currently using Online Banking.

Note that some accounts have more than 1 admin. Also note that some accounts may have changed away from OB, so only include those that are currently using OB.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by identifying the data source for BCROS accounts, their admin emails, CFS account numbers, and current Online Banking status. Build the spreadsheet for accounts still using Online Banking, include every admin where there is more than one, and verify that accounts which moved away from Online Banking are excluded.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.