S AllDiagnoses table

From CCMDB Wiki
Revision as of 17:09, 2012 February 7 by TOstryzniuk (talk | contribs)
Jump to navigation Jump to search

The S AllDiagnoses table can be found in CCMDB.mdb program. It contains the all the diagnoses labels and numeric codes used that the Data Collectors can select to enter into L_Dxs. A filtered subset of this table contains the values Comorbid Diagnosis that can be selected and entered into L_Como.

Data Structure

  • Area - Organs system or similar classification
  • MainDiagnosis
  • SubDiagnosis - explain uppercasing
  • DiagnosisCode - primary key
  • Notes
  • IsInfection
  • Como
  • Diag
  • ComoPoints

Related Tables:

trish check