Province field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (transcl and clean up)
m (m)
Line 1: Line 1:
<onlyinclude>The [[Province]]] field records the province in which the patient is registered with health care. If the patient is '''not eligible for health care''', it records the province that they reside in. </onlyinclude>
<onlyinclude>The [[Province]] field records the province in which the patient is registered with health care. If the patient is '''not eligible for health care''', it records the province that they reside in. </onlyinclude>


Choose the value for the "Province" field from the dropdown lists in [[CCMDB.mdb | Access]].  
Choose the value for the "Province" field from the dropdown lists in [[CCMDB.mdb | Access]].  

Revision as of 16:30, 2015 April 27

The Province field records the province in which the patient is registered with health care. If the patient is not eligible for health care, it records the province that they reside in.

Choose the value for the "Province" field from the dropdown lists in Access. The provincial abbreviations are the same as for mailing. In addition to the provinces you have the following options:

  • US United States
  • CF Canadian Funded (RCMP, Canadian Forces...)
  • NK Not Known / Not available
  • OS Outside of North America

CF

Use CF for patients who are funded by the federal government directly, eg. Canadian Forces, RCMP. These patients don't have a Manitoba PHIN.

We confirm our data against MB Health data, and Canadian Funded patients would not be on their list. To not get an error for them each time, we need a way to exclude them from the list. This is why they are coded as province = "CF".

If we need info on where they live we can use the Postal Code entries.

The CF entry was "Never used for anything. -Trish Ostryzniuk 13:34, 2013 February 11 (EST)"

  • RCMP and CF are federally funded so they don't have a PHIN number.

CF family members not coded as CF

Medical coverage for CF dependents is covered by the province in which they live. They do not receive any healthcare services from the CF.

Template:CCMDB Data Integrity Checks

Province can not be left blank. Also, see PHIN field for details on how the Province field and the PHIN field relate.

Data Structure

The field draws its options from the S_Provinces table on the PDA and in the CCMDB.mdb.