| 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 |
|
|
The groupname that created this record. |
|||||
| id | Unknown | 0 | null |
|
|
Unique identifier for each aftercare plan entry. Primary key. |
|||||
| pid | Unknown | 0 | null |
|
|
The internal patient identifier |
|||||
| provider | Unknown | 0 | null |
|
|
Provider assigned to the patient for aftercare planning.UNUSED |
|||||
| user | Unknown | 0 | null |
|
|
User responsible for creating the aftercare plan. |