Detailed data verification for existing GPs
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
With major changes in the data model for the legal name work, there is a need to verify the data migrated from the old LEAR db in detail to ensure data integrity.
In this ticket, we will verify data at the database level.
**TODOs**
Find some existing businesses in Dev or Test that exist in GCP LEAR db as well for the business type of interest. Ensure that you pick businesses that have lots of completed filing types and that your testing covers all the filing types available for the business type. Assuming the GCP LEAR db hasn’t been modified manually or via a filing after being migrated from OCP LEAR db.
Note that GPs have the following scenarios that need to be verified:
* partners are all persons
* partners are person + LEAR business
* partners are person + COLIN business
* partners are person + LEAR business + COLIN business
Do the following for the businesses you have selected to test with:
- [ ] Compare current/active and historical data in GCP LEAR db matches data in Openshift LEAR db.
- [ ] verify record values are same in tables. tables and fields are not a 1-1 mapping so that will need to be taken into account
- [ ] verify timestamps match
- [ ] Versioning approach is different in new GCP LEAR db so ensure you understand the differences. For example, the history table does not store a copy of the changes made in the active table in the history table which the previous versioning approach did.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.