Datawarehouse - Build views to join CPRD/PAY/CAS - Githubissues

bcgov / entity

ServiceBC Registry Team working on Legal Entities

Apache License 2.0

23 stars 59 forks source link

Datawarehouse - Build views to join CPRD/PAY/CAS #18407

Closed seeker25 closed 8 months ago

seeker25 commented 1 year ago

Datawarehouse - Build views to join CPRD/PAY/CAS

Estimated a bit higher since PAY>CAS queries will vary by payment type.

AR (PAD, ONLINE_BANKING, ROUTING_SLIPS)
EJV (Electronic Journal Voucher)
Disbursements (These can apply to DRAWDOWN) - Sum of invoices in PAY that have been disbursed should be equal to CAS disbursed
AP REFUNDS
AP EFT Disbursements? (Optional not running yet)

DIRECT_PAY ISN'T INCLUDED, they don't have much datawarehousing data available

JohnamLane commented 8 months ago

work to continue under newer DW epic