S HospitalCodes: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The S_HospitalCodes table | 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]]. | *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 == | == data structure == | ||
Revision as of 20:09, 2012 November 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.
- 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