Support Center

How can I import my claims from another system?

Last Updated: Nov 01, 2013 09:51AM EDT
CabMD has a feature called "Claim Import" which allows you to import claims, in bulk, from other systems (like EMR's). To do that, we require a file in the correct format. If you are able, have the other company or software output the claims into the following formatm within a CSV (Comma Seperated Value) file:
  • ProviderNumber
    A required field, the six-digit Ministry of Health OHIP billing number.
  • GroupNumber
    An optional four-digit number representing the OHIP billing group, right-justified with leading zeros (ie. 0364, 3510). When billing solo claims, leave it blank or specify 0000.
  • ProvinceCode
    A required field, two-character representation of the province code:

    AB - Alberta
    BC - British Columbia
    MB - Manitoba
    NB - New Brunswick
    NL - Newfoundland and Labrador
    NS - Nova Scotia
    NT - Northwest Territories
    NU - Nunavut
    ON - Ontario
    PE - Prince Edward Island
    SK - Saskatchewan
    YT - Yukon
  • HealthNumber
    A required field, representing the patient's health number. Has a maximum length of 12, though each province has a different set of rules. OHIP health numbers are 10 digits, and must pass the Luhn algorithm - for example.
  • VersionCode
    An optional two-character field for the version code.
  • DOB
    A required field, the patient's date of birth. Formatted MM-DD-YYYY.
  • Gender
    A required field, Male or Female (case-insensitive).
  • ReferringProviderNumber
    An optional six-digit Ministry of Health OHIP billing number representing the referring physician.
  • DiagnosticCode
    An optional four-digit number representing the diagnostic code, right-justified with leading zeros (ie. 0040, 0340).
  • MasterNumber
    An optional four-digit number representing the location the service was performed (ie. 4108, 1100)
  • AdmissionDate
    An optional field, the date of admission related to the claim. Formatted MM-DD-YYYY.
  • ServiceDate
    A required field, the date the service was performed. Formatted MM-DD-YYYY.
  • ServiceCode
    A required field, the service performed. In the format ANNNS, where A is any letter of the alphabet, N is a number (digits 0-9) and S is the suffix A, B or C.
  • ServiceQty
    A required field, the number of services provided or the total number of units to be billed for B and C suffix service codes.

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found