SYSTEM AND METHOD FOR AGGREGATING MORTGAGE AND SALES DATA FOR GENERATING, ASSESSING AND QUALIFYING MORTGAGE LEADS
The invention relates to mortgage and sales data assessment and more specifically to a system and method for aggregating mortgage and sales data for generating, assessing, and qualifying mortgage leads. The method for generating a table of mortgage leads comprising storing a plurality of mortgage leads in a database wherein each mortgage lead of the plurality of mortgage leads has a plurality of data of a plurality of data types including a data of a first data type, storing the relationships between the plurality of data of the plurality of data types in a fact table, selecting the first data type to organize the plurality of mortgage leads, and generating a table of mortgage leads wherein the plurality of mortgage leads are organized by the data of the first data type using the fact table.
1 . A method for generating a table of mortgage leads comprising:
storing a plurality of mortgage leads in a database, each mortgage lead of the plurality of mortgage leads having a plurality of data of a plurality of data types including a data of a first data type;
storing the relationships between the plurality of data of the plurality of data types in a fact table;
selecting the first data type to organize the plurality of mortgage leads; and
generating a table of mortgage leads wherein the plurality of mortgage leads are organized by the data of the first data type using the fact table.
2 . The method of claim 1 further comprising selecting a second data type to organize the plurality of mortgage leads.
3 . The method of claim 2 further comprising generating a table of mortgage leads wherein the mortgage leads are organized by the data of the first data type and the data of the second data type using the fact table.
4 . The method of claim 1 wherein the plurality of data types is a plurality of dimensions and the plurality of data is a plurality of measures.
5 . The method of claim 4 wherein the plurality of dimensions are selected from a group consisting of a Geography, Combined Loan Amount, Combined LTV, Equity Amount, Equity Type, Ethnicity, Fares Landuse, Interest Rates, Junior Presence, Lender Name, Loan Amounts, Loan Type, Mortgage Date, Mortgage Date Month, Mortgage History Count, Mortgage Position, Mortgage Term, Owner Relation, Owner Occupied, Private Mortgage Indicator, Rate Type, Sales Date, Search Type, SubPrime Indicator, Trust Position, Valid Mail, Valid Phone, VP4 Value, Loan Purpose, Parceled, Purchase Refinance Indicator, Total Measure, and combinations thereof.
6 . The method of claim 1 wherein the fact table is an index of the plurality of data types and an index of the plurality of data.
7 . A method for generating a list of qualified mortgage leads comprising:
storing a plurality of mortgage leads in a database wherein each mortgage lead of the plurality of mortgage leads has a plurality of data of a plurality of data types including a data of a first data type;
storing the relationships between the plurality of data of the plurality of data types in a fact table;
receiving a first qualifying data of the first data type; and
generating a table of mortgage leads wherein the mortgage leads have data of the first data type that match the first qualifying data of the first data type using the fact table.
8 . The method of claim 7 further comprising receiving a first qualifying data of a second data type.
9 . The method of claim 8 further comprising generating a table of mortgage leads wherein the mortgage leads have data of the first data type that match the first qualifying data of the first data type and data of the second data type that match the first qualifying data of the second data type using the fact table.
10 . The method of claim 7 wherein the plurality of data types is a plurality of dimensions and the plurality of data is a plurality of measures.
11 . The method of claim 10 wherein the plurality of dimensions are selected from a group consisting of a Geography, Combined Loan Amount, Combined LTV, Equity Amount, Equity Type, Ethnicity, Fares Landuse, Interest Rates, Junior Presence, Lender Name, Loan Amounts, Loan Type, Mortgage Date, Mortgage Date Month, Mortgage History Count, Mortgage Position, Mortgage Term, Owner Relation, Owner Occupied, Private Mortgage Indicator, Rate Type, Sales Date, Search Type, SubPrime Indicator, Trust Position, Valid Mail, Valid Phone, VP4 Value, Loan Purpose, Parceled, Purchase Refinance Indicator, Total Measure, and combinations thereof.
12 . The method of claim 7 wherein the fact table is an index of the plurality of data types and an index of the plurality of data.
13 . The method of claim 7 wherein the fact table keeps track of the relationships between each of the plurality of data types.
14 . A method for qualifying a mortgage lead comprising:
storing a plurality of mortgage leads in a database wherein each mortgage lead of the plurality of mortgage leads has a plurality of data of a plurality of data types including a data of a first data type;
storing the relationships between the plurality of data of the plurality of data types in a fact table;
selecting a mortgage lead from the plurality of mortgage leads;
receiving a qualifying data of the first data type; and
qualifying the selected mortgage lead based on whether the data of the first data type of the selected mortgage lead matches the qualifying data of the first data type using the fact table.
15 . The method of claim 14 further comprising receiving a qualifying data of the second data type.
16 . The method of claim 15 further comprising qualifying the selected mortgage lead based on whether the data of the first data type of the selected mortgage lead matches the qualifying data of the first data type and whether a data of the second data type of the selected mortgage lead matches the qualifying data of the second data type.
17 . The method of claim 14 wherein the plurality of data types is a plurality of dimensions and the plurality of data is a plurality of measures.
18 . The method of claim 17 wherein the plurality of dimensions are selected from a group consisting of a Geography, Combined Loan Amount, Combined LTV, Equity Amount, Equity Type, Ethnicity, Fares Landuse, Interest Rates, Junior Presence, Lender Name, Loan Amounts, Loan Type, Mortgage Date, Mortgage Date Month, Mortgage History Count, Mortgage Position, Mortgage Term, Owner Relation, Owner Occupied, Private Mortgage Indicator, Rate Type, Sales Date, Search Type, SubPrime Indicator, Trust Position, Valid Mail, Valid Phone, VP4 Value, Loan Purpose, Parceled, Purchase Refinance Indicator, Total Measure, and combinations thereof.
19 . The method of claim 14 wherein the fact table is an index of the plurality of data types and an index of the plurality of data.
20 . The method of claim 14 wherein the fact table keeps track of the relationships between each of the plurality of data types.