PNEG_SURG_HX

Description:

The PNEG_SURG_HX table contains pertinent negative surgical history data from history contacts entered in clinical system patient encounters. Since one patient encounter may contain multiple surgical history contacts, each contact is uniquely identified by a patient encounter serial number and a line number.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
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	PNEG_SURG_HX_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
4	PNEG_SURG_HX_DT	DATETIME	No
	The entry date for a patient's pertinent negative surgical history for a procedure.
5	PNEG_SURG_HX_CMT	VARCHAR	No
	Free text comments entered for the patient's pertinent negative surgical history.
6	PNEG_SURG_HX_SRC_C_NAME	VARCHAR	No
	The category number for the source of entry for the surgical history. Category table information for this item is stored in the Clarity table ZC_HISTORY_SOURCE. May contain organization-specific values: Yes Category Entries: Provider Patient Parent Legal Guardian Proxy User Automatically reconciled from patient Automatically reconciled from proxy