S HospitalCodes

The S_HospitalCodes table is found in CCMDB.mdb. It is a table that contains a list of ALL HospitalPrevious codes.

The S_HospitalCodes table 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

• Altona Community Memorial Health Center
  • 102
• Arborg & District Health Center
  • 103
• Baldur District Hospital
  • 106
• Beausejour District Hospital
  • 107
• Benito Health Center
  • 108
• Berens River Nursing Station
  • 287
• Bethel Hospital Boundary Trails - Winkler
  • 109
• Bethesda Hospital - Steinbach
  • 110
• Birtle Health Services District
  • 171
• Bloodvein Nursing Station
  • 288
• Boissenvain Health Center
  • 113
• Brandon General
  • 1
• Brochet Nursing Station
  • 282
• Carberry Plains Health Facility
  • 135
• Carman Memorial Hospital
  • 116
• Cartwright & District Hospital
  • 117
• Center Medico-Social Desalaberry District Health Cen.St. Pierre-Jolys
  • 124
• Churchill Health Center
  • 130
• Cross Lake Nursing Station
  • 271
• Dauphin General Hospital
  • 122
• Deloraine Health Center
  • 123
• Erickson Hospital Dist.# 8A
  • 129
• Flin Flon General Hospital
  • 134
• Garden Hill Nursing Station
  • 273
• Gillam Hospital Inc.
  • 136
• Glenboro Health District
  • 139
• God’s Lake Nursing Station
  • 272
• Grandview District Hospital
  • 140
• Hamiota District Health Center
  • 143
• Hartney Medical Nursing Unit
  • 142
• Johnson Memorial Hospital- Gimili
  • 146
• Lac Brochet Nursing Station
  • 290
• Lac Du Bonnet District Health Center
  • 52
• Lakeshore District Health System - Ashern
  • 178
• Lakeshore District Health System E.M. Crow Memorial - Eriksdale
  • 128
• Leaf Rapids Nursing Station
  • 155
• Little Grand Rapids Nursing Station
  • 274
• Lorne Memorial Hospital- Swan Lake
  • 147
• Lynn Lake District Hosp. #38
  • 149
• MacGregor & District Health Center - Norfold
  • 156
• Manitoba Adolescent Treatment Center
  • 20
• McCreary-Alonsa Health Center - Emerson
  • 150
• Melita Health Center
  • 184
• Minnedosa District Hospital
  • 152
• Morden Health District
  • 153
• Neepawa District Memorial
  • 158
• Nelson House Nursing Station
  • 277
• Northern Medical Units (x3) 1. Easterville Nsg. Station
  • 70
• Norway House Hospital
  • 212
• Notre Dame Medical Nursing Unit #198
  • 159
• Oxford House Nursing Station
  • 278
• Pembina-Manitou Health Dist.
  • 151
• Percy E. Moore Hospital-Hodgson
  • 210
• Pinawa Hospital
  • 163
• Pine Falls General Hospital
  • 161
• Poplar River Nursing Station
  • 285
• Portage District Hospital
  • 162
• Pukatawagan Nursing Station
  • 281
• Red River Valley Health -Emerson
  • 131
• Red River Valley Health Dist. - Morris
  • 154
• Red Sucker Lake Nurse Stat.
  • 289
• Reston Health Center
  • 164
• Riverdale Health Cent. Rivers
  • 166
• Roblin District Health Center
  • 165
• Rock Lake Health District - Crystal City
  • 119
• Rossburn District Health Center
  • 167
• Russell District Hospital
  • 169
• Selkirk & District Gen. Hosp.
  • 173
• Seven Regions Health Center - Gladstone
  • 138
• Shamattawa Nursing Station
  • 284
• Shilo Military Hospital Shoal Lake
  • 202
• Strathclair Health Center
  • 174
• Snow Lake Medical Nursing Unit # 40
  • 111
• Souris District Hospital
  • 175
• South Indian Lake Nursing Stat.
  • 283
• Split Lake Nursing Station
  • 279
• St. Anne Hospital
  • 179
• St. Claude Hospital
  • 182
• St. Rose General Hospital
  • 172
• St. Therese Point Nursing Stat.
  • 280
• Stonewall & District Health Center Dr. Evelyn Memorial
  • 176
• Swan River Valley Hospital
  • 177
• Teulon Hunter Health District - Teulon
  • 144
• The Pas Health Complex
  • 170
• Thompson General Hospital
  • 187
• Tiger Hills Health Center - Treherne
  • 183
• Tri-Lake Health District - Killarney
  • 148
• Virden District Hospital
  • 180
• Vita & District Health Center
  • 181
• Wassagamack Nursing Station
  • 286
• Wawanesa & District Memorial Health Center
  • 186
• Whitmouth District Health Center
  • 185
• Winnipegosis Gen Hospital
  • 118

Template:Stub