Add drg and diagnosis

Sourced from Epic.Finance.HospitalAccountAdmitDiagnosis to add in Admitting Diagnosis for ED and Inpatient stays Sourced from Epic.Finance.HospitalAccountDRG to add in DRG for ED and Inpatient stays

encounter_inpatient_encounters/encounter_inpatient_encounters.sql

@@ -50,7 +50,7 @@ from Epic.Encounter.PatientEncounterHospital_Enterprise peh
         -- Only show "Princial Problem" per Epic Clarity documentation
         and hp.PrincipalProblemFLG = 'Y'
     left join Epic.Patient.ProblemList_Enterprise pl on hp.ProblemListID = pl.ProblemListID
-	inner join Epic.Finance.HospitalAccountAdmitDiagnosis_Enterprise ad_diag on peh.HospitalAccountID = ad_diag.HospitalAccountID
+	left join Epic.Finance.HospitalAccountAdmitDiagnosis_Enterprise ad_diag on peh.HospitalAccountID = ad_diag.HospitalAccountID
 	left join epic.reference.ICDDiagnosis ad_dx on ad_diag.AdmitDiagnosisID = ad_dx.DiagnosisID
     left join Epic.Reference.ICDDiagnosis pl_dx on pl.DiagnosisID = pl_dx.DiagnosisID
     -- For ED-to-Inpatient encounters, include the chief complaint