bcgov / bcgov/alcs

Finish obfuscating C&E fields for when we copy Prod -> Test

Open
#2,523 0 comments 0 reactions 0 assignees View on GitHub
Task
Dominant language
TypeScript
Stars
10
Forks
0
Avg merge
20h 8m
Merged PRs (30d)
30

Description

### Devs are going to obfuscate as they go through the ETL, so this ticket is to capture all C&E fields, not just the those with data being ETL'd from NRIS

As the product owner, I want to see C&E data obfuscated in Test where appropriate, after a fresh pull from Production.

**Fields for obfuscation:**

alcs.compliance_and_enforcement
- [ ] alleged_contravention_narrative
- [ ] intake_notes

alcs.compliance_and_enforcement_property
- [ ] alc_history

alcs.compliance_and_enforcement_submitter

- [ ] name
- [ ] email
- [ ] telephone_number
- [ ] affiliation
- [ ] additional_contact_information

alcs.compliance_and_enforcement_responsible_party

- [ ] individual_name
- [ ] individual_mailing_address
- [ ] individual_telephone
- [ ] individual_email
- [ ] individual_note
- [ ] ~~organization_name~~ -> do not obfuscate
- [ ] organization_mailing_address
- [ ] organization_telephone
- [ ] organization_email
- [ ] organization_note

alcs.compliance_and_enforcement_responsible_party_director

- [ ] director_name
- [ ] director_mailing_address
- [ ] director_telephone
- [ ] director_email

alcs.compliance_and_enforcement_document

- [ ] the document itself

alcs.compliance_and_enforcement_chronology_entry
- [ ] description

Add notice, order, appeal, etc once the fields are in the ALCS db

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing the fresh Production-to-Test ETL and the ALCS database handling it uses; the payload names no files or tests. Check each listed C&E field and the document for obfuscation, preserve organization_name, and extend coverage to notice, order, appeal, and other records once those fields are in the database.

Written by the indexing model from the issue text.

Assessment

Domain
data-engineering, databases, security
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.