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