The GCS ARCHIVE A Precision 2000® Legacy Data Export and Archive Solution The extracting and permanently storing of the Precision 2000® legacy data is often a project that receives attention just prior to the plug being pulled on the old hardware.  Someone in the Business Office or Medical Records area asks how they can obtain access to the patient data after the legacy system is permanently turned-off.  Short of converting all of the detailed historical information from the old system into the new system, it becomes a problematic situation due to the large volumes of data that have been amassed over a decade or more of Precision 2000® system usage.  In order to meet regulatory requirements, hospitals have a need to keep Patient Accounting and Medical Records data accessible for a minimum of seven years.  To address this pressing need for access to the legacy information, Glassman Consulting Services has developed the GCS Archive.  The GCS Archive is an archival solution that provides continued access to historical Patient Accounting data for billing and medical records personnel.  Detailed biographic, demographic and financial data are retained permanently in view only screens.  Built on Microsoft Windows SQL 2000 with .NET Framework technology, the browser enabled archive tool makes deploying the system simple.  Users with access to an internet browser and appropriate security access may view the GCS Archive data. The GCS Archive allows the end-user to rapidly query the data via intuitive web-enabled screens to find the information they need.  For example, the end-user can do a patient search by a combination of name, history #, SSN# or DOB. Once a user locates the patient account, they can go to the account overview and query from there to additional account level screens (e.g. patient charge inquiry, payments/adjustment, patient notes, insurance, etc.).  This approach  allows end-users to dynamically look-up accounts and view the archived data in a familiar logical sequence.  The screens are organized and presented in an easy-to-use format, requiring very minimal training. All archived data within the GCS Archive is view only with no updates being allowed in order to permanently preserve an accurate historical copy of the archived data.  The Microsoft SQL Server database allows dynamic reporting via industry standard client/server reporting tools (e.g. Crystal Reports, Brio, Impromptu, etc.).  System access and security is provided by standard Microsoft local groups.  We can also work with domain groups or active directory to further enhance the GCS Archive security, if needed. The advantages of using the Microsoft ASP .NET Framework environment are numerous and will allow the end-users to view the archived Precision 2000® data via their web browser and in a format and sequence that is familiar to them. Since it is browser based, all software and data exist at the server, so there is no need to deploy software or data to the end-user pc. The GCS Archive has been designed to provide the hospital with a permanent archive solution that provides intuitive access and navigation of the Precision 2000® legacy data with maximum performance, flexibility and value. Screen Shots The following are sample screen shots found within the GCS Archive . Click-on the thumbnails to enlarge. Encounter View Account Overview Charge Inquiry Technical Requirements The GCS Archive product runs on Microsoft Windows 2000 Server (we can work with the recently released Windows Server 2003). The product runs Microsoft's web server (IIS) Internet Information Server, with a Microsoft SQL Server Database. The GCS Archive was developed using ASP .Net pages and has been tested with the Microsoft Internet Explorer 6.0 SP1 browser and should be compatible back to IE 5.5. Note: we have not tested Netscape functionality. The product uses Microsoft local groups in order to validate end-user access to the various applications in the system such as Patient Accounting and Medical Records.  We can also work with domain groups or active directory if requested.  Hardware requirements will depend upon the finalized number of end-users and the volume of data to be extracted (see Windows Minimum System Requirements below for more details).  The links below will direct you to the required Microsoft product licenses and pricing information: Microsoft Windows 2000 Server (REQUIRED)  [we can work with MS Windows Server 2003] http://www.microsoft.com/windows2000/server/howtobuy/pricing/default.asp Microsoft SQL Server 2000 Processor License Standard Edition (REQUIRED)   http://www.microsoft.com/sql/howtobuy/default.asp   Implementation Services Implementation services will be provided in the following steps: GCS will provide resources to deliver and install the GCS Archive software on the GCS server. GCS will deliver, install and execute the Base QTP Extract Software.  This software will run against the Precision 2000® data and extract the Archived Files for formatting in preparation for the load of the legacy data into the GCS Archive. Data scrubbing of the data so that we can import “clean data” into the GCS Archive. Remote assistance with Security set-up and product training for the client designated project leader Archived Files The following Precision 2000® Files will be extracted and loaded as part of the base GCS Archive install.  Additional Precision 2000® files and/or custom files can be loaded into the GCS Archive at additional costs.  Alt-Hcpcs-Mstr Ar-Acct-Detail Ar-Acct-Summary/H-Acct-Summary Ar-Invoice CC-Comments Charges Clin-Abs-Data Code-Table Diagnoses Dr-Mstr Entity-Ctrl ICD9CM Panel-Charges Pat-Acct-Xref Pat-Bio Pat-Bio-Rel Pat-Encounter/HPat-Temp-Enc Pat-Hcpcs Pat-Notes-Mstr Pat-Temp-Enc Procedures Serv-Item-Mstr Serv-Item-Price Sim-Hcpcs-Mstr The following files can optionally be delivered for additional costs: Accounts Payable Files AP-BANK-MSTR AP-CHECK-SEARCH AP-INV-HEADER AP-INVOICE-DETAIL AP-INVOICE-NOTES AP-MGT-CLASS-MSTR AP-VENDOR-MSTR AP-VENDOR-NOTES General Ledger Files GL-SRC-JOURNAL GL-BUDGET-MSTR GL-CHART-ACCTS GL-DEPT-MSTR GL-STAT-CLASS GL-STAT-MSTR  HR / Payroll Files PP-EMPL-BIOG PP-EMPL-BENEFITS PP-CODE-TABLE PP-EMPL-DEDN PP-EMPL-EARN PP-EMPL-POSN PP-EMPL-TAXES PP-TIME-HIST PP-EMP-NAMES PP-PAYROLL-ENT Screens   The following screens will be delivered with the base GCS Archive install: Patient Accounting / Medical Records – Entry Access Patient Search Episode Search Guarantor Name / Number Search Encounter Patient Biographic Information Next of Kin Patient Notes Patient Comments Account Overview Account Detail Activity Patient Charge Inquiry Guarantor Master Medical Record Overview Clinical Abstract Data Diagnoses Procedures Service Item Master Service Item Pricing Panel Charge Master HCPCS/CPT4 Maintenance Alternate HCPCS Codes * The following screens can be optionally be delivered for additional costs Accounts Payable Screens Vendor Search Invoice Search Check Detail Search Vendor Master 1099 Accumulations Vendor Notes 1099 Adjustments Invoice Header Information General Ledger Screens Chart of Accounts General Ledger Inquiry GL Summary Journal Inquiry GL Account Type Reconciliation GL Statistics Master GL Statistic Inquiry GL Budget Master General Ledger Parameters HR / Payroll Screens Employee Name Search Department Search Employee Biographics Employee Benefits Employee Taxes Employee Positions Employee Deductions Employee Earnings Employee Time History Employee Position History Employee Review/Event History Payroll Entity Parameters Code Tables  * Additional screens and/or modifications can be delivered for additional costs.  Windows Minimum System Requirements (Server) Pentium IV 2.0 Ghz Processor or equivalent Microsoft Windows 2000 Server or higher Microsoft SQL Server 2000 (database) 512 mb RAM Disc Space 100 Gbytes Secure access to server (VPN) with file transfer capability Intranet access to server    Please contact us for information, references, and current pricing.   return to top | home page | contact us