bcgov / bcgov/entity

Datawarehouse - Disbursements - credited CSO invoices with disbursement_status_code not showing up correctly

Open
#21,982 1 comment 0 reactions 0 assignees View on GitHub
analytics :chart: bug
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

![image](https://github.com/bcgov/entity/assets/3484109/a6332eb9-cefe-40b3-8932-fc9aad5c6ea0)

Note there are some invoices that don't have the invoice id in the description of the GL_LINES table

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the attached example and trace how credited CSO invoices and disbursement_status_code are represented in the data warehouse. Inspect the GL_LINES table, especially invoices whose descriptions do not contain an invoice ID, and verify that the affected disbursements appear with the correct status.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.