Client:
Leading U.S. supplier of healthcare information
technology (HIT) solutions that optimize clinical and financial outcomes.
Business
Needs:
§
Gather information from various
Cerner database tables according to the specifications provided by the Client.
§
Maintain the report performance, in
case of very complex database queries.
§
Identify the correct index to improve
the report performance.
§
Complex database structure having
more than 2000 tables.
Solutions:
§
Provide various tools to create complex database reports:
genviews, VisualDeveloper / ExplorerMenu
extracts and reports, and pharmacy label development, JavaScript ExplorerMenu
Prompt development.
§
Handling of huge number of database
tables.
§
Development of reports & graphs using PowerChart™,
GenViews and Smart Templates.
§
Seamlessly integrate lab results with
the patient’s electronic medical record.
§
Provide CCL programming; including
monitoring and audit reports.
§
Provide Layout Builder tool and various CCL commands to create Barcode,
Patient Labels, Charts, Complex Formats.
§
Provide OpsView Scheduler and OpsView
Monitor tools to handle day to day ops jobs, controls groups, job groups.
§
Integration of JavaScript to CCL
reports.
§
Normalize database structure.
§
Integration of Oracle commands with
CCL commands.
§
Error Handling.
§
Capability to run the Complex queries
on the basis of Normalized database structure and Indexes.
§
Global security for HNAM, including
Power Chart, First Net, RadNet, and Pharamanet.
§
Creation of new reports PostScript®
capabilities for graphs and other visual representations.
§
Label generation from Discern
Expert™.
§
Automated summary reporting.
Technology Platform:
Cerner development
platform with Oracle database.
We
provided structured project teams of 3-5 personnel with well-defined functions
like scrum master, team members, GUI designers, that developed web application
using agile project management methodology.
