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