I'm just reading this thread and wonder if you have a table of the ICD9 codes? Do you have info about the code's basic structure?
Seems code 250.x relates to Diabetes, but not necessarily DiabetesII.
Basicaly ICD9 codes work under a branch structure. 250.XX relates to diabetes. 250.00 is type II diabetes where as 250.01 is type I diabetes. The structure for all of Diabetes is listed here for example: http://www.icd9data.com/2012/Volume1...50/default.htm
Do you have a list of the types of questions you want to pose and get answers from whatever structure evolves?
Some. For example, based on intake questionnaires some patients are put on different weight loss tracks with different procedures. An example question: Do patients who have Type II diabetes fare better on the track that addresses Psychological Components or dietary components. Which track produces the best result for diabetics? Of the diabetics, did the presence of Byetta or X type of insulin have a more favorable result.
You need to model against what you want, in my view, at this time. Populate the structures based on the data you have as a prototype.
This is the problem I am having at the moment. I can't figure out how to build correct database structure. The structure jzwp11 proposed I understand and works as a prototype. I collected this data retrospectively, so I have some idea of the questions Iwant answered, but going through the data and analyzing it will help generate more ideas. It is why I am trying to build the database to query some very basic things. Another data extraction with the other half of the dataset is still coming, so I want to have the process of moving data from excel to access be familiar.
If you don't have the data, and can't get certain data, then you'll have to adjust the structure accordingly.
Definitely, I have come to terms with that.
There may be some questions that can't be answered, but some general prototyping should highlight those, provided you have a good understanding of the data you have, and the questions you want answered.
Again, just some thoughts, after reading the thread quickly.