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