Notifications
Clear all
Topic starter
Hello CHUGERS & Happy Valentines Day!!!
Marie here needing some input....A letterhead was created to be added in Centricity to provide our patients, most likely students. The letter contains a list of recommended accommodations that should be allowed for the student while in school.
Question: Can anyone think of a MEL expression to pull the patients school name? I've tried the following:
- {'{OBSANY("SCHOOL")}'}
- {OBSPREV("SCHOOLNAME")}
Thanks to all in advance!
Posted : February 14, 2018 5:19 am
"school" is a valid obs term. Perhaps you're using a different obs term.
There are a lot of obs terms with "school" in either the term or the description. I'd suggest downloading the list of obs terms for reference.
You may be able to determine which obs term is being used by looking at the database. Here is a query I wrote a few months ago to see what obs terms are in use, and frequency. It could probably be improved, but it did the job I needed. It's for CPS, but would probably translate to CEMR with little modification.
select count (*) as count, o.hdid, ob.name, ob.description, ob.unit, ob.MLCODE, ob.LOINCCODE from obs o, obshead ob where o.hdid = ob.hdid group by o.hdid, ob.name, ob.description, ob.unit, ob.mlcode, ob.loinccode ORDER by NAME
-dp
Posted : February 14, 2018 5:56 am
As noted by Dave, "School" is a valid Observation (Obs) Term. We use this Obs Term in one of our Custom forms. Do you know if you are recording this anywhere in a form? If it is in a form then you may have to find out from your form designer if they are recording the field values to an Obs Term or to a Form Variable. If recording to an Obs Term, then it is recorded in the database and you may have to find out from your designer what Obs Term is actually being used inside the form. If it is recording to a Form Variable then they are only temporary places to store values and are gone once the Document is signed. If the latter then you'll want to have your form designer update your form to use the Obs Term.
If you received this form from another party, then you'll need to reach out to them for the forms related questions, if you do not have a forms designer who can open it up in VFE.
If you are using some 3rd Party registration tool and it is a field in your Registration then you'll want to reach out to your vendor to see if they can get it properly mapped for you.
Obviously, if you are not recording it anywhere, then the MEL code has nowhere to pull it from.
Posted : February 14, 2018 7:52 am
It is going to depend greatly on how you are capturing that information. You will need to use exactly the same obs term to pull it forward that you used for capturing it in your documents.
Posted : February 14, 2018 9:46 am
If you are entering school information with in a form, the easiest way to determine how (and if) it is linked to an obsterm is to start an update. As least for CPS it works. I recommend a blank update, insert the form being used. Enter the data for school, then click the End update button and click the 'View Clinical List Changes' button. If there is nothing there, then the form is not saving that field to an obsterm. If there is you have found the name of the obsterm.
Of course none of this applies if you are collecting this information in a third party registration tool as mentioned above.
Here is an example from our system (obsterm is what is all in caps) :
OBSERVATIONS:
Added new observation of SCHOOL: Alameda Jr/Sr High (02/14/2018 15:24)
Posted : February 14, 2018 10:28 am
