- consent – Main consent record (this page)
- consent_scope_coding
- consent_policyrule_coding
- consent_category – Backbone for category
- consent_category_coding
- consent_provision_code – Backbone for provision code
- consent_provision_code_coding
- consent_extension
- consent_extension_vcc_coding
- consent_references – Normalized references; see Reference Tables
- consent_id
- patient_id - links to the patient table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| consent_id | varchar | Unique identifier for the consent |
| patient_id | varchar | Unique identifier for the patient |
| status | varchar | Status of the consent |
| datetime | datetime | When the consent was communicated (FHIR Consent.dateTime) |
| scope_text | varchar | Free-text scope of the consent |
| scope_hl7_code† | varchar | Scope: HL7 code (consentscope) |
| scope_hl7_display† | varchar | Scope: HL7 display |
| category_hl7_code† | varchar | Category: HL7 code (consentcategorycodes) |
| category_hl7_display† | varchar | Category: HL7 display |
| policyrule_text | varchar | Free-text policy rule |
| policyrule_hl7_code† | varchar | Policy rule: HL7 code (consentpolicycodes) |
| policyrule_hl7_display† | varchar | Policy rule: HL7 display |
| meta_source | varchar | Source document filename from FHIR meta.source |
| data_source_ext† | varchar | Integration source of the data, derived from FHIR extension |

