form_aftercare_plan


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_aftercare_plan.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Table for chart notes on patient aftercare plans, including Acute Intoxication/Withdrawal, Emotional/Behavioral Conditions and Complications, and Relapse Potential for patients’ care plans.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
activity Unknown 0 null

1 if plan is active, 0 if deleted
admit_date Unknown 0 null

Date when the patient was admitted to the aftercare plan.
authorized Unknown 0 null

Indicates authorization status for the aftercare plan.
client_name Unknown 0 null

Human readable name of the patient for whom the aftercare plan is created.
date Unknown 0 null

Date and time when the aftercare plan was created.
discharged Unknown 0 null

Date when the patient was discharged from the aftercare plan.
goal_a_acute_intoxication Unknown 0 null

1st Goal for Acute Intoxication/Withdrawal.
goal_a_acute_intoxication_I Unknown 0 null

2nd Goal for Acute Intoxication/Withdrawal.
goal_a_acute_intoxication_II Unknown 0 null

3rd Goal for Acute Intoxication/Withdrawal.
goal_b_emotional_behavioral_conditions Unknown 0 null

1st Goal for Emotional/Behavioral Conditions and Complications.
goal_b_emotional_behavioral_conditions_I Unknown 0 null

2nd Goal for Emotional/Behavioral Conditions and Complications.
goal_c_relapse_potential Unknown 0 null

1st Goal related to Relapse Potential.
goal_c_relapse_potential_I Unknown 0 null

2nd Goal related to Relapse Potential.
groupname Unknown 0 null
groups.name Defined in XML R

The groupname that created this record.
id Unknown 0 null

Unique identifier for each aftercare plan entry. Primary key.
pid Unknown 0 null
patient_data.pid Defined in XML R

The internal patient identifier
provider Unknown 0 null

Provider assigned to the patient for aftercare planning.UNUSED
user Unknown 0 null
users.username Defined in XML R

User responsible for creating the aftercare plan.

Relationships

Close relationships within degrees of separation