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
Automatically estimated from flowsheet responses
Care Everywhere