These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Infection Control System
- Data model
The tables behind Infection Control System
Infection Control System ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Case identity and access
Cases links to its assigned investigator in People; Consents and investigation team assignments belong to Cases.
Investigation episodes
Infection investigations belongs to Cases and names an investigator in People.
Clinical evidence
Investigation notes, metric observations, Specimens and treatment dispensations link to infection investigations.
Follow-up and service accounting
Follow up actions and Payments link to Cases; Charges link to infection investigations.
Staff governance
People links to Users, and clinical privileges links to People.
Every table, by feature
- Case intake4
- Investigation work5
- Team and privileges6
- Follow-up4
- Laboratory evidence5
- Treatment records5
- Shared and settings3
- Cases
Case identity and consent status
Linked to People - Consents
Purpose-specific case consent
Linked to Cases - Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People - Investigation team assignments
Investigation team access assignments
Linked to Cases, People
- Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People - Investigation notes
Attributed investigation documentation
Linked to Infection investigations, People - Metric observations
Measured metric observations
Linked to Infection investigations, People - Cases
Case identity and consent status
Linked to People - People
Infection control staff and clinicians
Linked to Users
- People
Infection control staff and clinicians
Linked to Users - Users
Users
Linked to Users - Clinical privileges
Verified clinician privileges
Linked to People - Investigation team assignments
Investigation team access assignments
Linked to Cases, People - Cases
Case identity and consent status
Linked to People - Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People
- Follow up actions
Follow-up actions for infection investigations
Linked to Cases, People - Cases
Case identity and consent status
Linked to People - People
Infection control staff and clinicians
Linked to Users - Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People
- Specimens
Lab specimens and their processing state
Linked to Infection investigations - Metric observations
Measured metric observations
Linked to Infection investigations, People - Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People - Investigation notes
Attributed investigation documentation
Linked to Infection investigations, People - People
Infection control staff and clinicians
Linked to Users
- Treatment dispensations
Medication dispensations with lot and quantity
Linked to Infection investigations, People - Infection investigations
Infection investigations and their exposure episodes
Linked to Cases, People - People
Infection control staff and clinicians
Linked to Users - Clinical privileges
Verified clinician privileges
Linked to People - Investigation notes
Attributed investigation documentation
Linked to Infection investigations, People
Keys and references
The case identifier groups investigations and case-level actions. Investigation references keep notes, observations, specimens, charges and dispensations under the episode that produced them. Person references identify investigators, note authors, observation recorders, assignees and treatment authorizers. Read the actual status and date fields on each related record when evaluating a case.
Migration order
- Load Users and People, checking their account links.
- Load Cases and their assigned investigators.
- Load clinical privileges, Consents and investigation team assignments with valid person and case references.
- Load infection investigations under the intended Cases.
- Load investigation notes, metric observations, Specimens, treatment dispensations and Charges under their investigations.
- Load follow up actions and Payments under their cases; verify due dates, amounts and states.
Set up Infection Control System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.