|
|
| (19 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''' Canadian Forces | | * '''[[#CF|CF]]''' Canadian Funded (RCMP, Canadian Forces...) |
| * '''NK''' Not Known / Not available | | * '''NK''' Not Known / Not available |
| * '''OS''' Outside of North America | | * '''OS''' Outside of North America |
|
| |
|
| == Data Integrity Checks == | | == Canadian Forces patients == |
| See [[PHIN field]] for details on how the Province field and the PHIN field relate.
| | see [[Canadian Forces patients]] |
|
| |
|
| == Should we have a CF entry? How is it used? == | | == Data Integrity Check List == |
| {{discussion}} | | {{Data Integrity Check List}} |
| This will probably address the two sub-headings.
| |
|
| |
|
| All province entries except CF are geographical and administrative. CF is only administrative. If we are interested in flagging patients who live in a province but are not insured by that province we would also need to track First Nations, RCMP and resident aliens like visa students. I don't think we care to break out the rest, so for consistency the "CF" province entry should be eliminated.
| | === Data Structure === |
| * Julie/Trish, is there any reason to keep CF separate? Has anyone request ever included this as a criterion? [[User:Ttenbergen|Ttenbergen]] 12:01, 2012 September 6 (CDT)
| | The field draws its options from the [[S_Provinces table]] in [[CCMDB.accdb]]. |
| ** no.-[[User:TOstryzniuk|Trish Ostryzniuk]] 19:18, 2012 November 13 (EST)
| |
| *** So, why do we code it separately? How is it used? Answer will affect question below as well. Ttenbergen 12:53, 2013 February 11 (EST)
| |
| ****Looking into it now. Have a couple in Med from 2012. Since some pts from HSC, Pagasa will look up in [[Reflections]] if they do have MB PHIN. There are 26 patients in entire ICU & Med database that have the code CF. One coded and CFM. Never used for anything. -[[User:TOstryzniuk|Trish Ostryzniuk]] 13:34, 2013 February 11 (EST)
| |
| *****Audit: Changed 7 files Province's from CF to MB. Found one RCMP codes as CF at STB. Updated 5 profiles in database with a PHIN that we found using [[Reflections]]. Reviewed Data crosschecked with MB Health showed no match on any of the identifiers for any of these clients. HSC has access to MB Health data so MR likely updated info on [[Reflections]] at some point much later. Not sure how often they check to fill in missing information either. We do have some MB health matches that we don't see as being updated in HSC [[Reflections]].
| |
| ****** Leaves us with 18 Prov still codes as CF. Will get the rest of audit finding from Pagasa tommorrow.-[[User:TOstryzniuk|Trish Ostryzniuk]] 20:27, 2013 February 11 (EST)
| |
| *RCMP and CF are federally funded so they don't have a PHIN number.
| |
|
| |
| === Precedence of CF over residence province === | |
| {{discussion}}
| |
| *Does CF take precedence over the province where someone lives? [[User:Ttenbergen|Ttenbergen]] 12:01, 2012 September 6 (CDT)
| |
| **Usually flagging a patient as a member of the CF is to ensure billing is properly handled. I wouldn't have thought it matters to CCMDB who's paying the bill--they are patient in a WRHA hospital receiving care and for which data should be collected. Ditto for TISS. -- [[User:Fschumacher|Fred Schumacher]] 17:12, 2012 November 13 (EST)
| |
| ***I don't think you meant to include TISS here. I believe we tagged patients as CF because they did not a MB health number, or it was some long number and so when we sent for crosschecking to MB Health and they find no match, we have a reason why no match was found. Julie might remember since she has taken over the crosschecking with MB Health. Julie also may have some idea's on this based on what she or Pagasa see coming back from MB health. -[[User:TOstryzniuk|Trish Ostryzniuk]] 19:17, 2012 November 13 (EST)
| |
|
| |
|
| === CF family members not coded as CF === | | == Related articles == |
| Medical coverage for CF dependents is covered by the province in which they live. They do not receive any healthcare services from the CF.
| | {{Related Articles}} |
|
| |
|
| [[Category: Data_Collection_Guide]] | | [[Category: Data_Collection_Guide]] |
| [[Category: Registry Data]] | | [[Category: Registry Data]] |
| [[Category: Questions General Collection]] | | [[Category: Demographics]] |
| 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.
Legacy implementation right in the table
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
Data Integrity Check List
Data Structure
The field draws its options from the S_Provinces table in CCMDB.accdb.
Related articles