Diagnosis and procedures

[Sherwin Ditlove]

I've extracted admission accounts from 2000 to current from STAR and created files in 2016. Ran same SQLs in QRE in 2018 with significant amount of records not extracted. Does dayend or monthend processing delete records? Most accounts were inactive.

Thanks
Sherwin Ditlove
SLHS
sdit...@att.net

[Brian Irvin]

I'd probably have to have more detail on exactly what is occurring. I would expect the older data to not be available. Typically there is a delay in getting recent accounts coded. It depends how far behind the coders are. There are retention days that can be entered in the Abstract & DRG Census Criteria in STAR. It's client specific. After those days pass for a given account the diagnosis and procedure data is purged from the system. Hopefully this helps.

Thank you,

Brian Irvin
Sr. Systems Analyst, Information Systems
Beacon Health System
bir...@beaconhealthsystem.org
574-647-4133 (O)
574-647-4107 (F)


-----Original Message-----
From: his...@googlegroups.com <his...@googlegroups.com> On Behalf Of Sherwin Ditlove
Sent: Friday, August 17, 2018 11:51 AM
To: hisnet <his...@googlegroups.com>
Subject: Diagnosis and procedures

Beacon Notification: This message came from an external sender.
________________________________

--
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://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fgroup%2fhisnet.&c=E,1,4LPxvvnQoo90SSEQkB5mE7jXlHFojYNGgWRMLp4Z-WaOipdrrTQQt1Q1EYUE57B2vu9iFbke52cZTlyg6n7GW9FBjboc2hYMJGzUdP-S5gh383Q,&typo=1
For more options, visit https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2foptout.&c=E,1,uAbQgMdQOCm6WaynsyftJbc4qiIHiAfJwNHv3YIif1lABr5ocWFhQmcw_RY6utpQljpfng0djLtVcblLaGnh_eFqzX58zXvBNckEEbCz9P1FEw,,&typo=1

[Kimberly Core]

What are the tables you're using to get your admissions, and what tables are you joining with (and how are they joined?)

Can you post your FROM and WHERE clause? That will help us point you in the right direction

The data you return will be different if you start from different sources - for example if you were using the active or inactive account indexes, the accounts in the those tables will be different over time, because they're "as of right now" when you run a query. Using something like the admit date index as your base for admissions in a time frame is a better starting source.


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.
Please ~ only print this email if necessary!  Reduce, Reuse, Recycle!

-----Original Message-----
From: his...@googlegroups.com <his...@googlegroups.com> On Behalf Of Sherwin Ditlove
Sent: Friday, August 17, 2018 11:51 AM
To: hisnet <his...@googlegroups.com>
Subject: Diagnosis and procedures

--
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.

[Sherwin Ditlove]

Sorry for the late reply.

To be more precise, the queries use AG_ADM_DT_IDX and uses subquires to check if the patient is in either CE_ABST tables. If there is a client parameter that determines when these records are deleted, where are these parameters located? Does the DBA or user have access?

[jako...@verizon.net]

Just became aware that Allscripts has purchased McKesson's Star product.  Does anyone know what the future holds for Star?

J.A.Kosiba

[Leonard Culberson]

Wow! This would be very interesting to know!

On Sun, Sep 9, 2018, 12:06 AM jako...@verizon.net <jako...@verizon.net> wrote:

Just became aware that Allscripts has purchased McKesson's Star product.  Does anyone know what the future holds for Star?

J.A.Kosiba

--

[Joni Stewart]

if anyone has knowledge of the future of STAR, please share with the group.

Thank you.

Have a wonderful day!

Joni Stewart

Application Analyst

Wyoming Medical Center

"Within the now lies all peace." Joanna Field.

[Vickie Jeffries]

Hey guys. 

Did  you see a new announcement about this issue this week? Tge reason I ask is because Allscripts purchased McKesson products either late last year or the first of this year. After that they sold OneContent to Hyland. And McKesson officially became Allscripts on 04.01.18.

Sent via the Samsung Galaxy Note8, an AT&T 4G LTE smartphone

[Joni Stewart]

I did not.  I am aware that Allscripts and McKesson did their thing, I just thought maybe someone did hear something new.  I guess kind of like you were wondering.  

Have a wonderful day!

Joni Stewart

Application Analyst

Wyoming Medical Center

"Within the now lies all peace." Joanna Field.

[Leonard Culberson]

So, McKesson Star, Horizon products,  any McKesson hospital,  physician practice products,  etc., were purchased by Allscripts?  Or did McKesson "sell out" to Allscripts?

[Brian Irvin]

I believe it was mutual.  McKesson was looking to sell off their Provider Technology Division.  If you Google McKesson AllScripts purchase there are lots of articles on it.  Here is one.

 

https://www.healthcare-informatics.com/article/ehr/allscripts-pay-185-million-mckesson-s-enterprise-information-solutions

 

We are still on STAR and some of the ancillary products.  Everything has pretty much been re-branded and we have been working with AllScripts now for support of our old McKesson Products.

 

Thank you,

 

Brian Irvin

Sr. Systems Analyst, Information Systems

Beacon Health System

bir...@beaconhealthsystem.org

574-647-4133 (O)

574-647-4107 (F)

 

From: his...@googlegroups.com <his...@googlegroups.com> On Behalf Of Leonard Culberson
Sent: Monday, September 10, 2018 4:53 PM
To: hisnet <his...@googlegroups.com>
Subject: Re: Allscripts plans

 

Beacon Notification: This message came from an external sender.

---

 

So, McKesson Star, Horizon products,  any McKesson hospital,  physician practice products,  etc., were purchased by Allscripts?  Or did McKesson "sell out" to Allscripts?

[Jager Jonathon]

McKesson did not sell the Horizon products.  They sunsetted those.  Ours are currently supported by Leidos Health until we convert to Cerner Millennium.  STAR, Performance Anlytics, P-Con, and some others (Paragon) were all sold to AllScripts (including the old support teams and the building on Windward Parkway in Alpharetta, GA).  McKesson sold their imaging solutions to Change Healthcare of which include McKesson Radiology (PACS) and Cardiology. 

 

JOnathon R. Jager

Chief Information Officer

St. Francis Hospital

2122 Manchester Expressway

Columbus, GA  31904

Ph: 706-596-4195 

jag...@sfhga.com

http://www.mystfrancis.com

 

From: his...@googlegroups.com [mailto:his...@googlegroups.com] On Behalf Of Leonard Culberson

Sent: Monday, September 10, 2018 4:53 PM
To: hisnet <his...@googlegroups.com>

Subject: [EXTERNAL] Re: Allscripts plans

 

WARNING: This email originated outside LifePoint Health’s email system.
DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.

The information transmitted via this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or proprietary information. Any use, review, retransmission, dissemination or other use of, or pursuing of any action in reliance upon this information by persons or entities other than the intended recipient is strictly prohibited. If you are the recipient of this e-mail transmission in error, please reply to the sender and delete the material from any computer. Thank you.