PAT_PREF_LAB_HX

Description:

This table contains the edit history for patient's preferred lab, including the lab, edit action, edit user, and instant of edit.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	LAB_EDIT_HX_ID	NUMERIC	No
	Patient's preferred labs' edit history.
4	LAB_EDIT_HX_ID_LLB_NAME	VARCHAR	No
	Interface laboratory name.
5	LAB_EDIT_ACT_HX_C_NAME	VARCHAR	No
	This column contains the category value corresponding to the edit action taken on the patient's preferred labs. May contain organization-specific values: No Category Entries: Add Remove
6	LAB_EDIT_USR_HX_ID	VARCHAR	No
	This column contains the user ID corresponding to the edit action taken on the patient's preferred labs.
7	LAB_EDIT_USR_HX_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	LAB_EDIT_IN_HX_DTTM	DATETIME (Local)	No
	The instant the edit action was taken on the patient's preferred labs.