Tables [dbo].[Encounter_Diagnosis_Detail]
primary and secondary ICD9 and ICD10 diagnosis codes for an encounter
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Encounter_Diagnosis_Detail: EncounterDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeForeign Keys FK_Encounter_Diagnosis_Detail_Encounter_diagnosis_ID: [dbo].[Encounter_Diagnosis].EncounterDiagnosisIDEncounterDiagnosisID[dbo].[uniqueid]9NOT NULLDiagnosis. Links to Encounter_Diagnosis.ID
Cluster Primary Key PK_Encounter_Diagnosis_Detail: EncounterDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeICDDiagnosisCodevarchar(10)10NOT NULLICD9 or ICD10 Diagnosis Code
Cluster Primary Key PK_Encounter_Diagnosis_Detail: EncounterDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeICDDiagnosisTypevarchar(5)5NOT NULLDiagnosis Type ('ICD9' or 'ICD10')
Levelsmallint2NULL allowedCode Level.
0 - Base DX Code
1- Primary DX Code
2- Secondary DX Code