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
Care Everywhere
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