In order to access data from other systems, we created a program which connects to any ODBC connection ("ODBC is a programming interface that enables applications to access data in database management systems that use Structured Query Language (SQL) as a data access standard."). The data shuttle program is able to read data and tables in other systems while not changing or altering the data, thus giving us the ability to transfer data into ESM™ on a real time or batch basis.
All information is formatted into the logical groups which you have created in your financial systems, as well as there is the ability to create unlimited groupings using fast building tools. These grouping can then be applied to a cube and viewed. All of your General Ledger Data statistics can be loaded as well as other systems data.
Depending on the intended audience, some cubes offer very high level, aggregated and normalized data to prohibit detail identification. There is a wide range of options. Cubes have many pre-calculated views of your organization, offering new insights using the same data sources. ESM™ goes the extra step by displaying only the data views that are logical for your specific organization. New cube definitions are built using your business expertise and desired outcome measures. Ease of Exploration The cubes in ESM™ offer:
  1. Consistent information presented in standardized format
  2. Coding is normalized to a single reporting format
  3. Fast, single-source reporting (frozen by reporting period or month)
  4. View the same data from various perspectives
  5. User-controlled reporting trees
  6. Filter to desired information level or exceptions
  7. Drill through to the underlying information source for detail requirements
  8. Access in the office or from any location with a computer
Technical - What is a Cube: A cube is three-dimensional data store (database files) built from a variety of operational data. This container stores various pre-calculated organizational views based on pre-defined summary groups and levels. Planning of a cube’s role is critical to its success. Typical activities to prepare a successful cube:
  1. What is cube’s intended role? (Summary documentation stays with cube)
  2. How will the summary data be evaluated?
  3. Trends (monthly, quarterly, yearly, pay or GL periods)
  4. Benchmarks or key indicators (percent, pre-set targets)
  5. Define lowest level to link data together
  6. Define desired summary levels through user defined trees
  7. Define data sources (Budget Manager, databases Sql Server, Oracle…)
  8. Define drill-down requirements, if any
  9. Define normalization levels (From consistency level to making data non-identifying)
  10. Define scripts to import, process, validate (audit), and normalize the data
  11. Managed through import process
  12. Once scripts manually tested, they can be fully automated
  13. Key is to fully audit the data to ensure proper coding
  14. Crosscheck totals
  15. Establish security rules and level, and define User ID access.
  16. Notify users when cube builds are ready for their use (monthly usually)
Graphing is currently being developed in conjunction with the users. The type / Style of all the graphs will be part of each cube.
Yes, any type of document can be stored in the Budgeting Module. Both on the Salary and Non-Salary (including statistics) we have access to store a document on line.
Depending on how information is currently circulated, the power of these products will drive your information access into a streamline environment. Due to the pressures in healthcare today, we believe that you will be able to see a RIO to be deployed on the operations of the hospital rather than within the Finance Department.
The columns are flexible in that it gives you the ability to control what information you want to see on the screen.
All titles and headings can be renamed with your hospitals names/mnemonics/short-forms to ease the learning curve and maintain hospital polices.
The Report Writer for both the ESM™ and Budget Manager is included. We currently have 170 template reports which are both for Dictionary and Data extraction. The data, once extracted, can also be saved in a few different formats i.e. Excel, PDF, Text
Security Levels are set in two basic manners
  1. Full System Access (Finance user)
  2. Restricted User (restrictions to Cost Centres and Secondary Accounts)
Then within each group, you set a level which dictates what information is displayed on the screen in relation to read/write access.
For Both the Budgeting and ESM™, it is estimated to require .3 FTE to maintain the application.
Yes, the product is sold on the basis of number of Staff (FTE employees) with unlimited user access.
Yes, we have a number of references and a list of hospitals that are willing to share their experience. An account manager can contact you with a comparable user.