Province field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Fschumacher (talk | contribs)
approved
142 edits
No edit summary
mNo edit summary
 
(35 intermediate revisions by 3 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? ==
{{discussion}}
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 Integrity Check List ==
* 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)
{{Data Integrity Check List}}


=== Precedence of CF over residence province ===
=== Data Structure ===
{{discussion}}
The field draws its options from the [[S_Provinces table]] in [[CCMDB.accdb]].
*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)


=== CF family members ===
== Related articles ==  
{{discussion}}
{{Related Articles}}
*Does this include family members of CF staff? [[User:Ttenbergen|Ttenbergen]] 12:01, 2012 September 6 (CDT)
** No. Medical coverage for CF dependents is covered by the province in which they live. They do not receive any healthcare services from the CF.-- [[User:Fschumacher|Fred Schumacher]] 17:07, 2012 November 13 (EST)


[[Category: Data_Collection_Guide]]
[[Category: Data_Collection_Guide]]
[[Category: Registry Data]]
[[Category: Registry Data]]
[[Category: Questions General Collection]]
[[Category: Demographics]]

Latest revision as of 12:03, 2022 January 5

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

Data Integrity Check List

Data Integrity Checks (automatic list)

 AppStatus
Function Validate ProvinceCCMDB.accdbimplemented

Data Structure

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

Related articles

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