I realize these are more associated with the public health side but know I'll be asked to make modifications.
Spent a bit of time reviewing the database and its structure but haven't come across the table where the race/ethnicity info is secured.
EDIT: Not the result stored within the patient record but the actual selection drop down choices...
I checked briefly through the definitions, preferences, patient and screening tables but with the exception of some potentially scrambled entries - I hadn't seen anything overly obvious - at least not yet - and figured somewhere here probably had already tackled this...
Any suggestions or is that just a limitation in the trial version?
EDIT: Disregard...these currently appear to be hardcoded. Any chance of this changing shortly?
Thanks
Modifications to the Race/Ethnicity dropdown?
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Right. It's hard coded as an enumeration. The options are those required by the Federal government for public health, so we thought we pretty much had it covered for a while. What other options are you looking for?
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
As with all too many things - especially with data - people usually will want more once they see what the system is capable of. Although this list may encompass the groupings currently in use by many Fed agencies - others and specific States and clients are interested in further breakdowns (e.g. specific Indian Tribes) and would prefer not to leave the data entry to either a blank - unknown - or other.jordansparks wrote:Right. It's hard coded as an enumeration. The options are those required by the Federal government for public health, so we thought we pretty much had it covered for a while. What other options are you looking for?
I couldn't agree more that standardization will be a great benefit but until that concensus is reached within the States and specific clients - the flexibility is something that all too often comes up as a request.
The next round of digging will include the BSS sections as that usually comes up too.
I know that and others will come up in discussions and rather than have to upgrade to another version once Feds / States change their minds on a specific grouping or how they want to further delineate the data for research concerns - I figured I'd ask.
Thanks
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
The solution, of course, it to eventually turn it into another table in the database.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com