Notifications
Clear all
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
Might have dropped and recreated indexes but 11 gig is a lot.
Posted : May 2, 2017 12:41 pm
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
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
Topic starter
Just the information is missing. Just a blank field is there.
Posted : May 3, 2017 6:40 am
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
Topic starter
David
This was a tremendous help.
Thank You
Mike
Posted : May 4, 2017 2:58 am
