Province field

From CCMDB Wiki
(Redirected from Province Field)
Jump to navigation Jump to search
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: