TPL_TXDAYS
Description:
This table contains the treatment days in a treatment plan record or the steps in a pathway record.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID NUMERIC No
The treatment plan ID.
2 LINE INTEGER No
The line number that corresponds to each treatment day in the treatment plan in this row.
3 TREATMENT_DAY_ID NUMERIC No
The treatment day row ID of a treatment day in the treatment plan.
4 TX_DAY_TYPE_C_NAME VARCHAR No
The treatment day type (outpatient or inpatient) of a treatment day in the treatment plan.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
5 TREATMENT_DAY_DAT VARCHAR No
The contact date (DAT) of a treatment day record in the treatment plan.
6 TREATMENT_DAY_NAME VARCHAR No
The treatment day name of a treatment day in the treatment plan.
7 TRT_CYCLE VARCHAR No
The cycle containing a treatment day in the treatment plan.
8 TREATMENT_DATE DATETIME No
The planned date in external format when a treatment day in the treatment plan is expected to occur.
9 PAT_ENC_CSN_ID NUMERIC No
The contact serial number (CSN) of the first patient encounter in which an order from this treatment day was released.
10 TRT_DAY_STATUS_C_NAME VARCHAR No
The status of a treatment day in the treatment plan. For example, Planned, Scheduled, Deferred, Canceled, Completed, or Deleted.
May contain organization-specific values: No
Category Entries:
Planned
Scheduled
Completed
Deleted
Started
Deferred
Canceled
Given Externally
Unscheduled
Non-Treatment Orders
11 TRT_DAY_WAIT_AFTER NUMERIC No
The number of days to wait after a treatment day in the treatment plan.
12 TRT_DAY_MAX_LEAD NUMERIC No
The max lead of a treatment day in the treatment plan.
13 TRT_DAY_MAX_LAG NUMERIC No
The max lag of a treatment day in the treatment plan.
14 TRT_DAY_UNIQ_ID VARCHAR No
A cycle-level unique ID of a treatment day in the treatment plan.
15 TRT_DAY_NUM INTEGER No
The treatment day number for this treatment day.
16 STEP_START_DTTM DATETIME (Local) No
The start date and time of the step.
17 MANUAL_STRT_STP_YN VARCHAR No
This flag indicates whether the step should be manually started. Y indicates that the step should be started manually. A null value or N indicates that the step doesn't need to be started manually.
May contain organization-specific values: No
Category Entries:
Yes
No
18 MANUAL_STRT_USER_ID VARCHAR No
The user who manually started the step.
19 MANUAL_STRT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
20 MANUAL_STRT_DTTM DATETIME (Local) No
The date and time when the step was manually started.
21 STEP_DURATION_SECS NUMERIC No
This item stores the duration of the step in seconds. This value can be added to the start date and time to get the end date and time of the step.
22 TX_STAT_CHG_USER_ID VARCHAR No
This item stores the ID of the user who changed the status of this treatment day.
23 TX_STAT_CHG_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
24 DAY_LENGTH INTEGER No
The number of calendar days that are represented by the treatment day.
25 TX_STATUS_CHG_DTTM DATETIME (Local) No
Stores the instant at which the day status changed.
26 DAY_CREATED_BY_ID VARCHAR No
Stores the ID of the user who created the treatment day.
27 DAY_CREATED_BY_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
28 DAY_CREATE_DTTM DATETIME (Local) No
Instant when the treatment day was created.
29 DAY_CREATE_COMMENT VARCHAR No
Additional comment entered by user when creating the treatment day.
30 DAY_SOURCE_UID VARCHAR No
Stores the unique ID of the day from which it was created.
31 TX_PLANNED_DT DATETIME No
Stores the planned date for the treatment day.
32 TX_STARTED_DTTM DATETIME (UTC) No
Stores the instant at which the day was started.
33 DAY_SOURCE_CSN NUMERIC No
When the treatment plan day is created from a protocol (PRL), the source treatment day (OSQ)'s contact serial number will be set in this item. If the treatment plan day is copied or deferred, this item will be copied into the new day.
34 AUTO_COMP_STATUS_C_NAME VARCHAR No
The status of the "Status" item of the day. Used in the cases where the system changes the status of the day (mainly auto-completes a day) so that we can determine if we need to let the user know about it the next time they open the plan.
May contain organization-specific values: No
Category Entries:
Pending
Reverted
Final
35 TREAT_DAY_CONTACT_DATE_REAL FLOAT No
The contact date real of the treatment day (TRG) record which is held in this row. The contact date real is a unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
36 DEFERRED_FROM_LN INTEGER No
If this treatment day was created by deferring another treatment day, this item will contain the line number of that deferred treatment day.
37 CONVERSION_TARGET INTEGER No
If this day was replaced for conversion, this will be the day (given by line in SI TPl 5000) that replaced it.
38 DAY_SOURCE_INSTANCE_NUM INTEGER No
For the clinical protocol treatment day contact indicated by the contact serial number in the DAY_SOURCE_CSN column, this column stores the instance number (or repetition number) represented by this day in the treatment plan.
39 TX_SCHED_DATE DATETIME No
Stores the date for which the treatment day is scheduled.
40 TX_SCHED_CONFLICT_C_NAME VARCHAR No
Stores whether the scheduled date of the treatment day is outside tolerance range or if multiple appointments are scheduled for the same treatment day.
May contain organization-specific values: Yes
Category Entries:
Outside Tolerance
Multiple Orders
41 DAY_PATTERN_SOURCE_LINE INTEGER No
For this day, if it was created from a pattern day, this item will store the source line in SI TPL 13000 it was created from.
42 DAY_CREATION_METHOD_C_NAME VARCHAR No
If this day was created from a repeating cycle, this column specifies whether it was created manually or automatically. This item will be blank if the day was not created from a repeating cycle, or if it was created by copying and pasting a repeating day.
May contain organization-specific values: No
Category Entries:
Created from Pattern Manually
Created from Pattern Automatically