Notifications
Clear all
Topic starter
Can anyone direct me on how to find the HDID number for BP values?
thanks!
Posted : February 18, 2015 6:47 am
BP DIASTOLIC = 053
BP SYSTOLIC = 054
Posted : February 18, 2015 6:58 am
If you have access to Crystal Reports, you may want to run the attached report.
I run this every once in a while, exported to Excel. The columns are:
OBS value; or HDID
Count of hits in my live date; useful when trying to gauge how much data to expect
OBS Date; the last time the data element was written; should be current for something active
OBS Code; the text abbreviation
OBS Description; full text of the term
Group Type; GE has things in different group codes
Group Name; the type of data element
Running this every couple of months really helps me when building inquiries or reports - to understand where to find data.
Posted : February 18, 2015 7:03 am
Another way to get the whole catalog of GE Obs terms with HDID is to download the latest factory obs term kit from GE. Open Excel first, then go into the folder and open Terms.fot, telling Excel to import the text file as delimited with commas. If you have trouble with it, make a copy of terms.fot and rename it to terms.csv, then open it in Excel. The last column contains HDID values.
Posted : February 18, 2015 8:30 am
And if you directly want to query the database, you will want to look at the OBSHEAD table.
Posted : February 18, 2015 9:02 am
Topic starter
Thank you everyone!!
Posted : February 18, 2015 9:58 am
