Province field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →{{CCMDB Data Integrity Checks|implemented}}: Template:CCMDB Data Integrity Checks change, replaced: {{CCMDB Data Integrity Checks}} → {{CCMDB Data Integrity Checks|implemented}} |
m Text replacement - "in_table = L_Log" to "in_table = L_Log table" |
||
| 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 | ||
Revision as of 16:50, 2017 November 29
| 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.mdb. 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 and RCMP patients
see Canadian Forces and RCMP patients
Template:CCMDB Data Integrity Checks
Province can not be left blank. Also, see PHIN field for details on how the Province field and the PHIN field relate.
Data Structure
The field draws its options from the S_Provinces table on the PDA and in the CCMDB.mdb.