S AllDiagnoses table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 13: | Line 13: | ||
Related Tables: | Related Tables: | ||
* [[ | * [[Check ORDx]] (to come) | ||
* [[s_alldiagnoses_Isolation]] (to come) | * [[s_alldiagnoses_Isolation]] (to come) | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
Revision as of 10:34, 2009 September 24
The S AllDiagnoses table contains the diagnoses that can be entered into L_Dxs. In Access, a filtered subset of this table also contains the values that can be entered into L_Como. On the PDA L_Como values are defined by the S CharlsonComorbids table instead.
Data Structure
- Area - Organs system or similar classification (
- MainDiagnosis
- SubDiagnosis - explain uppercasing
- DiagnosisCode - primary key
- Notes
- IsInfection
- Como
- Diag
- ComoPoints
Related Tables:
- Check ORDx (to come)
- s_alldiagnoses_Isolation (to come)