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

Database size reduced after 12.2 upgrade?

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

7 Posts

2 Users

0 Reactions

60 Views

RSS

tnc

(@tnc)

Posts: 517

Honorable Member

Topic starter

I don't think there is reason for concern here since everything seems to be working fine but I noticed that my compressed .BAK files shrank from 88GB (12.0.12) to 77GB (12.2). They are slightly larger every night now but wondering why there was an 11 G drop.

Anyone else notice this? I am assuming that they purged some junk in the DB

Mike Zavolas

Tallahassee Neurological Clinic

Posted : May 1, 2017 6:48 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Might have dropped and recreated indexes but 11 gig is a lot.

Posted : May 2, 2017 12:41 pm

tnc

(@tnc)

Posts: 517

Honorable Member

Topic starter

We are missing the tax IDs for referring physicians. All of ours are there for our own physicians but there is some concern that this will cause billing issues. I opened a case but waiting at the speed of GE and haven't heard back yet. It did it on my test DB also. I am awaiting a response from GE to hopefully get them to assist with a script to pull the IDs out of a pre 12.2 restored DB so put them back in. Certainly that wouldn't account for 11 G compressed but it is a bit concerning. Hope I can have a discussion with them soon.

Posted : May 3, 2017 12:47 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Did it drop the column or just the information in it for the referring physician tax ID's?

Posted : May 3, 2017 2:09 am

tnc

(@tnc)

Posts: 517

Honorable Member

Topic starter

Just the information is missing. Just a blank field is there.

Posted : May 3, 2017 6:40 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

I don't know if the fields are updated anywhere else, but if they just need to be updated in DoctorFacility you could do this.

On you DB with the Tax ID's, run

select DoctorFacilityID, FederalTaxId, FederalTaxIdType from DoctorFacility

Turn the results into an Excel spreadsheet where, in the first row, DoctorFacilityID is in A1, FederalTaxId in B1 and FederalTaxIdType in C1.

In E1, paste the formula:

="update DoctorFacility set FederalTaxID = "&B1&",FederalTaxIDType = "&CHAR(39)&C1&CHAR(39)&" where DoctorFacilityID = "&A1

The result of this formula should give you an Update statement. Copy E1 and do a Paste Special in O1 and paste it as a value. You can then copy the update statement and run it against your SQL database. If successful, you can copy E1's formula down all your data in the spreadsheet to get all the update statements needed to get back "up-to-date". Again, copy and Paste Special Value. No guarantees and TEST! TEST! TEST!

Posted : May 3, 2017 8:31 am

tnc

(@tnc)

Posts: 517

Honorable Member

Topic starter

David
This was a tremendous help.

Thank You

Mike

Posted : May 4, 2017 2:58 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