Tables [dbo].[Encounter_Diagnosis]
Encounter Diagnosis
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEIndexes UK_Encounter_Display, NIX_Encounter_Diagnosis_ProbDE_ICD9DE, TWstat_Encounter_Diagnosis_DeletedFLAG_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_DisplayOrder_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_FreeTextDiag_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_ICD9DiagnosisDE_EncounterID(6)Foreign Keys FK_Encounter_Diagnosis_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter Identifier. Link to Encounter.ID
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEIndexes NIX_Encounter_Diagnosis_ProbDE_ICD9DE, TWstat_Encounter_Diagnosis_DeletedFLAG_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_DisplayOrder_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_FreeTextDiag_EncounterID_ICD9DiagnosisDE, TWstat_Encounter_Diagnosis_ICD9DiagnosisDE_EncounterID(5)Foreign Keys FK_Encounter_Diagnosis_ICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].ICD9DiagnosisDEICD9DiagnosisDE[dbo].[dict_id]5NOT NULLICD9. Link to ICD9_Diagnosis_DE.ID
Indexes UK_Encounter_Display, TWstat_Encounter_Diagnosis_DisplayOrder_EncounterID_ICD9DiagnosisDE(2)DisplayOrderint4NOT NULLDiagnosis Display Order
Indexes TWstat_Encounter_Diagnosis_FreeTextDiag_EncounterID_ICD9DiagnosisDEFreeTextDiagvarchar(255)255NOT NULL('')Free text Diagnosis
Indexes TWstat_Encounter_Diagnosis_SubmittedFLAGCheck Constraints CK_Encounter_Diagnosis_SubmittedFLAG_Yes_Or_No : ([SubmittedFLAG]='N' OR [SubmittedFLAG]='Y')SubmittedFLAG[dbo].[BOOL]1NOT NULL('N')Is Diagnosis Submitted to Charge interface(Y/N)?
Indexes TWstat_Encounter_Diagnosis_DeletedFLAG_EncounterID_ICD9DiagnosisDECheck Constraints CK_Encounter_Diagnosis_DeletedFLAG_Yes_Or_No : ([DeletedFLAG]='N' OR [DeletedFLAG]='Y')DeletedFLAG[dbo].[BOOL]1NOT NULL('N')Is Diagnosis Deleted after submitted to Charge interface(Y/N)?
Indexes UK_Encounter_Display, NIX_Encounter_Diagnosis_ProbDE_ICD9DE(2)ProblemDE[dbo].[dict_id]5NOT NULL((0))Problem dicitionary entry. Link to Problem_DE.ID
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEICD9DiagnosisCodevarchar(10)10NOT NULL('')ICD9 Code for the selected Problem.
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEICD10DiagnosisCodevarchar(10)10NOT NULL('')ICD10 Code for the selected Problem.
Indexes UIDX_Encounter_diagnosisID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Encounter_Diagnosis table
IsConvertedchar(1)1NULL allowed('N')Is Diagnosis converted and added into Encounter_Diagnosis_Detail table(Y/N)?
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEDiagnosisDE[dbo].[dict_id]5NOT NULL((0))Diagnosis Identifier. Link to
Problem_DE.ID for  DiagnosisType = 'PROBLEM'
ICD9_Diagnosis_DE.ID  for  DiagnosisType = 'ICD9'
ICD10_Diagnosis_DE.ID  for  DiagnosisType = 'ICD10'
Cluster Primary Key PK_Encounter_Diagnosis_EncounterID_DiagnosisDE_DiagnosisType_ICD9DiagnosisCode_ICD10DiagnosisCode_ICD9DiagnosisDE: EncounterID\DiagnosisDE\DiagnosisType\ICD9DiagnosisCode\ICD10DiagnosisCode\ICD9DiagnosisDEDiagnosisTypevarchar(10)10NOT NULL('')Diagnosis Type.
PROBLEM - Problem
ICD9 - ICD9 Diagnosis
ICD10 - ICD10 Diagnosis