S HospitalCodes: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The S_HospitalCodes table is found in [[CCMDB.mdb]]. It is a table that contains a list of ALL [[ | The S_HospitalCodes table is found in [[CCMDB.mdb]]. It is a table that contains a list of ALL [[Hospital previous]] codes. | ||
The '''S_HospitalCodes''' table contains the possible values for the [[Hospital previous]] data entry field in the [[CCMDB.mdb]] in the Registry screen. | The '''S_HospitalCodes''' table contains the possible values for the [[Hospital previous]] data entry field in the [[CCMDB.mdb]] in the Registry screen. | ||
Revision as of 20:08, 2012 November 1
The S_HospitalCodes table is found in CCMDB.mdb. It is a table that contains a list of ALL Hospital previous 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
see table for actual contents as they change