Skip to content
Snippets Groups Projects

PROMs CSN Join Change

Merged Hubbell, Harrison Taylor requested to merge hh_proms_csn_enhance into master

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

Merge request reports

Merged by Hubbell, Harrison TaylorHubbell, Harrison Taylor 5 years ago (Mar 10, 2020 7:32pm UTC)

Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading