To begin, we have defined a generic file format for .csv files which can be used by almost any system. The current version of this template is available here.
At the top of the spreadsheet are the fields that need to be entered, and these need to be labeled as the following:
A required field, the six-digit Ministry of Health OHIP billing number.
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.
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
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.
An optional two-character field for the version code.
A required field, the patient's date of birth. Formatted MM-DD-YYYY.
A required field, Male or Female (case-insensitive).
An optional six-digit Ministry of Health OHIP billing number representing the referring physician.
An optional four-digit number representing the diagnostic code, right-justified with leading zeros (ie. 0040, 0340).
An optional four-digit number representing the location the service was performed (ie. 4108, 1100)
An optional field, the date of admission related to the claim. Formatted MM-DD-YYYY.
A required field, the date the service was performed. Formatted MM-DD-YYYY.
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.
A required field, the number of services provided or the total number of units to be billed for B and C suffix service codes.
Frequently Asked Questions
- Can I define my own file format?
No, not at this time. Just contact us and we'll see what we can do.
If you have any questions, please don't hesitate to ask. We're excited about this new feature, and always looking for feedback.