Is there anything like a data dictionary?

[Richard Uchytil]

Hi!  We're using the HAPI FHIR database on a SQL Server implemented by Edifecs.  I'm trying to write some SQL queries to get data out of the database, things like how many members are in the database, all records associated with a member, stuff like that.

Is there anything like a data dictionary that would explain where to find this information and how to join the tables together?  For example, I know how to find the unique member id and how to find a SmokingStatus record.  But I can't figure out how to tell which member id that SmokingStatus record belongs to or how to find all the SmokingStatus records for a member id.

Thanks!

Richard Uchytil

[Eric Jahn]

I've been using the web ontology file linked off here: https://www.hl7.org/fhir/rdf.html .  Somewhere in there is a turtle ontology file, but I just keep the link handy: https://www.hl7.org/fhir/fhir.ttl

Eric Jahn
alexandriaconsulting.com

[Richard Uchytil]

Thanks, I’ll take a look at that.

 

Rich

 

From: hapi...@googlegroups.com <hapi...@googlegroups.com> On Behalf Of Eric Jahn
Sent: Thursday, November 18, 2021 7:09 AM
To: HAPI FHIR <hapi...@googlegroups.com>
Subject: Re: Is there anything like a data dictionary?

 

EXTERNAL MESSAGE - TREAT LINKS/FILES WITH CARE

--
You received this message because you are subscribed to the Google Groups "HAPI FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hapi-fhir+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/df323e11-1bcc-4f17-a650-e889a1894c51n%40googlegroups.com.