Province field: Difference between revisions
Ttenbergen (talk | contribs) m →CF: clean-up |
Ttenbergen (talk | contribs) m clean up and template |
||
| Line 1: | Line 1: | ||
{{Data_element | |||
Choose the value for the "Province" field from the dropdown lists in [[CCMDB.mdb | | field_name = R_Province | ||
The provincial abbreviations are the same as for mailing. In addition to the provinces you have the following options: | |||
| element_description = 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. | |||
| in_table = (L_Log table / | |||
| data_type = text/string | |||
| datafield_length = 2 | |||
| program_collecting = Med and CC | |||
| created_raw = raw | |||
}} | |||
Choose the value for the "Province" field from the dropdown lists in [[CCMDB.mdb]]. 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 29: | Line 44: | ||
[[Category: Data_Collection_Guide]] | [[Category: Data_Collection_Guide]] | ||
[[Category: Registry Data]] | [[Category: Registry Data]] | ||
Revision as of 13:59, 2016 October 12
| Data Element (edit) | |
| Field Name: | R_Province |
| CCMDB Label: | not stated |
| CCMDB tab: | not stated |
| Table: | (L_Log table / |
| Data type: | text/string"text/string" is not in the list (number, integer, long, boolean, string, memo, date, not entered) of allowed values for the "FieldDataType" property. |
| Length: | 2 |
| Program: | Med and CC |
| Created/Raw: | raw"raw" is not in the list (Raw, Created, not entered) of allowed values for the "FieldCreatedRaw" property. |
| Start Date: | 1988-07-11 |
| End Date: | 2300-01-01 |
| Sort Index: | 999 |
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 CCMDB.mdb. 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. RCMP and CF are federally funded so they don't have a Manitoba PHIN number.
If we need info on where they live we can use the Postal Code entries.
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.
use of "CF"
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".
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.