Get information from patients - Health Share

Caché, SQL, HealthShare

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

 

 

 

 

  • + 1
  • 0
  • 251
  • 3
  • 3

Answers

What are you trying to do? Select the patients that only have certain kinds of data?

Exactally!

I need this information to present only patient with health related information.

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 

This is all well and good but the whole point in a community like this is so that people don't have to call and subsequent users with similar questions have access to the information.  I'm especially interested in the solution here.

or please, call Rochael or Claúdio at InterSystems Brazilian office.

thanks

Comments