bcgov / bcgov/entity

PAY - Rewire the daily stale payment job to query PAYBC Datawarehouse

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

Description

Pending confirmation that the Pay BC data is in the CAS DW extract we get.
Need to ensure the data is in the DW before doing

Next steps:
Re-use the idea from the BCOL status query job that already runs against the DW.

Note:
DW will still be 1 day behind so we need to keep the job that runs every 30mins.

Contributor guide

No contributing guide indexed for this repository

Research direction

First confirm that PAY BC data is present in the CAS DW extract, then inspect the existing BCOL status query job that runs against the DW. Done means the daily stale payment job queries PAYBC data from the DW while the existing 30-minute job remains in place because the DW is one day behind.

Written by the indexing model from the issue text.

Assessment

Domain
data-engineering, payments
Issue type
Refactor
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.