PAT_SURG_DATA
Description:
This table contains information about items related to surgery, including: primary surgeon, procedure, location, and case and log status.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

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 PAT_ENC_DATE_REAL FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is populated only if you use IntraConnect.
5 CS_SURG_SURGEON_ID VARCHAR No
The unique ID of the primary surgeon for the surgery, stored here so that it can be synched across deployments to be shown in the chart review.
6 CS_SURG_PROC_ID VARCHAR No
The unique ID of the primary procedure for the surgery, stored here so that it can be synched across deployments to be shown in the chart review.
7 CS_SURG_PROC_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
8 CS_SURG_LOCATION_ID NUMERIC No
The unique ID of the surgery location, stored here so that it can be synched across deployments to be shown in the chart review.
9 CS_SURG_CASE_STAT_C_NAME VARCHAR No
The case status category number for the associated surgery, stored here so that it can be synched across deployments to be shown in the chart review.
May contain organization-specific values: Yes
Category Entries:
Scheduled
Canceled
Not Scheduled
Missing Information
Voided
Pending
Arrived
Completed
No Show
Pending Unscheduled
10 CS_SURG_LOG_STAT_C_NAME VARCHAR No
The log status category number for the associated surgery, stored here so that it can be synched across deployments to be shown in the chart review.
May contain organization-specific values: Yes
Category Entries:
Missing Information
Posted
Unposted
Voided
Completed
Canceled
11 CS_SURG_EAP_ID NUMERIC No
The unique ID of the primary procedure for the surgery, stored here so that it can be synced across deployments to be shown in the chart review.
12 CS_SURG_PROC_FRTXT VARCHAR No
The procedure name as exactly ordered by the surgeon/provider, stored here so that it can be synced across deployments to be shown in the chart review.
13 CS_SURG_PROC_LAT_C_NAME VARCHAR No
The procedure laterality, stored here so that it can be synced across deployments to be shown in the chart review.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
14 CS_SURG_SCHED_DTTM DATETIME (UTC) No
The procedure scheduled time, stored here so that it can be synced across deployments to be shown in the chart review.
15 CS_SURG_PROC_CMT VARCHAR No
The procedure comments, stored here so that it can be synced across deployments to be shown in the chart review.
16 CS_SURG_NOT_PERF_YN VARCHAR No
The flag determining if the surgery was marked as procedure not performed, stored here so that it can be synced across deployments.
May contain organization-specific values: No
Category Entries:
No
Yes
17 CS_SURG_CASE_CLASS_C_NAME VARCHAR No
Stores the class of the case (either Inpatient or Outpatient), stored here so that the class of the case can be determined across deployments.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
Cannot Be Determined