Tables [dbo].[Charge_Diagnosis_Detail]
primary and secondary (ICD9 and ICD10) charge diagnosis codes
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Charge_Diagnosis_Detail: ChargeDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeForeign Keys FK_Charge_Diagnosis_Detail_Charge_Diagnosis_ID: [dbo].[Charge_Diagnosis].ChargeDiagnosisIDChargeDiagnosisID[dbo].[uniqueid]9NOT NULLCharge Diagnosis. Links to Charge_Diagnosis.ID
Cluster Primary Key PK_Charge_Diagnosis_Detail: ChargeDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeICDDiagnosisCodevarchar(10)10NOT NULLICD9 or ICD10 Diagnosis Code
Cluster Primary Key PK_Charge_Diagnosis_Detail: ChargeDiagnosisID\ICDDiagnosisCode\ICDDiagnosisTypeICDDiagnosisTypevarchar(10)10NOT NULLDiagnosis Type ('ICD9' or 'ICD10')
Levelsmallint2NULL allowedCode Level.
0 - Base DX Code
1- Primary DX Code
2- Secondary DX Code