Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Patient Banner - Display a database field

General Discussion

Last Post by ronmoses 9 years ago

3 Posts

3 Users

0 Reactions

54 Views

RSS

abulsara

(@abulsara)

Posts: 150

Estimable Member

Topic starter

Is there anyway to pull something from the database to display in the patient banner if there is no symbol or variable available?

Please email me at [email protected]

Posted : July 22, 2015 8:49 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Id be interested as well.

Posted : July 22, 2015 9:34 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Yes! I've done it a number of times. (I'll email this to you as well.)

We wanted to pull a few fields off the PatientProfile table. These are calculated fields that I added myself, so don't be confused when you don't recognize them. The first thing to do is to create a data object in one of the mldefs files. We use mldefs3.txt. The object looks like this:

/////////////////////////////////////
//NEW / ESTABLISHED PATIENT
/////////////////////////////////////
Object: _EstablishedPatient
 Table: PATIENTPROFILE
 Refresh: RBook
 Property: Snapshot
 Property: Prepare
 Field: NewEstPatient Type: String Length: 25
 Field: ContactByMId Type: Long
 Field: PioneerACO Type: String Length: 20
 Field: FinancialClass Type: String Length: 50
 Filter: PatientFilter, PatientProfileId = Patient.PatientProfileId Hidden

It's called that because we originally created it solely to bring in new/established patient status, but as you can see we've added a few other things since then.

Truth be told, I don't know what Refresh and Property are for. I simply copied them from another pre-existing data object and they worked. I also mimicked the format of the Field and Filter entries. This lets me grab any field I want from the PatientProfile table.

Next we added this declaration to mellib.txt:

global _MELNewEstPatient = _EstablishedPatient

That declares the data object and gives CPS access to it by the name _MELNewEstPatient. If you're in a Citrix environment, make sure you update these two files on each server. Same goes for any local installs.

Finally, we added this to our patient banner:

{! fn NEW_ESTABLISHED(){
local a = getRow("_MELNewEstPatient",0,"NewEstPatient")
return a
}}{NEW_ESTABLISHED()}

And that did the trick. And now that I've explained it here, I'm thinking this would be a perfect topic for a blog post! 🙂 (shameless plug: http://www.the-mosi.net/geblog)

Posted : July 27, 2015 3:12 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0