TRG_BLOCK_INFO
Description:
This table contains information about certain types of planned orders, including orders from treatment days in treatment plans and therapy plans, and orders from clinical pathways steps.

Primary Key
Column Name Ordinal Position
REGIMEN_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 REGIMEN_ID NUMERIC No
The treatment day ID.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The line number that corresponds to each order block in the treatment day in this row.
4 CONTACT_DT DATETIME No
The contact date in external format of the treatment day in this row.
5 CM_CT_OWNER_ID VARCHAR No
ID of the deployment owner for this contact.
6 BLOCK_ID VARCHAR No
The ID of an order block in the treatment day in this row. In an IntraConnect environment this column contains the community ID (CID).
7 BLOCK_DAT VARCHAR No
The contact date (DAT) of an order block in the treatment day in this row.
8 BLOCK_INI VARCHAR No
The master file (INI) of an order block in the treatment day in this row. For example, "OTP".
9 BLOCK_DURATION NUMERIC No
The duration of an order block in the treatment day in this row.
10 BLOCK_CAT_C_NAME VARCHAR No
The category of an order block in the treatment day in this row.
May contain organization-specific values: Yes
Category Entries:
Other
11 BLOCK_WAIT_AFTER NUMERIC No
The number of days to wait after an order block in the treatment day in this row.
12 BLOCK_WAIT_FROM_C_NAME VARCHAR No
The 'wait after' category of an order block in the treatment day in this row. For example, Start or End.
May contain organization-specific values: No
Category Entries:
Start
End
13 BLOCK_MAX_LEAD NUMERIC No
The max lead of an order block in the treatment day in this row.
14 BLOCK_MAX_LAG NUMERIC No
The max lag of an order block in the treatment day in this row.
15 BLOCK_SOURCE VARCHAR No
The source ID of an order block in the treatment day in this row.
16 BLOCK_OTP_ID NUMERIC No
The unique ID of the order block (patient order template) in the treatment day in this record.
17 CHILD_DISPLAY_NAME VARCHAR No
The display name of an order block in the treatment day in this record.
18 CHILD_SSC_ID NUMERIC No
The unique ID of a non-order block in the treatment day in this record.
19 CHILD_RECOMMEND_YN VARCHAR No
The flag indicating if the order item is recommended with an override reason.
May contain organization-specific values: No
Category Entries:
Yes
No
20 CHILD_REC_OVR_RSN_C_NAME VARCHAR No
The reason for deselecting the recommended item
May contain organization-specific values: Yes
No Entries Defined
21 CHILD_RECOM_OVR_CMT VARCHAR No
The comments for deselecting the recommended item
22 BLOCK_SRC_DAY_UID VARCHAR No
Stores the unique ID of the day from which it was created.
23 ORDER_RANK INTEGER No
Stores the position of this order in the treatment day from the source protocol. If this order was added manually to the treatment plan after it was created, then this item will be empty.