PROMs CSN Join Change

Reviewers Requested

This is an open call for reviewers. Please provide any feedback by 2/21/2020.

Details

According the following query, it is not possible to have a questionnaire submission (AnswerID) without an associated contact (PatientEncounterID). Therefore, we can change the join type to QuestionnaireFormAnswer from left to inner

select *
from Epic.Patient.QuestionnaireSubmission_Enterprise qs
    left join Epic.Clinical.QuestionnaireFormAnswer_Enterprise qfa on qs.AnswerID = qfa.AnswerID
where qfa.PatientEncounterID is null

added 1 commit

• 29e58e62 - Remove unnecessary join to QuestionnaireAnswer

Compare with previous version

merged

mentioned in commit 7d38efe1