PAT_ENC_2
Description:
This table supplements the PAT_ENC table. 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 system identifier of the patient encounter. Contact serial number is unique across all patients and all contacts.
2 CONTACT_DATE DATETIME No
The date on which this patient encounter took place.
3 COPAY_COINS_FLAG VARCHAR No
Set to 1 if copay is coinsurance.
4 CAN_LET_C_NAME NUMERIC No
This column links to the type of canceled appointment letter sent for this patient encounter. Some examples are "No Letter", "No Show","Cancelation Letter", etc. This category column is linked to ZC_LET.LET_C.
May contain organization-specific values: Yes
Category Entries:
No Letter
5 SUP_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
6 SUP_PROV_C_NAME VARCHAR No
This column links to information about the Type of Supervising provider.
May contain organization-specific values: Yes
Category Entries:
No Supervision
7 SUP_PROV_REV_TM DATETIME (Local) No
This column contains the date and time when the supervising provider submitted his or her review
8 MEDS_REQUEST_PHR_ID NUMERIC No
The pharmacy identifier from which the medications were requested.
9 MEDS_REQUEST_PHR_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
10 MEDS_REQUEST_OP_C_NAME VARCHAR No
This column contains information about the fill option for the medication request.
May contain organization-specific values: No
Category Entries:
Left
Right
11 PHYS_BP VARCHAR No
This contains the patient's blood pressure that was entered during the patient encounter.
12 VITALS_TAKEN_TM DATETIME (Local) No
Holds the time the vitals were taken
13 PHYS_TEMP_SRC_C_NAME VARCHAR No
The source of the patient's temperature measurement.
May contain organization-specific values: Yes
Category Entries:
Oral
Tympanic
Rectal
Axillary
Temporal
Skin
Bladder
Core
Esophageal
14 PAT_PAIN_SCORE_C_NAME VARCHAR No
This column indicates how much pain the patient was in via pain score.
May contain organization-specific values: Yes
15 PAT_PAIN_LOC_C_NAME VARCHAR No
This column contains information about which body part is experiencing discomfort.
May contain organization-specific values: Yes
16 PAT_PAIN_EDU_YN VARCHAR No
This column contains information as to whether pain education questions were asked.
May contain organization-specific values: No
Category Entries:
Yes
No
17 PAT_PAIN_CMT VARCHAR No
This column contains comments that were entered pertaining to the patient's pain
18 PAT_PAIN_SCALE_CAT VARCHAR No
This item stores the pain scale category under which the pain score is collected.
19 SMOKING_STATUS_C_NAME VARCHAR No
This simply stores information about whether the patient smokes, is quitting, etc.
May contain organization-specific values: No
Category Entries:
Current/Former
Passive
Never
20 PHYS_SPO2 INTEGER No
Contains the blood oxygen saturation value for this encounter.
21 SYS_GEN_LOS_ID_PROC_NAME VARCHAR No
The name of each procedure.
22 DOC_HX_SOURCE_C_NAME VARCHAR No
Stores the source of entry for the history documentation. This category column is linked to ZC_HISTORY_SOURCE.HISTORY_SOURCE_C.
May contain organization-specific values: Yes
Category Entries:
Provider
Patient
Parent
Legal Guardian
Proxy User
Automatically reconciled from patient
Automatically reconciled from proxy
23 APPT_LET_C_NAME NUMERIC No
This column links to the type of appointment letter that was sent to this patient for this patient encounter. Some examples are "No Letter", "Appt Letter", etc. This category column is linked to ZC_LET.LET_C.
The category values for this column were already listed for column: CAN_LET_C_NAME
24 PARENT_ENC_CSN_ID NUMERIC No
This item is a link to an encounter's parent encounter through the parent's contact serial number. The contact serial number is the unique identifier for the encounter.
25 SYNC_IP_DATA_C_NAME VARCHAR No
This is a contact-specific flag to tell Chart Sync whether inpatient clinical data for this visit (such as medication administration or documentation flowsheet data) should be synchronized between deployments. A value of 1 (or Yes) means that inpatient clinical data has been, and will continue to be, synchronized for this visit. Note that this item can only be set for a contact whose type is (or was at some point) an inpatient admission.
May contain organization-specific values: No
Category Entries:
No
Yes
26 APPTMT_LET_INST DATETIME (Local) No
If an appointment letter has been printed for this patient encounter, this column will list the date and time it was printed. If multiple letters were printed, we'll list the date and time of the most recent one.
27 RESULT_LET_INST DATETIME (Local) No
If a result letter has been printed for this patient encounter, this column will list the date and time it was printed. If multiple letters were printed, we'll list the date and time of the most recent one.
28 RESCHED_LET_INST DATETIME (Local) No
If a reschedule letter has been printed for this patient encounter, this column will list the date and time it was printed. If multiple letters were printed, we'll list the date and time of the most recent one.
29 FOLLOW_LET_INST DATETIME (Local) No
If a follow-up letter has been printed for this patient encounter, this column will list the date and time it was printed. If multiple letters were printed, we'll list the date and time of the most recent one.
30 PHYS_PEAK_FLOW INTEGER No
This column contains a measurement of the flow of air from the lungs: Peak Flow. If this column contains data, the measurement was taken during the associated encounter.
31 ENC_SPEC_C_NAME VARCHAR No
The encounter specialty item holds which of the encounter provider's specialties should be used for billing and reporting purposes for this encounter.
May contain organization-specific values: Yes
32 LD_STATUS_YN VARCHAR No
Flag to denote if the encounter is for a mother who will deliver
May contain organization-specific values: No
Category Entries:
No
Yes
33 ADT_PAT_CLASS_C_NAME VARCHAR No
The category value corresponding to the Admission/Discharge/Transfer (ADT) patient classification for this patient contact.
May contain organization-specific values: Yes
34 OTHER_BLOCK_ID NUMERIC No
Stores "Other" Summary Blocks (non-IP, ED, OpTime)
35 OTHER_BLOCK_TYPE_C_NAME VARCHAR No
Indicates the specific type of the episode summary, whose ID is stored in I EPT 1970.
May contain organization-specific values: No
Category Entries:
Ambulatory
Leader Rounds
Travel
36 BILL_NUM VARCHAR No
Billing number, often used as an identifier in downstream systems.
37 IP_DOC_CONTACT_CSN NUMERIC No
For Hospital Outpatient Visit (HOV) encounters, this column stores the unique contact serial number for the patient contact which is used for clinical documentation. This can be set for appointment contacts if they are not converted to HOVs.
38 TEMP_PT_HIS_C_NAME VARCHAR No
This item shows the temporary patient history.
May contain organization-specific values: No
Category Entries:
Temporary
Identified as New or Anonymous
39 PRIMARY_PROCONT_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
40 PRIMARY_TEAM_ID NUMERIC No
The unique ID of the primary Provider Care Team for this patient encounter.
41 PRIMARY_TEAM_ID_RECORD_NAME VARCHAR No
The name of the record.
42 MCIR_VACCINE_CODE_C_NAME VARCHAR No
The patient's eligibility code for Michigan's vaccination registry. This item only applies for the state of Michigan.
May contain organization-specific values: Yes
No Entries Defined
43 VISIT_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
44 NO_INTERP_RSN_C_NAME VARCHAR No
This column holds the reason an interpreter is not needed for the visit (in the case of a patient who would normally require one). It is meant to be populated when the corresponding EPT 495-INTERPRETER NEEDED? value is "no".
May contain organization-specific values: Yes
No Entries Defined
45 CVG_ADD_DT DATETIME No
The add date returned in the response message by the payor for the encounter. The add date is defined as the date that the payor added the patient as being covered.
46 FARM_WORKER_C_NAME VARCHAR No
The category number of the patient's farm worker status for the encounter or appointment.
May contain organization-specific values: Yes
47 KIOSK_HH_QUEST_ID VARCHAR No
The unique ID of the health history template that is assigned to the patient encounter.
48 KIOSK_HH_QUEST_ID_RECORD_NAME VARCHAR No
The name of the Visit Navigator (VN) History Template Definition (LQH) record.
49 HSP_ACCT_ADV_DTTM DATETIME (Local) No
If the Hospital Account Advisor is turned on, this item records the date and time that the advisor's recommendation was accepted or rejected.
50 VISIT_VERIFIED_YN VARCHAR No
Indicates whether the visit is verified.
May contain organization-specific values: No
Category Entries:
Yes
No
51 VERIF_VISIT_DT DATETIME No
The current date the visit contact was verified.
52 VERIF_DATE_INIT_DT DATETIME No
The initial date the visit contact was verified.
53 VERIF_USER_ID VARCHAR No
This collects the user ID of the user who verified the visit.
54 ENC_LACT_STAT_C_NAME VARCHAR No
The lactation status category ID for the patient.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
55 PAT_LACT_CMNT VARCHAR No
The comments entered when the patient's lactation status has been edited.
56 COSIGNER_USER_ID VARCHAR No
The unique ID of the user who cosigned the patient's chart.
57 COSIGNER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
58 COSIGN_REV_INS_DTTM DATETIME (Local) No
The date and time the chart was cosigned.
59 PAR_DICT_COUNTER INTEGER No
The counter for partial dictation.
60 IS_LOS_UPDATE_C_NAME VARCHAR No
Stores the status of any Level of Service updates.
May contain organization-specific values: No
Category Entries:
CHANGE LOS UPDATE SENT
TX LOCKED UPDATE SENT
61 FORM_ID_COUNTER INTEGER No
Stores the counter of form IDs.
62 CONSNT_REV_USER_ID VARCHAR No
The unique ID of the user who reviewed patient consent.
63 CONSNT_REV_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
64 VISIT_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
65 VISIT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
66 SOCIO_SRC_C_NAME VARCHAR No
Stores the source of entry for the sociological history.
The category values for this column were already listed for column: DOC_HX_SOURCE_C_NAME
67 TEL_ENC_MSG_RGRDING VARCHAR No
Free-text field containing user entered information regarding a telephone encounter message.
68 MSG_PRIORITY_C_NAME VARCHAR No
Indicates the priority of the routed message.
May contain organization-specific values: No
Category Entries:
High
Normal
Low
69 RESEARCH_ENC_FLG_C_NAME VARCHAR No
Category ID of the research encounter flag used to mark the patient encounter as having all charges billed to a research study, the patient, or a mixture. This is used for charge routing.
May contain organization-specific values: Yes
Category Entries:
Research - Bill All to Patient
Research - Bill All to Study
Research - Bill Some to Study and Some to Patient
Not Research - Bill All to Patient
70 FAM_SPOUSE_NAME VARCHAR No
The name of the patient's spouse
71 MSG_CALLER_NAME VARCHAR No
The name of the caller who left this message
72 CONSENT_EXP_DATE DATETIME No
This is the expiration date of any consent forms that are attached to the patient.
73 CV_ACC4_PAT_RESP_YN VARCHAR No
Indicates whether a patient wants identifying information to be excluded from submission to the American College of Cardiology-National Cardiovascular Data Registry's (ACC-NCDR) Catheterization and/or Percutaneous Coronary Intervention (CathPCI) registry.
The category values for this column were already listed for column: LD_STATUS_YN
74 FAMILY_MEM_PREFIX_C_NAME VARCHAR No
This column stores the relationship between the patient and the patient's guarantor.
May contain organization-specific values: Yes
No Entries Defined
75 AVS_REFUSED_DTTM DATETIME (UTC) No
The date and time when an end user documented that the patient declined the After Visit Summary.
76 AVS_LAST_PRINT_DTTM DATETIME (UTC) No
Records the instant the After Visit Summary was last printed
77 MED_LIST_UPDATE_DTTM DATETIME (UTC) No
If a patient's prescriptions or Facility-Administered Medications (FAMs) are updated (signed, modified, or discontinued; or other med reconciliation actions are changed) after the After Visit Summary (AVS) has been printed, this item is updated to hold a timestamp indicating the last time that such updates were made. It is left blank if no AVS has been printed yet.