Data dictionary › Treatment plans, protocols & standing orders

W_GOALS

Single Population

File
data/W_GOALS.csv
Category
reference
Primary key
GOAL_NUMBER
Columns
5

01Relates to the patient

reference data (no patient link)

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

02References

  • FUNCTIONAL_AREA_SEQUENCE, FUNCTIONAL_AREA_TYPE → FUNCTIONAL_AREAS.SEQUENCE_NO, FUNCTIONAL_AREA_TYPE
  • GOAL_GROUP_ID → W_GOAL_GROUPS.GOAL_GROUP_ID

03Columns

#ColumnTypeSource typeNullNotes
1GOAL_NUMBER PKintegerintno
2FUNCTIONAL_AREA_SEQUENCEintegerintyes
3FUNCTIONAL_AREA_TYPEstringvarchar(10)yes
4GOAL_DESCstringvarchar(max)yes
5GOAL_GROUP_IDintegerintyes