Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (2)![Foreign Keys FK_Charge_Diagnosis_ChargeID_Charge_ID: [dbo].[Charge].ChargeID Foreign Keys FK_Charge_Diagnosis_ChargeID_Charge_ID: [dbo].[Charge].ChargeID](../../../../Images/fk.png) | ChargeID | [dbo].[uniqueid] | 9 | NOT NULL | | | Charge Identifier. Link to Charge.ID |
 (2) | DiagnosisNumber | smallint | 2 | NOT NULL | | | Diagnosis Display Order |
 ![Foreign Keys FK_Charge_Diagnosis_BillingICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].BillingICD9DiagnosisDE Foreign Keys FK_Charge_Diagnosis_BillingICD9DiagnosisDE_ICD9_Diagnosis_DE_ID: [dbo].[ICD9_Diagnosis_DE].BillingICD9DiagnosisDE](../../../../Images/fk.png) | BillingICD9DiagnosisDE | [dbo].[dict_id] | 5 | NOT NULL | | | ICD9. Link to ICD9_Diagnosis_DE.ID |
| ProblemDE | [dbo].[dict_id] | 5 | NULL allowed | | | Problem Dictionary entry. Link to Problem_DE.ID |
| ICD9DiagnosisCode | varchar(10) | 10 | NULL allowed | | | ICD9 Code for the Linked diagnosis |
| ICD10DiagnosisCode | varchar(10) | 10 | NULL allowed | | | ICD10 Code for the Linked diagnosis |
| IsConverted | char(1) | 1 | NULL allowed | | ('N') | Is Diagnosis converted and added into Charge_Diagnosis_Detail table(Y/N)? |
| BillingDiagnosisDE | [dbo].[dict_id] | 5 | NULL allowed | | | Diagnosis Identifier. Link to
Problem_DE.ID for DiagnosisType = 'PROBLEM'
ICD9_Diagnosis_DE.ID for DiagnosisType = 'ICD9'
ICD10_Diagnosis_DE.ID for DiagnosisType = 'ICD10' |
| BillingDiagnosisType | varchar(10) | 10 | NULL allowed | | | Diagnosis Type.
PROBLEM - Problem
ICD9 - ICD9 Diagnosis
ICD10 - ICD10 Diagnosis |
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Charge_Diagnosis table |