Consolidate and streamline data from disparate systems
for a coherent and accurate picture of the facts

ETVL (Extract Transform Validate Load) provides powerful yet simple data integration functions for users, without requiring IT programming support:

  • Extract data from any type of system in their existing file formats. Incoming data is automatically cleansed and transformed, ensuring that quality decisions are based on quality information. Accepts batch and transactional data feeds, including HL7 and ODBC.

  • Transform data into useful information for costing and reporting purposes. For example, derive LOS from admission and discharge times.

  • Validate data using user-defined rules or by checking against reference tables. You can drilldown from a summary list to the actual records and correct the data.

  • Load data in its current interface format by selecting from a list and clicking a button. External feeder system data is linked to the correct episode of care during the load process.


Advantages

  • Ensures the integrity of your most valuable organizational asset — information

  • Links to all relevant information, from legacy systems to leading edge technology

  • Also a standalone solution to your organization's data warehousing strategy.



<< PowerPerformance Management Architecture >>