Good afternoon!
Is there a Database Diagram for the CPS tables anywhere? I know that there is one (I have seen it) but I can't find the darn thing to save my life!
Thanks!
Kim
Was published for EMR 2005. Currently CPS 12.0 file structures is available on line and can be downloaded. There is no linkage diagram, but all of the linkage information is contained within each table. It takes a while to get used to but it is the current gold standard.
GE does have a pretty good database documentation available. I believe it can be downloaded from the Service Portal. https://engage.gehealthcare.com
If the documentation is a bit too difficult to find, there is an option SQL Server to do this.
If you are comfortable with SQL Server Management Studio, you can create your own database diagrams in the database; however--be careful--it is a live editor so if you make a change, it will write it to the database. For this reason a test system is best.