PAT_ENC_8
Description:
This table supplements the PAT_ENC, PAT_ENC_2, PAT_ENC_3, PAT_ENC_4, PAT_ENC_5, PAT_ENC_6, and PAT_ENC_7 tables. It contains additional information related to patient encounters or appointments.

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_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 only populated if you use IntraConnect.
5 EST_PREPAY_CALC_PP_PROPOSED_YN VARCHAR No
Indicates whether the patient was offered an estimated payment plan for this visit ('Y'). 'N' or NULL indicates that the patient was not offered an estimated payment plan for this visit.
May contain organization-specific values: No
Category Entries:
No
Yes
6 EST_PREPAY_CALC_ELIG_C_NAME VARCHAR No
The eligibility for remaining balances category ID for the payment plan associated with this visit.
May contain organization-specific values: No
Category Entries:
No
Yes
Yes, if prepay paid
Yes, in Hyperspace
7 PMT_PLAN_AGRMT_SCHED_PMT_ID NUMERIC No
The unique ID of the payment plan agreement created from this visit's pre-service sign up.
8 RSLT_FOL_UP_CREAT_SRC_C_NAME VARCHAR No
Contains the source workflow which created the Results Follow-Up encounter.
May contain organization-specific values: No
Category Entries:
Result Management
Card View
Note
Reflex Order
Results Release
Message Patient
Radiant Suggestion
Letters
Ask A Question
Result Management Mobile
Result Follow-up Telephone
OurPractice Advisories
Advanced Guidelines
9 BILL_DECIS_FIN_ASST_TRACKER_ID NUMERIC No
The ID of the decision for which this encounter is used to generate charges. This is set only by an automated process that requires the decision service grid to function.
10 NO_FOLLOW_UP_YN VARCHAR No
This indicates whether no follow-ups are needed for a visit.
The category values for this column were already listed for column: EST_PREPAY_CALC_PP_PROPOSED_YN