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.
