Province field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 4: Line 4:
The field draws its options from the [[S_Provinces]] table on the PDA and in the [[CCMDB.mdb]].
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 [[HanDBase]] on the [[PDA]] or in [[CCMDB.mdb | Access]].  
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:  
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  
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 ==
{{discussion}}
{{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)
Does CF take precedence over the province where someone lives? Does this include family members of CF staff?
 


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

Revision as of 17:22, 2010 November 1

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.

Discussion

Template:Discussion Does CF take precedence over the province where someone lives? Does this include family members of CF staff? Ttenbergen 17:22, 1 November 2010 (CDT)