Notifications
Clear all
Topic starter
In an effort to systemically cleanup Letters, Forms, etc..., I wanted to do a quick Crystal Report to list them out. I have been able to figure out how to list Forms & Encounters which was very helpful in cleaning up and removing duplicates.
But, I just cannot figure out what tables and/or CODES to sue to get listings of the Letters & Handouts. I thought the Handouts might be in HANDDEPT, but that is not giving me everything (only a short burst of a few items).
So, anyone have an idea on the tables and codes necessary to create active lists? Thanks.
Posted : March 17, 2021 6:34 am
Here's an old query I used for handout custom lists:
select q.qpicktype,q.description,h.folder,h.description from handdept h, qpicks q where h.gid = q.qpid order by q.qpicktype,q.description
And this one was for custom handouts:
select * from hierobjs where prtattrid = 70 order by groupid
And you might look at this too:
select * from houtmapcrs order by summary
And I THINK this will get you letters:
select g.groupname, o.name from hierobjs o, hiergrps g where o.groupid = g.groupid and g.grouptype = 4
Posted : March 17, 2021 12:44 pm
Topic starter
Thanks David, I forgot about those files.
Especially HIERGRPS which has a GroupType
The type of folder, identified numerically, that this row represents.
The types of data stored in folders that reside in the HIERGRPS and
HIEROBJS tables include:
1 Text components
2 Flowsheet views
3 Observation terms
4 Letter templates
6 Patient handouts
7 Patient handouts for clinical reference systems
9 Protocols
11 Reports
12 Document templates
Posted : March 23, 2021 11:42 pm
