SURGICAL_HX
Description:
The SURGICAL_HX table contains data from medical history contacts entered in clinical system patient encounters. Since one patient encounter may contain multiple medical history contacts, each contact is uniquely identified by a combination of the 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_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
2 LINE INTEGER No
The line number of the surgical history contact within the encounter.
3 PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
4 SURGICAL_HX_DATE VARCHAR No
The free-text date entered in a patient's Surgical History for the procedure.
5 COMMENTS VARCHAR No
Free-text comments entered for the procedure in the surgical history contact.
6 PROC_COMMENTS VARCHAR No
Free-text comments entered for the "other" procedure in the patient's surgical history.
7 CONTACT_DATE DATETIME No
The contact date of the encounter associated with this surgical history contact. Note: There may be multiple encounters on the same calendar date.
8 CM_CT_OWNER_ID VARCHAR No
ID of the deployment owner for this contact.
9 PAT_ENC_CSN_ID NUMERIC No
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
10 SURGICAL_HX_SRC_C_NAME VARCHAR No
This category number represents the source of entry, the person providing the information, for the surgical history data.
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
11 HX_LNK_ENC_CSN NUMERIC No
The Contact Serial Number of the encounter in which the history was created/edited. If the history was created/edited outside of the context of an encounter, then this column will be blank.
12 SURGICAL_HX_SRG_CSN NUMERIC No
Stores the contact serial number of the surgery contact related to the current procedure.
13 SURG_LATERALITY_C_NAME VARCHAR No
This category is used to store the laterality for each past surgical record in surgical history.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
14 SURG_HX_START_DT DATETIME No
The starting date for the range of possible dates extracted from the free text date entered in column SURGICAL_HX_DATE. It is filled in automatically when the patient's history is saved. The ending date is in column SURG_HX_END_DT.
15 SURG_HX_END_DT DATETIME No
The ending date for the range of possible dates extracted from the free text date entered in column SURGICAL_HX_DATE. It is filled in automatically when the patient's history is saved. The starting date is in SURG_HX_END_DT.
16 SURG_HX_ORDER_ID NUMERIC No
The unique ID of the order related to the current surgical history procedure