Data Export - Collaborative Care Enrollment Diagnoses
Generated by the Bulk Data Export system.
The order of columns is subject to change. When parsing files, please ensure to use headers rather than positional parsing to ensure you are reading the data correctly.
What this export contains
One row per diagnosis applied to a CoCM enrollment, with the code, designation and the exact start and end dates it was active. Unlike the diagnoses on the CoCM Billing export, this gives the full dated history per enrollment, so you can see precisely when a diagnosis was active.
Example questions this export can answer
- See the full diagnosis history for an enrollment, with dates
- Find enrollments with a specific diagnosis active in a period
- Reconcile billed diagnoses against the dated diagnosis history
| Column | Name | Format | Cardinality | Notes |
|---|---|---|---|---|
| instituteId | Institute ID | identifier | 1..* | Unique identifier of the institute |
| instituteShortcode | Institute Shortcode | string | 1..* | Short string human-readable name of the institute found in the instituteURL |
| id | ID | identifier | 1..1 | Unique identifier of a specific diagnosis & enrollment pair |
| enrollmentId | Enrollment ID | uuid | 1..1 | Identifier of the enrollment |
| patientId | Patient ID | identifier | 1..1 | Identifier of the patient for this enrollment |
| diagnosisId | Diagnosis ID | uuid | 1..1 | Identifier of the institute condition |
| code | Code | string | 1..1 | Code of the specific diagnosis |
| name | Name | string | 1..1 | Name of the specific diagnosis |
| designation | Designation | uuid | 1..1 | Designation of the specific diagnosis. Options include: {“primary”, “secondary”, “none”} |
| startDate | Start Date | timestamp | 1..1 | Date when this diagnosis was applied in YYYY-MM-DD format |
| endDate | End Date | timestamp | 0..1 | Date when this diagnosis was removed in YYYY-MM-DD format. Null blank valueif diagnosis is ongoing |