Province field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(→‎Discussion: Should we continue to collect CF as a province?)
Line 14: Line 14:
See [[PHIN field]] for details on how the Province field and the PHIN field relate.
See [[PHIN field]] for details on how the Province field and the PHIN field relate.


== Discussion ==
== Should we have a CF entry? How is it used? ==
{{discussion}}
{{discussion}}
Does CF take precedence over the province where someone lives? Does this include family members of CF staff? [[User:Ttenbergen|Ttenbergen]] 17:22, 1 November 2010 (CDT)
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.
* 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)
 
=== 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)
 
=== CF family members ===
{{discussion}}
Does this include family members of CF staff? [[User:Ttenbergen|Ttenbergen]] 12:01, 2012 September 6 (CDT)





Revision as of 12:01, 2012 September 6

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

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

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 Armed Forces
  • NK Not Known / Not available
  • OS Outside of North America

Data Integrity Checks

See PHIN field for details on how the Province field and the PHIN field relate.

Should we have a CF entry? How is it used?

Template: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.

  • Julie/Trish, is there any reason to keep CF separate? Has anyone request ever included this as a criterion? Ttenbergen 12:01, 2012 September 6 (CDT)

Precedence of CF over residence province

Template:Discussion Does CF take precedence over the province where someone lives? Ttenbergen 12:01, 2012 September 6 (CDT)

CF family members

Template:Discussion Does this include family members of CF staff? Ttenbergen 12:01, 2012 September 6 (CDT)