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
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.