Skip to main content

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
ColumnNameFormatCardinalityNotes
instituteidInstitute Ididentifier1..*
instituteShortcodeInstitute ShortcodeString1..*
patientIdPatient Iduuid1..1
patientNamePatient Namestring1..1
mrnMRNstring0..1
enrollmentIdEnrollment Iduuid1..1
monthOfCareMonth of Careinteger1..1The month number in the enrollment (1, 2, 3, etc.)
beginningOfMonthBeginning of Monthdate1..1The calendar month (beginning of month date)
algorithmIdAlgorithm Iduuid1..1
algorithmNameAlgorithm Namestring1..1
primaryDiagnosisIdPrimary Diagnosis IDuuid0..1Unique 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.
primaryDiagnosisCodePrimary Diagnosis Codestring0..1Code of the specific diagnosis
primaryDiagnosisNamePrimary Diagnosis Namestring0..1Name of the specific diagnosis
secondaryDiagnosisIdSecondary Diagnosis IDuuid0..1Unique identifier of a specific diagnosis
secondaryDiagnosisCodeSecondary Diagnosis Codestring0..1Code of the specific diagnosis
secondaryDiagnosisNameSecondary Diagnosis Namestring0..1Name of the specific diagnosis