Is Diagnosis Deleted after submitted to Charge interface(Y/N)?
(2)
ProblemDE
[dbo].[dict_id]
5
NOT NULL
((0))
Problem dicitionary entry. Link to Problem_DE.ID
ICD9DiagnosisCode
varchar(10)
10
NOT NULL
('')
ICD9 Code for the selected Problem.
ICD10DiagnosisCode
varchar(10)
10
NOT NULL
('')
ICD10 Code for the selected Problem.
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Encounter_Diagnosis table
IsConverted
char(1)
1
NULL allowed
('N')
Is Diagnosis converted and added into Encounter_Diagnosis_Detail table(Y/N)?
DiagnosisDE
[dbo].[dict_id]
5
NOT 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'
DiagnosisType
varchar(10)
10
NOT NULL
('')
Diagnosis Type. PROBLEM - Problem ICD9 - ICD9 Diagnosis ICD10 - ICD10 Diagnosis