Tables [dbo].[Encounter]
Encounter. An encounter is an interaction between a patient and a provider. Encounter is the main level of aggregation for clinical documentation.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Encounter_ID: IDCluster Key CIX_Encounter_PatientID_ID_EncounterTypeDE: PatientID\ID\EncounterTypeDEIndexes NIX_Encounter_DTTM, NIX_Encounter_EncounterTypeDE_DTTM, XAK1Encounter, nix_Encounter_IDDTTM, NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDE, Nix_Encounter_ID_VisitID, XAK4Encounter, XAK3Encounter, NIX_Encounter_VisitID_EncounterTypeDE, XAK5Encounter, TWstat_Encounter_BillingAreaDE_PatientID_ID, TWstat_Encounter_ComplianceCodeDE_PatientID_ID, TWstat_Encounter_DefaultBillingLocationDE_PatientID_ID, TWstat_Encounter_DefaultBillingProviderID_PatientID_ID, TWstat_Encounter_DivisionDE_PatientID_ID, TWstat_Encounter_DTTM_PatientID_ID, TWstat_Encounter_EncounterTypeDE_PatientID_ID, TWstat_Encounter_HoldFlag_PatientID_ID, TWstat_Encounter_ICD9DiagnosisDE_PatientID_ID, TWstat_Encounter_LevelofInvolvement_PatientID_ID, TWstat_Encounter_LockedDTTM_PatientID_ID, TWstat_Encounter_OptionalField1_PatientID_ID, TWstat_Encounter_OptionalField2_PatientID_ID, TWstat_Encounter_OptionalField3_PatientID_ID, TWstat_Encounter_OptionalField4_PatientID_ID, TWstat_Encounter_OptionalField5_PatientID_ID, TWstat_Encounter_PlaceofServiceDE_PatientID_ID, TWstat_Encounter_PrimaryLocationDE_PatientID_ID, TWstat_Encounter_Provider2ID_PatientID_ID, TWstat_Encounter_ReferringProvider_PatientID_ID, TWstat_Encounter_ReferringProvider3DE_PatientID_ID, TWstat_Encounter_ReferringProviderID_PatientID_ID(32)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Encounter table
Indexes XAK1EncounterEpisodeID[dbo].[uniqueid]9NOT NULLEpisode. Link to Episode.ID. not used.
Indexes TWstat_Encounter_ICD9DiagnosisDE_PatientID_IDForeign Keys FK_Encounter_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDEICD9DiagnosisDE[dbo].[dict_id]5NOT NULLDiagnosis. Link to ICD9_Diagnosis_DE.ID. No longer  used.
Indexes NIX_Encounter_DTTM, NIX_Encounter_EncounterTypeDE_DTTM, nix_Encounter_IDDTTM, Nix_Encounter_ID_VisitID, XAK6Encounter, XAK3Encounter, NIX_Encounter_VisitIDEncounterTypeDEProviderID(7)ProviderID[dbo].[uniqueid]9NOT NULLBilling Provider. Link to provider.ID
Indexes NIX_Encounter_DTTM, nix_Encounter_IDDTTM, Nix_Encounter_ID_VisitID, NIX_Encounter_PatientCaseID_INC_DTTM, XAK4Encounter(5)PatientCaseID[dbo].[uniqueid]9NOT NULLCase. Link to Patient_Case.ID
Cluster Key CIX_Encounter_PatientID_ID_EncounterTypeDE: PatientID\ID\EncounterTypeDEIndexes NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDE, XAK3Encounter, NIX_Encounter_VisitID_EncounterTypeDE, TWstat_Encounter_BillingAreaDE_PatientID_ID, TWstat_Encounter_ComplianceCodeDE_PatientID_ID, TWstat_Encounter_DefaultBillingLocationDE_PatientID_ID, TWstat_Encounter_DefaultBillingProviderID_PatientID_ID, TWstat_Encounter_DivisionDE_PatientID_ID, TWstat_Encounter_DTTM_PatientID_ID, TWstat_Encounter_EncounterTypeDE_PatientID_ID, TWstat_Encounter_HoldFlag_PatientID_ID, TWstat_Encounter_ICD9DiagnosisDE_PatientID_ID, TWstat_Encounter_LevelofInvolvement_PatientID_ID, TWstat_Encounter_LockedDTTM_PatientID_ID, TWstat_Encounter_OptionalField1_PatientID_ID, TWstat_Encounter_OptionalField2_PatientID_ID, TWstat_Encounter_OptionalField3_PatientID_ID, TWstat_Encounter_OptionalField4_PatientID_ID, TWstat_Encounter_OptionalField5_PatientID_ID, TWstat_Encounter_PlaceofServiceDE_PatientID_ID, TWstat_Encounter_PrimaryLocationDE_PatientID_ID, TWstat_Encounter_Provider2ID_PatientID_ID, TWstat_Encounter_ReferringProvider_PatientID_ID, TWstat_Encounter_ReferringProvider3DE_PatientID_ID, TWstat_Encounter_ReferringProviderID_PatientID_ID(25)Foreign Keys FK_Encounter_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Indexes TWstat_Encounter_PrimaryLocationDE_PatientID_IDForeign Keys FK_Encounter_PrimaryLocationDE_Location_DE_ID: [dbo].[Location_DE].PrimaryLocationDEPrimaryLocationDE[dbo].[dict_id]5NOT NULLLocation. Link to Location_DE.ID
Indexes nix_Encounter_IDDTTM, NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDE, Nix_Encounter_ID_VisitID, NIX_Encounter_VisitID_EncounterTypeDE, NIX_Encounter_VisitIDEncounterTypeDEProviderID, XAK5Encounter(6)VisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID
Indexes Portal_Encounter, NIX_Encounter_DTTM, NIX_Encounter_EncounterTypeDE_DTTM, nix_Encounter_IDDTTM, Nix_Encounter_ID_VisitID, NIX_Encounter_PatientCaseID_INC_DTTM, XAK4Encounter, NIX_Encounter_VisitID_EncounterTypeDE, TWstat_Encounter_DTTM_PatientID_ID(9)DTTMdatetime8NULL allowedDate and Time
Cluster Key CIX_Encounter_PatientID_ID_EncounterTypeDE: PatientID\ID\EncounterTypeDEIndexes NIX_Encounter_DTTM, NIX_Encounter_EncounterTypeDE_DTTM, NIX_Encounter_VisitID_EncounterTypeDE, NIX_Encounter_VisitIDEncounterTypeDEProviderID, TWstat_Encounter_EncounterTypeDE_PatientID_ID(5)Foreign Keys FK_Encounter_EncounterTypeDE_Encounter_Type_DE_ID: [dbo].[Encounter_Type_DE].EncounterTypeDEEncounterTypeDE[dbo].[dict_id]5NOT NULLEncounter type. Link to Encounter_Type_DE.ID
Indexes TWstat_Encounter_ReferringProviderID_PatientID_IDReferringProviderID[dbo].[uniqueid]9NOT NULLReferring Provider. link to Referring_Provider.ID
Indexes TWstat_Encounter_PlaceofServiceDE_PatientID_IDForeign Keys FK_Encounter_PlaceofServiceDE_Place_of_Service_DE_ID: [dbo].[Place_of_Service_DE].PlaceofServiceDEPlaceofServiceDE[dbo].[dict_id]5NOT NULLPlace of Service. link to Place_Of_Service_DE.ID. No longer used.
Indexes TWstat_Encounter_DefaultBillingProviderID_PatientID_IDDefaultBillingProviderID[dbo].[uniqueid]9NOT NULLBilling Provider. link to Provider.ID
Indexes TWstat_Encounter_DefaultBillingLocationDE_PatientID_IDForeign Keys FK_Encounter_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDEDefaultBillingLocationDE[dbo].[dict_id]5NOT NULLBilling Location. Link to  Billing_Location_DE.ID
Indexes TWstat_Encounter_Provider2ID_PatientID_IDForeign Keys FK_Encounter_Provider2ID_Provider_ID: [dbo].[Provider].Provider2IDProvider2ID[dbo].[uniqueid]9NOT NULL(0)Performing Provider. link to Person.ID
Indexes NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDE, XAK6Encounter(2)Foreign Keys FK_Encounter_InsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].InsuranceClassDEInsuranceClassDE[dbo].[dict_id]5NOT NULL(0)Registration Insurance 1. link to Insurance_Class_DE.ID
Indexes NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDE, TWstat_Encounter_ReferringProvider_PatientID_ID(2)ReferringProvidervarchar(255)255NULL allowedReferring Provider name
Indexes TWstat_Encounter_BillingAreaDE_PatientID_IDForeign Keys FK_Encounter_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDEBillingAreaDE[dbo].[dict_id]5NOT NULL(0)Billing Area. Link to Billining_Area_DE.ID
Indexes TWstat_Encounter_DivisionDE_PatientID_IDForeign Keys FK_Encounter_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDEDivisionDE[dbo].[dict_id]5NOT NULL(0)Division. Link to Division_DE.ID
Indexes TWstat_Encounter_LevelofInvolvement_PatientID_IDCheck Constraints Encounter_LevelofInvolvement_Check : ([LevelofInvolvement] IS NULL OR [LevelofInvolvement]=(3) OR [LevelofInvolvement]=(2) OR [LevelofInvolvement]=(1) OR [LevelofInvolvement]=(0) OR [LevelofInvolvement]=((-1)))LevelofInvolvementsmallint2NULL allowedLevel of Involvement (0,1,2,3, -1)
Indexes TWstat_Encounter_LockedDTTM_PatientID_IDLockedDTTMdatetime8NULL allowedDate and time encounter form is or will be locked.
Indexes TWstat_Encounter_HoldFlag_PatientID_IDHoldFlagchar(1)1NULL allowedHold Encounter form (Y/N)
Indexes TWstat_Encounter_OptionalField1_PatientID_IDOptionalField1varchar(255)255NOT NULL('')Optional Field 1
Indexes TWstat_Encounter_OptionalField2_PatientID_IDOptionalField2varchar(255)255NOT NULL('')Optional Field 2
Indexes TWstat_Encounter_OptionalField3_PatientID_IDOptionalField3varchar(255)255NOT NULL('')Optional Field 3
Indexes TWstat_Encounter_OptionalField4_PatientID_IDOptionalField4varchar(255)255NOT NULL('')Optional Field 4
Indexes TWstat_Encounter_OptionalField5_PatientID_IDOptionalField5varchar(255)255NOT NULL('')Optional Field 5
Indexes TWstat_Encounter_ComplianceCodeDE_PatientID_IDForeign Keys FK_Encounter_ComplianceCodeDE: [dbo].[Compliance_Code_DE].ComplianceCodeDEComplianceCodeDE[dbo].[dict_id]5NOT NULL(0)Compliance Code. Link to Compliance_Code_DE.ID
Foreign Keys FK_Encounter_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DEReferringProvider2DE[dbo].[dict_id]5NOT NULL(0)Referring Provider2. Link to Referring_Provider_DE.ID
Indexes TWstat_Encounter_ReferringProvider3DE_PatientID_IDForeign Keys FK_Encounter_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DEReferringProvider3DE[dbo].[dict_id]5NOT NULL(0)Referring Provider 3. Link to Referring_Provider_DE.ID
Indexes TWstat_Encounter_SecondaryInsuranceDEForeign Keys FK_Encounter_SecondaryInsuranceDE: [dbo].[Insurance_Class_DE].SecondaryInsuranceDESecondaryInsuranceDE[dbo].[dict_id]5NULL allowed(0)Registration Insurance 2. Link to Insurance_Class_DE.ID
Indexes TWstat_Encounter_TertiaryInsuranceDEForeign Keys FK_Encounter_TertiaryInsuranceDE: [dbo].[Insurance_Class_DE].TertiaryInsuranceDETertiaryInsuranceDE[dbo].[dict_id]5NULL allowed(0)Registration Insurance 3. Link to Insurance_Class_DE.ID
Indexes NIX_Encounter_ID_PatientID_VisitID_InsuranceClassDECheck Constraints CK_Encounter_IsTransitionofCareFLAG_Yes_Or_No : ([IsTransitionofCareFLAG]='N' OR [IsTransitionofCareFLAG]='Y')IsTransitionofCareFLAG[dbo].[BOOL]1NOT NULL('N')Transition of care occured on this encounter (Y/N)
IsSummaryofCareReceivedFLAG[dbo].[BOOL]1NOT NULL('N')Was a summary of care received on this encounter (Y/N)