1. Field of the Invention
This invention relates to financial transaction notification systems and methods, generally. Particularly, this invention relates to systems and methods for collecting, monitoring, and comparing data to customer requests.
2. Description of Related Art
Prior to the current invention, available event notification systems included, for example, local desktop notification systems, such as e-mail alerts or instant messaging alerts which alert a user through a visual or audio signal that a new e-mail or instant message has arrived and is available for retrieval within the users local computer network. These alerts merely indicate that a message is available for viewing, the alerts do not provide the substance of the message.
Other event notification systems alert a user via, for example, an e-mail message, of the availability of certain information, solicited or unsolicited, on the Internet or World Wide Web through a specified Web site or universal resource locator (“URL”). An unsolicited notification includes, for example, the availability of an electronic greeting card (e.g., www.bluemountain.com). A solicited notification provides notification of the availability of information that was specifically requested by the user. For example, at www.realtor.com, a registered user can request notification of homes for sale according to pre-defined user parameters, e.g., location, price, number of bedrooms. When homes meeting the registered user's parameters are listed on the www.realtor.com Web site, the Web site sends an e-mail to the registered user indicating that there are homes available for sale fitting the user's parameters and providing the link to the Web site in the e-mail. These types of notification systems are limited to one method of notification, e-mail. Further, the notification system is not linked to any other type of user information, such as user financial information, e.g., bank accounts, credit accounts, investment accounts, that is constantly variable due to the actions of the user, i.e., the actions of the user do not result in a triggering of the alert.
Finally, there are notification systems available wherein a user's local computer is equipped with a data filter that receives and searches incoming data messages, e.g., e-mail messages, intended for the user, for predetermined event information. When the data filter identifies the predetermined event information, a local event indicator, e.g., audio and/or visual, is presented through the user's local computer indicating that a previously specified event has occurred. The user then has a specified amount of time, e.g., 10 seconds, to acknowledge the local event indicator by, for example, clicking on the provided visual alert, e.g., icon. If the user does not acknowledge the local event indicator within the specified amount of time, the user's computer establishes a connection with a server in order to remotely notify the user of the event through a notification method of the user's choice, such as, pager, telephone, or personal digital assistant (“PDA”). This notification system is limited to searching and retrieving local event information from user-intended messages, e.g., Web pages pushed to a users e-mail address. Further, the local events, though pre-defined and requested, are not triggered by user actions, such as financial transactions.
Consequently, there is a need in the art for a notification system that is directly linked to the actions of the user, in addition to the pre-defined parameters selected by the user, wherein such a system collects data independent of any electronic address of the user, i.e., information searched for the requested alert is not limited to messages directed to the user. Further, there is a need for a notification system wherein the requested alerts are triggered based on the values of private customer-specific financial information, such as bank account, credit card, or brokerage portfolio information.
Further still, there is a need for a notification system to provide notification to customers of possible fraudulent activity related to their account(s). There is also a need for a notification system to provide additional security for higher risk online transactions, by sending a specialized code, e.g., a transaction code, to a customer in a timely manner, that must be entered into the online system to complete the transaction.
Various embodiments of the present invention comprise a standalone notification system, including a notification server which generates electronic messages to registered customers upon their request or upon a host business request. A customer provides the system with his/her messaging identification (“ID”), e.g. e-mail address, GSM (global system for mobile communications) or other mobile phone numbers that are able to accept, e.g., short message service (“SMS”) messages, facsimile number, and/or telephone number. Customers can register with the host notification server without having any relationship, banking or otherwise, with the host. Customers can choose between different notification channels such as e-mail, SMS message, fax or pager.
Further embodiments of the present invention comprise a notification system, which allows host personnel, such as customer service representatives (“CSR”), to create and maintain customer requests on behalf of a customer.
The design of the notification system is geared toward scalability and performance. The notification system ensures a scalable architecture by using a stateless Web site and distributed architecture. The use of a stateless Web site results in increased available memory.
a) and 6(b) are schematic views of a Web page according to an embodiment of the present invention;
The notification system embodied by the present invention is capable of multiple avenues of access to and from multiple parties. Further, the notification system utilizes multiple databases which are fed information via the multiple parties and/or via other servers and/or back office host systems, such as readable files which are updated by running an appropriate executable program.
In an embodiment of the present invention, all live financial information comes from one or more host computers operated by the host financial institution. The information provided by these hosts is presented to the databases and the alert message generators included in the notification system in the form of a “host handoff file” (See
In at least one embodiment of the present invention, a preferred medium for facilitating all of the customer configuration interactions described below is a public access network, such as the Internet or World Wide Web, due to such a network's far-reaching, efficient and expeditious characteristics for data transmission and presentment. A particularly effective method of displaying and generating data and information is through the use of Web sites and/or Web pages. While the specific schema illustrated in the tables printed below provide the necessary format for collecting and synthesizing data within the databases themselves, the requests for data which are made to or by the customers or CSRs are made through a more user-friendly and recognizable format such as a graphical user interface (“GUI”).
In at least one embodiment of the present invention, multiple Web sites are provided to facilitate data collection and presentation. The following, which are in no way intended to be limiting, represent Web sites and Web pages used in a preferred embodiment of the present invention: non-member customer (“NMC”) preference site; member customer (“MC”) preference site (e.g., CITIDIRECT® customer preference sub applications (“MiniApps”) and Transaction executors); CSR preference site; product information, rates and host messages maintenance site; notification reports site; system maintenance site; and database access security site.
In an embodiment of the present invention wherein a sponsoring financial institution or host (hereafter “host”) maintains the notification system, the host establishes a central Web site (e.g., homepage) as an advertising and explanatory mechanism as well as the conduit through which MCs, NMCs, and CSRs are able to access their respective login Web pages. The format of the Web sites and Web pages may be HTML, XML, or the like. Depending on which type of customer is attempting to gain access, the customer selects the appropriate link, which links them to a login Web page. Once presented with the selected Web page, the user may be further prompted to select between a “first-time user” and a “repeat user” login link. The difference between these two login links being the amount of information which needs to be entered prior to granting the user access to the preference sites.
Referring to
Web sites 12, 14 and 110 feed information, directly and indirectly, to a number of sources. The Web sites 12 and 14 are sources of configuration information related to the specific configuration parameters for each customer (both member and non-member users). The Web site 110 feeds additional configuration information into the system. This Web site is only useable by host employees, and provides configuration information about the nature of the notifications; the text of the notifications; the manner of notification (email, SMS, etc.); and similar system wide configuration information. As discussed below, the invention also contemplates accessing external sources of information. One or more back office host processors 18 provide host handoff files to a host handoff files database 16 which include information that feeds into the customer preference database 24, the alert message text database 26, and the rates and information database 30; and which, in some cases, are processed directly by the alert message generators 32. The information provided by MCs and NMCs to Web sites 12 and 14 is fed into a database containing customer preferences 24. The information provided by the host's maintenance personnel to Web site 110 is fed into the same database containing customer preferences 24, as well as the alert message text database 26 and, potentially, the rates and information database 30. The host-handoff files 16 are fed to all of these databases. Finally, in an embodiment of the present invention, the system uses externally generated data from external sources 28. These externally generated sources include Internet based sources, contracted sources via private lines or any other available sources. They feed information into the rates and information database 30. The rates database contains information including, for example, interest rates and fees on loans and credit cards, interest rates on deposit accounts, foreign exchange rates, etc. The information database contains information including, for example, product information, corporate news, new products or services, etc.
Given the three databases, customer preference 24, alert message 26, and rates and information 30; as well as the information in the host handoff files database 16, alert message generators 32 access the information therein, to form a rates and information alert message generator 34 and a host alert message generator 36. These alert message generators 32, generate the messages requested by the customers, which are stored in an alert message text database 26 prior to being sent to a customer selected alert message gateway 40. As discussed below, these gateways may include but are not limited to e-mail 42, HTML (hypertext mark-up language) 44, pager 46, CSR call 48, mobile phone text messaging, e.g., Global System for Mobile Communications Service (“GSM”) 50, and XML (extensible mark-up language) 52, facsimile 54, and short message service (“SMS”) 54. Through these alert message gateways 40, requested information is transmitted to the customer 58.
In embodiments of the present invention, multiple servers may be grouped according to the particular databases into which they are feeding data and information. While not explicitly depicted in the Figures, these servers or feeders are executables that are run through, for example, the system maintenance site, in order to continually update the databases within the notification system. For example, a customer profile server and a rates server both update the customer preference database 24. Similarly, the same rates server and a host handoff server update the host handoff files database 16. While not explicitly depicted in the Figures, the customer profile, rates, and host handoff servers are executables that are launched, for example, through the system maintenance server/site 110. By way of example, prompted by the system maintenance server/site 110, in a specific embodiment of the present invention, the servers read selected information from the up-to-date host handoff files, format the selected information according to a command program and update the aforementioned databases, respectively. Further in this specific embodiment, the customer profile server's functionality is to keep up to date customer profile and customer relationship data. As will be discussed further later in this disclosure, the customer profile server updates only host customer records, such that only MC and not NMC notification set-ups are affected by this server. The host handoff and rate servers functionalities are to import host generated events and to keep the rate related information up to date, respectively.
The alert message generators 32 contemplated by at least one embodiment of the present invention include, a rates and information alert message generator 34 and a host alert message generator 36. Message generators are designed to analyze the customer's preferences against current rates, product information and host handoff data and create entries within the alert message text database 26.
The rates and information message generator(s) 34 is an executable which has direct access to the customer preference database 24, to rates and information database 30 and to alert message text database 26 through database access security server. These executables populate the alert message text database 26 with notification requests based on customer preference specification and rates and info content. Each request record indicates the customers preferred notification channel i.e., alert message gateway. The message generators create the actual message phrases taking into consideration the type of transaction they are reporting on.
The host alert message generator(s) 36 is an executable which has direct access to the customer preference database 24, to host handoff files database 16 and to alert message text database 26 through the database access security server. These executables populate the alert message text database 26 with notification requests based on customer preference specification and host handoff results. Each request record indicates the customer's preferred notification channel. The message generators create the actual message phrases taking into consideration the type of transaction they are reporting on. The alert message gateways 40 are executables which extract the content from the alert message text database 26 based on the customer's preferred notification channel and forward them to the corresponding gateway. Forwarded messages are moved from a “work” table to an “audit” table within the same database. Specific alert message gateway agents will be written for each notification channel such as the FAX or the SMTP (simple mail transfer protocol) mail. In preferred embodiments of the present invention, a web-based product information, rates and host messages maintenance site is provided to update individual rates records, information records, host product records, and to report on statistical usage of the product database. This site is also used to enter the specific response messages sent to the customer for each event.
In preferred embodiments of the present invention, a web-based reports server/site 100 is used to generate MIS (management information system) and marketing reports on the customer preference database 24 and alert message text database 26. The web-based system maintenance server site 110 is used to backup, archive, restore and report on statistical usage of all databases within the notification system 10. This system maintenance server/site 110, in addition to the configuration operations discussed above, is also used to launch and control different server executables and different alert message generators 32. Finally, a web-based database access security server/site 120 is used to control access to databases and servers within the notification system 10. This database access security server/site 120 gives a requesting server the proper database connection string, database login ID, and PASSWORD. The database access security server/site 120 has administrator privileges over all the databases. This server/site 120 solves the problem of hard coding the database login IDs into the operating system registry.
Referring to
Again, referring to
Further alternative embodiments require that the MC pay a host-determined fee depending on various factors, such as the number of notification requests, the type of notification requests, and/or the MC's current financial relationship with the host. In a particular alternate embodiment, the host requires a minimum cumulative balance of, for example, $10,000.00, including all of the MC's accounts with the host in order to avoid paying a fee for the notification service. In the case where the MC's balance is less than $10,000.00, the host charges the MC a flat monthly fee for using the notification service. These charges are assessed to, for example, the MC's credit card, wherein the MC provides credit card information during the registration process (
Referring to
Referring to
In an embodiment where a NMC enters the initial Web site 12, the NMC selects link 13 which, referring to
Alternatively, referring to
In a further alternative embodiment, the host provides the NMC with the same alerts that are provided to the MC. In this alternative embodiment, the host uses either pre-established lines of communication, such as ATM lines, credit authorization lines, settlement lines (e.g., Automated Clearing House) and/or specifically negotiated and established lines of communication, in order to obtain the NMC's financial information from the NMC's financial institution. Referring to
As with the MCs and the NMCs login, the CSRs are also able to access the notification system through the Web site 12. A CSR selects the CSR login link 15 on Web site 12. CSR login link 15 links the CSR to login Web page 71, wherein the CSR is prompted to enter identification information, such as CSR Name 73 and CSR NUMBER 75, as shown in
Referring to
By way of example, in
If in response to (S2) the customer selects the MC icon, the MC is linked to the MC login Web page (S8). The MC login Web page queries the MC as to whether or not this is their first login attempt (S9). If this is the MCs first login attempt, the MC selects the appropriate icon, is linked to the first-time login Web page, and provides the requisite information (S10). Assuming the MC has logged in at some previous time, the MC selects the repeat customer icon and enters the appropriate ID Name and PASSWORD (S11). After logging in, the MC is directed to the MC preference site (e.g., CITIDIRECT® site) where the MC is prompted to select message and notification information (S12).
Within both the NMC preference site 80 and the MC preference site 70, respectively, the customers are prompted to choose and provide information relating to a message they would like to receive and also to select the notification alert message gateway 40 through which they would like to be alerted of the message (S13). This information is saved by the notification system 10 within the host-handoff files 16, (S14). The host-handoff files 16 are accessed by multiple servers (see
The notification system 10 described above is capable of alerting customers in multiple transaction areas. In embodiments of the present invention, MCs enjoy a wider range of possible notification scenarios, due to their financial relationship with the host. For example, MCs may be alerted as to account balances, CD maturation, credit card payment being due, a check has bounced, foreign or domestic exchange has hit a target price, foreign exchange rates, domestic interest rates, etc. Either the MC or a CSR would enter the appropriate preference cite and proceed to enter the request. In an alternative embodiment, if the MC has a broker relationship with the host, an embodiment of the present invention contemplates a multiple alert scenario, wherein, for example, the MC requests notification when a particular stock hits a specified value. This is the first alert. The MC further instructs the host broker at the time of establishing the first alert, to buy X shares of the stock, using funds from a specified account, when the stock value reaches this specified value. The host broker sends a second alert notifying the MC that the transaction has been completed. Alternatively, after sending the first alert, instead if purchasing the stock automatically, the host broker is instructed by the MC to wait for a reply message from the MC prior to purchasing the stock. Although more restricted in the types of alerts that they may receive in certain embodiments, NMCs may still be alerted regarding for example, interest rates and stock prices.
In various embodiments of the present invention all of the customers of the notification system 10 create their own login IDs and PASSWORDS through a web application interface in order to access the notification system 10 via the Internet. Customer login IDs and PASSWORDS are subject to creation business rules and are checked for uniqueness. The web application login IDs are independent of any host ID such as host account numbers, or CINs in the case of MCs. The PASSWORDS are kept in encrypted format. In the case of NMCs, the ID and PASSWORD may only grant them limited access to the notification system 10. In alternative embodiments, the MCs may have access to other levels or databases within the notification system due to their membership status. In order to access these databases, in addition to their self-created IDs and PASSWORDS, MCs are prompted to enter additional identifying information such as, account numbers or CINs.
In various preferred embodiments of the present invention, once the customers have created IDs and PASSWORDS, the notification system 10 offers multiple avenues for alerting or notifying the customers of financial opportunities to which they might wish to avail themselves. Referred to herein as alert message gateways 40, these include but are not limited to electronic mail (“E-mail”) 42, mobile phone text messaging, e.g., Global System for Mobile Communications Service (“GSM”) 50, facsimile (“Fax”) 54, extensible mark-up language (“XML”) 52, hypertext mark-up language (“HTML”) 44, pager service 46, and short message service (“SMS”) 56. Additionally, personal contact methods may also be chosen, such as person-to-person calls with CSRs 48. In the event that a particular notification gateway 40 is not specifically selected, an embodiment of the present invention provides a default notification gateway, for example, the customer's e-mail address. In this embodiment, the e-mail address of the customer would be a required field that must be completed prior to enrollment into the notification system.
In various embodiments of the present invention, customers access the notification system 10 for any of a variety of reasons. Customers may choose to access the notification system 10 in order to add new or updated information to one or more of the available databases. In particular, customers may wish to choose or change their preferences for when and how they wish to be notified of transaction opportunities. Further, customer's may wish to check a log or report of the most recent notifications that they have received. For example, an embodiment of the present invention allows customers to check a report containing the last X (X=1, 2, 3 . . . n) notifications of which the customer was alerted via their chosen notification gateway 40. Further as discussed with reference to
Embodiments of the present invention allow host personnel or CSRs to access the notification system 10, in addition to customers accessing the notification system. CSRs, including host telephone operators, are able to create or update customer records through, for example, a web application interface. These additions or updates may be added in response to a customer call, either after the call or simultaneous therewith. In an alternative embodiment, the CSR accesses the notification system 10 to enter customer record information that has been collected from other off-line sources, such as from customer paperwork that has been completed by the customer for host service enrollment, e.g. opening new accounts, applying for loans, etc. As previously discussed, the CSR's also have IDs and PASSWORDS to ensure the security of the customer records. Further, the embodiments of the present invention contemplate that the CSR web application interface be only available to CSRs.
In addition to adding or updating customer records directly into the Web site, an alternative embodiment enables the CSRs to access particular feeder databases or servers which are not part of the immediate Web site databases/servers and enter data thereto for later addition to the Web site databases/servers. In this embodiment, the files from the off-site databases or servers (hereafter “feeder servers”) are fed into the Web site databases/servers in response to an established execution program. These feeder servers are as numerous as is necessary in order to efficiently and accurately supply customer and other relevant information to the Web site databases/servers. The possible configurations are too numerous to mention but one skilled in the art will recognize the many variations which flow from the following embodiments.
The alert message text database 26 contains the notification requests based on the specified customer preferences. In addition to the substantive requests (e.g., notify me when each share of Microsoft® is $150) each request record stored in the alert message text database 26 indicates the customer's preferred notification channel (e.g., page me with the notification at the following number (zzz-zzz-zzzz). This database utilizes information gathered through the customer preference databases 24. The formatted requests held in the alert message text database 26 are accessed and searched during the running of the execution program (e.g., CITIALERT™ software program), using information from the host handoff files as well as the rate and information databases. If an alert condition has been satisfied based on the up-to-date information, the alert message text database 26 initiates the procedure for notifying the customer that the request has been met. The following tables represent various schema followed for accessing and utilizing information from the alert message text database 26.
The feeder servers, as well as the Web site databases/servers may be separated, depending on design parameters and the type of notification scenarios envisioned, into various types of categories. For example, the Web site databases/servers might include as shown in
In an embodiment of the present invention, the customer preference database 24 contains information about the customer, customer preference information, CSR information, notification method information, rates and information data, including prompt and response data, and display group information. Each type of information is represented in schema tables, such as those printed and described further with reference thereto below. The particular schema tables set forth below are merely exemplary and may include more or less information as determined by one skilled in the art for the type of notification system that is envisioned.
Referring to the system of
The actual fraud alert is sent in response to an event occurring on an MC's account which, in the view of the host, should be brought to the MC's attention even though the MC may not have specifically requested notification. Events of this nature include such things as the detection of potential fraud activity on an account, execution of high value transactions and/or wire transfer transactions; addition of new payees; etc. This list is merely exemplary of potentially fraudulent activities and is not intended to be limiting. The list may include any event that is deemed suspicious or worthy of immediate MC notification.
In a particular embodiment, the potentially fraudulent activity varies depending on the history of account activity. For example, for a first MC who maintains a few thousand dollars in an account and consistently executes transactions generally in amounts less than, say, $1,000, the notification system may flag transaction requests in excess of $2,000 as being suspicious, i.e., for this first MC, a “high value” transaction is anything over $2,000. For a second MC who maintains a much higher account balance and periodically executes transactions greater than $1,000, the notification system would not flag a transaction in excess of $2,000, but may instead only flag transactions in excess of $10,000 for this second MC. Alternatively, a first MC who has a history of using a specific transaction system, i.e., always uses interactive voice response (IVR), to conduct transactions may be alerted when one or more transactions are attempted or executed using an on-line transaction system. Further, the suspicious activity changes with the MCs history of use, e.g., as an MC acquires or loses wealth, the “high value” amount that will result in an alert will change as well.
Utilizing the real-time data gathering and alert capabilities of the notification system 10 as described herein, MCs who have some alert gateway information available to the notification system 10 may be alerted quickly of potentially fraudulent activity. In the case where the notification system 10 is unable to determine any alert message gateway for the MC, the notification system may send a message to this effect to the host at which point the host may request such information from the MC via, for example, United States mail. In a specific embodiment of the present invention, the MC may specifically request alerts for transactions requested or executed for amounts over a certain amount. In this case, the MC selects the amount. Similarly, the MC may request an alert if any transactions are attempted using a specific transaction system.
In a particular embodiment, the notification system 10 includes a database, e.g., Alert Message Text Database 26, containing a list of parameters which are indicative of potentially fraudulent activity. The notification system compares these parameters to the details of incoming account information and if the parameters are met, the notification system attempts to send an alert to the MC associated with the affected account. Alternatively, the host may perform the parameter comparison earlier in the process and provide the alert information to the Alert Message Text Database 26 or directly to the Alert Message Generators 32, e.g., as a Host Handoff File from the Host Handoff File Database 16, for formatting and sending to the MC.
In another exemplary embodiment of the present invention, the notification system 10 of
In this exemplary embodiment, when a MC attempts to execute such a high risk transaction, the notification system 10 described herein may be used to send a notification to the customer through a selected or available alert message gateway which includes a uniquely generated alphanumeric secure transaction code. The secure transaction code is unique to the high-risk transaction in progress. In order to complete the high-risk transaction, the secure transaction code provided to the user through the notification system 10 must then be entered into the transaction system within a certain period of time, e.g., on the order of minutes, in order for the transaction to proceed. Entering the secure transaction code could mean typing it into a field provided through a webpage as part of an online system, speaking the code to the customer service representative or in response to IVR prompt or keying the code into a telephone system using an alphanumeric keypad. In a particular embodiment, the secure transaction code is generated by the host and provide to the notification system 10 through the Host Handoff Files Database 16 and in turn to either the Alert Message Text Database 26 and Alert Message Generators 32 or directly to the Alert Message Generators 32. In the case where the notification system 10 is unable to determine any alert message gateway for the MC, the notification system may send a message to this effect to the host at which point the host may request preferred alert message gateway information from the MC.
In certain embodiments of the present invention, the customer preference database 24 contains multiple data tables for storing and correctly logging in required data into the requisite datafields. In these certain embodiments, the customer preference database 24 is accessed and information is entered thereto by multiple entities, for multiple purposes. The following tables provide exemplary data schema formats for data storage within the customer preference database 24.
Referring to TABLE 1, the exemplary “Customer from Customer Preferences Database” table includes, for example, an unique customer identifier used internally by the host, customer name, contact information (e.g., phone/fax number(s), e-mail address, GSM or other mobile phone text messaging numbers), CSR ID, customer type/host affiliation (e.g., MC or NMC), password(s), and login ID. The customer preference database retains all passwords, including customer passwords, in encrypted format. TABLE 1 contains a default notification method data field which ranks a customer's preference for notification methods, e.g., e-mail first, GSM second, facsimile third, in addition to data fields containing: the date for the last time a modification was made to a particular customer's notification record; an activation flag for indicating whether a message is to be sent for a particular notification subscription or not e.g., messages resulting from a particular notification subscription are held in queue; and an authentication cookie generated each time a customer retrieves their record to be updated.
Referring to TABLE 2, the exemplary “Customer Request from Customer Preferences Database” table includes: customer ID (described above); identification of the processor type, e.g., rates and information or host type; reference ID, e.g., the alert to which the customer has subscribed which is dependent upon processor type; threshold flag; threshold value; notification method; notification limit; last notification date; and CIN for MCs, e.g., used to access MC information from host database. Customer requests are separated through this table according to the whether the customer's request requires that the internal host databases be accessed to fulfill the request, e.g., for various MC requests involving an MC's account(s) with the host, or requires that external databases be accessed to fulfill the request. This table includes a threshold flag data field for indicating whether a particular updated value is the same, greater, or lesser than a customer indicated threshold value (e.g., interest rates, stock quotes). The notification limit data field holds an indicator for how often or how many times a customer chooses to be notified of the same alert, e.g., no limit, no alert, a specified number.
Referring to TABLE 3, the exemplary “Customer Service Representative from Customer Preferences Database” table includes CSR ID which is an internally generated identifier unique to each CSR, name, phone number, e-mail, and a CSR manager's ID, which is the identifier for the CSR's manager.
Referring to TABLE 4, the exemplary “Notification Methods from Customer Preferences Database” table includes the data fields for the type of notification methods that are available and the specifications for the text that appears for the heading of each notification method.
Referring to TABLE 5, the exemplary “Rates and Information Prompts from Customer Preferences Database” table includes data fields for: an unique internal identifier for a particular rates and information prompt; a display group identifier; the display order; rates and information types; prompt text; CSR notification; activation flag; start date; expiration date; current rate; last update date; and automatic feed identifier.
The display group identifier identifies the particular group of prompts to which this particular prompt belongs. Exemplary display groups include, for example, auto loans, Certificate of Deposit (“CD”) rates, mortgage rates, stock quotes, credit card rates, etc. The display order data field determines the order in which a particular prompt appears on the customer's notification screen. The rates and information type data field reflects whether the prompt is directed toward product information only or product information with the associated rates. For example, product information only is a list of available mortgage loans such as 30-year fixed, 30-year variable, 15-year fixed, and 15-year variable, while product information with associated rates would include the types of mortgage loans plus the current interest rates for each. The prompt data field dictates the format, e.g., length, type of the notification textual phrase. The CSR notification data field dictates whether or not the customer chooses to have a CSR be copied on an alert. CSR notification may be desirable, for example, where the customer desires that he be notified of alerts by a CSR directly. The start, expiration, and last update date data fields indicate the date on which the notification system should begin generating appropriate alert messages, the date after which the system will no longer generate alert messages, and the date on which the current rate and info prompt record was updated, respectfully. The current rate data field contains the current rate, e.g., interest rate, against which a customer's threshold rate is compared. Finally, the auto feed identifier data field is used by the feeder applications (discussed above) to identify matching records during the process of importing rates and information from sources.
Referring to TABLE 6, the exemplary “Rates and Information Responses from Customer Preference Database” table includes data fields for: an unique internal identifier for a particular rates and information response; the corresponding unique internal identifier for the particular rates and information prompt; notification method; subject; response detail; and activation flag.
The “Rates and Information Responses from Customer Preference Database” details the corresponding response information for the “Rates and Information Prompts from Customer Preference Database.” Consequently, the responses are assigned an identifier that is linked to the prompt identifier representing the prompt to which it is responding. The subject data field dictates the textual phrase that appears in the response message heading, e.g., such as the subject line in a standard e-mail message. The response detail data field dictates the textual phrase that appears in the body of the response message, e.g., such as the body of a standard e-mail message.
Referring to TABLE 7, the exemplary “Display Groups from Customer Preference Database” table includes data fields for: a display group identifier; heading; source database;
and the display order. The source database indicates the database which stores the display groups, e.g., the customer preference database.
In an embodiment of the present invention, the rates and information database 30 contains promotional content such as current rates and upcoming specials. This database keeps generic notification options available to all customers. This database can also be used to broadcast critical messages to selected customers. For example, if a customer has indicated a specific price at which the customer wishes to purchase a specified amount of stock or has requested notification in the event of a particular amount of variation in a foreign exchange rate, the rates and information database contains this type of information.
In an embodiment of the present invention, the alert message text database 26 is used to keep the content of the text of the alert messages (provided by the host handoff files database 16) in an efficient format. Only the latest handoff file content is retained in the alert message text database 26.
Referring to TABLE 8, the exemplary “Host Information Prompts from Alert Message Text Database” table includes data fields for: an unique internal identifier for a particular host information prompt; a display group identifier; the display order; prompt text; CSR notification; activation flag; start date; expiration date; message code; last update date; and automatic feed identifier.
The majority of the data fields from TABLE 8 are described with reference to at least TABLE 5. Additionally, the message code is an action code that is set by the host and represents the host-identified event which the customer has selected for alert purposes. This message code is used by the alert message generator to map host event records to host information prompt records.
Referring to TABLE 9, the exemplary “Host Information Responses from Alert Message Text Database” table includes data fields for: an unique internal identifier for a particular rates and information response; the corresponding unique internal identifier for the particular rates and information prompt; notification method; subject; response detail; and activation flag. The description of these data fields is found with reference to TABLE 6.
Referring to TABLE 10, the exemplary “Host Event From Alert Message Text Database” table includes data fields for: an unique identifier for identifying a host event; account number; product type code; sub product code; currency code; CIN; message code; current value; as of date; last update date; and notes.
In addition to previously defined data fields, further data fields defined through TABLE 10 include identifiers for identifying a customer through the customer's relationship with the host. For example, account number, product type, sub product type, and currency code represent four (4) data fields that link a customer to the host. In a particular exemplary embodiment, a customer has a checking account, e.g., account number, with the host as well as a car loan, e.g., product type, wherein the car loan is a 5 year loan at an 8.0% fixed interest rate, e.g., sub product type, calculated in U.S. dollars, e.g., currency. The notes and as of date data fields are for information which is only merged with the response detail or the message text when messages are sent to the customers. For example, the notes data field is used to send account specific information such as current balance.
Referring to TABLE 11, the exemplary “Display Groups from Alert Message Text Database” table includes data fields for: a display group identifier; heading; source database; and the display order. The source database indicates the database which stores the display groups, e.g., the host handoff database.
Referring to TABLE 12, the exemplary “Alert Messages from Alert Message Text Database” table includes data fields for: an alert message identifier; customer ID; customer type; notification method; processor type; reference identifier; create date; sent date; subject; response detail; and CSR notification.
The alert messages are uniquely identified to the database through an identifier. In addition to previously defined data fields, in order to formulate specific alert messages the requesting customer is identified through a customer ID, the customers status as an MC or NMC is identified, the notification method is identified, the processor type is identified, and a reference ID is used to identify which alert the customer has selected. Further, the create and sent dates identify when the alert message was created and sent, respectively.
In certain embodiments of the present invention, the access database is used to give database access to all other applications within the notification system.
Referring to TABLE 13, the exemplary “Access from Access Database” table includes data fields for: an access ID; login ID; password; last changes date; connection string; and password change interval. The access database gives a requesting database/server with an appropriate access identifier, the proper database connection string, database login ID, and password for the database that is sought to be accessed. The table also tracks password changes through the last changes date data field and contains the value for the time intervals at which the password is required to be changed for security reasons through the password change interval data field.
In certain embodiments of the present invention, servers are either accessed or perform an accessing function in order to update one or more of the databases described above. In order to provide timely notifications to customers, it is necessary to ascertain and synthesize the most up to date information that is available. As was discussed previously, data may be collected from a variety of different sources and fed into a variety of different databases or files. The term “servers” is a generic term utilized to describe any and all sources of data and information which may be used to update the specific databases described above. These servers could be databases, servers, or direct data links, such as people, entering information in real-time or networks.
The tables and descriptions set forth herein are merely meant to be exemplary embodiments of the present invention and are not intended to be limiting. One skilled in the art recognizes the many variations and embodiments which fall within the scope of the invention.
The present application is a continuation and claims priority to U.S. application Ser. No. 11/395,162 filed Apr. 3, 2006 entitled, METHOD AND SYSTEM FOR NOTIFYING CUSTOMERS OF TRANSACTION OPPORTUNITIES, which is a continuation-in-part of and claims priority to U.S. application Ser. No. 09/832,863 filed Apr. 12, 2001 entitled, METHOD AND SYSTEM FOR NOTIFYING CUSTOMERS OF TRANSACTION OPPORTUNITIES, which in turn claims priority to U.S. Provisional Application Ser. No. 60/197,773 filed Apr. 14, 2000 entitled, “METHOD AND SYSTEM FOR NOTIFYING CUSTOMERS OF TRANSACTION OPPORTUNITIES,” all of which are incorporated herein by reference in their entireties.
Number | Date | Country | |
---|---|---|---|
60197773 | Apr 2000 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 11395162 | Apr 2006 | US |
Child | 13159038 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 09832863 | Apr 2001 | US |
Child | 11395162 | US |