McKesson SQL tables and Patient data in MS SQL

[Leonard Culberson]

Hello all!

I was wondering if anyone out there has tried copying McKesson STAR SQL tables and Patient detail data over to a MS SQL database?  Has anyone accomplished this?  What was your process; how does it work, etc.

Anyone who has any information to share would be greatly appreciated!!

Thanks!

Leonard

[Anton Soldatkin]

Leonard, we do maintain MS Access and MS SQL databases that are replicas of STAR patient detail data, charges, financial transactions, AR, etc.

 

Anton Soldatkin

 

Jupiter Medical Center

--
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 http://groups.google.com/group/hisnet.
For more options, visit https://groups.google.com/d/optout.

[Leonard Culberson]

Hello Anton!

Great!  Is there any possible way you get send me how you maintain this in a MS SQL database?  How you created in MS SQL the star tables, data elements, the patient account and detail data?  We are at looking possibly doing this and any information you have, documentation, steps, processes, etc., would be great to show us what you did.

Thank you for responding!

Leonard

[Anton Soldatkin]

Leonard, at the very general level:

 

We have a dedicated SQL Server 2008R2. We started with Patient Demographics and Charges extracts from STAR followed by many more. I will share with you the process for Patient Demographics as an example.

 

We have decided what fields out of STAR we wanted for Patient Demographics extract first. We ended with about 120 fields from various STAR tables. Then we wrote STAR SQL to grab those fields. We went back to 2008.

 

Then on SQL server we created new Database and new table to hold Patient Demographics data. We did not keep STAR field names but rather used user friendly field names. Then we ran STAR SQL to get historical accounts to load. The result was flat text file comma delimited but now I think pipe delimited would work better. Than we created an SSIS package on SQL Server that loads STAR extract into SQL Server Patient Demographics table. This is how we obtained historical data.

 

The next step was to bring new records from STAR to SQL server. For that we decided that each day we want to bring in STAR accounts discharged yesterday, today and still in house. We added that criteria to our STAR SQL and scheduled it to run daily to drop the file on STAR box. On SQL Server machine we created scheduled job to FTP that file from STAR box to SQL Server file system. Then we created and scheduled SQL Server job that runs SSIS package every day to bring new accounts in.

 

The next challenge was to bring in updates from STAR for the accounts previously loaded if there was a material change in demographics fields. Given that we decided to implement incremental approach for loading this table we needed to make sure we do catch those changes to the accounts. We used Trendstar trigger events for accomplishing that. That is a topic for a separate conversation though. Also, if your facility doesn't use Trendstar it is a mute point.

 

Each month end we reload last three month of discharges and then reconcile our DB against STAR. This is pretty much the whole process. Other extracts may be done a little differently but the idea is the same.

 

Let me know if you have any questions.

 

Anton.

[Leonard Culberson]

Anton,

Great information!  thank you for sharing.  If something comes up and I have questions, i will contact you!

Thank you again!

Leonard