Data dictionary › Problems, diagnoses & assessments

DIAGNOSIS

Population

File
data/DIAGNOSIS.csv
Category
reference
Primary key
GROUPID, PROBLEMNUMBER, DIAGNOSISTYPEID, DIAGNOSISNUMBER
Columns
8

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

02References

  • GROUPID, PROBLEMNUMBER → PROBLEM.GROUPID, PROBLEMNUMBER

03Columns

#ColumnTypeSource typeNullNotes
1GROUPID PKintegersmallintno
2PROBLEMNUMBER PKintegersmallintno
3DIAGNOSISTYPEID PKintegersmallintno
4DIAGNOSISNUMBER PKintegersmallintno
5ORDERNUMBERintegersmallintyes
6DESCRIPTIONstringnvarchar(100)yes
7LEGALCODEstringnvarchar(10)yes
8ISCUSTOMbooleanbitno