- coverage – Main coverage record (this page)
- coverage_type_coding
- coverage_relationship_coding
- coverage_class – Backbone for class
- coverage_class_type_coding
- coverage_extension
- coverage_extension_vcc_coding
- coverage_references – Normalized references; see Reference Tables
- coverage_id
- patient_id - links to the patient table (beneficiary)
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| coverage_id | varchar | Unique identifier for the coverage |
| patient_id | varchar | Unique identifier for the patient (beneficiary) |
| status | varchar | Status of the coverage (e.g. active, cancelled, draft, entered-in-error) |
| period_start | datetime | Start of the coverage period |
| period_end | datetime | End of the coverage period |
| type_text | varchar | Free-text coverage type |
| type_hl7_code† | varchar | Coverage type: HL7 ActCode (v3-ActCode) |
| type_hl7_display† | varchar | Coverage type: HL7 ActCode display |
| relationship_text | varchar | Free-text subscriber relationship |
| relationship_hl7_code† | varchar | Subscriber relationship: HL7 code (subscriber-relationship) |
| relationship_hl7_display† | varchar | Subscriber relationship: HL7 display |
| subscriberid | varchar | Subscriber identifier |
| dependent | varchar | Dependent number |
| meta_source | varchar | Source document filename from FHIR meta.source |
| data_source_ext† | varchar | Integration source of the data, derived from FHIR extension |
Version diff
Renamedsubscriber_member_id→subscriberiddata_source→meta_source
source_type_code→coverage_type_coding.codew/code_rank = 1source_type_display→coverage_type_coding.displayw/code_rank = 1source_type_system→coverage_type_coding.systemw/code_rank = 1source_relationship_code→coverage_relationship_coding.codew/code_rank = 1source_relationship_display→coverage_relationship_coding.displayw/code_rank = 1source_relationship_system→coverage_relationship_coding.systemw/code_rank = 1class_group_code,class_group_display,class_group_system→coverage_classw/type_code = groupclass_plan_code,class_plan_display,class_plan_system→coverage_classw/type_code = plan