Data dictionary › Treatment plans, protocols & standing orders

TREATMENT_PLAN_OBJECTIVES

Population

File
data/TREATMENT_PLAN_OBJECTIVES.csv
Category
reference
Primary key
MASTER_TEMPLATE_ID, GOAL_SEQUENCE_NO, OBJECTIVE_SEQUENCE
Columns
4

01Relates to the patient

reference data (no patient link)

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

02References

03Columns

#ColumnTypeSource typeNullNotes
1MASTER_TEMPLATE_ID PKintegerintno
2GOAL_SEQUENCE_NO PKintegerintno
3OBJECTIVE_SEQUENCE PKintegerintno
4OBJECTIVEstringvarchar(max)yes