Data Export - CoCM Billing Data
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
The CoCM billing summary: one row per enrollment per month of care, with the patient, the algorithm and the primary and secondary diagnoses in effect. It pulls together what you need to bill monthly Collaborative Care codes. Pair it with the Time Entry Log for the underlying minutes.
Example questions this export can answer
- Prepare monthly CoCM billing by patient and month
- See which diagnoses were in effect for a billed month
- Cross-check billing months against logged time
| Column | Name | Format | Cardinality | Notes |
|---|---|---|---|---|
| instituteid | Institute Id | identifier | 1..* | |
| instituteShortcode | Institute Shortcode | String | 1..* | |
| patientId | Patient Id | uuid | 1..1 | |
| patientName | Patient Name | string | 1..1 | |
| mrn | MRN | string | 0..1 | |
| enrollmentId | Enrollment Id | uuid | 1..1 | |
| monthOfCare | Month of Care | integer | 1..1 | The month number in the enrollment (1, 2, 3, etc.) |
| beginningOfMonth | Beginning of Month | date | 1..1 | The calendar month (beginning of month date) |
| algorithmId | Algorithm Id | uuid | 1..1 | |
| algorithmName | Algorithm Name | string | 1..1 | |
| primaryDiagnosisId | Primary Diagnosis ID | uuid | 0..1 | Unique identifier of a specific diagnosis. The primary and secondary diagnoses are based on the particular month. The diagnosis values can change throughout a month but are "locked in" for a month once the month is complete. Any changes to the diagnosis after a month is complete will only reflect on the following month. |
| primaryDiagnosisCode | Primary Diagnosis Code | string | 0..1 | Code of the specific diagnosis |
| primaryDiagnosisName | Primary Diagnosis Name | string | 0..1 | Name of the specific diagnosis |
| secondaryDiagnosisId | Secondary Diagnosis ID | uuid | 0..1 | Unique identifier of a specific diagnosis |
| secondaryDiagnosisCode | Secondary Diagnosis Code | string | 0..1 | Code of the specific diagnosis |
| secondaryDiagnosisName | Secondary Diagnosis Name | string | 0..1 | Name of the specific diagnosis |