THRESHOLD_VALUES

Description:

Patient-specific reference range values and related information.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier (.1 item) for the patient threshold record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	HIGH_VALUE	VARCHAR	No
	High value for the reference range
4	LOW_VALUE	VARCHAR	No
	Low value for the reference range
5	FROM_TM	DATETIME (Local)	No
	Beginning instant for the reference range for when it should be used
6	TILL_TM	DATETIME (Local)	No
	Ending instant for when the reference range should be used
7	WHO_CHANGED_ID	VARCHAR	No
	The unique ID representing the employee who entered the data corresponding to this line.
8	WHO_CHANGED_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	WHEN_TM	DATETIME (Local)	No
	Instant when the data in this line was changed.
10	COMMENTS	VARCHAR	No
	Comments about the reference range represented by the current line.
11	FROM_UTC_DTTM	DATETIME (UTC)	No
	Beginning instant (UTC, used for new values) for when this reference range should be used.
12	TILL_UTC_DTTM	DATETIME (UTC)	No
	Ending instant (UTC, used for new values) for when this reference range should be used.