Tables [dbo].[Charge_Diagnosis]
Charge Diagnosis
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Charge_Diagnosis_ChargeID_DiagnosisNumber: ChargeID\DiagnosisNumberIndexes TWstat_Charge_Diagnosis_BillingICD9DiagnosisDE_ChargeID_DiagnosisNumber, TWstat_Charge_Diagnosis_DiagnosisNumber_ChargeID(2)Foreign Keys FK_Charge_Diagnosis_ChargeID_Charge_ID: [dbo].[Charge].ChargeIDChargeID[dbo].[uniqueid]9NOT NULLCharge Identifier. Link to Charge.ID
Cluster Primary Key PK_Charge_Diagnosis_ChargeID_DiagnosisNumber: ChargeID\DiagnosisNumberIndexes TWstat_Charge_Diagnosis_BillingICD9DiagnosisDE_ChargeID_DiagnosisNumber, TWstat_Charge_Diagnosis_DiagnosisNumber_ChargeID(2)DiagnosisNumbersmallint2NOT NULLDiagnosis Display Order
Indexes TWstat_Charge_Diagnosis_BillingICD9DiagnosisDE_ChargeID_DiagnosisNumberForeign Keys FK_Charge_Diagnosis_BillingICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].BillingICD9DiagnosisDEBillingICD9DiagnosisDE[dbo].[dict_id]5NOT NULLICD9. Link to ICD9_Diagnosis_DE.ID
ProblemDE[dbo].[dict_id]5NULL allowedProblem Dictionary entry. Link to Problem_DE.ID
ICD9DiagnosisCodevarchar(10)10NULL allowedICD9 Code for the Linked  diagnosis
ICD10DiagnosisCodevarchar(10)10NULL allowedICD10 Code for the Linked  diagnosis
IsConvertedchar(1)1NULL allowed('N')Is Diagnosis converted and added into Charge_Diagnosis_Detail table(Y/N)?
BillingDiagnosisDE[dbo].[dict_id]5NULL allowedDiagnosis Identifier. Link to

Problem_DE.ID for  DiagnosisType = 'PROBLEM'

ICD9_Diagnosis_DE.ID  for  DiagnosisType = 'ICD9'

ICD10_Diagnosis_DE.ID  for  DiagnosisType = 'ICD10'
BillingDiagnosisTypevarchar(10)10NULL allowedDiagnosis Type.

PROBLEM - Problem

ICD9 - ICD9 Diagnosis

ICD10 - ICD10 Diagnosis
Indexes UIDX_Charge_DiagnosisID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Charge_Diagnosis table