Abstract: A system, method and software product retrieve a formatted data value from a data layer to a business logic layer by invoking a formatted variable abstraction procedure from the business logic layer, passing at least one parameter to the formatted variable abstraction procedure (the at least one parameter identifying a formatted system variable), and building a dynamic statement based upon the formatted system variable such that execution of the dynamic statement: accesses a formatted variable table based upon the formatted system variable to locate information relating to the formatted system variable; retrieves one or more data items based upon the information; formats the data items to form the formatted data value based upon the information; and returns the formatted data value to the business logic layer.

Abstract: A system and method store addresses within a database. An address and an address usage type that define an intended use of the address for an entity are captured. Address elements of the address are determined using an address template based upon the address usage type. If the address is not already stored within the database, an address entry having a new unique address identification number is created within an address table, each of the address elements are stored within an address element table of the database in association with the new unique address identification number, and an association entry is created within an address association table to associate the new unique address identification number with the entity, as well as to store the address usage type.

Abstract: A method of processing health insurance claims includes receiving, within a claim receiver, a claim submission from a client, the claim submission identifying a policy of the client and details of the health insurance claim. The claim receiver converts, within the claim receiver, the claim submission into a claim charge to facilitate automated processing of the health insurance claim. The claim charge is validated against one or more validation rules to the identify zero, one, or more claim validation exceptions. The validation exceptions are resolved and the claim submission is settled if the validated claim charge and any remaining validation exceptions conform to settlement control data.

Abstract: A system and method store addresses within a database. An address and an address usage type that define an intended use of the address for an entity are captured. Address elements of the address are determined using an address template based upon the address usage type. If the address is not already stored within the database, an address entry having a new unique address identification number is created within an address table, each of the address elements are stored within an address element table of the database in association with the new unique address identification number, and an association entry is created within an address association table to associate the new unique address identification number with the entity, as well as to store the address usage type.

Abstract: A system, method and software product retrieve a formatted data value from a data layer to a business logic layer by invoking a formatted variable abstraction procedure from the business logic layer, passing at least one parameter to the formatted variable abstraction procedure (the at least one parameter identifying a formatted system variable), and building a dynamic statement based upon the formatted system variable such that execution of the dynamic statement: accesses a formatted variable table based upon the formatted system variable to locate information relating to the formatted system variable; retrieves one or more data items based upon the information; formats the data items to form the formatted data value based upon the information; and returns the formatted data value to the business logic layer.