Data dictionary › Treatment plans, protocols & standing orders

TREATMENT_PLAN_ACTIONS

Population

File
data/TREATMENT_PLAN_ACTIONS.csv
Category
reference
Primary key
MASTER_TEMPLATE_ID, GOAL_SEQUENCE_NO, OBJECTIVE_SEQUENCE, ACTION_SEQUENCE
Columns
5

01Relates to the patient

reference data (no patient link)

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

02References

  • MASTER_TEMPLATE_ID, GOAL_SEQUENCE_NO, OBJECTIVE_SEQUENCE → TREATMENT_PLAN_OBJECTIVES.MASTER_TEMPLATE_ID, GOAL_SEQUENCE_NO, OBJECTIVE_SEQUENCE

03Columns

#ColumnTypeSource typeNullNotes
1MASTER_TEMPLATE_ID PKintegerintno
2GOAL_SEQUENCE_NO PKintegerintno
3OBJECTIVE_SEQUENCE PKintegerintno
4ACTION_SEQUENCE PKintegerintno
5ACTION_DESCRIPTIONstringvarchar(max)yes