|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| The S_HospitalCodes table is found in [[CCMDB.mdb]]. It is a table that contains a list of ALL [[HospitalPrevious]] codes.
| | #redirect:[[S HospitalCodes table]] |
| | |
| 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
| |
| | |
| | |
| {{stub}}
| |
| [[Category: Data structure]]
| |
| [[Category: Data Collection Guide]] | |