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

Factory Immunization Custom List contents

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

13 Posts

5 Users

0 Reactions

74 Views

RSS

jesran

(@jesran)

Posts: 13

Active Member

Topic starter

Does anybody know how to access the contents of Go->Setup->Settings->Chart->Immunization Custom Lists->Factory Immunization Custom Lists?

We need to get our heads around which NDC and/or CPT attached each vaccine has attached.

So far I looked through the 9.8 Data Dictionary and the ".js" files from the COPY TO HTML Folder->Immunizations with no luck.

Thank you!

Posted : October 13, 2016 3:13 am

JillSnider

(@jillsnider)

Posts: 110

Estimable Member

The only thing I've found is through the database and will give the vaccine, dose and NDC based on immunizations given. Even though I've mapped CPT codes to the immunizations, I can't seem to locate the table/s where they are related. Here is the query I use for NDC:

select DISTINCT vaccinename, administereddose || administereddoseunits as DOSE, ndc
from immunization
where ndc IS NOT NULL
and vaccinename IS NOT NULL
and administereddose IS NOT NULL
and administereddoseunits IS NOT NULL
order by vaccinename, ndc

Posted : October 13, 2016 3:52 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

Contentlist table where namespace = GE.IMM.CUSL

unfortunately you will probably have to do some JS coding to get anything useful out of it.

Posted : October 13, 2016 4:10 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

if you know web services you could use a proxy tool like soap UI and trace the calls to the GetContentlist service

Posted : October 13, 2016 4:30 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

here is your WSDL:

https://jbosshost:9443/emr-ml/ws/Services/emr?wsdl

and sample soap call to get the custom lists:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<s:Header>
<Workstation xmlns="http://cp.gehcit.com/ws/soap/ext/">
<Id>6338</Id>
</Workstation>
<o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
<u:Timestamp u:Id="_0">
<u:Created>2016-10-13T16:26:38.890Z</u:Created>
<u:Expires>2016-10-13T16:31:38.890Z</u:Expires>
</u:Timestamp>
<o:UsernameToken u:Id="uuid-">
<o:Username>mm</o:Username>
<o:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">REMOVED</o:Password>
</o:UsernameToken>
</o:Security>
</s:Header>
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<GetContentList xmlns="http://emr.ws.cp.gehcit.com/">
<nameSpace>GE.IMM.CUSL</nameSpace>
<recursive>false</recursive>
</GetContentList>
</s:Body>
</s:Envelope>

Posted : October 13, 2016 4:35 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

i suppose the person who sent you a solution does not want to share with the group since post was deleted.

Posted : October 13, 2016 4:52 am

pandait

(@pandait)

Posts: 43

Trusted Member

You can run the following MEL function to get a dump of the GE.IMM.CUSL namespace in the ContentList table: Mel_Get_Content('GE.IMM.CUSL','contains'). This will give you a | and ^ delimited list of all the immunization custom lists (so if you have your own custom list it will dump those too). You can add the node name to the GE.IMM.CUSL argument to get a particular custom list. For instance the statement in our system for the Factory custom list is:

Mel_Get_Content('GE.IMM.CUSL.1704884167062630','contains')

You can then use MEL code to break it apart and get what you need. Mel_Get_Content also supports a 'match' argument when you want something where you know the particular node name. I don't have time right now or I'd give you more details.

Posted : October 14, 2016 4:24 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

This is a side question, but do you have any documentation on MEL_GET_CONTENT()? What does it return, what parameters can you give it? Its not in the help file. Thanks!

Brad

Posted : October 14, 2016 5:32 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

Ditto. Where did you find it?

Posted : October 14, 2016 5:48 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

After I posed my question I did a bit of searching around and found the following discussion. It is helpful:

https://centricityusers.com/forum/where-table-does-mel_add_content-write-to/#answer-184786#answer-184787

Posted : October 14, 2016 5:54 am

pandait

(@pandait)

Posts: 43

Trusted Member

Hi Brad,

No documentation that I know of. I found it in trying to figure out the HTML forms. It seems to take a Namespace as the first parameter and either match or contains as the second. Match is somewhat similar to an = in an SQL Select statement and contains is more in the nature of a "like". The easiest way to see what it does is wrap it in brackets and put it in a handout.

The Namespace is hierarchical with node names being appended to with . to drill down. If I run this:

Mel_Get_Content('GE.IMM.CUSL','match')

I get the information for the custom immunization lists on our system (notice the "match" argument).

1736^GE.IMM.CUSL^1704884167062630^Factory Immunization Custom
List^^^^^^|1785607416483800^GE.IMM.CUSL^1785607416483800^PANDA^^^^^

To get everything under our PANDA custom list. I'd append 1785607416483800 to the GE.IMM.CUSL with a period.
Mel_Get_Content('GE.IMM.CUSL.1785607416483800','match')

I then get (again notice the "match").

1785607417483810^GE.IMM.CUSL.1785607416483800^1776332982543700^Hepatitis B^Hepatitis
B^^^^1^0|1785607418484250^GE.IMM.CUSL.1785607416483800^1776333781597020^DTaP^DTaP^^^^
2^|1785607418484670^GE.IMM.CUSL.1785607416483800^1776335415704070^Polio^Polio^^^^3^|17856
07419485140^GE.IMM.CUSL.1785607416483800^1776335739726230^Hib^Hib^^^^4^|178560741948530
0^GE.IMM.CUSL.1785607416483800^1776336040746480^PneumoPCV^PneumoPCV^^^^5^|178560742
0485460^GE.IMM.CUSL.1785607416483800^1776336347767680^Rotavirus^Rotavirus^^^^6^|178560742
0485610^GE.IMM.CUSL.1785607416483800^1776337038811750^MMR^MMR^^^^7^|178560742148594
0^GE.IMM.CUSL.1785607416483800^1776337392839930^Varicella^Varicella^^^^8^|1785607421486540
^GE.IMM.CUSL.1785607416483800^1776338125888360^Hepatitis A^Hepatitis
A^^^^9^|1785607422486960^GE.IMM.CUSL.1785607416483800^1776338563914270^Tdap^Tdap^^^^10
^|1785607422487160^GE.IMM.CUSL.1785607416483800^1776338818929930^Meningococcal^Meningo
coccal^^^^12^|1785607422487340^GE.IMM.CUSL.1785607416483800^1776339028944450^Human
Papillomavirus^Human
Papillomavirus^^^^13^|1785607423487520^GE.IMM.CUSL.1785607416483800^1776339566979630^Influ
enza^Influenza^^^^14^1|1785607429491360^GE.IMM.CUSL.1785607416483800^1782980466760270^Td
^Td^^^^11^

If I want everything, including NDC numbers, I'd change that to "contains".

Steve

Posted : October 14, 2016 6:38 am

pandait

(@pandait)

Posts: 43

Trusted Member

Thank you for the link. That's a great post!

Posted : October 14, 2016 6:41 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Sure thing. Thanks for your explanation.

Posted : October 14, 2016 6:47 am

24 Forums
9,940 Topics
39.9 K Posts
14 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