Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

Encounter

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to record encounter information. This table serves as a header from which details are stored in related tables.

Field Datatype Default Null Option Comment
EncounterSID INTEGER ?   MANDATORY System generated unique id using Encounter sequence.
ServiceCenterID INTEGER ?   OPTIONAL FK
PracticeID INTEGER ?   MANDATORY FK
EncounterNumber CHARACTER(14)   MANDATORY Practice assigned encounter number.
StaffID INTEGER ?   OPTIONAL FK
PatientID INTEGER ?   OPTIONAL FK
ReasonCode CHARACTER(6)   OPTIONAL User entered code for defining appointment reason. Valid reason code which corresponds to the purpose for the appointment.
OccurDate DATE   OPTIONAL Date encounter occurred.
OccurTime INTEGER 0   OPTIONAL Time encounter occurred.
RecordStatus CHARACTER(1)   MANDATORY User selected record status for the diagnosis code. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
EncounterStatus CHARACTER(1) Value__O_   OPTIONAL Indicates the status of the encounter. Possible values: Possible values: (O)pen (N)o-show (V)oid
DNSortEncounterNumber CHARACTER(14)   OPTIONAL Denormalized field maintained by customized write triggers. It is used for sorting purposes.
EncounterClass CHARACTER(6)   OPTIONAL User entered. Class of encounter. It classifies the encounter. Field is supported by the lookup types:[EncounterClass]. Values are defined in the LookupCode table for the above lookup types.
EncounterType CHARACTER(1) Number_One   OPTIONAL Indicates if the encounter is used for tracking. Possible values: 1- Non-Tracking Encounter 2 -Tracking encounter.
RoomCode CHARACTER(6)   OPTIONAL FK - User entered room number assigned to a room for non appointment encounters. If encounter associated with appointment then roomcode is denormalized from appointment.
EncounterSource CHARACTER(10)   OPTIONAL Indicates the 'source' of the encounter. Possible Values: (Ultia, CDT, EncNote, Intergy) This is not the full set. Over time, this list may grow. If the value is not filled in, it is assumed to be 'Intergy'.
HiddenCreate CHARACTER(1)   OPTIONAL
Description CHARACTER(60)   OPTIONAL
EMMedcinID INTEGER 0   OPTIONAL The Medcin ID of the EM Code that is indicated for this encounter.
EMCounselingFlag CHARACTER(1)   OPTIONAL Flag indicating whether counseling time was over 50% of the time spent with the patient.
EMOverrideDetails CHARACTER(15)   OPTIONAL The override levels for the E&M categories.
EMFloorTime INTEGER 0   OPTIONAL The amount of time (in minutes) spent with the patient during the visit.
EMPatientStatus CHARACTER(1)   OPTIONAL The patient status used in calculating the E&M code. Valid values are 'N' for new patient or 'E' for existing patient.
EMOverrideFlag CHARACTER(1)   OPTIONAL Flag indicating whether the E&M code was calculated using E&M category override levels.
EMServiceType CHARACTER(2)   OPTIONAL System defined. The code representing the type of service used in calculating the E&M code. Allowed values must be defined in this lookup. Field is supported by the lookup types:[EMR_EMServiceType]. Values are defined in the LookupCode table for the above lookup types.
EMSetting CHARACTER(2)   OPTIONAL System defined. The code representing the visit setting used in calculating the E&M code. Allowed values must be defined in this lookup. Field is supported by the lookup types:[EMR_EMSetting]. Values are defined in the LookupCode table for the above lookup types.
EMExamType CHARACTER(2)   OPTIONAL System defined. The code representing the type of exam performed. This is used in calculating the E&M code. Allowed values must be defined in this lookup. Field is supported by the lookup types:[EMR_EMExamType]. Values are defined in the LookupCode table for the above lookup types.
ClinicalStatus CHARACTER(1) EncClinicalStatus_O   MANDATORY Indicates the status of the encounter from the perspective of clinical activities. Allowed values must be defined in EncounterClinicalStatus lookup type.
SignUser INTEGER 0   OPTIONAL User who signed the encounter. From MMUser. Note: just like lastuser, createuser, no DB relationship created between Encounter and MMUser.
SignStamp CHARACTER(14)   OPTIONAL Timestamp when encounter was signed.
EncounterNoteCatalogSID INTEGER ?   OPTIONAL System generated document identifier. The identifier value is obtained from the DOCUMENT sequence.
AccountSID INTEGER ?   OPTIONAL FK - From Account table For Standalone EHR
DuplicatePatEncounterSID INTEGER ?   OPTIONAL FK - Encounter. When merging two patients via the IEHR Merge Patient utility, an encounter containing IEHR data and non-IEHR data is split into two encounters. One will keep the non-IEHR data on the source patient and one will keep the IEHR data on the target patient. This field points to the target patient's encounter just as the Patient record's DuplicatePersonID points to the target patient.
CLWTemplateSID INTEGER ?   OPTIONAL FK - From table CLWTemplate. CLWTemplate Identifier that is generated using the 'GeneralSystem' sequence.
SignedDocumentEdited CHARACTER(1) No_Value__N_   OPTIONAL Allowed values are Y(es) and N(o). The field will be used to keep track of whether the user edited the encounter document when signing.
ConfidentialEncounter LOGICAL Logical_False   OPTIONAL Encounter is confidential. Right now (03/31/2008), this field works only for Encounter Documents. Only users with permissions will be allowed to view confidential Documents.
ReminderSnapshotStatus CHAR(1) Set_To_Empty_String   OPTIONAL Defines current status of the Health Reminder snapshot for this Encounter. Default value of this field is blank - indicates that no snapshot has been taken for this Encounter. After the snapshot is updated, the status will be set to (C)urrent. When Encounter clinical data changes, the status is set to (S)tale to indicate the reminder snapshot needs to be updated.
EMDefaultMedcinID INTEGER 0   OPTIONAL This is the default ID returned from the Medcin server. The value is returned during the E&M calculation.
EMOverrideMedcinID INTEGER 0   OPTIONAL This is the ID returned from the Medcin server using the category override levels. The value is returned during the E&M calculation.
EMDefaultDetails CHAR(15)   OPTIONAL This default category levels returned from the Medcin Server.
EHRNoteType CHAR(16) Set_To_Empty_String   OPTIONAL Classification of Note Type. Allowed values must be defined in the EHRNoteType lookup type. The Empty value for this field will correspond to an Encounter Note based on the ClinicalStatus field.
EMAckAssessmentFindings LOGICAL Logical_False   MANDATORY A true value a means that user has acknowledged the E&M calculation for assessment findings. Once user acknowledges the value will hold unless until the Note is deleted and recreated.
MedicationReconciliationUser INTEGER ?   OPTIONAL Indicates which user performed Medication Reconciliation for this encounter. FK - from MMUser table.
ElectronicReconcileUserAllergy INTEGER ?   OPTIONAL User that electronically reconciled allergies using current Encounter.
ElectronicReconcileUserProblem INTEGER ?   OPTIONAL User that electronically reconciled patient problem using current Encounter.
ElectronicReconcileUserRx INTEGER ?   OPTIONAL User that electronically reconciled medications using current Encounter.
AllergyReconciliationDate DATE   OPTIONAL Date Allergies reconciliation occurred.
AllergyReconciliationUser INTEGER ?   OPTIONAL Indicates which user performed Allergies Reconciliation for this encounter. FK - from MMUser table.
ProblemReconciliationDate DATE   OPTIONAL Date Problems reconciliation occurred.
ProblemReconciliationUser INTEGER ?   OPTIONAL Indicates which user performed Problems Reconciliation for this encounter. FK - from MMUser table.
CQMPrimaryDiagnosis CHARACTER(10) ?   OPTIONAL Diagnosis Code of the Encounters CQM Primary Diagnosis
OccurDateTimeUTC DATETIME-TZ   OPTIONAL This is a denormalized field based off OccurDate and OccurTime. This field contains the Date, Time and timezone offset. If the OccurTime is null then the OccurTime will be set to midnight.
ProblemConfidentialityLevel CHAR(2) Alpha_-_N   OPTIONAL The field will hold default Confidentiality Level for the problems tied to a confidential encounter
LabConfidentialityLevel CHAR(2) Alpha_-_N   OPTIONAL The field will hold default Confidentiality Level for the lab orders/tests tied to a confidential encounter
DocumentsConfidentialityLevel CHAR(1) Alpha_-_N   OPTIONAL The field will hold Confidentiality Level of a document (based on InteropConfLevel LookupType).
EMMedcinIDDescription CHARACTER(150)   OPTIONAL The description of the EMMedcinID that is indicated for this encounter.
DischargeStatus CHARACTER(6)   OPTIONAL Latest Discharge Status from the InPatientVisit table for this Encounter. Field is supported by the lookup type: [DischargeStatus]. Values are defined in the LookupCode table for the above lookup type.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Diagnosis Encounter.CQMPrimaryDiagnosis = Diagnosis.DiagnosisCode RESTRICT if Encounter exists
MMUser Encounter.ProblemReconciliationUser = MMUser.MMUserSID NONE if Encounter exists
MMUser Encounter.AllergyReconciliationUser = MMUser.MMUserSID NONE if Encounter exists
MMUser Encounter.MedicationReconciliationUser = MMUser.MMUserSID NONE if Encounter exists
Encounter Encounter.DuplicatePatEncounterSID = Encounter.EncounterSID SET NULL if Encounter exists
Account Encounter.AccountSID = Account.AccountSID SET NULL if Encounter exists
TMSCatalog Encounter.EncounterNoteCatalogSID = TMSCatalog.CatalogSID SET NULL if Encounter exists
Patient Encounter.PracticeID = Patient.PracticeID and
Encounter.PatientID = Patient.PatientID		 RESTRICT if Encounter exists
ServiceCenter Encounter.ServiceCenterID = ServiceCenter.ServiceCenterID RESTRICT if Encounter exists
Staff Encounter.PracticeID = Staff.PracticeID and
Encounter.StaffID = Staff.StaffID		 RESTRICT if Encounter exists

Child Tables
Child TableJoin PhraseWhen deleting Encounter record...
Appointment Appointment.VoidedEncounterSID = Encounter.EncounterSID SET NULL if Appointment exists
EncounterNotingActivity EncounterNotingActivity.EncounterSID = Encounter.EncounterSID CASCADE if EncounterNotingActivity exists
PatImplantableDeviceActivity PatImplantableDeviceActivity.EncounterSID = Encounter.EncounterSID CASCADE if PatImplantableDeviceActivity exists
PatImplantableDevice PatImplantableDevice.EncounterSID = Encounter.EncounterSID CASCADE if PatImplantableDevice exists
EncounterDiagnosis EncounterDiagnosis.EncounterSID = Encounter.EncounterSID CASCADE if EncounterDiagnosis exists
DURAlert DURAlert.EncounterSID = Encounter.EncounterSID RESTRICT if DURAlert exists
Document Document.EncounterSID = Encounter.EncounterSID SET NULL if Document exists
Encounter Encounter.DuplicatePatEncounterSID = Encounter.EncounterSID SET NULL if Encounter exists
CardioOrder CardioOrder.EncounterSID = Encounter.EncounterSID SET NULL if CardioOrder exists
EncounterFindingHistory EncounterFindingHistory.EncounterSID = Encounter.EncounterSID CASCADE if EncounterFindingHistory exists
AdvanceDirectiveActivity AdvanceDirectiveActivity.EncounterSID = Encounter.EncounterSID RESTRICT if AdvanceDirectiveActivity exists
PatientProblemHistory PatientProblemHistory.EncounterSID = Encounter.EncounterSID RESTRICT if PatientProblemHistory exists
PersonAllergyHistory PersonAllergyHistory.EncounterSID = Encounter.EncounterSID SET NULL if PersonAllergyHistory exists
PatientOrderSet PatientOrderSet.EncounterSID = Encounter.EncounterSID SET NULL if PatientOrderSet exists
EncounterEducation EncounterEducation.EncounterSID = Encounter.EncounterSID RESTRICT if EncounterEducation exists
OBEncounter OBEncounter.EncounterSID = Encounter.EncounterSID RESTRICT if OBEncounter exists
CLWCorrespondence CLWCorrespondence.EncounterSID = Encounter.EncounterSID SET NULL if CLWCorrespondence exists
PatientVacDoseReaction PatientVacDoseReaction.EncounterSID = Encounter.EncounterSID RESTRICT if PatientVacDoseReaction exists
PatientVacDoseAction PatientVacDoseAction.EncounterSID = Encounter.EncounterSID RESTRICT if PatientVacDoseAction exists
PatientVacDose PatientVacDose.EncounterSID = Encounter.EncounterSID RESTRICT if PatientVacDose exists
EncounterVitalSet EncounterVitalSet.EncounterSID = Encounter.EncounterSID CASCADE if EncounterVitalSet exists
EncounterFinding EncounterFinding.EncounterSID = Encounter.EncounterSID CASCADE if EncounterFinding exists
LabOrderTask LabOrderTask.EncounterSID = Encounter.EncounterSID RESTRICT if LabOrderTask exists
RISStudy RISStudy.EncounterSID = Encounter.EncounterSID NONE if RISStudy exists
PatientRx PatientRx.EncounterSID = Encounter.EncounterSID NONE if PatientRx exists
LabOrder LabOrder.EncounterSID = Encounter.EncounterSID NONE if LabOrder exists
TMSCatalog TMSCatalog.EncounterSID = Encounter.EncounterSID NONE if TMSCatalog exists
EncounterEvent EncounterEvent.EncounterSID = Encounter.EncounterSID CASCADE if EncounterEvent exists
Appointment Appointment.EncounterSID = Encounter.EncounterSID SET NULL if Appointment exists
ProcedureEvent ProcedureEvent.EncounterSID = Encounter.EncounterSID SET NULL if ProcedureEvent exists