One number, intelligent call processing system
View Patent ↗Systems and methods for retrieving household data based on an origination identifier. In an embodiment, an origination identifier of a communication is captured. The origination identifier is indexed into a master table comprising a plurality of records. Each of the records comprises an association between an origination identifier and a universal database linkage key, and each universal database linkage key comprises an index into one or more databases. A universal database linkage key associated with the captured origination identifier is retrieved and indexed into one or more databases. Household data associated with the captured origination identifier is retrieved from the one or more databases and communicated to at least one recipient.
1. A method of retrieving household data based on an origination identifier, the method comprising, by one or more hardware processors:
capturing an origination identifier of a communication from a customer;
indexing the captured origination identifier into a master table comprising a plurality of records, each record comprising an association between an origination identifier and a universal database linkage key, wherein each universal database linkage key comprises an index into one or more databases;
retrieving a first universal database linkage key associated with the captured origination identifier from the master table;
indexing the first universal database linkage key into the one or more databases;
retrieving household data associated with the captured origination identifier from the one or more databases; and
communicating the retrieved household data to at least one recipient.
2. The method of claim 1 , wherein each universal database linkage key comprises a single index into two or more databases.
3. The method of claim 2 , wherein one of the two or more databases is remote from one or more of the other two or more databases.
4. The method of claim 2 , wherein the single index of each universal database linkage key is generated from a common trait shared by the two or more databases.
5. The method of claim 4 , wherein the common trait is a geographic definition.
6. The method of claim 1 , further comprising validating the captured origination identifier.
7. The method of claim 1 , wherein the retrieved household data comprises a customer name associated with the captured origination identifier.
8. The method of claim 1 , wherein the retrieved household data comprises geographical information associated with the captured origination identifier.
9. The method of claim 1 , further comprising providing an informational item to the at least one recipient, wherein the informational item is one or more of:
information related to one or more service locations associated with the retrieved household data;
an address certified by a United States Postal Service (USPS) coding accuracy support system (CASS) and associated with the retrieved household data;
latitude and longitude associated with the retrieved household data;
property information associated with the retrieved household data; and
product announcements and promotions.
10. The method of claim 1 , wherein the origination identifier comprises an e-mail address.
11. The method of claim 1 , wherein the origination identifier comprises an Internet address.
12. A system for retrieving household data based on a origination identifier of a communication, the system comprising:
one or more hardware processors;
a master table comprising a plurality of records, each record comprising an association between an origination identifier and a universal database linkage key, wherein each universal database linkage key comprises an index into one or more databases; and
one or more modules that, when executed by the one or more hardware processors,
capture an origination identifier,
index the captured origination identifier into the master table,
retrieve a first universal database linkage key associated with the captured origination identifier from the master table,
index the first universal database linkage key into the one or more databases,
retrieve household data associated with the captured origination identifier from the one or more databases, and
communicate the retrieved household data to at least one recipient.
13. The system of claim 12 , wherein each universal database linkage key comprises a single index into two or more databases.
14. The system of claim 13 , wherein one of the two or more databases is remote from one or more of the other two or more databases.
15. The system of claim 13 , wherein the single index of each universal database linkage key is generated from a common trait shared by the two or more databases.
16. The system of claim 15 , wherein the common trait is a geographic definition.
17. The system of claim 12 , wherein the one or more modules further validate the captured origination identifier.
18. The system of claim 12 , wherein the retrieved household data comprises a customer name associated with the captured origination identifier.
19. The system of claim 12 , wherein the retrieved household data comprises geographical information associated with the captured origination identifier.
20. The system of claim 12 , wherein the one or more modules further provide an informational item to the at least one recipient, wherein the informational item is one or more of:
information related to one or more service locations associated with the retrieved household data;
an address certified by a United States Postal Service (USPS) coding accuracy support system (CASS) and associated with the retrieved household data;
latitude and longitude associated with the retrieved household data;
property information associated with the retrieved household data; and
product announcements and promotions.
21. The system of claim 12 , wherein the origination identifier comprises an e-mail address.
22. The system of claim 12 , wherein the origination identifier comprises an Internet address.