PATHWAY_STATUS
Description:
This table displays the status of the pathway (active, completed, or discontinued).

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID NUMERIC No
The unique ID of the treatment plans record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 STATUS_C_NAME VARCHAR No
This is the pathway status which can be Active, Completed or Discontinued.
May contain organization-specific values: Yes
Category Entries:
Active
Completed
Discontinued
4 UPDATE_BY_USER_ID VARCHAR No
The user who updated the pathway status.
5 UPDATE_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 UPDATE_AT_DATETIME DATETIME (Local) No
Stores the date and time when the pathway status was updated.