Notifications
Clear all
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
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
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
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
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
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
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
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
Ditto. Where did you find it?
Posted : October 14, 2016 5:48 am
After I posed my question I did a bit of searching around and found the following discussion. It is helpful:
Posted : October 14, 2016 5:54 am
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
Thank you for the link. That's a great post!
Posted : October 14, 2016 6:41 am
Sure thing. Thanks for your explanation.
Posted : October 14, 2016 6:47 am
