Province field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(removed from questions category...)
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''Province''' field records the province that the patient is registered with health care.  
{{Data_element
If the patient is '''not eligible for health care''', enter the province that they reside in.  
| field_name = R_Province
| CCMDB_label = Province
| CCMDB_tab = Dispo
| element_description = 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.  
| in_table = L_Log table
| data_type = string
| datafield_length = 2
| program_collecting = Med and CC
| created_raw = Raw
| data_element_sort_index = 16
}}


The field draws its options from the [[S_Provinces]] table on the PDA and in the [[CCMDB.mdb]].
== Collection Instructions ==
 
Choose the value for the "Province" field from the dropdown lists in [[CCMDB.accdb]]. The provincial abbreviations are the same as for mailing. In addition to the provinces you have the following options:  
Choose the value for the "Province" field from the dropdown lists in [[CCMDB.mdb | Access]].  
The provincial abbreviations are the same as for mailing. In addition to the provinces you have the following options:  
* '''US''' United States  
* '''US''' United States  
* '''[[#CF|CF]]''' Canadian Funded (RCMP, Canadian Forces...)
* '''[[#CF|CF]]''' Canadian Funded (RCMP, Canadian Forces...)
Line 11: Line 19:
* '''OS''' Outside of North America  
* '''OS''' Outside of North America  


== Data Integrity Checks ==
== Canadian Forces patients ==
Province can not be left blank.
see [[Canadian Forces patients]]
Also, see [[PHIN field]] for details on how the Province field and the PHIN field relate.
 
== 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.
== Cross checks ==
* [[Function Validate_Province]]


The CF entry was "Never used for anything. -[[User:TOstryzniuk|Trish Ostryzniuk]] 13:34, 2013 February 11 (EST)"
=== Data Structure ===
The field draws its options from the [[S_Provinces table]] on the PDA and in the [[CCMDB.accdb]].


*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.


[[Category: Data_Collection_Guide]]
[[Category: Data_Collection_Guide]]
[[Category: Registry Data]]
[[Category: Registry Data]]
[[Category: Demographics]]

Revision as of 11:43, 2019 September 22

Data Element (edit)
Field Name: R_Province
CCMDB Label: Province
CCMDB tab: Dispo
Table: L_Log table
Data type: string
Length: 2
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 16

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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instructions

Choose the value for the "Province" field from the dropdown lists in CCMDB.accdb. 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

Canadian Forces patients

see Canadian Forces patients

Cross checks

Data Structure

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Province_field&oldid=139452"