S HospitalCodes table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m
 
m legacy
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.  
 
 
 
 
 
Legacy Data Only, now uses [[s_dispo table]]. Sites where we collect can be found in [[Site and Location table]].
 
 
 
 
 
 
 


== Data Structure ==
== Data Structure ==
Line 17: Line 29:
|}
|}


[[Category: Data structure]]
[[Category: Legacy Data structure]]

Revision as of 15:52, 2017 April 28



Legacy Data Only, now uses s_dispo table. Sites where we collect can be found in Site and Location table.





Data Structure

field type description
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