WIP: EncounterSurgicalEncounters View

Reviewers Wanted

This is an open call for reviews of this PR. Please provide any feedback by 9/6/2019

Surgical Encounters

This view allows users to quickly identify surgeries and link them to other data sources to identify specific events or outcomes. This view intentionally avoids trying to identify what procedures occurred during the surgery due to the tricky nature of coding these procedures. Often we find that logged procedures != billed procedures. In the future I hope that we can add additional functionality related to this, but I think that this view is an OK minimum viable product for now.

Your best bet is to use this view in conjunction with Integration.CommonCoding to identify specifics (i.e. surgeon, site, etc.) related to billed procedures. For instance:

select top 1000 *
from UserWork.EAViewLibrary.EncounterSurgicalEcounters ese
    inner join Integration.CommonCoding.CPTProcedure cpt on ese.PatientEncounterID = cpt.PatientEncounterID
where cpt.CPTCD in ('[MY CPT CODE SET]')