Methods and systems for automated data collection and analysis

• US 8,571,974 B1
• Filed: 06/17/2008
• Issued: 10/29/2013
• Est. Priority Date: 11/30/2001
• Status: Expired due to Term

• Current Assignee: The PNC Financial Services Group, Inc.
• Original Assignee: The PNC Financial Services Group, Inc.
• Inventors: Coleman, Donald P.
• Primary Examiner(s): AMELUNXEN, BARBARA J
• Application Number:
  US12/140,621
• Time in Patent Office: 1,960 Days
• Field of Search: 705/36.R, 705/37, 705/38, 705/9, 705/8, 705/2, 705/4, 705/10, 705/36, 705/35.R, 707/100, 707/695, 713/168, 713/178, 726/22, 1/1, 715/848
• US Class Current: 705/38
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method for processing documents in a database having at least one record therein. Asset-related data contained on at least one document is reviewed pursuant to securitization of multiple assets. The at least one of the multiple assets comprises a commercial mortgage loan. The document is received into the database on a flow basis including receiving information from the document into the database as the document information becomes available for entry into the database. The flow basis includes collecting data from the document independently of an end use of the document. The contents of the document are analyzed to ensure compliance with at least one standard. The output data is provided from the record in the database. The output data includes at least data related to multiple assets associated with a securitization of the multiple assets. System, computer readable memory, and computer readable memory storage embodiments also are provided.

Claims

1. A computer-assisted method for processing documents in a database having at least one record therein, the method comprising:

receiving, by a computer system, a document file comprising asset data stored therein in preparation for securitization of multiple assets, wherein at least one of the multiple assets comprises an issued commercial mortgage loan, wherein the commercial mortgage loan is ready for securitization;

transmitting, by the computer system, the document file into the database on a near real time basis as the asset data stored in the document file becomes available for entry into the database;

receiving, by the computer system, preexisting asset data generated by a first party to the commercial mortgage loan, wherein the asset data stored in the document file is generated by a second party to the commercial mortgage loan, wherein the first party and the second party are distinct, and wherein at least one of the preexisting asset data generated by the first party and the asset data comprised by the document file generated by the second party reflects a physical inspection of a property covered by the issued commercial mortgage loan;

inventorying the document file into an associated record in the database on a near real time basis as the asset data in the document file becomes available for inventorying, including collecting asset data from the document file independently of an end use of the document file;

when the asset data stored in the document file relates to preexisting asset data contained within the at least one record stored in the database, comparing, by the computer system, the asset data stored in the document file to the preexisting asset data contained in the at least one record;

generating a data mismatch alert, by the computer system, when the asset data stored in the document file does not match the preexisting asset data contained in the at least one record;

providing, by the computer system, the data mismatch alert to a user of the computer system via a user interface;

analyzing, by the computer system, the asset data stored in the document file in near real time as the asset data become available to determine compliance with at least one preprogrammed banking rule for securitizing multiple financial instruments;

generating a banking rule alert, by the computer system, when the contents of the document file do not comply with the at least one preprogrammed banking rule for securitizing multiple financial instruments;

providing, by the computer system, the banking rule alert to the user of the computer system via the user interface; and

providing, by the computer system, specific output data from the at least one record in the database to a user on demand, wherein the output data includes asset data related to the multiple assets pertaining to a securitization of the multiple assets.

2. The method of claim 1, wherein the providing step comprises:

requesting specific information contained in the document file;

locating a record associated with the document file;

retrieving the record; and

extracting the specific information contained in the record.

3. The method of claim 1, wherein each of the multiple assets comprise a commercial mortgage loan that is ready to be prepared for securitization.

4. The method of claim 1, wherein generating the banking standard alert comprises generating the banking standard alert in real time as the document file is transmitted in to the database.

5. A computer system for automated processing of documents in a database having at least one record therein, the system comprising:

a data input device to receive first information stored in an asset document file related to an asset from an input source on a flow basis including to receive the first information as the first information becomes available for entry, wherein information from a plurality of the asset document files related to the asset comprises a record;

a storage device for storing the record;

a processor in communication with at least one computer readable memory including stored computer executable instructions that, when executed by the processor, cause the processor to;

receive in at least one document file comprising asset data stored therein in preparation for securitization of multiple assets, wherein at least one of the multiple assets comprises an issued commercial mortgage loan, wherein the commercial mortgage loan is ready for securitization;

receive preexisting asset data generated by a first party to the commercial mortgage loan, wherein the asset data stored in the document file is generated by a second party to the commercial mortgage loan, wherein the first party and the second party are distinct, and wherein at least one of the preexisting asset data generated by the first party and the asset data comprised by the document file generated by the second party reflects a physical inspection of a property covered by the issued commercial mortgage loan;

transmit the document file into the database on a near real time basis as the asset data stored in the document file becomes available for entry into the database;

inventory the document file into an associated record in the database on a flow basis as the asset data in the document file becomes available for inventorying, including collecting asset data from the document file independently of an end use of the document file;

when the asset data stored in the document file relates to preexisting asset data contained within the at least one record stored in the database, compare the asset data stored in the document file to the preexisting asset data contained in the at least one record;

generate a data mismatch alert when the asset data stored in the document file does not match the preexisting asset data contained in the at least one record;

provide the data mismatch alert to a user of the computer system via a user interface;

analyze the asset data stored in the document file in near real time as the asset data become available to determine compliance with at least one preprogrammed banking rule for securitizing multiple financial instruments;

generate a banking rule alert when the contents of the document file do not comply with the at least one preprogrammed banking rule for securitizing multiple financial instruments;

provide the banking rule alert to the user of the computer system via the user interface; and

provide specific output data from the at least one record in the database to a user on demand, wherein the output data includes asset data related to the multiple assets pertaining to a securitization of the multiple assets.

6. The system of claim 5, wherein the processor is configured to:

request specific information contained in the document file;

locate a record associated with the document file;

retrieve the record; and

extract the specific information contained in the record.

7. The system of claim 5, wherein the stored instructions, when executed by the processor, cause the processor to generate the banking standard alert in real time as the document file is transmitted in to the database.

8. An apparatus, comprising:

a computer readable memory;

the computer readable memory including stored computer executable instructions that, when executed by a processor, cause the processor to;

receive in at least one document file comprising asset data stored therein in preparation for securitization of multiple assets, wherein at least one of the multiple assets comprises an issued commercial mortgage loan, wherein the commercial mortgage loan is ready for securitization;

transmit the document file into the database on a near real time basis as the asset data stored in the document file becomes available for entry into the database;

receive preexisting asset data generated by a first party to the commercial mortgage loan, wherein the asset data stored in the document file is generated by a second party to the commercial mortgage loan, wherein the first party and the second party are distinct, and wherein at least one of the preexisting asset data generated by the first party and the asset data comprised by the document file generated by the second party reflects a physical inspection of a property covered by the issued commercial mortgage loan;

inventory the document file into an associated record in the database on a near real time basis as the asset data in the document file becomes available for inventorying, including collecting asset data from the document file independently of an end use of the document file;

when the asset data stored in the document file relates to preexisting asset data contained within the at least one record stored in the database, compare the asset data stored in the document file to the preexisting asset data contained in the at least one record;

generate a data mismatch alert when the asset data stored in the document file does not match the preexisting asset data contained in the at least one record;

provide the data mismatch alert to a user of the apparatus via a user interface;

analyze the asset data stored in the document file in near real time as the asset data become available to determine compliance with at least one preprogrammed banking rule for securitizing multiple financial instruments;

generate a banking rule alert when the contents of the document file do not comply with the at least one preprogrammed banking rule for securitizing multiple financial instruments;

provide the banking rule alert to the user of the apparatus via the user interface; and

provide specific output data from the at least one record in the database to a user on demand, wherein the output data includes asset data related to the multiple assets pertaining to a securitization of the multiple assets.

9. The apparatus of claim 8, wherein the stored instructions, when executed by the processor, further cause the processor to:

request specific information contained in the document file;

locate a record associated with the document file;

retrieve the record; and

extract the specific information contained in the record.

10. The apparatus of claim 8, wherein the stored instructions, when executed by the processor, further cause the processor to generate the banking standard alert in real time as the document file is transmitted in to the database.

11. An apparatus, comprising:

a computer readable memory storage;

the computer readable memory storage including stored computer executable instructions that, when executed by a processor, cause the processor to;

receive in at least one document file comprising asset data stored therein in preparation for securitization of multiple assets, wherein at least one of the multiple assets comprises an issued commercial mortgage loan, wherein the commercial mortgage loan is ready for securitization;

transmit the document file into the database on a near real time basis as the asset data stored in the document file becomes available for entry into the database;

receive preexisting asset data generated by a first party to the commercial mortgage loan, wherein the asset data stored in the document file is generated by a second party to the commercial mortgage loan, wherein the first party and the second party are distinct, and wherein at least one of the preexisting asset data generated by the first party and the asset data comprised by the document file generated by the second party reflects a physical inspection of a property covered by the issued commercial mortgage loan;

inventory the document file into an associated record in the database on a near real time basis as the asset data in the document file becomes available for inventorying, including collecting asset data from the document file independently of an end use of the document file;

when the asset data stored in the document file relates to preexisting asset data contained within the at least one record stored in the database, compare the asset data stored in the document file to the preexisting asset data contained in the at least one record;

generate a data mismatch alert when the asset data stored in the document file does not match the preexisting asset data contained in the at least one record;

provide the data mismatch alert to a user of the apparatus via a user interface;

analyze the asset data stored in the document file in near real time as the asset data become available to determine compliance with at least one preprogrammed banking rule for securitizing multiple financial instruments;

generate a banking rule alert when the contents of the document file do not comply with the at least one preprogrammed banking rule for securitizing multiple financial instruments;

provide the banking rule alert to the user of the apparatus via the user interface; and

provide specific output data from the at least one record in the database to a user on demand, wherein the output data includes asset data related to the multiple assets pertaining to a securitization of the multiple assets.

12. The apparatus of claim 11, wherein the stored instructions, when executed by a processor, further cause the processor to:

request specific information contained in the document file;

locate a record associated with the document file;

retrieve the record; and

extract the specific information contained in the record.

13. The apparatus of claim 11, wherein the stored instructions, when executed by a processor, further cause the processor to generate the banking standard alert in real time as the document file is transmitted in to the database.