Province field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →CF: broken out into Canadian Forces and RCMP patients |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
| CCMDB_tab = Dispo | | 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. | | 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 | | in_table = L_Log table | ||
| data_type = string | | data_type = string | ||
| datafield_length = 2 | | datafield_length = 2 | ||
| Line 13: | Line 13: | ||
== Collection Instructions == | == Collection Instructions == | ||
Choose the value for the "Province" field from the dropdown lists in [[CCMDB. | 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 | * '''US''' United States | ||
* '''[[#CF|CF]]''' Canadian Funded (RCMP, Canadian Forces...) | * '''[[#CF|CF]]''' Canadian Funded (RCMP, Canadian Forces...) | ||
| Line 19: | Line 19: | ||
* '''OS''' Outside of North America | * '''OS''' Outside of North America | ||
== Canadian Forces | == Canadian Forces patients == | ||
see [[Canadian Forces | see [[Canadian Forces patients]] | ||
=={{ | == Data Integrity Check List == | ||
{{Data Integrity Check List}} | |||
=== Data Structure === | === Data Structure === | ||
The field draws its options from the [[S_Provinces]] | The field draws its options from the [[S_Provinces table]] in [[CCMDB.accdb]]. | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data_Collection_Guide]] | [[Category: Data_Collection_Guide]] | ||
[[Category: Registry Data]] | [[Category: Registry Data]] | ||
[[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.
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
Data Integrity Check List
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Function Validate Province | CCMDB.accdb | implemented |
Data Structure
The field draws its options from the S_Provinces table in CCMDB.accdb.