DOCS_RCVD_TREAT_RESTR
Description:
This table contains treatment restrictions for the received document.

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

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of 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.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 TRT_REF_ID VARCHAR No
A unique reference identifier for a specific treatment restriction
6 CODE_STATUS_C_NAME VARCHAR No
The code status category ID for the received document.
May contain organization-specific values: Yes
Category Entries:
<Disabled>
Full Code
DNR
Partial Code
7 CODE_STS_DISP_NAME VARCHAR No
The code status display name
8 TREATMENT_C_NAME VARCHAR No
The treatment category ID for the received document
May contain organization-specific values: Yes
Category Entries:
Admission to intensive care unit
Cardiopulmonary resuscitation
Artificial respiration
Administration of blood product
Other
9 TREAT_PERMITTED_C_NAME VARCHAR No
The treatment permitted category ID for the received document.
May contain organization-specific values: Yes
Category Entries:
Yes
Yes with limitations
No
10 TREAT_LIMITS_HNO_ID VARCHAR No
The unique ID of the note record for the limitations or circumstances that apply to the treatment restriction
11 TREAT_START_DATE DATETIME No
The start date of the treatment restriction
12 TREAT_END_DATE DATETIME No
The end date of the treatment restriction
13 TREAT_EXPLANATION_HNO_ID VARCHAR No
The unique ID of the note record for additional free-text notes on the treatment restriction
14 TREAT_RESTR_CHKSUM VARCHAR No
Stores the checksum of the treatment restriction
15 TREAT_RESTR_SRC_CSN NUMERIC No
Stores the CSN of the source DXR that has the treatment restriction information
16 TREAT_LAST_UPD_INST_DTTM DATETIME (UTC) No
Stores the instant we consider the date this treatment restriction was last changed
17 TREATMENT_DISP_NAME VARCHAR No
The display name of the code for the medical treatment the treatment restriction relates to
18 TRT_CODE_STATUS_GRP_IDENT VARCHAR No
Identifier of the group that this Treatment Restriction/Code Status belongs to