Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (32) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Encounter table |
 | EpisodeID | [dbo].[uniqueid] | 9 | NOT NULL | | | Episode. Link to Episode.ID. not used. |
 ![Foreign Keys FK_Encounter_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDE Foreign Keys FK_Encounter_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDE](../../../../Images/fk.png) | ICD9DiagnosisDE | [dbo].[dict_id] | 5 | NOT NULL | | | Diagnosis. Link to ICD9_Diagnosis_DE.ID. No longer used. |
(7) | ProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Billing Provider. Link to provider.ID |
(5) | PatientCaseID | [dbo].[uniqueid] | 9 | NOT NULL | | | Case. Link to Patient_Case.ID |
 (25)![Foreign Keys FK_Encounter_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Encounter_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Patient_Member.ID |
 ![Foreign Keys FK_Encounter_PrimaryLocationDE_Location_DE_ID: [dbo].[Location_DE].PrimaryLocationDE Foreign Keys FK_Encounter_PrimaryLocationDE_Location_DE_ID: [dbo].[Location_DE].PrimaryLocationDE](../../../../Images/fk.png) | PrimaryLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Location. Link to Location_DE.ID |
(6) | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | | | Visit. Link to Visit.ID |
(9) | DTTM | datetime | 8 | NULL allowed | | | Date and Time |
 (5)![Foreign Keys FK_Encounter_EncounterTypeDE_Encounter_Type_DE_ID: [dbo].[Encounter_Type_DE].EncounterTypeDE Foreign Keys FK_Encounter_EncounterTypeDE_Encounter_Type_DE_ID: [dbo].[Encounter_Type_DE].EncounterTypeDE](../../../../Images/fk.png) | EncounterTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Encounter type. Link to Encounter_Type_DE.ID |
 | ReferringProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Referring Provider. link to Referring_Provider.ID |
 ![Foreign Keys FK_Encounter_PlaceofServiceDE_Place_of_Service_DE_ID: [dbo].[Place_of_Service_DE].PlaceofServiceDE Foreign Keys FK_Encounter_PlaceofServiceDE_Place_of_Service_DE_ID: [dbo].[Place_of_Service_DE].PlaceofServiceDE](../../../../Images/fk.png) | PlaceofServiceDE | [dbo].[dict_id] | 5 | NOT NULL | | | Place of Service. link to Place_Of_Service_DE.ID. No longer used. |
 | DefaultBillingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Billing Provider. link to Provider.ID |
 ![Foreign Keys FK_Encounter_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDE Foreign Keys FK_Encounter_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDE](../../../../Images/fk.png) | DefaultBillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Billing Location. Link to Billing_Location_DE.ID |
 ![Foreign Keys FK_Encounter_Provider2ID_Provider_ID: [dbo].[Provider].Provider2ID Foreign Keys FK_Encounter_Provider2ID_Provider_ID: [dbo].[Provider].Provider2ID](../../../../Images/fk.png) | Provider2ID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Performing Provider. link to Person.ID |
(2)![Foreign Keys FK_Encounter_InsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].InsuranceClassDE Foreign Keys FK_Encounter_InsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].InsuranceClassDE](../../../../Images/fk.png) | InsuranceClassDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Registration Insurance 1. link to Insurance_Class_DE.ID |
(2) | ReferringProvider | varchar(255) | 255 | NULL allowed | | | Referring Provider name |
 ![Foreign Keys FK_Encounter_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE Foreign Keys FK_Encounter_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE](../../../../Images/fk.png) | BillingAreaDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Billing Area. Link to Billining_Area_DE.ID |
 ![Foreign Keys FK_Encounter_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE Foreign Keys FK_Encounter_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE](../../../../Images/fk.png) | DivisionDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Division. Link to Division_DE.ID |
 ![Check Constraints Encounter_LevelofInvolvement_Check : ([LevelofInvolvement] IS NULL OR [LevelofInvolvement]=(3) OR [LevelofInvolvement]=(2) OR [LevelofInvolvement]=(1) OR [LevelofInvolvement]=(0) OR [LevelofInvolvement]=((-1))) Check Constraints Encounter_LevelofInvolvement_Check : ([LevelofInvolvement] IS NULL OR [LevelofInvolvement]=(3) OR [LevelofInvolvement]=(2) OR [LevelofInvolvement]=(1) OR [LevelofInvolvement]=(0) OR [LevelofInvolvement]=((-1)))](../../../../Images/c-constraint.png) | LevelofInvolvement | smallint | 2 | NULL allowed | | | Level of Involvement (0,1,2,3, -1) |
 | LockedDTTM | datetime | 8 | NULL allowed | | | Date and time encounter form is or will be locked. |
 | HoldFlag | char(1) | 1 | NULL allowed | | | Hold Encounter form (Y/N) |
 | OptionalField1 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 1 |
 | OptionalField2 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 2 |
 | OptionalField3 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 3 |
 | OptionalField4 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 4 |
 | OptionalField5 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 5 |
 ![Foreign Keys FK_Encounter_ComplianceCodeDE: [dbo].[Compliance_Code_DE].ComplianceCodeDE Foreign Keys FK_Encounter_ComplianceCodeDE: [dbo].[Compliance_Code_DE].ComplianceCodeDE](../../../../Images/fk.png) | ComplianceCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Compliance Code. Link to Compliance_Code_DE.ID |
![Foreign Keys FK_Encounter_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DE Foreign Keys FK_Encounter_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DE](../../../../Images/fk.png) | ReferringProvider2DE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Referring Provider2. Link to Referring_Provider_DE.ID |
 ![Foreign Keys FK_Encounter_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DE Foreign Keys FK_Encounter_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DE](../../../../Images/fk.png) | ReferringProvider3DE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Referring Provider 3. Link to Referring_Provider_DE.ID |
 ![Foreign Keys FK_Encounter_SecondaryInsuranceDE: [dbo].[Insurance_Class_DE].SecondaryInsuranceDE Foreign Keys FK_Encounter_SecondaryInsuranceDE: [dbo].[Insurance_Class_DE].SecondaryInsuranceDE](../../../../Images/fk.png) | SecondaryInsuranceDE | [dbo].[dict_id] | 5 | NULL allowed | | (0) | Registration Insurance 2. Link to Insurance_Class_DE.ID |
 ![Foreign Keys FK_Encounter_TertiaryInsuranceDE: [dbo].[Insurance_Class_DE].TertiaryInsuranceDE Foreign Keys FK_Encounter_TertiaryInsuranceDE: [dbo].[Insurance_Class_DE].TertiaryInsuranceDE](../../../../Images/fk.png) | TertiaryInsuranceDE | [dbo].[dict_id] | 5 | NULL allowed | | (0) | Registration Insurance 3. Link to Insurance_Class_DE.ID |
 ![Check Constraints CK_Encounter_IsTransitionofCareFLAG_Yes_Or_No : ([IsTransitionofCareFLAG]='N' OR [IsTransitionofCareFLAG]='Y') Check Constraints CK_Encounter_IsTransitionofCareFLAG_Yes_Or_No : ([IsTransitionofCareFLAG]='N' OR [IsTransitionofCareFLAG]='Y')](../../../../Images/c-constraint.png) | IsTransitionofCareFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Transition of care occured on this encounter (Y/N) |
| IsSummaryofCareReceivedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Was a summary of care received on this encounter (Y/N) |