|
|
| Line 1: |
Line 1: |
| 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.
| | #redirect:[[S HospitalCodes table]] |
| *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
| |
| | |
| [[Category: Data structure]]
| |
| [[Category: Data Collection Guide]]
| |