Data Warehouse - Reconcile vs unreconciled- investigate and correct pay discrepancies
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
> _This issue was auto-created as part of the Zenhub sub-issues migration. The original entity was opened on 2024-05-29. For more details see [this post](https://changelog.zenhub.com/migration-of-epics-projects-to-sub-issues-313645?zenhub_entity_id=Z2lkOi8vcmFwdG9yL1plbmh1YkVwaWMvMjA4OTA0)._
We need to investigate what payments don't match between our Pay DB and the downstream systems, ie,. BCOL and CAS. and correct them in data warehouse.
Power BI reconciled and unreconciled
https://app.powerbi.com/groups/me/apps/6a21fa68-0f79-4556-bc2a-ed39643d20e0/reports/583ac8a6-8e03-4271-bb4a-ede07c29dd9a/ReportSection?ctid=6fdb5200-3d0d-4a8a-b036-d3685e359adc&experience=power-bi&bookmarkGuid=cd8cd26fb3d391e0a594
Ticket to create view is https://github.com/bcgov/entity/issues/20275
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the Power BI reconciled and unreconciled report and compare the Pay DB results with BCOL and CAS. Review ticket #20275 for the planned view, then identify the mismatched payments and determine how they should be corrected in the data warehouse. Done means the discrepancies are investigated and the warehouse data is corrected.
Written by the indexing model from the issue text.
Assessment
- Domain
- data-engineering
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100