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
11 MCAID_INCARCERATION_BILL_CODE VARCHAR No
A code that indicates the encounter is billable to Medicaid due to a state-specific program for reimbursing care offered to incarcerated patients.
12 MCAID_INCAR_BILL_START_DATE DATETIME No
The earliest date associated with this encounter that Medicaid is billable due to a state-specific program for reimbursing care offered to incarcerated patients.
13 MEDICARE_CHANGE_C_NAME VARCHAR No
Question on the MSPQ RTE Integration version of the MSPQ. The question asks if there has been a change in Medicare entitlement. The three possible answers are Yes, No, and Could Not Answer.
May contain organization-specific values: No
Category Entries:
Yes
No
Could Not Ask
14 MSP_RTE_VERI_STAT_C_NAME VARCHAR No
The verification status for MSPQ RTE Integration. If the user manually completes the full MSPQ, this status is set to one that starts with "User Filled Out" based on the reason manual completion was required. Otherwise, it's set to the outcome of comparing eligibility messages from Medicare to determine if the MSPQ for this encounter can be shortened by reusing information from one of the patient's previous MSPQs.
May contain organization-specific values: No
Category Entries:
RTE Has Changes
RTE Has No Changes
User Filled Out - Difference Found in RTE Responses
RTE Has No Changes and Patient Verified No Changes
User Filled Out - No MSPQ to Copy
User Filled Out - No RTE Response
User Filled Out - Patient Didn't Confirm No Coverage Change
User Filled Out - Questionnaire Response Prevented Copying
User Filled Out - MSPQ RTE Integration Disabled
User Filled Out - Initially Suppressed
15 MSP_COMP_REALTIME_TX_CSN_ID NUMERIC No
The unique RTE contact serial number of the 271 Eligibility Response associated with the encounter's date of service, compared with prior responses for MSPQ RTE Integration.
16 MSP_RTE_COMP_PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number (CSN) of the encounter being used for RTE message comparison for MSPQ RTE Integration.