ORDER_SHEET_DATA
Description:
This table stores order and scheduling info for active and historical therapy protocols.

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 identifier for the plan 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 LINKED_OTP_ID NUMERIC No
Identifiers for order templates (OTP) present in this plan.
4 SESS_INTER_C_NAME VARCHAR No
Category value representing the plan level interval of an order.
May contain organization-specific values: No
Category Entries:
Every visit
Weekly
Every two weeks
Monthly
Quarterly
PRN
Once
Every three weeks
Every four weeks
Every five weeks
Every six weeks
Twice per week
Three times per week
Selected dates
Selected treatments
Daily
Every eight weeks
5 SESS_INIT_CNT NUMERIC No
Planned treatment count for an order scheduled for a fixed number of treatments.
6 TX_ORD_RELEASE_CNT NUMERIC No
The number of times an order has been generated from the associated order template (OTP).
7 SESS_START_DATE DATETIME No
Stores the first date on which treatment with the associated order is planned (user entered or calculated from a relative offset in the protocol).
8 ORDER_CAT NUMERIC No
Category associated with the general type of order.
9 ORDER_ADDED_DTTM DATETIME (Local) No
Instant at which this order was added to the plan.
10 SESS_ORDER_STAT_C_NAME VARCHAR No
Status of the order template.
May contain organization-specific values: Yes
Category Entries:
Active
Signed
Removed
Completed
11 LAST_RELEASE_DTTM DATETIME (Local) No
Instant at which the linked order template was last released as an order.
12 LAST_RELEASE_ORD_ID NUMERIC No
Identifier for the order (ORD) created on the last release of this order template.
13 MIN_TREAT_SEP INTEGER No
The minimum number of days expected between treatments with the affected order.
14 TREAT_DIST_C_NAME VARCHAR No
Stores the initial treatment distribution type. This item determines how a treatment is distributed from a chosen interval. If weekly is the chosen interval, only two distribution types are available for selection: any day or specific days. If any day is selected, then user's value in interval details description determine how many times a week this treatment is to be released. If specific days is selected, interval details description displays which days are selected. If another interval type is chosen, then other treatment distribution types are available. Currently this category only has items supporting a weekly interval.
May contain organization-specific values: No
Category Entries:
Any Day
Specific Days
Specific Day of Month
Specific Day of Week
15 INTER_DETAILS_DESC VARCHAR No
Stores information on how treatments are distributed in a specified interval.
16 DUE_DATE VARCHAR No
Stores the next due date of the linked order.
17 OTP_DISPLAY_SEQ INTEGER No
Stores the display order of an order template (OTP) within the therapy plan.
18 OTP_GROUP_PRL_CSN NUMERIC No
Stores the contact serial number (CSN) of the protocol contact that this order was associated with for grouping purpose.
19 END_DATE DATETIME No
Stores the end date for an order after which the order should be completed.
20 DEFAULT_SELECTION_C_NAME VARCHAR No
Stores the default selection status of the order during ordering workflow.
May contain organization-specific values: No
Category Entries:
Sign
Remove
21 ORDER_GROUP_CSN NUMERIC No
Stores the source order group contact serial number (CSN) from where the order came from.
22 ORDER_GROUP_NUM INTEGER No
Stores a unique number for orders that came from the same order group.
23 ORDER_GROUP_DFLT_SELECTION_C_NAME VARCHAR No
Stores the default selection status of the order group during ordering workflow.
The category values for this column were already listed for column: DEFAULT_SELECTION_C_NAME