Hello all,
I have the following fields,
Name
Address
Patient Count
LOS (length of stay)
TGR (total gross revenue)
ICD9 code (disease, illness, injury code)
ICD9 description (text description of the code)
The ICD9 code and description can have 30 levels, so ICD9 code 1, ICD9 code 2, ICD9 code 3, etc, meaning 30 columns or fields.
I have three issues or items I wish to accomplish, and they are,
1. All I want is one field for the code, one for the description, and maybe if I was going to keep the levels intact, create a new "ICD9 level" field.
So instead of 60 columns, 30 for the code, 30 for the description, I would be down to 3.
2. The reason I want just the 3 columns is that I want to do counts on the ICD9 codes, within each and across all patients, as well as, if I choose, each level. There are literally, 11,000 distinct codes, so counting these across 30 columns rather than 1 makes it nearly impossible.
3. How do I do this count mentioned in #2? Do I have to specify each of the 11,000 individual codes somewhere?
How do I go about achieving this?
Thank you,
Eric Lutz
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar