Error and load summary reporting in a health care solution environment

A computer program embodied on a computer readable medium for generating error and summary reports for a data load, while storing user input data files in a multi-tier client/server architecture such that the data files are organized around tiers of keywords, comprising:

• (a) a code segment that maintains a connection between multiple user stations and a server having a database;
• (b) a code segment that selects a plurality of user-selected keywords from a user interface, wherein each keyword is associated to a data file name and a data type, also wherein the plurality of keywords are arranged in the user interface in a tier structure such that keywords in a first tier are associated to data files that must be loaded into the database before data files associated to a second tier are loaded into the database;
• (c) a code segment that receives from one of the user stations a plurality of user input data files that are associated to the selected plurality of keywords;
• (d) a code segment that selects a data management template corresponding to the keywords, wherein the data management template organizes the data files to be loaded into the database;
• (e) a code segment that validates that all data to be loaded into the database matches the data management template by enforcing business rules and requirements and ensuring that referential integrity, codependency, primary key, required field, default field, sequence number, and hard-coded field checks are met;
• (f) a code segment that loads the validated data into the database;
• (g) a code segment that compiles a report identifying data that match the data management template and data that do not match the data management template;
• and
• h) a code segment that provides said compiled report to said user for review.