S HospitalCodes

The S_HospitalCodes table in CCMDB.mdb contains the possible values for the Hospital previous data entry field in the CCMDB.mdb in the Registry screen.

• On the Registry data collection screen this field is referred to as Hospital Prev, however the CCMDB.mdb table that it draws data from is called: S_HospitalCodes.

data structure

• Hospital - Text - full name of hospital
• code - text - code in data type text
• codeNr - long integer - code in data type long integer, used for sorting
• sort_group - byte integer - sorting column to keep out-of-town etc together

Out of the Province of Manitoba

HospitalCode

• Alberta
  • 200
• British Columbia
  • 100
• New Brunswick / Newfoundland / Nova Scotia
  • 600
• North West Territories / Nunavut / Yukon
  • 700
• Ontario
  • 400
• Other Continents – all others
  • 900
• Saskachewan
  • 300
• Quebec
  • 500
• USA – any state
  • 800

In Province of Manitoba

see table for actual contents as they change