Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add materialized view for eCR Version number #3068

Open
1 task
emmastephenson opened this issue Dec 16, 2024 · 1 comment
Open
1 task

Add materialized view for eCR Version number #3068

emmastephenson opened this issue Dec 16, 2024 · 1 comment
Assignees
Labels
Streamline eCR Issues for Streamline eCR team to work on

Comments

@emmastephenson
Copy link
Collaborator

emmastephenson commented Dec 16, 2024

What needs to be done

Create a materialized view to store the eCR Version number in our SQL database. This view should contain eICR ID, eCR version number, and maybe set ID.

Why it needs to be done

We need a version ID that will tell us which number a specific eICR is within the set. This could be calculated with:

  • The version number already present in the eICR
  • The created date of the eCR

Acceptance Criteria

List out all expected functionality/requirements

  • There is a materialized view in the database that contains the correct version number for each eICR ID.

Technical Notes

Owned by eng team - write out any important technical considerations such as: architecture plan/notes, data dependencies, testing plan, etc. Also link any tickets that are dependent on or related to this task

Additional context

[OPTIONAL, delete if not needed]
Include any additional context or information here that doesn't fit into other parts of the template

@emmastephenson emmastephenson added the Streamline eCR Issues for Streamline eCR team to work on label Dec 16, 2024
@emmastephenson
Copy link
Collaborator Author

There may be a version number included in the eICR already - part of this ticket will be reviewing this field to see if it contains what we need.

@lina-roth lina-roth self-assigned this Jan 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Streamline eCR Issues for Streamline eCR team to work on
Projects
None yet
Development

No branches or pull requests

2 participants