whoknows361
Technical User
hello all. firstly i appreciate ur help on my last 2 questions. I have a more effective design based on your support, but at this point I am a bit confused.
background: i am creating a database for program managers in a mental health facility. my current problem is how to arrange the diagnosis table(s).
current: i have created tables to handle client data, changes in therapists and case managers, 6 mo and annual updates to information, discharges and referrals, but am not sure how to arrange my diagnosis information.
info: A client is given a diagnosis on 5 axis' at certain points in their treatment. Once at open, second at 6 months, then at 12 months and then at every 6 month interval. Additionally, A therapist can change the current diagnosis on any axis at any time in treatment, until their discharge.
my thoughts: I was thinking of creating a table like this:
DX TABLE
Client name pk (links to client data table)
initial axis 1 code
initial axis 2 code
initial axis 3 code
initial axis 4 code
initial axis 5 score
6 month axis 1 code
6 month axis 2 code
6 month axis 3 code
6 month axis 4 code
6 month axis 5 score
12 month axis 1 code..... etc (for up to 5 years)
but am running into a conceptual understanding of how to include the dates, codes and score for each axis if a therapist changes the diagnosis anytime in treatment.
my ultimate goal is to be able to pull up in a report the dates and 5 axis of diagnosis assinged throughout a ct's treatment. ie.. when and what diagnosis was assigned to each axis. I have attached my current database design in hopes of some support.. and any ideas in regards to database design would be appreciate as well.
This is my first big database design and usage of Access and I would apppreciate all comments and ideas in how to do this and how to make my overall project more effective. Thanks for your help in advance.
If there is any more information you need for an effective response, please let me know and I will provide it.
Jonathan
background: i am creating a database for program managers in a mental health facility. my current problem is how to arrange the diagnosis table(s).
current: i have created tables to handle client data, changes in therapists and case managers, 6 mo and annual updates to information, discharges and referrals, but am not sure how to arrange my diagnosis information.
info: A client is given a diagnosis on 5 axis' at certain points in their treatment. Once at open, second at 6 months, then at 12 months and then at every 6 month interval. Additionally, A therapist can change the current diagnosis on any axis at any time in treatment, until their discharge.
my thoughts: I was thinking of creating a table like this:
DX TABLE
Client name pk (links to client data table)
initial axis 1 code
initial axis 2 code
initial axis 3 code
initial axis 4 code
initial axis 5 score
6 month axis 1 code
6 month axis 2 code
6 month axis 3 code
6 month axis 4 code
6 month axis 5 score
12 month axis 1 code..... etc (for up to 5 years)
but am running into a conceptual understanding of how to include the dates, codes and score for each axis if a therapist changes the diagnosis anytime in treatment.
my ultimate goal is to be able to pull up in a report the dates and 5 axis of diagnosis assinged throughout a ct's treatment. ie.. when and what diagnosis was assigned to each axis. I have attached my current database design in hopes of some support.. and any ideas in regards to database design would be appreciate as well.
This is my first big database design and usage of Access and I would apppreciate all comments and ideas in how to do this and how to make my overall project more effective. Thanks for your help in advance.
If there is any more information you need for an effective response, please let me know and I will provide it.
Jonathan