bcgov / bcgov/cas-data-warehouse

CIIP/Import Payment Info into database

Open
#48 0 comments 0 reactions 1 assignee Claimed by @pbastia View on GitHub
attn: Business Area Low Priority Task
Dominant language
Smarty
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

#### Describe the task

As requested by Robb Tones: "Create a file for import into the database with actual payment information. This could then be queried with Metabase"

This would support their work on archiving all CIIP documentations and ensuring all records are saved appropriately before decommissioning.

#### Acceptance Criteria

- [x] Obtain CIIP payment information in .csv or excel format from CSNR (Robb Tones to coordinate this)
- [ ] Import CIIP payment data into database
- [ ] Create any requires views/joins in Metabase for BA to use this data in analysis

#### Definition of Done

- [ ] All the data from CSNR is imported in the database and viewable in Metabase

#### Additional context

- Add any other context about the task here.
- Or here

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.