Question
· Sep 27, 2016

Get information from patients - Health Share

Hello,

I need to create a query that return the amount of heath related information from a patient. 

I created one using the Analitics but, once our Analitcs database is update once a day this information is not reliable during the current query day.

Part of my Analitcs query is shown below. Where can I find the equivalent tables in Health Share? Any help is appreciate.

Tanks In Advance.

 

--Analitcs Query

SELECT patient FROM  HSAA.AdvanceDirective union all
SELECT patient FROM  HSAA.Allergy union all
SELECT patient FROM  HSAA.Appointment union all
SELECT patient FROM  HSAA.Diagnosis union all
SELECT patient FROM  HSAA.Document union all
SELECT patient FROM  HSAA.Encounter union all
SELECT patient FROM  HSAA.EventCareProviderSite union all
SELECT patient FROM  HSAA.FamilyHistory union all
SELECT patient FROM  HSAA.HSAAOrder union all
SELECT patient FROM  HSAA.HSAAProcedure union all
SELECT patient FROM  HSAA.LabResultItem union all
SELECT patient FROM  HSAA.Medication union all
SELECT patient FROM  HSAA.MemberPCPSite union all
SELECT patient FROM  HSAA.Observation union all
SELECT patient FROM  HSAA.PatientProgram union all
SELECT patient FROM  HSAA.Problem union all
SELECT patient FROM  HSAA.Referral union all
SELECT patient FROM  HSAA.SocialHistory union all
SELECT patient FROM  HSAA.Vaccination union all
SELECT patient FROM  HSAA.VitalSign

Discussion (6)0
Log in or sign up to continue

Hi David,

In order to answer your question, I think we may need to ask a few more questions, understand your current configuration, and clarify your objective(s). It's probably best if you open a support issue so we can give it our full attention and get you the right solution. If you already have a WRC account you can open the issue yourself at wrc.intersystems.com, email us at support@intersystems.com or call us at 617-621-0700. 

Robert