Data dictionary › Treatment plans, protocols & standing orders

GOAL

Single Population

File
data/GOAL.csv
Category
reference
Primary key
GROUPID, PROBLEMNUMBER, GOALNUMBER
Columns
5

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

02References

  • GROUPID, PROBLEMNUMBER → PROBLEM.GROUPID, PROBLEMNUMBER

03Columns

#ColumnTypeSource typeNullNotes
1GROUPID PKintegersmallintno
2PROBLEMNUMBER PKintegersmallintno
3GOALNUMBER PKintegersmallintno
4DESCRIPTIONstringnvarchar(255)yes
5ISCUSTOMbooleanbitno