General Education Related to STAR Inquiry

[Mark]

Hi Everyone,

I work in a hospital that currently uses STAR for its HIS.  This year, I'm trying to build a better foundational knowledge of the technologies it uses.  This is partially because training material for the application itself is limited and partially to develop a more transferable skill set.

The three categories I think would be most relevant are: Linux, SQL & databases, and MUMPS.

Has anyone done anything similar or have advice for this approach?  Or, do you know of a repository for the STAR specific variants (like KBSQL).

Thank you,

Mark

[Kimberly Core]

I don’t think I completely understand your question.

 

But if you’re looking for KB_SQL info, they do have a knowledge base – it won’t be STAR specific but does have lots of really good info there

https://www.kbsystems.com/kbsql.html

 

There’s also a windows based query editor called QRE, so you still connect to STAR though the back end via ODBC and use KB_SQL like you would inside of STAR Vista Reporting in STAR… It looks more like T-SQL environment would with the colours for the key words and operators etc.  But any hard hitting complex coding I still do inside of STAR, the QRE version doesn’t always like it

 

As for MUMPS – good luck with that one ;)

 

I’d also think that you’d want HL7 interfaces in that list of skillsets?

 

Regards,

Kim

 

 

Kimberly Core | Systems Analyst | Transform Shared Service Organization | (519) 352-6401 x6971 | Kimber...@transformsso.ca

 

 

CONFIDENTIALITY STATEMENT:  This email transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the email address.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this email is strictly prohibited.  If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.

P Please ~ only print this email if necessary!  Reduce, Reuse, Recycle!

--
You received this message because you are subscribed to the Google Groups "hisnet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hisnet+un...@googlegroups.com.
To post to this group, send email to his...@googlegroups.com.
Visit this group at https://groups.google.com/group/hisnet.
For more options, visit https://groups.google.com/d/optout.

[Debbie Ford]

does anyone know someone that "teaches" sql beside allscripts?

 

Debbie Ford

Information Systems, Rush Health Systems

Meridian,MS  601-703-9530

Rush Health Systems, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this message or its attachments (hereinafter collectively "communication").  Any personal comments made in this communication do not reflect the views of Rush Health Systems, Inc. or its subsidiary and affiliated companies The information contained in this communication may be privileged and/or confidential and solely for the use of the intended recipient or protected from disclosure under applicable law.  If you are not the intended recipient or the individual responsible for delivering to the intended recipient, please (1) be advised that any review, use, dissemination, forwarding, printing or copying of this communications IS STRICTLY PROHIBITED; (2) notify sender immediately by telephone and (3) permanently delete or destroy this communication.

[Kimberly Core]

I’m sure there are still folks around that do, I’ll see if I can find an old mail with any contact info

 

In the interim I’m sure there’s still some of us seasoned SQL gurus around that can help out with specific questions.  And some of us would probably (off hours) do some free tutoring, sort of walk folks though the basics. 

 

Kimberly Core | Systems Analyst | Transform Shared Service Organization | (519) 352-6401 x6971 | Kimber...@transformsso.ca

 

 

CONFIDENTIALITY STATEMENT:  This email transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the email address.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this email is strictly prohibited.  If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.

P Please ~ only print this email if necessary!  Reduce, Reuse, Recycle!

 

[Debbie Ford]

I am retiring and need someone that knows the basics/advanced  to admistrative stuff.

 

Debbie Ford

Information Systems, Rush Health Systems

Meridian,MS  601-703-9530

 

[Susan Hunter]

Hi Debbie!

Congratulations on retiring! What exactly are you looking for for SQL? I can reach out to a friend in TN who did work for us when I was at MS Baptist. She’s excellent with SQL. 

Susan Hunter

Sent from my iPhone

On Feb 14, 2019, at 10:08 AM, Debbie Ford <Debbi...@rushhealth.com> wrote:

I am retiring and need someone that knows the basics/advanced  to admistrative stuff.

 

Debbie Ford

Information Systems, Rush Health Systems

Meridian,MS  601-703-9530

 

From: Kimberly Core [mailto:Kimber...@transformsso.ca]
Sent: Thursday, February 14, 2019 8:59 AM
To: Debbie Ford; his...@googlegroups.com
Subject: RE: General Education Related to STAR Inquiry

 

I’m sure there are still folks around that do, I’ll see if I can find an old mail with any contact info

 

In the interim I’m sure there’s still some of us seasoned SQL gurus around that can help out with specific questions.  And some of us would probably (off hours) do some free tutoring, sort of walk folks though the basics. 

 

Kimberly Core | Systems Analyst | Transform Shared Service Organization | (519) 352-6401 x6971 | Kimber...@transformsso.ca

 

<image001.jpg>

<image001.jpg>

[Susan Hunter]

Sorry gang! Meant to send that directly to Debbie. 

Susan Hunter

Sent from my iPhone

[Debbie Ford]

ALSO, who is still on Horizon Clinicals.

 

Debbie Ford

Information Systems, Rush Health Systems

Meridian,MS  601-703-9530

 

From: his...@googlegroups.com [mailto:his...@googlegroups.com] On Behalf Of Debbie Ford

Sent: Thursday, February 14, 2019 7:53 AM
To: his...@googlegroups.com

[judi.s...@cfl.rr.com]

Kevin Green is a former McKesson SQL support tech who is now an independent consultant.  He would teach SQL.

[judi.s...@cfl.rr.com]

Congratulations on your retirement, Debbie.  I’m going to be retiring from full-time work in about a year myself.  Might consider some adhoc SQL assignments or teaching then.  Soon there won’t be any of us left that know it. 

 

Judi Spillers

CTG Sr. Support Analyst

[judi.s...@cfl.rr.com]

Here is Kevin’s contact info.

 

Judi Spillers

CTG Sr. Support Analyst

 

[Leonard Culberson]

Debbie,

Yes!  Congratulations!  I myself worked in the McKesson/SQL environment for approx. 20 years.  I retired from working in April 2017.  I enjoyed the McKesson environments and SQL, although sometimes it was very aggravating!  😊

I hope you find someone.

 

Leonard

 

Sent from Mail for Windows 10

[jayecostello]

Kevin Green is amazing.  We had him come to town several years ago to do a class and he was one of my go-to people at McKesson.  He also did presentations at InSight.   

If you can get him to help you out, I'd do it.  :-)

Sent from my Verizon, Samsung Galaxy smartphone

-------- Original message --------

From: judi.s...@cfl.rr.com

Date: 2/16/19 1:57 PM (GMT-05:00)

To: his...@googlegroups.com

Cc: kevingr...@gmail.com

Subject: RE: General Education Related to STAR Inquiry

Here is Kevin’s contact info.

 

Judi Spillers

CTG Sr. Support Analyst

 

From: his...@googlegroups.com <his...@googlegroups.com> On Behalf Of judi.s...@cfl.rr.com
Sent: Saturday, February 16, 2019 1:51 PM
To: his...@googlegroups.com
Subject: RE: General Education Related to STAR Inquiry

 

Kevin Green is a former McKesson SQL support tech who is now an independent consultant.  He would teach SQL.

 

From: his...@googlegroups.com <his...@googlegroups.com> On Behalf Of Debbie Ford
Sent: Thursday, February 14, 2019 11:26 AM
To: his...@googlegroups.com
Subject: RE: General Education Related to STAR Inquiry

 

ALSO, who is still on Horizon Clinicals.

 

Debbie Ford

Information Systems, Rush Health Systems

Meridian,MS  601-703-9530

[MollyGmail]

Agreed... Kevin G is great.