PAT_ENC_3
Description:
This table supplements the PAT_ENC and PAT_ENC_2 tables. It contains additional information related to patient encounters or appointments.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN 1

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN 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 contact date in decimal format. The integer portion of the number indicates the date of 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 CHKOUT_USER_ID VARCHAR No
The unique ID number of the user who completed the check out process for the patient for this encounter. If the encounter has not been checked out, this field will appear as "null." This ID may be encrypted.
4 CHKOUT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 ENC_BILL_AREA_ID NUMERIC No
The bill area which should be assigned to charges created from this encounter. The available bill areas to choose from will be determined based on lists in the provider and department records.
6 ENC_BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
7 RX_CHG_ADMIT_FLG_C_NAME VARCHAR No
This item contains the status of charge suppression for the patient. 1 indicates all charges are being suppressed. 2 indicates suppressed charges are now dropped. 3 indicates some or all charges are currently being suppressed.
May contain organization-specific values: No
Category Entries:
All Rx Charges Pending
Rx Dropped Charges on Admission
Rx Charges Pending -- Charges Individually Flagged
Rx Dropped Charges by Utility
8 DX_UNIQUE_COUNTER VARCHAR No
The number of unique diagnoses associated with this patient encounter. Unique diagnoses are stored in item EPT 18425, which is extracted by the DX_UNIQUE column in the PAT_ENC_DX table.
9 HP_DEFAULTED_YN VARCHAR No
Whether the hospital problem was automatically populated from the list of admission diagnoses. This column will have a Y if the problem was populated from an admission diagnosis and an N otherwise.
May contain organization-specific values: No
Category Entries:
Yes
No
10 IP_CP_LAST_VAR_DTTM DATETIME (Local) No
The date and time the last care plan variance was documented.
11 READY_QUT_SMOKING_C_NAME VARCHAR No
This column is used to indicate whether patient is ready to quit smoking.
May contain organization-specific values: No
Category Entries:
Not Asked
Yes
No
12 COUNSELING_GIVEN_C_NAME VARCHAR No
This column is used to indicate whether smoking counseling is given.
May contain organization-specific values: No
Category Entries:
Not Answered
Yes
No
13 COMMAUTO_SENDER_ID VARCHAR No
The unique user ID of the sender of the automatically generated communications.
14 COMMAUTO_SENDER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 BENEFIT_ID NUMERIC No
The benefit record used to store discrete information about the patient's insurance benefits for this encounter.
16 PREPAY_DUE_AMT NUMERIC No
The amount of pre-payment that is due for this visit.
17 PREPAY_AMT_FROM_C_NAME VARCHAR No
The activity that set the pre-payment due amount.
May contain organization-specific values: No
Category Entries:
Estimate
Benefit Collection
Payment Collection
External System
Financial Assistance
18 PREPAY_PAID_AMT NUMERIC No
The pre-payment amount that has been collected for this visit.
19 PREADMSN_TESTING_DT DATETIME No
The preadmission testing date.
20 SMK_CESS_USER_ID VARCHAR No
The last user to modify the Smoking Cessation items for the encounter.
21 SMK_CESS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
22 SMK_CESS_DTTM DATETIME (UTC) No
Indicates whether Instant Smoking Cessation items were modified for an encounter.
23 DO_NOT_BILL_INS_YN VARCHAR No
Indicates if a visit is marked as Do Not Bill Insurance.
May contain organization-specific values: No
Category Entries:
No
Yes
24 SELF_PAY_VISIT_YN VARCHAR No
Indicates whether a visit is self-pay.
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
25 REFERRAL_TYPE_C_NAME VARCHAR No
The means by which the patient learned about the organization.
May contain organization-specific values: Yes
No Entries Defined
26 SCHOOL VARCHAR No
The patient's school.
27 COPAY_NUM_UNITS INTEGER No
The number of units used to calculate the copay for this encounter.
28 COPAY_AMT_PER_UNIT NUMERIC No
The copay per each copay unit for this encounter.
29 COPAY_LASTCALC_DT DATETIME No
The date the copay was last calculated for this encounter.
30 COPAY_OVERRIDDEN_YN VARCHAR No
Indicates whether the user has overridden the copay amount for this encounter.
The category values for this column were already listed for column: DO_NOT_BILL_INS_YN
31 OB_TOTAL_WT_GAIN NUMERIC No
This column contains the patient's total weight gain in ounces as of the encounter if the patient had a weight documented on the encounter and a pregnancy episode with a pregravid weight linked to the encounter.
32 MEDICAID_GROUP_NAME VARCHAR No
Item to store the name of a group defined by a Medicaid program.
33 STUDENT_STATUS_C_NAME VARCHAR No
Tracks a patient's student status for a given encounter.
May contain organization-specific values: Yes
No Entries Defined
34 MEDICAID_GROUP_ID VARCHAR No
Item to store the identifier of a group defined by a Medicaid program.
35 EXTERNAL_REF_ID VARCHAR No
The reference ID from an external organization for the patient visit.
36 OUTCOME_C_NAME VARCHAR No
The clinical outcome of an encounter. The value of this item will then be used to determine the appropriate RTT/waiting status for the encounter. It is primarily applicable to the UK and Denmark.
May contain organization-specific values: Yes
37 HSPC_NO_ADM_C_NAME VARCHAR No
The Hospice Reason for Non-Admit category ID for the hospice episode.
May contain organization-specific values: Yes