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
id BIGINT 19 √ null

Unique identifier for each aftercare plan entry. Primary key.
date DATETIME 19 √ null

Date and time when the aftercare plan was created.
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
users.username Defined in XML R

User responsible for creating the aftercare plan.
provider VARCHAR 255 √ null

Provider assigned to the patient for aftercare planning.UNUSED
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 √ null

Indicates authorization status for the aftercare plan.
activity TINYINT 3 √ null

1 if plan is active, 0 if deleted
client_name VARCHAR 255 √ null

Human readable name of the patient for whom the aftercare plan is created.
admit_date DATE 10 √ null

Date when the patient was admitted to the aftercare plan.
discharged DATE 10 √ null

Date when the patient was discharged from the aftercare plan.
goal_a_acute_intoxication TEXT 65535 √ null

1st Goal for Acute Intoxication/Withdrawal.
goal_a_acute_intoxication_I TEXT 65535 √ null

2nd Goal for Acute Intoxication/Withdrawal.
goal_a_acute_intoxication_II TEXT 65535 √ null

3rd Goal for Acute Intoxication/Withdrawal.
goal_b_emotional_behavioral_conditions TEXT 65535 √ null

1st Goal for Emotional/Behavioral Conditions and Complications.
goal_b_emotional_behavioral_conditions_I TEXT 65535 √ null

2nd Goal for Emotional/Behavioral Conditions and Complications.
goal_c_relapse_potential TEXT 65535 √ null

1st Goal related to Relapse Potential.
goal_c_relapse_potential_I TEXT 65535 √ null

2nd Goal related to Relapse Potential.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation