System and Method for Inter-Relating Multiple Data Types

摘要

A system and method of inter-relating multiple data types to provide a comprehensive data output reflecting non-retail sales of pharmaceuticals is disclosed. In particular, the system and method of the present invention provides for receiving non-retail pharmaceutical delivery information of pharmaceuticals deliver to outlets from manufacturers or distributors, where the data is primarily inconsistent and features many voids (102, 104, 202-204). The present invention inter-relates one or more reference datum from other sources (402-412) in a cross relational manner to ensure that voided fields in the pharmaceutical deliver information are populated and/or verified (414). The present invention also provides means to configure pre-defined queries of the data extract for efficient service of reports for clients (416).