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.
17 | TAKING_PULL_REJECTED_YN | VARCHAR | No |
Indicates whether a user has clicked the "Clear Selections" button to dismiss suggested medication taking values from the current encounter.
The category values for this column were already listed for column: EST_PREPAY_CALC_PP_PROPOSED_YN
18 | HOSP_SERV_C_NAME | VARCHAR | No |
The category value corresponding to the hospital service for this patient contact.
May contain organization-specific values: Yes
19 | LEVEL_OF_CARE_C_NAME | VARCHAR | No |
The category value corresponding to the level of care for this patient contact.
May contain organization-specific values: Yes
20 | ACCOMMODATION_C_NAME | VARCHAR | No |
The category value corresponding to the room accommodation for this patient contact.
May contain organization-specific values: Yes
21 | ACCOM_REASON_C_NAME | VARCHAR | No |
The category value corresponding to the reason for the room accommodation for this patient contact.
May contain organization-specific values: Yes
22 | APPT_NEEDS_BED_C_NAME | VARCHAR | No |
Indicates whether the appointment needs bed utilization.
May contain organization-specific values: No
Category Entries:
None
Preprocedure
Postprocedure
Pre and Postprocedure
23 | APPT_BED_PREDEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
24 | APPT_BED_HOSP_SERV_C_NAME | VARCHAR | No |
For an appointment that needs bed utilization, the hospital service where the bed is needed.
The category values for this column were already listed for column: HOSP_SERV_C_NAME
25 | APPT_BED_POST_LEVEL_OF_CARE_C_NAME | VARCHAR | No |
For an appointment that needs bed utilization, the level of care where the bed is needed.
The category values for this column were already listed for column: LEVEL_OF_CARE_C_NAME
26 | APPT_BED_CMT_S | VARCHAR | No |
The comments associated with an appointment's bed utilization needs.
27 | SEPARATED_GROUP_YN | VARCHAR | No |
For group appointments, indicates whether the appointment was scheduled with the patients separated.
May contain organization-specific values: No
Category Entries:
Yes
No