| 3576539 | COUNTER CONTROLLER CREDIT VERIFICATION SYSTEM | Huber | 340/152 | |
| 3605092 | MAGNETIC INK CHARACTER RECOGNITION SYSTEM | Richard | 340/146.3 | |
| 3629829 | CHARACTER RECOGNITION CIRCUITRY | Ordower | 40/146.3 | |
| 3786421 | AUTOMATED DISPENSING SYSTEM | Wostl, et al. | 340/149 | |
| 3833885 | AUTOMATIC BANKING SYSTEM | Gentile et al. | 340/152 | |
| 3876981 | METHOD AND SYSTEM FOR COMBINING MAGNETICALLY AND OPTICALLY DERIVED SIGNALS TO RECOGNIZE CHARACTERS | Welch | 340/146.3 | |
| 3914789 | Manually operated magnetic card encoder | Coker, Jr., et al. | 360/2 | |
| 3941977 | Off-line cash dispenser and banking system | Voss et al. | 235/61.7 | |
| 3949363 | Bar-Code/MICR/OCR merge | Holm | 340/146.3D | |
| 3959624 | Coded merchandising coupon | Kaslow | 235/61.11E | |
| 3987411 | Character recognition system employing extraneous and required peak detection with variable threshold controlled timing | Kruklitis et al. | 340/146.3 | |
| 4015701 | Apparatus for driving a document through an encoder station | Templeton | 197/127 | |
| 4027142 | Automated processing of financial documents | Paup, et al. | 235/61.9 | |
| 4053735 | Assured-check computer-based bank credit disbursing system | Fondos | 235/61.9 | |
| 4053737 | Magnetic reader for bar encoded characters | Lafevers et al. | 235/61.11 | |
| 4063070 | Wideband frequency multiplier particularly adapted for use in badge readers and the like | Delarue et al. | 235/474 | |
| 4087789 | Magnetic ink character recognition system | Beery | 340/146.3 | |
| 4088879 | Credit card reader amplifier | Banka et a | 235/449 | |
| 4107653 | Document processing, magnetic character detecting apparatus | Kruklitis | 340/146.3 | |
| 4109238 | Apparatus for verifying checks presented for acceptance | Creekmore | 340/5.8 | |
| 4124109 | Dispensing apparatus and method | Bissell et al. | 194/4R | |
| 4127770 | Arrangement for synchronizing an information reading device with the speed of an information medium | Baader | 235/474 | |
| 4142235 | Electronic cash register | Tadakuma et al. | 705/24 | |
| 4143355 | Character recognition system | MacIntyre | 340/146.3 | |
| 4143356 | Character recognition apparatus | Nally | 340/146.3 | |
| 4148010 | Magnetic ink character reader system | Shiau | 340/146.3 | |
| 4176783 | Manually operable card reader including column sensor | Eppich | 235/474 | |
| 4201978 | Document processing system | Nally | 340/146.3D | |
| 4208575 | Credit card or check validator | Haltof | 235/380 | |
| 4245211 | MICR Waveform analyzer | Kao | 340/146.3 | |
| RE30579 | Check authorization system | Goldman et al. | 340/149R | |
| RE30580 | Check authorization system | Goldman et al. | 340/149R | |
| 4260880 | Optical character scanner | Thomas | 235/454 | |
| 4277689 | Document reader | Thomas et al. | 250/567 | |
| RE30821 | Customer service unit | Goldman et al. | 340/5.4 | |
| 4325117 | Apparatus for calculating a check digit for a stream of data read from a document | Parmet et al. | 707/519 | |
| 4332325 | Bottle package with promotional card insert | Manizza | 206/216 | |
| 4356472 | Character recognition system | Ku et al. | 340/146.3 | |
| 4380734 | Measuring magnetic intensity independent of speed in a succession of moving magnetic strips | Allerton | 324/225 | |
| 4381494 | Intercharacter gap detector for MICRS | Wisner | 382/64 | |
| 4396902 | OCR/Variable head slot reader | Warthan et al. | 382/320 | |
| 4399553 | Character reader | Toyama | 382/7 | |
| 4404649 | Document processing system | Nunley et al. | 364/900 | |
| 4425626 | Apparatus for translation of character codes for application to a data processing system | Parmet et al. | 235/449 | |
| 4439670 | Method and device for the checking of the number of access attempts to an electronic store, notably that of an integrated circuit of an object such as a credit card or a buyer's card | Basset et al. | 235/382 | |
| 4441204 | Apparatus for recognition of stylized characters | Hanna | 382/7 | |
| 4453074 | Protection system for intelligent cards | Weinstein | 235/380 | |
| 4510615 | Magnetic character reader with double document detection | Rohrer | 382/7 | |
| 4523330 | Banking system and method | Cain | 382/140 | |
| 4547780 | Printer with manual paper feed and weigh scale incorporating the same | Cummins | 346/9 | |
| 4547899 | Waveform matching system and method | Nally et al. | 382/7 | |
| 4554446 | Supermarket inventory control system and method | Murphy et al. | 235/487 | |
| 4595997 | Queue symbol field recovery flags for defining boundaries of one or more fields of a document read by a reader sorter | Parmet et al. | 707/500 | |
| 4617457 | Teller-assisted, customer-operated ATM document cashing system | Granzow et al. | 235/379 | |
| 4628194 | Method and apparatus for currency validation | Dobbins et al. | 235/379 | |
| 4670853 | Coupon computer and method for handling coupons | Stepien | 364/70 | |
| 4672377 | Check authorization system | Murphy et al. | 340/5.4 | |
| 4672572 | Protector system for computer access and use | Alsberg | 364/900 | |
| 4673802 | System for making payments for transactions | Ohmae et al. | 235/379 | |
| 4674041 | Method and apparatus for controlling the distribution of coupons | Lemon et al. | 364/401 | |
| 4676343 | Self-service distribution system | Humble et al. | 186/61 | |
| 4678895 | System for making payments for transactions | Tateisi et al. | 235/379 | |
| 4703423 | Apparatus and method for generation of brand name specific advertising media | Bado et al. | 364/400 | |
| 4722054 | Input system for POS terminal | Yorozu et al. | 364/401 | |
| 4723212 | Method and apparatus for dispensing discount coupons | Mindrum et al. | 705/14 | |
| 4727243 | Financial transaction system | Savar | 235/379 | |
| 4748668 | Method, apparatus and article for identification and signature | Shamir et al. | 380/30 | |
| 4748673 | Reader for reading magneto-optical characters, with the options of printing them or storing them | Barre et al. | 382/7 | |
| 4750119 | Purchasing system with rebate feature | Cohen et al. | 364/401 | |
| 4776021 | Speed compensation scheme for reading MICR data | Ho | 382/7 | |
| 4791281 | Encoding and decoding system | Johnsen et al. | 235/383 | |
| 4797938 | Method of identifying magnetic ink (MICR) characters | Will | 382/7 | |
| 4799156 | Interactive market management system | Savit et al. | 364/401 | |
| 4809351 | Optical character reader | Abramovitz et al. | 382/59 | |
| 4810866 | Check validation/check writing system | Lord, Jr. | 235/379 | |
| 4812628 | Transaction system with off-line risk assessment | Boston et al. | 235/380 | |
| 4821186 | Bar code reading electronic cash register having an automatic discount function | Munakata et al. | 364/405 | |
| 4825045 | System and method for checkout counter product promotion | Humble | 235/383 | |
| 4833308 | Checkout counter product promotion system and method | Humble | 235/383 | |
| 4872113 | Credit check scanner data analysis system | Dinerstein | 705/10 | |
| 4882675 | Paperless system for distributing, redeeming and clearing merchandise coupons | Nichtberger et al. | 364/401 | |
| 4885685 | Investment management system with travel usage funds indexed to customer account status | Wolfberg et al. | 364/401 | |
| 4887207 | Automated system for evaluating the sensitivity of inventory costs due to fluctuations in customer demand | Natarajan | 364/401 | |
| 4891503 | Distributed authorization system | Jewell | 235/380 | |
| 4897880 | Data acquisition control method and system for a hand held reader | Wiber et al. | 382/13 | |
| 4908761 | System for identifying heavy product purchasers who regularly use manufacturers' purchase incentives and predicting consumer promotional behavior response patterns | Tai | 364/401 | |
| 4910672 | Method and apparatus for dispensing discount coupons | Off et al. | 364/405 | |
| 4933536 | Check processing device | Lindemann et al. | 235/375 | |
| 4941090 | Centralized consumer cash value accumulation system for multiple merchants | McCarthy | 364/405 | |
| 4947321 | MICR rejects analysis and management information system | Spence et al. | 705/43 | |
| 4949256 | Coupon validation network with storage of customer coupon data for credit on future purchases | Humble | 364/401 | |
| 4972504 | Marketing research system and method for obtaining retail data on a real time basis | Daniel, Jr. et al. | 455/2 | |
| 4975841 | Method and apparatus for reporting customer data | Kehnemyi et al. | 364/401 | |
| 4982346 | Mall promotion network apparatus and method | Girouard et al. | 364/550 | |
| 5008518 | Data gathering system interface | Taussig et al. | 235/383 | |
| 5010485 | Apparatus, system and method for creating credit vouchers usable at point of purchase stations | Bigari | 364/408 | |
| 5014324 | MICR character reader using magnetic peaks to update timing clocks | Mazumder | 382/7 | |
| 5025372 | System and method for administration of incentive award program through use of credit | Burton et al. | 364/406 | |
| 5040226 | Courtesy amount read and transaction balancing system | Elischer et al. | 382/7 | |
| 5053607 | Point-of-sale device particularly adapted for processing checks | Carlson et al. | 235/379 | |
| 5053955 | Process and apparatus for administering promotional mailings | Peach et al. | 364/401 | |
| 5054092 | Hand-operated low cost magnetic character recognition system | LaCaze | 382/11 | |
| 5056019 | Automated purchase reward accounting system and method | Schultz et al. | 364/405 | |
| 5070452 | Computerized medical insurance system including means to automatically update member eligibility files at pre-established intervals | Doyle, Jr. et al. | 364/401 | |
| 5077805 | Hybrid feature-based and template matching optical character recognition system | Tan | 382/7 | |
| 5091634 | Coupon validation terminal | Finch et al. | 235/375 | |
| 5095195 | Automated videocassette dispensing terminal with reservation feature | Harman et al. | 235/381 | |
| 5117355 | Centralized consumer cash valve accumulation system for multiple merchants | McCarthy | 364/405 | |
| 5128520 | Scanner with coupon validation | Rando et al. | 235/375 | |
| 5173851 | Method and apparatus for dispensing discount coupons in response to the purchase of one or more products | Off et al. | 364/401 | |
| 5179375 | Interconnection system for an electronic cash register | Dick et al. | 340/825.51 | |
| 5185695 | Method and system for handling discount coupons by using centrally stored manufacturer coupons in place of paper coupons | Pruchnicki | 364/401 | |
| 5201010 | Method and system for building a database and performing marketing based upon prior shopping history | Deaton et al. | 382/7 | |
| 5202826 | Centralized consumer cash value accumulation system for multiple merchants | McCarthy | 364/405 | |
| 5237496 | Inventory control method and system | Kagami et al. | 364/401 | |
| 5245164 | Transaction processing apparatus | Oyama | 235/379 | |
| 5245533 | Marketing research method and system for management of manufacturer's discount coupon offers | Marshall | 364/401 | |
| 5249044 | Product information storage, display, and coupon dispensing system | Von Kohorn | 358/86 | |
| 5251152 | Storage and display of historical LAN traffic statistics | Notess | 364/550 | |
| 5253345 | Point of sale register system | Fernandes et al. | 395/275 | |
| 5256863 | In-store universal control system | Ferguson et al. | 152/541 | |
| 5310997 | Automated order and delivery system | Roach et al. | 235/375 | |
| 5353218 | Focused coupon system | De Lapa et al. | 705/14 | |
| 5621812 | Method and system for building a database for use with selective incentive marketing in response to customer shopping histories | Deaton et al. | 382/100 | |
| 5644723 | Method and system for selective incentive point-of-sale marketing in response to customer shopping histories | Deaton et al. | 705/14 | |
| 5832457 | Method and apparatus for selective distribution of discount coupons based on prior customer behavior | O'Brien et al. | 705/14 |
| EP8603310 | ||||
| EP9103789 | ||||
| GB2094532 | ||||
| JP5216941 | ||||
| JP5547560 | ||||
| JP5627468 | ||||
| JP5815547 | ||||
| JP5817847 | ||||
| JP5994166 | ||||
| JP5918496 |
This application is a continuation of U.S. application Ser. No. 08/178,052, filed Jan. 4,1994, now U.S. Pat. No. 5,644,723 pending; which is a continuation of U.S. application Ser. No. 08/096,921, filed Jul. 23, 1993, abandoned; which is a continuation-in-part of U.S. application Ser. No. 08/063,413, filed May 17, 1993, now U.S. Pat. No. 5,512,812; issued Apr. 15, 1997; which is a continuation of U.S. application Ser. No. 07/886,383, filed May 19, 1992, now abandoned; which is a continuation-in-part of U.S. application Ser. No. 07/826,255, filed Jan. 24, 1992, now abandoned, which is a continuation of U.S. application Ser. No. 07/345,475, filed May 1, 1989, now abandoned.
This application also relates to U.S. application Ser. No. 08/117,951, filed Aug. 30, 1993, abandoned; U.S. application Ser. No. 08/302,521, filed Sep. 6, 1994, now U.S. Pat. No. 5,675,662 issued Oct. 7, 1997; U.S. application Ser. No. 08/178,056, filed Feb. 28, 1994 now U.S. Pat. No. 5,638,457 issued Jun. 10, 1997; U.S. application Ser. No. 07/885,649, filed May 19, 1992, now U.S. Pat. No. 5,237,620, issued Aug. 17, 1993; U.S. application Ser. No. 07/886,383, filed May 19, 1992, now U.S. Pat. No. 5,305,196, issued Apr. 19, 1994; U.S. application Ser. No. 08/221,622, filed Mar. 30, 1994, now U.S. Pat. No. 5,448,471, issued Sep. 5, 1995; U.S. application Ser. No. 07/886,385, filed May 19, 1992, now U.S. Pat. No. 5,201,0101, issued Apr. 6, 1993; U.S. application Ser. No. 08/016,991, filed Feb. 10, 1993, now U.S. Pat. No. 5,327,508, issued Jul. 5, 1994; U.S. application Ser. No. 08/177,690, filed Jan. 1, 1994, now U.S. Pat. No. 5,388,165, issued Feb. 7, 1995; U.S. application Ser. No. 08/303,631, filed Sep. 8, 1994, now U.S. Pat. No. 5,592,560, issued Jan. 7, 1997; U.S. application Ser. No. 08/336,880, filed Nov. 9, 1994, now U.S. Pat. No. 5,430,644, issued Jul. 4, 1995; U.S. application Ser. No. 08/429,938, filed Jun. 3, 1995, pending; U.S. application Ser. No. 08/701,456, filed Aug. 22, 1996, pending, U.S. application Ser. No. 08/457,300, filed Jun. 1, 1995, pending; U.S. application Ser. No. 08/458,172, filed Jun. 1, 1995, pending; and U.S. application Ser. No. 08/457,299, filed Jun. 1, 1995, pending, by the present inventors and are assigned to Credit Verification Corporation, the assignee hereunder.
This invention relates to transaction processing and analysis methods and systems, including check, credit card and debit card verification and marketing systems, and more particularly, to a method and system for processing and developing a customer database of customer information, such as credit verification status and transaction frequency and dollar volume over specified intervals, that can be used for credit verification, targeted customer marketing and other customer relations purposes.
Retail and other business establishments that serve a large number of customers generally have a problem obtaining transactional information about their customers, such as for identifying new customers and determining transactional patterns for repeat customers (such as transactional frequency and dollar volume).
For those stores that experience a high volume of transactions, an immediate customer information problem is determining whether to authorize a transaction, whether check, debit card or credit card, in the typical situation where the sales clerk does not personally know the purchaser. Beyond this immediate problem of credit verification, these stores have a broader need for gathering transactional information that could be used in developing customer profiles useful in targeting and implementing advertising, marketing and promotions.
For example, a typical grocery store does a high transactional volume with checks comprising a significant percentage of the total transactions (typically as much as 85%). These businesses strive for maximum efficiency in completing transactions at the checkout counter, which results in a minimum of contact between the customer and the sales clerk. In this sales environment, neither clerks nor store managers typically develop any significant personal relationship with an individual customer.
Since check transactions account for such a significant percentage of a grocery store's business, these stores naturally make an effort to minimize the number of bad checks that will be returned. Typically, the store will require an additional piece of identification, such as a driver's license and/or a major credit card. However, this requirement for additional identification reduces the efficiency of the checkout process, and inconveniences the significant majority of check transaction customers who do not write bad checks—typically, a grocery store's bad check experience will be approximately 2% of its check transactions.
Thus, check verification presents a store with problems in customer relations and risk management. A store naturally seeks to improve customer relations with the great majority of customers who do not present check transaction problems by efficiently and quickly authorizing check transactions. However, the store must guard against the financial risks from customers who do write bad checks, either as part of a concerted bad check scheme or as a result of less larcenous conduct that may range from simple bookkeeping mistakes to overly aggressive check floating. In the former case, bad check risk is greatly dependent upon abnormal check transaction activity over a given interval. In the latter cases, the bad check risk is greatly dependent upon check transaction history (total check transaction frequency and dollar volume at a store).
The check transaction risk management problem has two principal aspects—the risk that a person will write a bad check and the risk that a bad check cannot be recovered. Again, both of these risk factors are greatly dependent upon a customer's historical check transaction activity. As the total number of check transactions by a customer at a particular store increases, both the risk that the customer will write a bad check decreases, and more significantly, the risk that store will not be able to recover on a bad check decreases.
For example, a customer with fewer than 200-300 check transactions at a store presents a relatively high risk in terms of recovery on a bad check, while a customer with more than 600-700 check transactions presents a minimal risk. Thus, a store practicing risk management should put substantially more restrictions in terms of check transaction frequency and total dollar volume over given intervals in the former case than in the latter.
These risk management problems are multiplied in the case of multiple store businesses, particularly in the case of concerted bad check cashing schemes. In that case, the typical pattern is to move from store to store within a relatively short period of time. Such credit risks are also present with other forms of financial instruments, such as credit cards, or debit cards unless credit verification procedures are in place.
Beyond these check and credit verification and risk management problems, grocery and other retail stores have a broader problem in accumulating customer information because of the emphasis on minimizing the amount of time required for a sales transaction, and the attendant impersonality of the customer relationship. Thus, it is extremely difficult to develop any meaningful customer profiles, or to identify customer groups such as regular customers and new customers who might become regular customers. If a store could accumulate more detailed customer information, customer profiles could be developed and used for targeted advertising, marketing and promotional programs.
Accordingly, a need exists for a transaction processing system for individual stores (in both single and multiple store environments) that facilitates transactions by improving the efficiency of the verification process, and that maintains a local customer database containing transactional information about the store's customers useful for verification risk management, and for other customer relations purposes such as identifying new customers and profiling regular customers.
Prior credit verification systems require connecting a point-of-sale terminal through telephone lines to a remote transaction processing system, thereby increasing not only the cost of operating the systems, but also increasing the time for providing check or credit verification. Also, existing systems typically do not focus on maintaining a local customer database useful not only for check or credit or debit card transaction processing, but also for identifying new customers and developing customer profiles for regular customers.
In prior systems, information regarding checks returned to a store by its bank is entered into a computer (PC). This PC stores information on that check (name, address, dollar amount of the check, reason for the return of the check, etc.) and this PC can be programmed to transfer that data to other processors controlling point-of-sale keypad terminals, both in the same and in other store-based operations. Responses displayed by one of these point-of-sale terminals may be altered pursuant to these transfers of data. Alternatively, data on returned checks may be entered into a multiple tasking computer environment in which the same processor simultaneously manages the operations of returned check entry and point-of-sale keypad operation. This multiple tasking processor can be programmed to transfer data to other similar store-based operations by telephone communications.
Copending patent application Ser. No. 07/826,255 discloses a system and technique wherein a customer's checking account number may be used as a unique customer identification number to provide credit verification and also to perform marketing functions. In such a prior system, such customer checking account numbers have been manually entered by the retail store clerk, thus causing delay and possible inaccuracies. A need has thus arisen for an automated system for providing quick and efficient check verification and marketing follow-up. Previous automatic readers have, however, not been satisfactory for such purposes, because of their inability to uniformly detect desired account information on all checks in a consistent manner.
Marketing by retail stores has previously been confined to advertising to large segments of the population, and often to existing customers. Competition among stores has made it more important to target advertising, and a need has arisen for marketing techniques to target non-customers or infrequent customers. It would be particularly advantageous if such targeted marketing could be accomplished in conjunction with a check or credit verification system.
Retail stores have heretofore attempted to provide marketing to its customers by the issuing of cards bearing individual numbers associated with a customer (which may or may not be smart cards) which contain information which may be automatically detected by a reader. Before a customer can obtain such a card, the customer has to fill out a substantial amount of information, such information is being entered into the system prior to the card being issued. Stores, however, have found that it is difficult to get a large segment of its customers to provide such information and customers also do not wish to or forget to use such cards at the checkout terminal. Hence, use of such cards for marketing purposes has not been particularly successful.
For example, when such cards are used, another form of financial payment has to be implemented into the system, such as by accepting cash, verifying and accepting a check or verifying and accepting a credit or debit card or the like. Use of such shopping cards thus creates additional delays at the terminals and has not been found to enable stores to reach high-target individuals such as the infrequent shopper, since such people are unlikely to have or to utilize such cards. Moreover, prior stores which have used such shopping cards have tried marketing such as direct mail to an untargeted group of customers or for immediate discounts on current transactions. The providing of such rewards without requiring some future activity by the customer has not been found to provide good marketing results by inducing the customer to do some act in the future.
A need has thus arisen for a method and system utilizable by retail stores to provide targeted incentive marketing to customers by utilizing account codes on such financial instruments as a check, credit card or debit card, without the combination of a marketing card. It would be further advantageous for such a method and system to be able to utilize a multiplicity of transaction documents in order to identify individual customers to enable such targeted marketing. It would further be desirable to provide such targeted marketing in combination with credit verification.
Important aspects of the present invention are to facilitate transactions by reducing the requirements for customer identification, to enable a store to adopt a risk management approach to credit verification based on a customer's transactional history (frequency and dollar volume over specified intervals), and to improve a store's marketing and other customer relations programs by collecting transactional data for that store, both current and historical, that can be used to identify new or infrequent customers, develop customer profiles and to perform targeted marketing.
More specifically, this invention is a transaction processing system that uses a customer's financial instrument account number (check, credit card, debit card or the like) as a unique customer identification number. Thus, the system does not require time-consuming checking of additional customer identification, but only requires the speedy entry of the customer's account number by use of an improved automatic reader in accordance with the present invention. The system operates at an individual store, and maintains at that store a local customer database of customer records, each identified by the corresponding customer identification number. The customer records also include customer information, such as verification data (such as verification status) as well as other selected transactional data (such as transaction frequency and dollar volume), the verification and transaction data being regularly updated with new data (such as during transaction verification).
The system includes one or more transaction terminals, coupled to a transaction processor that stores the customer database. A transaction terminal is used to transmit a customer information request (such as for check or credit card transaction verification), which includes an automatically read customer's identification number, from the point-of-sale (POS) to the transaction processor.
The transaction processor processes the customer information request, using the identification number to search the customer database and retrieve the corresponding customer record, if any. Based on the customer information in the customer record, or the lack of a customer record, the transaction processor returns an appropriate response (such as credit verification status) and marketing response information to the transaction terminal.
Thus, the method of this invention for transaction processing involves various aspects of: (a) identifying a customer by automatically reading the customer's unique ID; (b) developing and maintaining for a store a local customer database of customer records, each identified by the corresponding customer identification number, and each including customer information (such as verification status and transactional data); (c) generating a customer information request; (d) processing the request using the customer identification number to access the corresponding customer record, if any; (e) returning an appropriate customer information response based on the customer information in the customer record; (f) updating the customer database regularly to reflect new customer information; and (g) utilizing the database to perform targeted marketing functions based upon the customer's prior shopping history.
More specific aspects of the preferred embodiment of the invention are the following:
One form of the transaction terminals and the transaction processor form a token ring data communication network, although other types of networks are possible. Each transaction terminal includes (a) an automatic reader constructed in accordance with the present invention for automatically entering identification numbers, along with a keypad for entering function codes and appropriate transaction data, which form customer information requests, and (b) a display for displaying the requests and the returned responses.
The customer records in the customer database include an assigned check verification status, such as POSITIVE (transaction authorized), NEGATIVE (transaction not authorized) or CAUTION (transaction should be scrutinized or subject to certain conditions). The first time a customer attempts a check transaction at a store (i.e., a search of the customer database pursuant to a check verification request indicates no existing customer record), a new customer record with a CAUTION status is created, and a CAUTION response is returned to the transaction terminal. The customer remains in the CAUTION status for a period of time sufficient for this initial check to clear or be returned. If this CAUTION/POSITIVE interval passes, the system automatically updates status to POSITIVE; if the check is returned, customer status is updated by inputting a NEGATIVE status.
In addition to, or in place of, check verification status data, the local customer database may include credit or debit card data and transactional data such as transaction frequency and dollar volume over specified intervals. This transactional data can be used to place conditions risk management on transaction verification over and above verification status. For example, in the case of a customer with either CAUTION or POSITIVE status, if a transaction exceeds certain specified transaction limits frequency and/or dollar amount over a specified interval (such as day, week or total), a CALL MANAGER response is returned in response to a verification request, regardless of customer status.
Moreover, because the transactional data is generated and maintained locally, it provides significant information about the store's customers over and above the information necessary for verification risk management. New customers are readily identified, and prior shopping history such as frequency and dollar volume information may be used to establish customer profiles and to target advertising, marketing and promotional programs, and for other customer relations purposes.
In the case of a multiple store business, each store has a local transaction processing system, with one of the systems being designated a host site and the rest being designated remote sites. At selected intervals, each remote system transmits to the host selected customer information from its local customer database (such as customer records for those customers with CAUTION and NEGATIVE status including transactional data), which is used to update the host customer database to include this global customer information. The host, in turn, transmits that global customer information to the other remote systems.
Transaction processing is implemented by a multi-tasking program executing in the transaction processor. The program includes: (a) a terminal manager task that implements network data communication for the transaction terminals, communicating customer information requests and responses; (b) a Data Manager Task that controls the database operations necessary to respond to customer information requests and to update the customer information in the database; and (c) an Event Manager Task that implements system activities such as backup and database purge, and in the case of multiple-store systems, implements host/remote communications activities to transfer selected customer information among the stores for updating each store's local customer database with the selected global customer information.
Important features and advantages of this invention are the following. The transaction processing system uses the automatic reading of the customer's identification number, which is used as a unique customer identification number, thus avoiding the requirement for additional identification and the attendant delay in completing the transaction.
The system develops and maintains a local customer database, allowing the store to accumulate customer information relevant to the store's customers over and above that information necessary for credit verification. The system provides for the selection of procedures and criteria for database management and credit verification, allowing the store owner/manager considerable flexibility in developing and using the customer information in the store's customer database.
For check verification, the system uses three primary status levels—POSITIVE, NEGATIVE and CAUTION—allowing the store to identify those customers with a bad check outstanding, and to identify new customers and establish selected interim risk management procedures for granting those customers check transaction privileges. In addition to check verification status, the system collects and accumulates selected additional transactional data, including frequency and dollar amounts over specified intervals (such as Day/Week/Month/Quarter/Total) and other historical information such as departments shopped, products purchased and the like, thus allowing the store to adopt risk management approach to check verification tailored to the store's particular customer and financial situation by conditioning check authorization on meeting certain selected transactional limits regardless of customer status (the CALL MANAGER response), and allowing the store to develop customer profiles and to target advertising, marketing and promotions, and otherwise improve customer relations.
For multiple-store businesses, the system can use automatic host/remote transfer of selected customer information to upgrade the local customer database at each store with global customer information (such as those customers with CAUTION and NEGATIVE check verification status), thereby maximizing protection against bad checks while maintaining the local character of the store's customer database.
The transaction processing system is implemented by a multi-tasking program, and uses local area network data communication among the transaction terminals and the transaction processor, allowing efficient operation of the system at each individual store.
The system and method of the invention also provides automatic targeting of individual customers based upon their shopping history. Thus, at the point-of-sale, coupons or other incentives may be generated which are specifically targeted to a specific customer based upon his prior history. Alternatively, coupons may be later mailed to selected customer. For example, substantial rewards may be given to an infrequent shopper, while less substantial rewards may be given to a more frequent shopper. A marketing program may be implemented whereby a customer is sequentially induced to purchase additional volume or additional products based upon the customer's prior history. Based upon that customer's prior history, the types of incentive coupons can be varied by the system. Further, the redemption and efficiency of the coupons are subsequently monitored, and subsequent coupons are varied in dependency upon the monitoring. All of these and many other marketing techniques described herein are able to be accomplished in coordination with a check verification or credit authorization system without requiring additional customer identification codes.
Other objects, features and advantages of this invention will be apparent from the drawings and the following detailed description of the preferred embodiment, and the appended claims.
For a more complete understanding of the present invention, and the advantages thereof, reference is now made to the following descriptions taken in conjunction with the accompanying drawings, in which:
A first embodiment of the present invention and its advantages are best understood by referring to FIGS.
The check transaction processing system of the present invention enables a store with a significant volume of check transactions to accumulate and process transactional customer information for check verification and customer profiles for target marketing. The system operates at the store using a local database of customer information useful in that store's business.
A customer's bank checking account number provides a unique identification for that customer—using this check ID, a customer record is created and included in the local customer database. The customer record includes an assigned customer verification status, as well as selected transactional data. Customer status designations include POSITIVE, NEGATIVE and CAUTION, while transactional data includes transaction frequency and dollar volume over given intervals (such as Day/Week/Total or DWT). Selected transactional (CALL MANAGER) limits are assigned to both CAUTION and POSITIVE status. This customer information (customer status and transactional data) in the customer database is continuously updated (a) on a local basis through either processing check verification requests, or inputting customer status, and (b) in the case of a multiple store business, on a global basis through inter-store transfers of selected customer information (such as CAUTION and NEGATIVE status information).
The description of the first and second embodiment of the check transaction processing system is organized as follows:
1.0 Hardware Description
1.1. System Overview
1.2. Data Communications Network
1.3. POS Terminal
1.4. Multiple-Store Configuration
1.5. Exemplary Components
2.0 Functional Description
2.1. Database Structure
2.2. Function Codes
2.3. Verify/Query
2.4. Local Status Update
2.5. Global Update
2.6. Purge
2.7. Event/Activities
2.8. Communications
2.9. System
2.10. Risk Management
2.11. Customer Information Reporting
3.0 Program Description
3.1. General
3.2. System Kernal
3.3. Data Manager Task
3.4. Terminal Manager Task
3.5. Event Manager Task
3.6. Modem Manager Task
4.0 Alternative Embodiments
5.0 Targeted Marketing Features
5.1. Automatic Building Of A Database For A Retail Store Marketing Program
5.2. Targeted Marketing Program
5.3. Infrequent Shopper Database And Marketing Techniques
5.4. Marketing Based On Range Of Last Shopping Dates
5.5. Dissemination Of Point-Of-Sale Coupons And Direct Mail Coupons Based Upon Shopping History
5.6. Dissemination Of Point-Of-Sale Coupons And Direct Mail Coupons Based Upon Scanned Data
5.7. Second Alternate Embodiment Of Payment Processing And Point-Of-Sale Marketing System
The check transaction processing system is located at a store, and maintains a local customer database for that store. For a multiple store business, a local system is located at each store and global customer information transfers are used to supplement the essentially local customer database.
1.1. System Overview. As shown in
Transaction processor
Transaction terminals
For example, in the case of check verification, a transaction terminal is used to transmit a verification request—the customer's check ID, the verification function code, and the dollar amount. The transaction processor processes the request, updates the customer database to reflect that transaction, and returns a customer verification status response.
1.2. Data Communications Network. Data communications between transaction processor
Transaction processor
| POLL Token | An invitation for the terminal | |
| to transmit data | ||
| RXDATA Token | Includes data requested by the | |
| terminal | ||
In response to a POLL token, the transaction terminal transmits back one of two answers:
| TXDATA Answer | Includes data entered into the | |
| terminal | ||
| NODATA Answer | Indicates no data | |
During any given polling sequence, each transaction terminal is in one of three polling states that control the polling operation:
| Poll | Send a POLL token | |
| Wait | Do not send a token until | |
| requested data is available | ||
| Data | Send an RXDATA token that | |
| includes the requested data in | ||
| the terminal's buffer | ||
For example, in response to a POLL token, a transaction terminal may transmit a TXDATA Answer containing a check verification request. Once the request is transmitted, the terminal is placed in the Wait state until the verification response from the transaction processor is available. The response is placed in the terminal's buffer, and the terminal is placed in the Data state. The response is included in an RXDATA token sent to the terminal during the next polling sequence, and the terminal is placed in the Poll state ready to receive a POLL token in the next polling sequence.
For the preferred embodiment, network communications interface
1.3. POS Terminal. As shown in
For example, to initiate a check verification request, check reader
The MICR encoding of checks is known, and a detailed explanation of the MICR encoding scheme may be found in
The present automatic check reader is provided with structure which enables the customer checking account number and the bank transit number (which identifies the bank) to be detected within the code printed on the customer's check. This process involves detecting or parsing (the examination or analysis of a string of numbers or characters which is designed to detect or identify various subgroupings or sets within the string) followed by extraction of that set or sets which have been defined as the customer checking account number. The present automatic check reader is thus provided with circuitry which enables the customer's checking account number and the bank transit number to be parsed or detected and the remainder of the data extracted or omitted, such that the customer's checking account number and the bank transit number may be used as the unique customer identification code for the present invention. The present check reader thus provides substantial advantages over prior check readers which have not been useful for check verification or marketing techniques because it was not possible for such prior check readers to consistently detect customer account numbers on checks presented from different banks and bank branches.
Referring to
In operation, the read head
The detected customer account number and bank transit number are then subsequently used in the various programs and subroutines of the present invention to provide check verification and marketing techniques in accordance with the invention. As noted, the present automatic check reader differs from previously developed check readers in its ability to detect the location of the customer account number and to omit all other portions of the MICR code except for the desired account number and perhaps the transit number. In this way, the present automatic check reader may be used to process all checks from all banks and their branches, regardless of the location of the customer account number and regardless of which branch of a particular bank is being utilized or even in such situations where a branch is sold or transferred to another entity.
It can thus be seen that the sequence 179201476663 contains both the sequence number of the particular check, which in this particular instance is 1792, and also the customer's checking account number 01476663. As noted, it is very important in the present invention to automatically detect the customer's checking account number. It is common for many banks to provide symbology which separates the number of the particular check and the customer's account number. However, with many banks, as in the illustrated check of
An important aspect of the present invention is the ability of automatic check reader
It will be understood that the check number advances one unit each time a new check is written and therefore the data contained in the On Us field of the Mills County Bank would be continuously changing. Only by the check reader of the present invention having a stored knowledge of a particular location of the check number of the Mills County Bank would it be able to detect and omit or parse out the unwanted check number information.
The present check reader of the invention can determine the instances when the On Us field contains a space or suitable symbology separating the check number from the customer's account number, in addition to the scheme previously noted. In such cases, the check reader parses and omits the shortest number, which will be the check number. A particularly important aspect of the present invention is that the automatic check reader can read the MICR code of all banks and accurately pick out the customer's account number for utilization as a unique customer ID to perform the advantages of the invention.
Another important aspect of the invention, as will be described in greater detail in
The present automatic check reader
In addition, banks often have different types of accounts such as money markets, now accounts, commercial accounts, personal accounts and the like. So for a given bank transit number, there may be several non-obvious embedded locations for the particular next sequence number. For example, in the check shown in
Another important aspect of the invention is that the MICR parsing operation previously described and shown in
The important aspect of the invention is the ability to always recognize a customer's checking account number in a MICR line automatically, no matter which bank or which type of account is involved. With the ability to generate an extremely accurate indication of the customer's account number and the bank transit number, a unique customer identification code is provided which may be utilized to provide the many advantages of the invention to be subsequently described.
While the preferred customer identification code comprises the checking account number and the bank transit number, it should be understood that various aspects of the invention may be practical using different customer identification codes. For example, many of the marketing and verification techniques hereinafter described can be accomplished by the store clerk manually entering the name, address and/or phone number into the system through data terminal keypad
As shown in
(a) A Z8 microprocessor
(b) An associated address latch
(c) An EPROM
(d) An LCD (liquid crystal display) module
(e) A differential transceiver
The transaction terminal is coupled to the RS485 multi-drop network bus (
EPROM
EPROM
LCD module
From above, the display control program in EPROM
Microprocessor
Port
In addition to the four I/O ports, microprocessor
A clock circuit
Address latch
EPROM
LCD module
LCD module
A potentiometer
To read instructions from EPROM
To read display data from the display data register in LCD module
Once LCD module
In accordance with this mode control command, LCD module
Microprocessor
This procedure—select control/status, read status, select display data, read display data—is continued until all requested display data characters have been read. That is, microprocessor
The procedure by which microprocessor
Differential transceiver
While waiting for a token (either POLL or RXDATA) over the network bus, microprocessor
Keypad input is accomplished in a conventional manner using a 4×4 keypad matrix with column lines C
Keypad control functions, such as debouncing and N-key rollover are accomplished in a conventional manner using program routines of the keypad control program stored in EPROM
Power for the transaction terminal is provided by a voltage regulator
A transaction terminal is initialized as follows. At power on, voltage regulator
Microprocessor
1.4. Multiple-Store Configuration. As shown in
One store is designated as a “host” system, and the other stores are designated as “remote” systems. The host system coordinates the global exchange of check verification data and other customer information, but otherwise operates as a local system for that store in the same manner as the remote systems. Operation as a host does not affect concurrent local operation, i.e., host/remote status is transparent to the check transaction processing operation at each store.
Each store operates relatively autonomously in developing and maintaining its local customer database and providing check transaction processing. However, the stores are also able to globally exchange certain customer information useful to all of the stores, particularly for purposes of check verification. For example, while it is probably unnecessary from a credit standpoint for the stores to exchange information about customers who typically frequent only a single store and do not present check transaction problems, the stores will probably want to exchange information about customers who have written bad checks at one or more stores, or who are in a cautionary status as new customers. Moreover, the present system permits exchange of data between stores for marketing purposes. Such a global exchange of customer information reduces the likelihood that the business will experience a significant loss from a concerted bad check writer.
Each store's customer database is updated with both local and global customer information. Each local check transaction processing system
1.5. Exemplary Components. The detailed specifications for transaction processor
The detailed specification for point-of-sale transaction terminals
| Microprocessor 130 | Zilog Z8 (86C9112PSC) | |
| Address Latch 132 | 74HC373 | |
| EPROM 134 | 27C64 | |
| LCD Module 136 | Optrex DMC16207 | |
| 4 × 4 Keypad | Standard 4 × 4 matrix | |
| Diff. Transceiver | 75176 (R5485 compatible) | |
| Voltage Regulator | LM2925 | |
Alternative similar point-of-sale units are commercially available, such as from Omron Business Systems Model No. C.A.T. 90.
As diagrammed in
(a) Verification (with Transactional Update) and Query
(b) Local Status Update
(c) Global Update
(d) Event-driven activities
(e) Customer database purge
(f) Host/Remote communications as well as the customer database management operations necessary to support these functions. In addition, certain system information and diagnostic functions are performed.
The verification function involves sending a request for check transaction verification from a point-of-sale terminal
2.1. Database Structure. The customer database includes all customer information used and maintained by the check transaction processing system. The customer database comprises two separate files containing customer information: the customer file and the negative status file. In addition, a system control file contains transactional limits used during check verification and purge limits.
The customer file contains customer records that include the following customer information:
| Field | Description | |
| Check ID | Customer checking account number | |
| Verification Status | POSITIVE, NEGATIVE, CAUTION, | |
| CASH ONLY, or STOLEN | ||
| User Flags | User assigned flags that | |
| designate a customer as | ||
| PREAPPROVED for check | ||
| transactions regardless of any | ||
| transactional limits, or as | ||
| being authorized for check | ||
| transactions on a MANAGER ONLY | ||
| approval basis regardless of | ||
| actual status | ||
| Transfer Date/Time | Date/time the customer record | |
| was last accessed and updated | ||
| (written to disk), used in host/ | ||
| remote transfers for global | ||
| update (transfers from host to | ||
| remote generally do not affect | ||
| this date) | ||
| Access Date/Time | Last date/time the customer | |
| record was accessed and updated | ||
| (a query function does not | ||
| change the access date/time) | ||
| Status Change Date | Date/time customer status | |
| changed (e.g., CAUTION TO | ||
| POSITIVE) | ||
| DWT Frequency | Day/Week/Total values for | |
| transaction frequency (updated | ||
| transactionally during check | ||
| verification and globally | ||
| DWT $Amount | Day/Week/Total dollar amounts | |
| (updated transactionally during | ||
| check verification and globally | ||
| Previous Status | Customer's previous status (such | |
| as CAUTION prior to being rolled | ||
| POSITIVE) | ||
| Frequency Since Transfer | Total number of check | |
| transactions since the last | ||
| global transfer | ||
| $Amount Since Transfer | Total dollar amount volume since | |
| the last global transfer | ||
| Marketing Data | Purchases made of predetermined | |
| products, store departments and | ||
| the like | ||
The file specification for a customer record is set forth in Table 1 at the end of the specification.
The customer file is indexed by (a) check ID, and (b) status/transfer date/check ID.
The preferred intervals for maintaining frequency and dollar amount transactional data are Day/Week/Month/Total, where the day is the current 24-hour period, the week is the previous 7 days, the month is trailing 30 days, and the total is the total since the customer's first check transaction. The DWT designation will be used throughout this specification to indicate the three separate values for either Frequency or $Amount. Preferably, DWT Frequency and $Amounts are maintained on a global basis, so that for those records that have been globally updated (such as NEGATIVE and CAUTION status customer records), the DWT values will be global rather than local. Alternatively, separate local and global DWT transactional data can be maintained in the customer records, as shown in Table 2.
A customer can be assigned one of five check verification status designations:
| Status | Description | |
| CAUTION | The customer is a new customer, and a | |
| specified check clearance interval | ||
| since the customer's first check | ||
| transaction has not passed | ||
| NEGATIVE | The customer has one or more | |
| outstanding bad checks at any store | ||
| location | ||
| POSITIVE | The specified check clearance | |
| interval since the customer's first | ||
| check transaction has passed, and no | ||
| bad checks are outstanding at any | ||
| store location | ||
| CASH ONLY | The customer is not authorized to | |
| cash checks, even though no bad | ||
| checks are outstanding | ||
| STOLEN | The customer has reported stolen | |
| checks | ||
Customer status is assigned during customer record creation, and then updated (transactionally, locally or globally) to reflect changes in customer status, such as due to elapsed time between check transactions or bad check history.
In addition, the local update function can be used to assign to a customer either of the following user flag designations, which override normal status responses to check verification or status query requests:
| User Flag | Description | |
| PREAPPROVED | The customer has been preapproved for | |
| check transactions that may otherwise | ||
| exceed certain transactional limits | ||
| applied even to customers with | ||
| POSITIVE status | ||
| MANAGER ONLY | The customer is not authorized to | |
| cash checks without manager approval, | ||
| even though no bad checks are | ||
| outstanding | ||
In response to a check verification (or status query) request entered at a transaction terminal, the transaction processor returns a response with either customer status, or if specified transactional limits have been exceeded, a CALL MANAGER directive, unless the PREAPPROVED or MANAGER ONLY user flags in the customer's record have been set. Generally, a check transaction will be authorized if the customer has a POSITIVE status or is PREAPPROVED, will require manager approval for MANAGER ONLY regardless of status, and will be refused if customer status is NEGATIVE, CASH ONLY or STOLEN. Check authorization for customers with CAUTION status is a matter of store policy. For example, check authorization can depend upon DWT Frequency or $Amount, or the type of check transaction (such as amount of purchase only), or upon having the check transaction approved by a store manager.
The CALL MANAGER directive is not a verification status contained in a customer record, but rather, is the response to a verification request if, for any status (including POSITIVE), the current check transaction causes transactional limits specified in the system control file for DWT Frequency and $Amount to be exceeded.
The negative status file contains negative status records that include the following customer information (by location for multiple store systems):
| Field | Description | |
| Check ID | Customer checking account number | |
| Location | The location identification for the | |
| store (each store having a NEGATIVE | ||
| and/or CASH ONLY status history is | ||
| assigned a separate negative status | ||
| record) | ||
| NEGATIVE Status | Active - That location has a bad | |
| check outstanding | ||
| Inactive - That location has no bad | ||
| checks outstanding | ||
| CASH ONLY Status | Active - That location has | |
| designated the customer as CASH ONLY | ||
| Inactive - That location has not | ||
| designated the customer CASH ONLY | ||
| Access Date/Time | Last date/time the negative status | |
| record was accessed and updated (a | ||
| query function does not change this | ||
| date) | ||
| NEGATIVE Date/Time | Date/time the status first became | |
| NEGATIVE | ||
| CASH ONLY Date/Time | Date/time the status first became | |
| CASH ONLY | ||
| BAD Frequency | Total number of bad checks at that | |
| location | ||
| BAD $Amount | Total dollar amount in bad checks at | |
| that location | ||
The file specification for a negative status record is set forth in Table 2 at the end of the specification.
The negative status file is indexed by (a) status/check ID/location, and (b) status/access date/check ID/location.
The negative status file supplements the customer file for those customers with a bad check history by recording BAD Frequency/$Amount by location, and also maintains CASH ONLY status by location.
The system control file includes the following selectable limits:
| Limits | Description | |
| CAUTION/POSITIVE | This limit defines a check clearance | |
| interval for new customers who will | ||
| be rolled for check transactions | ||
| after that interval (assuming the | ||
| first check is not returned) | ||
| CALL MANAGER | Separate DWT limits are provided by | |
| status for both Frequency and | ||
| $Amount, defining the transactional | ||
| limits applied to each status | ||
| PURGE | Separate Purge limits are specified | |
| for each of the five customer status | ||
| designations; also used to define a | ||
| Reset/CAUTION interval | ||
The file specification for the system control file, including coupon control filer, is contained in Table 3 at the end of the specification.
These limits are all specified by the user during system configuration. The CALL MANAGER limits are used to override the normal customer status response to a verification request when any DWT Frequency/$Amount CALL MANAGER limit is exceeded by the current check transaction. As an alternative to using the Purge limits for deleting customer records with a specified (by status) degree of obsolescence, these limits can be used to roll a POSITIVE or any other status back to CAUTION if the specified Reset/CAUTION interval between check transactions (defined by the corresponding Purge limit) has passed. In addition to these limits, the system control file contains various system information.
The specific design of the customer database, and in particular the file specifications for the customer file, negative status file, and system control file, are not critical to the invention, being a matter of design choice. Any customer database will likely comprise customer records identified by the customer check ID, and include selected transactional/customer information; such as check verification status and transactional frequency and dollar volume over specified intervals.
2.2. Function Codes. The specific functions available in the check transaction processing system are invoked by entering at a transaction terminal
The specific check transaction processing functions are set forth in Table 4 at the end of the specification, with each function being described in terms of function code, description, keypad input, and keypad output. These functions are in the following general categories:
| Function | Description (Function Code) | |
| Verify | Request check verification status for | |
| the current check transaction (F55) | ||
| (updating the corresponding customer | ||
| record to reflect the current | ||
| transaction) | ||
| Query | Request information about status | |
| (F1), NEGATIVE status and locations | ||
| (F2, F3, F4) and DWT Frequency and $ | ||
| Amounts (F5) (the customer database | ||
| is not updated) | ||
| Input Status | Add (F40, F41, F44) and Delete (F60, | |
| F61, F62, F63, and F66) the status | ||
| values CASH ONLY, STOLEN and | ||
| NEGATIVE, and Add (F42, F43) and | ||
| Delete (F62, F63) PREAPPROVED and | ||
| MANAGER ONLY user flags | ||
| Event Activity | Start (F950) and Stop (F951) an event | |
| activity, request event time (F952), | ||
| and request activity status (F953) | ||
| System Information | Request certain system information, | |
| including memory usage (F902), disk | ||
| usage (F903), customer file size | ||
| (F904), negative status file size | ||
| (F905), CAUTION/POSITIVE roll period | ||
| (F906, F907), Purge limits (F906, | ||
| F908-F912), CALL MANAGER limits | ||
| (F906, F913-F917) | ||
| System Diagnostics | Request system diagnostic functions, | |
| including log-in/out (F77/F88), | ||
| keypad debug (F960), modem debug | ||
| (F970), data manager debug (F980), | ||
| open/close customer database | ||
| (F981/F982) and shutdown (F999) | ||
2.3. Verify/Query. The verify function is used both to provide verification status (such as POSITIVE, NEGATIVE or CAUTION) for a check transaction, and to update the transactional data in the customer database. The principal difference between the verify and query functions is that, while both functions retrieve the specified (by check ID) customer record (or in the case of query, the negative status record) to provide an appropriate response, only the verify function actually updates the customer database by writing the updated customer record back to disk.
As previously noted, check reader
| Step | Description | |
| | ||
| 4 | Check is taken for tendering purchase | |
| at retail store. | ||
| 5 | Scanning device is used to read the | |
| MICR code from the bottom of the | ||
| check. | ||
| 6 | Scanning device sends MICR data to | |
| parsing processor 128a. Processor | ||
| may be in reader itself or external | ||
| computer. | ||
| 8 | MICR code must now be parsed for | |
| meaningful data. ANSI standards | ||
| specify the following field locations | ||
| within MICR band: | ||
| Amount field | 1-12 | |
| On Us | 14-31 | |
| Transit | 33-43 | |
| Auxiliary On Us | 45-64 | |
| 9-10 | Use transit field for the first part of | |
| the customer's ID number. | ||
| 12 | The check's sequence number (which matches | |
| the number on the top right hand corner of | ||
| the check) must be located in order to | ||
| determine the customer's bank checking | ||
| account number. | ||
| 13 | A variable length, dynamic TRANSIT CODE | |
| TABLE is maintained for checks that cannot | ||
| be successfully parsed. In addition, | ||
| information for MICR changes such as new | ||
| transit number or addition or change of | ||
| Transaction Processing Code (TPC - used | ||
| for branch banking) are indicated in the | ||
| table. The indexed key for this table is | ||
| the transit number allowing duplicates for | ||
| multiple entries for each bank. Included | ||
| for each table entry is the current MICR | ||
| “mask” and a prior “mask” to show any | ||
| changes. Updates to this table can be | ||
| entered from the keypad or downloaded from | ||
| another computer. | ||
| 14 | START a database query in the TRANSIT CODE | |
| TABLE at the FIRST entry with the transit | ||
| number scanned from the check. | ||
| 16 | If NO entry is found for this transit | |
| number, proceed to the parsing functions | ||
| starting at step 29. Otherwise continue | ||
| to step 17 to determine if this table | ||
| entry pertains to this check. | ||
| 17-18 | Use the current MICR “mask” in the table | |
| as a template to determine if this MICR | ||
| data corresponds with this table entry. | ||
| If they do match proceed to step 19, | ||
| otherwise go to step 24 to try the next | ||
| entry. | ||
| 19-20 | Locate the sequence number in the current | |
| MICR “mask” and use this to remove | ||
| sequence number from MICR data. | ||
| 21 | If the prior “mask” indicates that the | |
| banking institution has either changed | ||
| transit numbers or made additions to their | ||
| account number (such as TPC code for | ||
| branch banking), use this prior mask to | ||
| build the key for the OLD record. Proceed | ||
| to step 61; | ||
| 24 | Query for the NEXT entry in the TRANSIT | |
| CODE TABLE for this transit number. If no | ||
| additional entry was found, proceed to | ||
| parsing functions starting at step 29, | ||
| otherwise go to step 17 to determine is | ||
| this table entry pertains to this check. | ||
| 29-32 | Data in the Auxiliary On Us field, unless | |
| otherwise indicated in the TRANSIT CODE | ||
| TABLE, is the check sequence number. This | ||
| would indicate that all data in the On Us | ||
| field make up the customer's bank account | ||
| number. | ||
| 35-37 | Parse On Us field. Use any data within | |
| positions 13 through 32 as the On Us | ||
| field. Discrete numbers are usually | ||
| divided with 2 or more spaces or the ANSI | ||
| On Us character. Embedded single spaces | ||
| and the ANSI MICR dash are removed from | ||
| within said discrete numbers. | ||
| 38 | Test for number of discrete numbers parsed | |
| from the On Us field. | ||
| 40-43 | If one, or more than three discrete | |
| numbers are located in the On Us field, | ||
| the sequence number is either not present | ||
| or is embedded in such a way that its | ||
| location cannot be determined. The | ||
| operator is signaled that the sequence | ||
| number cannot be determined. Operator | ||
| then enters the sequence number including | ||
| any lead zeros. The system can then | ||
| determine the relative position of the | ||
| sequence number in the On Us field and | ||
| stores this as an additional entry to the | ||
| TRANSIT CODE TABLE. | ||
| 47-49 | If two discrete numbers are located in the | |
| On Us field, unless otherwise indicated in | ||
| the TRANSIT CODE TABLE, the number with | ||
| the lesser value is the check sequence | ||
| number, and the number with the greater | ||
| value is the customer's checking account | ||
| number. | ||
| 51-55 | If three discrete numbers are located in | |
| the On Us field, unless otherwise | ||
| indicated in the TRANSIT CODE TABLE, the | ||
| number with the greatest value is the | ||
| customer's checking account number. The | ||
| smallest value is the Transaction | ||
| Processing Code and is appended to the end | ||
| of the checking account number. The | ||
| middle value is the check sequence number. | ||
| 61 | Once the bank's transit number and | |
| customer's checking account number are | ||
| parsed from the MICR band, they are | ||
| combined (transit number followed by | ||
| account number) to form the customer's | ||
| unique checking account ID. | ||
| 63-64 | A packet such as following is built and | |
| passed to the Data Manager: | ||
| char source_id; | /* Node ID indicating | |
| source of packet */ | ||
| char FLAG; | /* A flag signaling a | |
| change in account | ||
| number */ | ||
| char ID_CODE [30]; | /* 30 byte field | |
| containing current ID | ||
| CODE */ | ||
| char OLD_CODE [30]; | /* 30 byte field | |
| containing old ID CODE | ||
| */ | ||
| 65-67 | Use ID CODE as primary key for accessing | |
| check database. | ||
| 68 | If record is found, go to step 83 for the | |
| verification process. Otherwise proceed | ||
| to step 72 for possible account change | ||
| processing. | ||
| 72 | If FLAG indicates there was a change in | |
| the account number, proceed to step 73 to | ||
| locate the old record, otherwise go to | ||
| step 83 for the verification process. | ||
| 73-75 | Using OLD CODE as primary key to query the | |
| check database. If no record is found, | ||
| proceed to step 83 for the verification | ||
| process, otherwise proceed to step 76 to | ||
| transfer the information from the OLD | ||
| record to the NEW. | ||
| 76 | Copy OLD record to NEW record. | |
| 77 | DELETE OLD record from check database. | |
| 78 | Move new ID code into NEW record. WRITE | |
| NEW record to check database. | ||
| 83 | VERIFICATION PROCESS. | |
It can thus been seen that the check reader
The transaction processor uses the check ID input from the MICR parsing subroutine of
First, the Access Date/Time in the customer record is rolled (
Next, for a given status, the transaction interval is compared (
The last roll/update operation is to roll (
After the roll/update operation (
Next, the user flags in the customer record are checked (
Finally, DWT Frequency/$Amount are compared (
For the status query function, the same roll/update operation (
2.4. Local Status Update. Local status update of the customer database is accomplished by inputting certain status (and user flag) information to reflect bad check experience or store policy.
Status input functions are used to Add or Delete the status values NEGATIVE, CASH ONLY and STOLEN. Typically these functions will involve modifying the Status of an existing customer record and/or negative status record, although new records may be created. In addition, local input functions are used to Add or Delete user flags that designate the customer as PREAPPROVED or MANAGER ONLY.
For multiple store systems, a separate negative status record is kept for each location having a NEGATIVE and/or CASH ONLY status history. Thus, assuming negative status records are transferred during the global update function, each store's negative status file will contain separate negative status records for the various locations, sometimes for the same customer. Generally, a store can only affect through the local update function, negative status records for its location.
For each status input function, the update operation for the customer record includes the roll/update operation described in connection with
For the Delete NEGATIVE Status function, the corresponding negative status record is retrieved (
For status input functions that Add/Delete CASH ONLY (which status is also kept by location in negative status file), the basic operation is the same as for Add/Delete NEGATIVE except that the BAD Frequency/$Amount data are unaffected.
For the status input functions that Add/Delete STOLEN, only the customer file need be updated. For the Add STOLEN function, the corresponding customer record is updated in accordance with the roll/update operation, but with status rolled to STOLEN. For the Delete STOLEN function, the corresponding customer record is updated and rolled to CAUTION.
For the user flag input functions that Add/Delete PREAPPROVED or MANAGER ONLY, again, only the corresponding customer record need be updated.
2.5. Global Update. For multiple-store systems, the global update function is used to coordinate the exchange of certain customer information among the individual stores.
Global update is accomplished by file (record) transfers between each remote system and the host system. The host system receives selected customer records and negative status records from each remote, updates its customer database, and then transmits globally updated records back to each of the remotes. Each remote is able to maintain a local customer database, supplemented with selected global customer information deemed to be useful to all stores in the system.
The type of customer information transferred by the global update function is based on store management policies. The recommended approach to exchanging global customer information is as follows:
(a) Negative Status Records—All NEGATIVE status records (NEGATIVE or CASH ONLY status) accessed (created or updated) since the last transfer; and
(b) Customer Records—All customer records with status values CAUTION, NEGATIVE, CASH ONLY and STOLEN accessed (created or updated) since the last file transfer;
(c) POSITIVE status records (even those designated MANAGER ONLY) are not recommended for global transfer.
As a result, the local customer database contains negative status records (including NEGATIVE and CASH ONLY status and BAD Frequency/$Amount) for all store locations (although each remote system only transfers to the host the negative status records for its location). For those customer records transferred, DWT Frequency/$Amounts can be maintained either globally or locally and globally. That is, a store may decide not to maintain both global and local transaction data since, for regular customers that primarily frequent that store (i.e., the customers of primary interest) global and local transaction data are essentially the same anyway. On the other hand, a store may want to keep its local transaction data completely separate from the global data attributable to all stores.
The host/remote file transfers that support global update are accomplished automatically through the event/activity function described in Section 2.7. Generally, for each remote system, host/remote file transfer constitutes an activity automatically invoked at predetermined regular event intervals. This procedure insures that the local customer databases are regularly supplemented with globally updated status and other customer information affecting check verification.
A global update session is initiated by a remote system, or in the alternative by a host computer. The remote transmits only those negative status or selected customer records accessed (updated) since the last host/remote file transfer. Since a remote only updates (or creates) negative status records for its location (although negative status records for other locations may be queried), a remote only transfers those local records (but will receive back from the host recently updated negative status records for all locations). And, only those updated customer records meeting the selected status criteria are transferred (i.e., POSITIVE status records are not transferred, even if designated MANAGER ONLY).
Negative status records are extracted using the index [status/transfer/date/ID/location], while customer records are extracted using the index [status/access date/ID].
After global update of the host customer database, the host transmits to the remote all negative status records and selected customer records accessed (updated) at the host since the previous transfer. Because every remote record transferred to the host caused a corresponding host record to be created or updated, and therefore accessed, the host-to-remote file transfer necessarily includes all host records corresponding to the remote records transferred to the host during that session. In particular, host negative status records for all locations, meeting the recently accessed transfer criteria, are transferred to the remote. For negative status records from other locations, the remote merely copies (
2.6. Purge. The customer database purge function allows a store to orient its customer database toward active customers, stabilizing the database size by deleting certain customer records and negative status records deemed to be obsolete.
During database purge, customer records or negative status records with a given status are read, and the access data/time is compared with the corresponding purge limit from the system control file. Records not accessed during the interval defined by the purge limit are deleted.
Implementing the purge function is optional as a matter of store policy. For the preferred embodiment, the purge limits are also used to define a reset/CAUTION interval (described in connection with FIG.
The purge limits are a matter of design selection. The following purge limits are recommended:
| CAUTION | 270 days | |
| POSITIVE | 360 days | |
| NEGATIVE | 360 days | |
| CASH ONLY | 360 days | |
| STOLEN | 360 days | |
Because customer record status is not rolled automatically from CAUTION to POSITIVE, but only as a result of a transaction in which the access date/time is also rolled current, the customer database maintains an accurate record of CAUTION status for those first-time customers who do not return after the check clearance interval. Those CAUTION status customers who do not return to a store within a reasonable period of time can be eliminated from the customer database. Likewise, POSITIVE status customers who stop transacting business with a store can be eliminated from the active customer database.
Selected purge limits are entered into the system control file during system installation/configuration. If the purge function is selected, performing it automatically as an event-driven activity (described in Section 2.7) is recommended.
2.7. Event/Activities. Event-driven activities are performed automatically by the check transaction processing system to implement certain functions without operator intervention.
The configuration and timing of these activities is a matter of routine design selection. The following event-driven activities, and the associated event intervals, are recommended:
| Host/Remote File Transfer | Every 15 minutes | |
| System Backup | Every 10 minutes | |
| Purge | Every 24 hours | |
In addition, certain report functions can be made automatic as event-driven activities, such as reporting every day all customer records with CAUTION or NEGATIVE status.
The specified event-driven activities and associated event intervals are contained in an event table established during system installation/configuration. These activities are then executed in background at the designated event times without user intervention, and without affecting other foreground functions such as check verification. Once the event table is configured, the various activities may be started or stopped by invoking appropriate functions from a transaction terminal (functions F
For multiple-store systems, performing the host/remote file transfers necessary for global update on a regular, event-driven basis insures that CAUTION/NEGATIVE status information for check verification purposes is kept current throughout the system. Performing such transfers at relatively short intervals keeps the individual host/remote communications sessions sufficiently short that other functions, such as check verification, are not significantly affected. Moreover, performing host/remote file transfers on a regular basis at short intervals helps guard against fraudulent bad check passing schemes.
Regularly, purging the customer database facilitates database stabilization, and focuses the database on reasonably regular customers. The need for regular, and often, event-driven driven backup is obvious, and is not burdensome of system computing resources because only those customer records actually updated during the short interval between backup events need be backed up.
2.8 Communications. The communications function is primarily used to support host/remote file transfers for global update in multiple-store systems. In addition, the communications function can be used for remote diagnostic operations.
The communications function is implemented in a conventional manner. Both the implementation of the communications function and the mode of communications (such as using modem communications over dial up lines) are a matter of routine design selection. Implementing the communications function so as to be essentially transparent to the local operation of the remote and host check transaction processing systems is recommended (see Section 3.6).
2.9. System. Certain system diagnostic and system information functions are available to users of the check transaction processing system.
These system functions are not critical to the inventory but are a matter of routine design selection. The recommended system functions are identified in Section 2.2 and Table 4, and include querying the customer database and system control file, obtaining disk usage and file size information, starting/stopping activities in the event file, and controlling certain keypad and modem configuration functions, as well as controlling certain system level functions such as log-on, log-off, open/close database, debug and system shutdown. In particular, these system functions are useful to store supervisory personnel for querying the customer database and for controlling event-driven activities, and to vendor support personnel for remote diagnostic purposes.
2.10. Risk Management. The check transaction processing system enables a store to adopt a risk management approach to check verification. specifically, through selection of the CALL MANAGER limits for each status (including POSITIVE) a store has considerable flexibility in adjusting its check authorization policy to accommodate the different risks presented by different customers, both in terms of bad check risks and recovery risk.
Adopting specific risk management procedures for check verification is a matter of store policy implemented by routine design selection. In addition to selecting the CALL MANAGER transactional limits for each status, the reset/CAUTION interval can be selected to force customers who do not return for that interval into a CAUTION status. Moreover, the user flags—PREAPPROVED and MANAGER ONLY—can be used to assign special check verification treatment to selected customers regardless of status or transactional (CALL MANAGER) limits.
Adopting risk management approach to check verification through selecting transactional CALL MANAGER limits enables each store to make a policy decision about the degree of risk the store is willing to take within a given interval. Moreover, this approach can be tailored to the specific business climate of the store in terms of dollar volume, profitably, customer base and management philosophy. By specifying transactional CALL MANAGER limits in terms of status, frequency, dollar amount and transaction interval, the store's risk management approach to check verification can reflect statistical patterns for bad check/recovery risks.
For example, frequency and dollar volume limits are important for the CAUTION status to reduce the risk that a store will be hit by a concerted bad check scheme. (Global update is particularly important in this area.) Depending on past experience with its typical customer, or store policy, a new customer can be restricted in terms of numbers of checks and/or dollar volume during the selected check clearance interval.
Frequency and dollar volume limits are just as important for the POSITIVE status. A store should not assume any significant risk in terms of dollar volume (either for a current transaction or over a given relatively short interval such as a week) just because a customer has had one or a few checks clear. That is, total historical check transaction frequency is a significant factor in assessing the risk of cashing a given check; both in terms of likelihood that the check is bad and likelihood that a bad check will be recovered.
2.11. Customer Information Reporting. The check transaction processing system allows a store to build and maintain a customer database containing customer information useful for identifying new customers and developing customer profiles, in addition to its use for check verification.
Reporting customer information, such as verification status and DWT Frequency/$Amounts, is a matter of routine design selection and store policy.
Customer information reports are recommended (a) to identify new customers, and (b) to develop customer profiles, both of which can be used in targeting marketing, advertising and promotional programs, and for other customer relations purposes. Specifically, new customers are identified by regularly reporting customer records with a CAUTION status. Regular customers are identified by reporting customer records based on DWT Frequency data, while the level of a customer's business is identified by reporting customer records based on DWT $Amount data. Additional customer information that can be readily collected in the customer records includes zip code and marital status information useful in demographic analysis.
The check transaction processing system permits the customer information contained in the customer database to be collected in an unobtrusive and efficient manner during high volume check transactions.
The various check transaction processing functions described in Section 2.0 are implemented using a check transaction processing system (“CTPS”) program executed by the transaction processor.
The CTPS Program must implement several operations in real time:
(a) transaction terminal network communications, including communicating verification requests and the corresponding responses;
(b) database operations, including responding to verification requests and updating the customer database;
(c) event-driven activities, including global update, which must execute in the background while the check verification function is executing; and
(d) host/remote communications to support global update.
Moreover, while the purge function may be run after-hours as a batch operation, system backup should be executed at regular intervals throughout a business day as an event-driven background activity.
To achieve acceptable performance using a 286-class engine for the transaction processor, the preferred embodiment of the CTPS Program uses a multi-tasking architecture. The various functions performed by the CTPS Program are implemented as separate program tasks executed by the transaction processor in a multi-tasking mode. For the preferred system configuration (described in connection with FIG.
3.1. General. As shown in
System Kernal
Data Manager Task
Terminal Manager Task
Event Manager Task
Modem Manager Task
In addition to these check transaction processing tasks, a Screen Manager Task
In general, for the Verify/Query and Local Status Update functions, the Terminal Manager Task sequentially polls the transaction terminals which enter and transmit requests, such as:
Verify [Function Code/check ID/Function Code/$Amount]
Query [Function Code/check ID]
Add/Delete [Function Code/check ID/Status] For each terminal request, the Terminal Manager Task spawns a corresponding terminal request subtask that dispatches the request to a corresponding function/request routine, which sends the request to the Data Manager Task. The Data Manager Task executes the request, and notifies the function/request routine (by a semaphore operation) that response data is ready. The function/request routine then builds the appropriate response from the response data, and writes it into the terminal buffer for the requesting terminal. The Terminal Manager Task sends the response to the requesting terminal in the next polling sequence.
For the Global Update function, the Event Manager Task running in a remote system sequences through an event table, and at specified event times and intervals, spawns a corresponding event subtask to execute the global update activities, i.e., send/receive customer records and negative status records. The subtask dispatches to corresponding activity routines, i.e. activities that send/receive customer and negative status records. The send activity routines first request the remote Data Manager Task to retrieve records accessed since the previous global update, and then request the remote Modem Manager Task to transfer those records to the host Data Manager Task for global update. The receive activity routines first send requests for globally updated records through the remote Modem Manager Task to the host Data Manager Task, and then requests the remote Data Manager Task to globally update the remote customer database using the records returned by the host.
3.2. System Kernal. The System Kernal Program is implemented functionally by a multi-tasking module and a system services module.
The multi-tasking module controls resource allocation through task switching, with multi-task execution being implemented using standard context switching to swap task instructions/data between (a) the program and data memory areas allocated to the task, and (b) the task execution registers (i.e., the program counter, stack and other specified and general purpose registers). To implement intertask communications, the multi-task module allocates for each task data memory areas for request and response data, and maintains a task control block that contains for each task (a) task queues for intertask requests, and (b) semaphore flags.
The system services module implements intertask communications through calls to the multi-task module. For intertask communication, the system services module implements semaphore operations on the allocated semaphore flags in the task control block.
Functionally, the System Kernal interfaces to the various task programs that comprise the CTPS Program as a multi-tasking operating system. The Kernal performs four principal operations that establish a multi-tasking environment for the check transaction processing system:
(a) task switching;
(b) task control block management for task queues and semaphores;
(c) intertask communication of task requests/responses using the task control block and allocated data areas; and
(d) spawning subtasks.
The first two operations are performed by the multi-tasking module, while the second two operations are performed by the system services module.) In addition, the System Kernal manages the system control file, and performs diagnostic and system utility operations (these operations being implemented by the system services module).
The specific program implementation of the System Kernal is not critical to this invention, being a matter of routine design specification. Indeed, as described in Section 4.0., the System Kernal can be replaced with a commercially available multi-tasking operating system.
For the preferred embodiment, the multi-tasking module is implemented with a commercially available program, Time Slicer from Life Boat Systems. Time Slicer provides a conventional multi-tasking environment, including task switching (context switching) and task control block management (request queues and semaphore flags). These multi-tasking operations are implemented in a conventional manner. Alternative multi-tasking modules are commercially available.
At system initialization, the System Kernal allocates the task control block (queues and semaphores flags) and the data areas for the various tasks. Thereafter, the System Kernal receives service requests from a requesting task addressed to a responding task and written into the System Kernal's request queue.
The requesting task builds a service request in the following format
responding task ID
requesting task ID
function code
address of request data
address for response data
stope semaphore
The function code is one of the function codes set forth in Table 4. The addresses for the request and response data are data memory locations allocated to the requesting task.
In the case of an intertask service request, the system kernal builds (
The intertask request packet built by the System Kernal is in the following format:
requesting task ID
function code
address of request data
address for response data
semaphore flag
That is, the intertask request packet includes the same information as contained in the service request from the requesting task, but without the responding task ID. That identification is unnecessary since each task is assigned a specific allocation of address space for its task queue and semaphore flags in the task control block, and for its data area. The stop request is the intertask request packet, which the System Kernal recognizes as a stop request when it appears in its request queue.
In general, intertask request execution is accomplished as follows: Each task monitors its task queue in the task control block. If the task queue does not contain a request, the task continues executing internal functions. When an intertask request packet is written into a task queue by the System Kernal (in response to a service request), the responding task reads the packet from the queue. The responding task decodes the request packet, and dispatches the request to an execution routine (either directly or by first spawning a subtask that handles dispatching). This execution routine reads the request data located in the requesting task's data area at the address specified in the intertask request packet, and executes the requested function using the request data. After request execution, the execution routine provides a response by writing response data to the specified address in the requesting task's data area, and sends a stop request (which is the intertask request packet) to the System Kernal indicating that request execution is complete and response data is ready. The System Kernal executes the stop request by setting the specified semaphore flag.
For example, in the case of a verification request entered at a transaction terminal, the Terminal Manager Task spawns (through the System Kernal) a terminal request subtask. The terminal request subtask dispatches to a verification/request routine that sends a verification request through the System Kernal to the Data Manager Task. The Data Manager Task reads from its task queue the verification request (i.e. the intertask verification/request packet), and determines that a verification function is requested. The Data Manager Task dispatches the request to an verification execution routine that reads the request data (check ID and $Amount) from the specified request data address, and performs the necessary customer database operations, including retrieving or creating a corresponding customer record and updating status and transactional data (DWT Frequency and $Amount) to reflect the current transaction. The execution routine then writes the updated customer record to the specified response data address, and sends a stop request (i.e., the intertask request packet) to the System Kernal. The System Kernal sets the specified semaphore flag, and the terminal request subtask reads the customer record and builds an appropriate response that is sent to the terminal by the Terminal Manager Task.
3.3. Data Manager Task. The Data Manager Task manages the customer database, maintaining the customer record file and negative status record file, and the related indices. The Data Manager Task controls all database operations for check transaction processing functions (such as verify/query and local and global update) and customer database management functions (such as backup and purge), including record creation, retrieval, modification and deletion.
The check transaction processing functions performed by the Data Manager Task are, generally:
(a) Verify (with Transactional Update)
(b) Query
(c) Local Status Update
(d) Global Update (Host and Remote)
The verify, query, and local status update functions are invoked from a transaction terminal. The global update function is an activity invoked by the Event Manager Task.
For the preferred embodiment, the Data Manager Tasks interfaces to the disk files (i.e., the customer, negative status and system control files) through a commercially available library of database management routines, C-Tree from Faircom Software. The C-Tree library, in turn, uses the MS/DOS File System (DFS) to handle disk file I/O. The configuration of those routines to operate with the Data Manager Task and the MS/DOS DFS is a matter of routine design specification. Other such libraries of database management routines are commercially available.
At system initialization, the Data Manager Task opens the customer and negative status files, and a password file (used for supervisor functions requiring a password).
If no requests are in the Data Manager Task queue, it executes internal functions (
(a) reading (
(b) decoding (
(c) dispatching (
The function execution routine executes the function, performing the necessary database operations, and upon completion, writes appropriate response data into the location specified by the requesting task, and then sends a stop request (the intertask request packet) to the system kernal.
The various functions identified in FIG.
The Verify routine reads (
The Verify routine then calls (
The purge limit for the customer's status is read (
Next, the roll routine determines whether, for customer records with a CAUTION status, the predetermined check clearance period defined by the CAUTION/POSITIVE limit has passed. If the customer status is CAUTION (
The roll routine then rolls (
The customer record is now updated to the current access date, the roll routine having rolled/updated the Access Date/Time, Status and DWT Frequency and $Amount.
The status roll subroutine is called when any function routine rolls customer status from one value to another. As part of the call instruction, the status roll subroutine receives a new status, CAUTION in the case of the reset/CAUTION operation. Program state-logic then determines whether the roll is allowable according to specified roll state-logic: (a) if allowed, status is rolled to the specified new status; or (b) if not allowed, status is rolled to an allowable status value, or is not rolled, in accordance with the roll state-logic. The status roll subroutine then rolls the status change date in the customer record to the current date (if the subroutine effected a change in status). Thus, for customer records in which the transaction interval exceeds the status purge limit, the customer record is modified to reflect a CAUTION status with a corresponding status change date.
The roll routine returns (
The updated customer record constitutes the response data for the verify request, and the Verify routine writes (
Finally, the Verify routine sends (
The query function is used to query the customer database, and retrieve an updated customer record or updated negative status record from which the desired information may be extracted. For each query function, the Data Manager Task dispatches to a corresponding query execution routine that retrieves and updates the requested customer record or negative status record. The essential difference between the query routines and the verify routine is that no current check transaction data is involved, and the updated record is not written to disk to update the customer database.
For example, in the case of a query for customer information (such as status and/or DWT transactional data), the Data Manager Task dispatches the intertask query request packet to the corresponding Query execution routine. The routine reads the check ID from the specified location for the request data, and initiates a search of the customer record file. If no corresponding customer record is found, the query routine returns an error message response. If a corresponding customer record is retrieved, the Query routine calls the roll routine to update Access Date/Time, Status and DWT Frequency/$Amount. The roll/updated customer record is written to the specified location for the response data, and a stop request is sent to the System Kernal. The Query routine does not update the customer database by writing the updated customer record back to disk.
In addition to updating the customer database in real time through the verification operation, the Data Manager Task also implements the following local status update functions:
Add/Delete NEGATIVE
Add/Delete CASH ONLY
Add/Delete STOLEN
Add/Delete PREAPPROVED
Add/Delete MANAGER ONLY
These functions are used to input customer status and user flag information.
For multiple store systems, negative status records are kept by location, i.e. each location creates a negative status record for any customer with NEGATIVE or CASH ONLY status at that location. Global Update causes the negative status file at each location to contain negative status records for each location (assuming negative status records are selected for global update). Each location can access through the Add/Delete NEGATIVE and CASH ONLY functions only those negative status records for its location. The query function can be used to query negative status records from other locations.
The Add NEGATIVE routine reads (
The customer file is searched (
After the add NEGATIVE function is accomplished, a confirmation response is written (
For multiple-store systems, the Delete NEGATIVE function is used according to the following criteria: (a) it is only used to delete NEGATIVE status for the location requesting the delete NEGATIVE function; i.e., to change NEGATIVE status from Active to Inactive only in the negative status record for that location; and (b) it is only used if all bad checks for that location have been paid off or otherwise resolved. Thus, each location can only affect its own negative status record—the global update function is used to distribute negative status records among all locations.
The Delete NEGATIVE routine reads (
Next, the routine determines (
After the delete NEGATIVE function is accomplished, a confirmation response is written (
The routines that Adding/Delete CASH ONLY operate analogously to the Add/Delete NEGATIVE routine because CASH ONLY is also maintained by location in a negative status record. These routines function in accordance with
The routines that Add/Delete STOLEN affect only the customer file. Thus, these routines read the specified request data (check ID/status), and either retrieve or, for the add routine, create a corresponding customer record. The customer record is updated using the roll routine, and then rolled to STOLEN (add function) or to CAUTION (delete function) using the status roll subroutine. The updated customer record is written to the customer file, and a confirmation response is written to the specified response data location. The routine terminates with a stop request sent to the System Kernal.
The routines that Add/Delete PREAPPROVED and MANAGER ONLY operate to set/clear the corresponding user flags in the customer record in a manner analogous to the Add/Delete STOLEN routine. That is, these routines roll/update the corresponding customer record, set/clear the specified user flag, and then provide an appropriate confirmation response.
For the global update function, the host Data Manager Task receives negative status and selected customer records from all the remote systems, and executes a host global update function. Host negative status and selected customer records are then sent to the remote Data Manager Task which executes a remote global update function. The global update function is implemented by the remote Event Manager Task which executes a global update event/activity (see Section 3.5).
The criteria for selecting records for transfer in connection with global update are:
(a) Negative Status File—All records accessed since the previous host/remote file transfer for global update (NEGATIVE or CASH ONLY status); and
(b) Customer File—All customer records accessed since the previous host/remote file transfer for global update, and having a status value of CAUTION, NEGATIVE, CASH ONLY or STOLEN.
Since a remote location only accesses (updates) the negative status records for its location, each remote only transfers to the host negative status records for its location. The host global update function necessarily accesses each negative status record transferred by a remote during a global update session, so that all such records are transferred back to each remote (along with the host location negative status records that were accessed as a result of local host operation.
For each negative status record received (
If a corresponding host record is retrieved (
The updated (or copied) host negative status record for the remote location is written (
If not (i.e., if NEGATIVE status for that customer is Inactive at all locations), the corresponding customer record is retrieved (
The Global Update (Negative Status) routine terminates with stop request sent (
For each customer record received from the remote (
If a corresponding host customer record is retrieved (
The host updates DWT Frequency/$Amount in the host customer record by adding (
Finally, the host customer file is updated by writing (
Once the host has completed updating its negative status file (
Since for each remote record transferred to the host, the host performs an update operation that changes Access Date/Time, the host-to-remote file transfer will necessarily result in all such updated records being retransmitted back to the remote. In addition, the host will transfer to the remote NEGATIVE status and selected customer records accessed and updated by the host during either (a) local-host verification or update operations, or (b) a host global update operation initiated by another remote.
The remote receives the negative status and customer records transferred from the host, and performs a global update of its customer database. As described in Section 3.5, the remote Event Manager Task requests host records from the host Data Manager Tasks, and then sends them to the remote Data Manager Task with a global update request.
The remote global update function for the negative status file is based on two criteria: (a) for remote-location negative status records, the remote record is assumed to be correct and the remote record is ignored; and (b) for other-location negative status records, the host record is assumed to be correct and it is copied without any update or other access by the remote. After receiving and decoding the appropriate intertask request packet (containing the global update request for the host negative status record from the remote Event Manager Task), the remote Data Manager Task dispatches to the Remote Global Update (Negative Status) execution routine that implements these global update operations.
For each customer record received (
If status is CAUTION, POSITIVE or STOLEN, the status for the updated remote customer record is compared (
The updated customer record (with its transfer date updated current) is written (
The arbitration rules used by the host during global update to assign status (
The database operations associated with purge and backup are also handled by the Data Manager Task. These functions are implemented as event activities by the Event Manager Task. In response to requests from the corresponding event activity routine, the Data Manager Task retrieves the specified records and processes them in accordance with conventional record delete (purge) or copy (backup) operations. Thus, for backup, the Event Manager Task provides a backup key [status/access date/time], and all records accessed since the last backup are copied to a backup file. For purge, a purge routine operates analogously to the roll routine (
3.4. Terminal Manager Task. The Terminal Manager Task manages the communication of requests/responses between the transaction terminals and the transaction processor, implementing a token ring local area network. In implementing token ring data communications, the Terminal Manager Task sequentially polls each transaction terminal using the token ring protocol described in Section 1.2.
When request data (such as check ID/$Amount) are entered into a transaction terminal, the transaction terminal responds to its next POLL token by transmitting TXDATA answer packet including the request to the Terminal Manager Task, which writes the request data into the corresponding terminal buffer.
For each request received from a transaction terminal, the Terminal Manager Task spawns a terminal request subtask that:
(a) Builds a System Kernal service request for the request entered into the transaction terminal;
(b) Sends the service request to the responding task through the System Kernal;
(c) Receives response data from the responding task;
(d) Builds the appropriate response from the response data; and
(e) Sends the response to the transaction terminal.
The responding task depends upon the request function code entered into the terminal. (See Section 2.2) Most of the request functions are for the Data Manager Tasks because they involve customer database access. However, requests to the other tasks for diagnostic or system information can be made from a transaction terminal.
At system initialization, the Terminal Manager Task: (a) Initializes the 32-port network communications interface (
For the preferred embodiment, no attempt is made to deallocate terminal buffers/flags for those communications ports that do not have an active, on-line transaction terminal. This design choice does not require any significant memory allocation for the 32-terminal configuration of the preferred embodiment. Such deallocation procedures are a matter of routine program implementation.
The Terminal Manager Task continually monitors (
If no TMT request has been written into the task queue, the Terminal Manager Task begins a token polling sequence (
A token polling sequence is accomplished by sequencing through the terminal addresses
The Terminal Manager Task makes no attempt to segregate active and inactive communications ports, or to remove from the polling sequence terminal addresses not assigned to active, on-line transaction terminals. This design choice does not significantly impact network communications for the
Terminal addresses are determined as follows. During each polling sequence, the Terminal Manager Task polls each of the 32 ports—beginning with Port
For each terminal address the Terminal Manager Task determines (
If the terminal is in the Poll state, the Terminal Manager Task sends (
During execution of the request, while the requesting terminal is in the “Wait” state, the Terminal Manager Task does not poll that terminal, but rather, continues with the polling sequence.
Once a request has been executed and the response data placed in the terminal buffer for the requesting transaction terminal, the request subtask sets the terminal Data state flag. During the next poll sequence, the Terminal Manager Task reads (
When the token poll sequence is completed (i.e., terminal address
When the operator enters the terminal ID, the network software watches for that terminal address—when a POLL with that address is received, the network software waits for a time-out to determine whether another terminal has that address. If not, the network software grabs the next POLL with that address and commences normal network communications.
For the preferred embodiment, the POLL token is one byte (
| Bit 7 | Token Flag (set if POLL token; | |
| otherwise clear) | ||
| Bits 5-6 | TX-POLL token | |
| RX-RXDATA token | ||
| Bits 0-4 | Terminal address | |
All data communications over the network are in 7 bit ASCII (
| Bit 7 | Not used | |
| Bits 0-6 | TXDATA | |
| NODATA | ||
The TXDATA byte is followed by up to 40 characters of data in 7-bit ASCII (
Thus, in operation, a transaction terminal watches the network for its POLL token (with its terminal address). When its POLL is received it sends back either a NODATA answer byte, or a TXDATA byte followed by up to 40 characters of data terminated in an END character. If the terminal is waiting for response data, so that it has been placed in a Wait state, it will not receive a POLL token. When response data is available, the Terminal Manager Task will retrieve the data from the terminals' RXBUFFER and transmit it with the next TXDATA token.
This implementation for a token ring network is a matter of design choice. Other implementations are a matter of routine program design. Commercial token ring program packages are available.
To execute a request sent by a transaction terminal during a polling sequence, the terminal request subtask first determines which function is requested, and then dispatches to an appropriate service request routine that:
(a) Builds a service request;
(b) Sends the service request to the responding task (via the System Kernal);
(c) Builds an appropriate response from the response data returned by the responding task; and
(d) Writes the response into the appropriate terminal buffer.
In addition, for a verify request, the verify service request routine determines whether any “CALL MANAGER” limits have been exceeded, and if so, causes the “CALL MANAGER” response to be returned to the terminal.
From Section 3.2, a service request is in the following format:
Requesting task ID
Responding task ID
Function code
Address of request data location
Address for response data location
Semaphore flag
The service request is sent to the System Kernal, which builds a corresponding intertask request packet.
The responding task that executes the request depends upon the function code. Of course, most function codes will be executed by the Data Manager Task because they involve accessing in some way the customer database.
After execution of the request, the response data returned by the responding task depends upon the request function code. The Data Manager Task returns updated customer or negative status records in response to verify/query requests and confirmations in response to local status update functions and global update functions.
Exemplary terminal request subtask operation is described in connection with a verify request in which the responding task is the Data Manager Task.
The subtask then dispatches (
The service request subroutine builds (
The terminal request subtask then suspends execution and monitors (
The terminal request subtask then reads (
The first operation in building an appropriate verification response from the customer record returned by the Data Manager Task is to test the MANAGER ONLY flag (
If the MANAGER ONLY user flag is clear, the next operation is to test the PREAPPROVED flag (
After testing the user flags, the next operation in building a response for a verify request is to test the CALL MANAGER limits (
As described in Section 2.3 and 2.10, the CALL MANAGER limits are used to place predetermined transactional limits (DWT Frequency/$Amount) on a check transaction primarily for customers with CAUTION and POSITIVE status. These limits are set as a matter of store policy, and placed in the system control file during system configuration.
For function requests other than verify and query status, the user flag and CALL MANAGER operations (
The response—MANAGER ONLY, PREAPPROVED, CALL MANAGER or [Normal] —is written (
The basic operation of the terminal request subtask for each request function is as described in connection with
3.5. Event Manager Task. The Event Manager Task manages background activities that are executed automatically without operator intervention, maintaining an Event File that includes an Event Table, an Activity Table and associated indices. The Event Table includes event records each specifying an event time, an event interval and associated activity pointers into the Activity Table. The Activity Table includes a list of activity codes.
The basic activities implemented by the Event Manager Task are:
(a) Host/Remote Communications—These activities transfer customer records and negative status records between host and remote systems for global update;
(b) Purge—These activities, one for each status, delete customer records and negative status records that are obsolete based on specified purge limits contained in the system control file; and
(c) Backup—These activities are regularly invoked to backup the customer and negative status files.
The host/remote communications and backup activities operate only on those customer records or negative status records that are accessed (i.e., that have their transfer dates updated) after the last corresponding activity was performed. Host/remote communications are implemented in connection with the Modem Manager Task.
The Event Table contains an event record for each event, with each event record including: (a) an event interval specifying the interval between execution of the associated event activities; (b) the next event time, calculated by the event subtask after completing execution of an event/activity based on the event interval and the system clock; (c) up to
In its basic operation, the Event Manager Task sequences through the events (event records) in the Event Table, spawning a corresponding event subtask to execute the specified activity.
Event/activities are started and stopped using a transaction terminal to enter a corresponding request (see the function codes
While event frequency for a given activity is a matter of store policy and design choice, typically, host/remote communications and backup will be performed fairly frequently to insure both the regular update of the customer database, and the ability to recover from a system failure without significant loss of data. On the other hand, the purge function is more a matter of system administration designed to control the size of the customer database. Indeed, the purge function can be omitted as an event activity. In that case, the status purge limits contained in the system control file define the reset/CAUTION interval used in the roll routine to roll all statuses back to CAUTION if the specified reset/CAUTION (i.e., purge) limits are exceeded, as described in connection with FIG.
The selection and timing of event-driven activities is a matter of design choice. The recommended event-driven activities, and the associated event intervals, are:
| Host/Remote File Transfer | Every 15 minutes | |
| System Backup | Every 10 minutes | |
| Database Purge | Every 24 hours | |
The Event Manager Task sequences through the event file, selecting the specified event-driven activities on a read-next basis. Event times are specified as time intervals starting from a baseline system time 00:00:00:00:00:00 [yymmddhhmmss] for Jan. 1, 1970 (the transaction processor includes a battery assisted hardware clock synchronized to this baseline system time).
When an event time is reached, and the associated activity is completed, the event time is incremented by the event interval, based on the previous event time and not on when the activity was actually completed. For example, if host/remote file transfers to support global update activities (i.e., transfers of negative status records and selected customer records are to be accomplished every 15 minutes, then each activity is entered into the event file with an interval of 15:00[mmss]. The activity will be entered into the event file, along with its event interval and its initial event time of 15 minutes after system initialization (assumed to be 00:00[mmss]). The activity will then first be executed at 15:00, and when the activity is completed, the associated event time will be incremented to 30:00.
At initialization, the Event Manager Task opens the Event Table and Activity Table, and clears all semaphore flags. Thereafter, the Event Manager Task sequences through the Event Table, spawning event subtasks at specified event times to execute corresponding activities. While a given event may have several activities associated with it, only one event subtask (and only activity within an event record) is executed at a time.
If the task queue is empty, the Event Manager Task tests the event-active semaphore (
If no event is active (semaphore clear), the Event Manager Task reads (
The Event Manager Task then the task reads (
If the event time for the next event/activity is greater than or equal to the current time (
Event subtask operation will be described in connection with executing at a remote system the activities associated with the global update function. Specifically, the event subtask will be described in connection with sequentially executing the following global update activities:
(a) originate call;
(b) Send customer records (all selected statuses);
(c) Send negative status records (NEGATIVE and CASH ONLY);
(d) Receive customer records (all selected statuses); and
(e) Receive negative status records (NEGATIVE and CASH ONLY).
That is, each of the send/receive activities reads all selected statuses. When the remote event subtask receives the event record containing the event time pointers into the Activity Table, it sets (
For each activity code read from the Activity Table, the event subtask dispatches (
Each activity routine includes an activity data control data block containing certain fixed and/or variable data used by the routine in executing the activity. Thus, for the global update event, the originate call routine includes in its activity control data block the phone number for the host (as well as other system numbers that may be called by the remote) and a corresponding log-in ID. The send/receive record routines include in their respective activity control data blocks the previous event time for the activity which defined the end of the previous event interval for that activity.
Thus, the current event interval for a global update (send/receive) activity is defined by the previous event time in the activity routine's control data block, and the current event record. After execution of the activity, the current event time is written into the activity routine's control data block to define the beginning of the next global update event interval. (A similar control data block operation is used for the backup activity.)
A global update event begins at a remote system with an originate call activity that directs the remote Modem Manager Task (MMT) to establish a communications link to the host. This activity is dispatched to an originate call routine (
The originate call routine begins by building and sending to the remote MMT a request (
The event subtask reads (
The event subtask dispatches (
The DMT receives the initial customer record retrieval request, and dispatches it to a corresponding customer record retrieval routine. This routine reads the initial record retrieval key (including the ending time for the previous event interval which is the beginning time for the current event interval) from the specified request data location, and using this initial key and the index [status/transfer date/check ID], retrieves the first customer record with an access date/time equal to or greater than the beginning event time (if more than one customer record has the same access date/time, then the customer record with the lowest check ID is retrieved). When the DMT retrieval routine has retrieved this first customer record in the current event interval, it provides an appropriate response to the send customer record routine, writing the retrieved customer record into the specified response data location and sending a stop request to the System Kernal.
When the stop semaphore is set (
The send customer record routine then sends a global update service request to the host DMT, along with the just-retrieved remote customer record, through the remote MMT (
The above remote/host intertask communication operation is described in greater detail in Section 3.6 (Modem Manager Task). Essentially, the Modem Manager Task is designed so that remote/host intertask communications is essentially transparent to the requesting and responding tasks. That is, the remote/host requesting task sends a service request with request data and a stop semaphore to its System Kernal addressed to the host/remote responding task. The remote/host MMTs provide an essentially transparent communications link between the remote/host System Kernals to effect the return of the stop semaphore and response data from the host/remote responding task to the remote/host requesting task.
When the send customer record routine detects (
As with the first customer record retrieved in the current event interval, the DMT dispatches this request to a customer record retrieval routine that reads the new retrieval key from the specified request data location, and using the index [status/transfer date/check ID], searches the customer file by incrementing first check ID and then transfer date/time until the next record is retrieved. The DMT retrieval routine then responds to the customer record retrieval request, writing the retrieved customer record into the specified response data location for the send customer record routine.
This procedure—requesting a customer record using the transfer date/time and check ID for the previous record as the retrieval key, retrieving that customer record by reading the customer file using the retrieval key, sending the retrieved customer record to the host, and requesting the next customer record—continues until either (a) the remote DMT responds to a retrieve customer record request from the send customer record routine by indicating that the customer file contains no other customer records accessed after the just-sent customer record (as detected in step
After the activity for sending customer records (by selected status) has executed, the next activity specified in the Event Table is for sending negative status records (both NEGATIVE and CASH ONLY status). The corresponding routine in the event subtask for executing the send negative status record activity operates identically to the send customer record routine (
After negative status records have been sent, the receive customer records and negative status records activities are executed. Because of the essential transparency of the remote/host communications operation using the host/remote MMTs, the receive activity is analogous to the send activity. The remote receive record activity routine requests records from the host DMT. The host DMT responds with globally updated records that are sent by the remote routine to the remote DMT for remote global update.
When the last send/receive activity for the global update function at the current event time has been completed (i.e., the last receive negative status record routine has completed transferring negative status records from the host DMT to the remote DMT for global update), that routine returns to the event subtask, which determines that the current event time contains no more activities to be executed (
Accordingly, at the completion of the activity sequence for the global update function, the event subtask detects that the modem flag is set (
If the event subtask had been executing an event time and associated activity sequence in which communications was not necessary, such as backup or purge, the event subtask detects that the modem flag is clear (
3.6 Modem Manager Task. The Modem Manager Task manages modem communications, primarily to support host/remote file transfer for global update, but also for remote diagnostic purposes. Operation for host/remote file transfer depends in part upon whether the modem manager task is running in the host or remote check transaction processing system—all host/remote file transfers are initiated and controlled by the remote system.
Modem communications through the Modem Manager Task are essentially transparent to the other tasks, functionally operating as an extension of the normal intertask communications using intertask service requests. Thus, the remote Event Manager Task sends service requests to the host Data Manager Task through: the remote System Kernal, the remote Modem Manager Task, the host Modem Management Task and finally the host System Kernal. Similarly, the host Data Manager Task responds with a reply, including response data and a stop request, over the same host/remote communications path.
For remote-to-host file transfers, the remote Event Manager Task first issues a dial host request to the remote Modem Manager Task, which the Modem Manager Task executes by dialing the host Modem Manager Task and detecting an off-hook condition at the host. When the remote Event Manager Task is notified by a stop semaphore that a connection has been made, it requests the MMT to send a Log-In ID to establish an active communications link. The remote Event Manager Task then issues a service request to the host Data Manager Task, which is directed by the remote System Kernal into the Modem Manager Task queue. The Modem Manager Task reads the request and sends it to the host system, where the host Modem Manager Task transfers the request to the host Data Manager Task through the host System Kernal. The host data manager task responds with a reply that includes a stop request—this response is communicated through the host/remote Modem Manager Task link to the remote Event Manager Task.
At system initialization, the Modem Manager Task opens its communications port, and conducts modem start-up diagnostic tests.
Typically, when the remote Event Manager Task is advised (with a stop semaphore) by the Modem Manager Task that the host answered the call and a line connection is made, the Event Manager Task sends, via the Modem Manager Task a Log-In ID that establishes an active communications link between the two systems. Once an active communications link is established, the remote/host file transfer procedure for communicating negative status and customer records is as follows.
The remote Event Manager Task sends a request for global update of a record to the host Data Manager Task, writing the record into a specified request data location. The remote System Kernal builds an intertask request packet and routes it to the remote Modem Manager Task. The Modem Manager Task reads (
When the Modem Manager Task receives (
This communication procedure is continued so long as requests are sent to the Modem Manager Task (
The host and remote Modem Manager Tasks cooperate to establish a communications link as follows. A communications session is initiated by a dial request from the remote Event Manager Task is directed to the remote Modem Manager Task, which responds by dialing the host.
A ring indication at the host modem is detected (
The remote Event Manager Task then sends an appropriate log-in identification (
File transfer communications are commenced when the host Modem Manager Task receives (
The service request is directed to the designated responding task, such as the host Data Manager Task, which executes the request and provides both response data and a stop request. The host Modem Manager Task reads (
The host Modem Manager Task then builds (
The Modem Manager Task implements remote/host communications functions in a manner that is essentially transparent to the other tasks and the System Kernal. That is, intertask communications between a remote task and a host task are accomplished in a manner identical to intertask communications between tasks running in the same check transaction processing system, except that both the remote and the host System Kernal are involved in the intertask communication, as are the remote and host Modem Manager Tasks. However, the communications function provided by the remote and host Modem Manager Tasks is essentially transparent to the other tasks running in either the remote or the host. For example, the remote event subtask sends requests in the form of service requests to the host Data Manager Task just as it would send requests to the remote Data Manager Task. Specifically, the remote event subtask builds a request to the host DMT, and sends the service request to the remote System Kernal. The remote System Kernal builds a inner task request packet and places it in the remote MMT task queue. The remote MMT task reads the intertask request packet and builds a communications packet for the request to the host DMT (including function code, request data and stop semaphore flag). The remote MMT transmits the communications packet to the host MMT, which builds a corresponding service request for the host System Kernal. The host System Kernal builds an intertask request packet that is placed in the host DMT task queue. The host DMT retrieves the intertask request packet, which constitutes a request from the remote event subtask, and executes it in the same manner that it would a request from the host event subtask, writing response data into the specified response data location and sending a stop request to the host System Kernal. The host System Kernal, recognizing the stop request as being directed to the remote event subtask, builds an intertask packet with both the response data and the stop request and writes into the remote MMT task queue.
The remote MMT reads the intertask request packet, builds a communications packet and sends it to the remote MMT. The remote MMT writes the response data into a specified location in the data area for the Event Manager Task, and sends the stop request to the remote System Kernal. The remote System Kernal sets the specified stop semaphore, notifying the remote event subtask that response data from the host DMT is available, completing the request/response cycle.
While the check transaction processing system has been described in connection with a preferred embodiment, other embodiments within the spirit and scope of the invention as defined by the following claims will be apparent to those skilled in the art.
For example, in the case of multiple-store systems, the preferred embodiment includes separate, essentially autonomous check transaction processing systems at each store site, thereby permitting each store to establish and maintain an essentially local customer database, and limiting off-site data communications activities to remote/host file transfers for global update. However, the local customer database (and associated disk system) need not be located at the store site, but may be remote from the stores' transaction terminal network (such as by locating it in a central office) so long as: (a) transaction terminal response time is not adversely affected and, (b) the essentially local character of the customer database for each is maintained.
The preferred embodiment's implementation of a multitasking system using a System Kernal for task-switching and intertask communications, can be readily adapted to operate under a commercial, multi-tasking operating system. These operating systems provide the task switching and intertask message communications functions performed by the System Kernal. Adapting the CTPS multi-tasking program to a commercially available multi-tasking operating system is well within the programming capabilities of those skilled in the art. Each program task would be modified in a conventional manner to accommodate the specific message communication function implemented by the multi-tasking operating system.
5.1. Automatic Building Of A Database For A Retail Store Marketing Program. Copending patent application Ser. No. 07/826,255 discloses manually inputting customer information, such as a customer's checking account number, into a database for various purposes. However, previous techniques of building a database from checks required a store employee to physically review the name and address preprinted on each check and type in certain parts of that name and address to try to determine if the name matched a name and address previously stored in the database. For example, after typing in the last name Jones, it would be discovered that there are multiplicity of Jones previously stored in the database. The name Jones would then have to be refined by typing in the names or initials which again might produce a multiplicity of matches. The information could then be further refined by imputing the street address to match along with the full name and initials.
If a grocery store for example, has a volume of several thousand check customers per day, this manual database building technique would mean a substantial amount of labor and time required to manually key in the name and address information to find out if, in fact, that record was already in the database and was complete. If the database was incomplete, the new information would have to be manually loaded into the database.
The present invention provides a method which may be accomplished utilizing the automatic check reader
If the predetermined customer identification data is found in the stored database, a signal is transmitted from the host processor
Thus, the present system may continuously build an up-to-date database which contains relevant information about the frequency of the customer's transactions, the amount of the transaction, along with the current address and information. As will be subsequently described, this database may be used for various types of targeted marketing in order to enhance the retail store's marketing.
| Step | Description | |
| 3 | Beginning a process being flowed. | |
| 5 | Check is taken for tendering purchase | |
| at retail store. | ||
| 6 | Scanning device is used to read the | |
| MICR code from the bottom of the | ||
| check. | ||
| 8 | MICR code must now be parsed for | |
| meaningful data. ANSI standards | ||
| specify the following field locations | ||
| within MICR band: | ||
| Amount field | 1-12 | |
| On Us | 14-31 | |
| Transit | 33-43 | |
| Auxiliary On Us | 45-64 | |
| 9-10 | Use transit field for the first part | |
| of the customer's ID number. | ||
| 12 | The check's sequence number (which | |
| matches the number on the top right | ||
| hand corner of the check) must be | ||
| located in order to determine the | ||
| customer's bank checking account | ||
| number. | ||
| 13-16 | A variable length, dynamic TRANSIT | |
| CODE TABLE is maintained on disk for | ||
| checks that cannot be successfully | ||
| parsed. The index key for this table | ||
| is the bank's transit number. | ||
| Included for each table entry are the | ||
| beginning and ending positions of the | ||
| sequence number within the MICR band. | ||
| The system will prompt the operator | ||
| for the sequence number if it cannot | ||
| determine its location within the On | ||
| Us field, and then add the entry to | ||
| the TRANSIT CODE TABLE. The | ||
| modifications to the TRANSIT CODE | ||
| TABLE and/or the TABLE may be | ||
| maintained and downloaded from | ||
| another computer. | ||
| 20-22 | Data in the Auxiliary On Us field, | |
| otherwise indicated in the TRANSIT | ||
| CODE TABLE, is the check sequence | ||
| number. This would indicate that all | ||
| data in the On Us field make up the | ||
| customer's bank account number. | ||
| 25-27 | Parse On Us field. Use any data | |
| within positions 13 through 32 as the | ||
| On Us field. Discrete numbers are | ||
| usually divided with 2 or more spaces | ||
| or the ANSI On Us character. | ||
| Embedded single spaces and the ANSI | ||
| MICR dash are removed from within | ||
| said discrete numbers. | ||
| 28 | Test for number of discrete numbers | |
| parsed from the On Us field . . . | ||
| 30-33 | If one or more than three discrete | |
| numbers are located in the On Us | ||
| field, the sequence number is either | ||
| not present or is embedded in such a | ||
| way that its location cannot be | ||
| determined. The operator enters the | ||
| sequence number including any leading | ||
| zeros. The system can then determine | ||
| the relative position of the sequence | ||
| number in the On Us field and stores | ||
| this as an additional entry to the | ||
| TRANSIT CODE TABLE. | ||
| 37-39 | If two discrete numbers are located | |
| in the On Us field, unless otherwise | ||
| indicated in the TRANSIT CODE TABLE, | ||
| the number with the lesser value is | ||
| the check sequence number, and the | ||
| number with the greater value is the | ||
| customer's checking account number. | ||
| 41-45 | If three discrete numbers are located | |
| in the On Us field, unless otherwise | ||
| indicated in the TRANSIT CODE TABLE, | ||
| the number with the greatest value is | ||
| the customer's checking account | ||
| number. The smallest value in the | ||
| Transaction Processing Code and is | ||
| appended to the end of the checking | ||
| account number. The middle value is | ||
| the check sequence number. | ||
| 51 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed from the MICR band, they | ||
| are extracted and combined (transit | ||
| number followed by account number) to | ||
| form the customer's unique checking | ||
| account ID. | ||
| 52-54 | This ID is used as the primary key | |
| for a customer database on disk | ||
| indexed by checking account ID. In | ||
| this database building process, the | ||
| key is passed to the processor and | ||
| the database is searched by checking | ||
| account ID key. | ||
| 57-63 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked and the result is signaled | ||
| back to the operator. | ||
| 67-68 | If no record exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete of predetermined | ||
| identification criteria. | ||
| 70-71 | If signaled to do so, operator enters | |
| additional information from off of | ||
| the face of the check. The updated | ||
| record is rewritten in the database. | ||
| 73 | Shopping event and dollars spent is | |
| recorded in order to build a shopping | ||
| history for each customer's record. | ||
5.2. Targeted Marketing Program. It has been previously known to utilize marketing programs wherein users of a retail store's services are targeted to attempt to induce the customers to make additional purchases from the retail store. What has not before been possible, however, is to allow a retail store owner to target only non-customers. If such were possible, store owners would not waste mailing and marketing expenses on people in their targeted geographic area who had been previous customers. In other words, the retailer would be able to use his marketing dollars to attempt to entice non-customers or infrequent customers to visit the store.
| Step | Description | |
| 3 | Beginning of process being flowed. | |
| 6 | Check is taken for tendering purchase | |
| at retail store. | ||
| 7 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed and extracted from the | ||
| MICR band, they are combined (transit | ||
| number followed by account number) to | ||
| form the customer's unique checking | ||
| account ID. This ID is used as the | ||
| primary key for a customer database | ||
| on disk indexed by checking account | ||
| ID. | ||
| 8-15 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked and the result is signaled | ||
| back to the operator. Shopping event | ||
| and dollars spent are recorded in | ||
| order to build a shopping history for | ||
| each customer's record. | ||
| 19-20 | If no record exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete of predetermined | ||
| identification criteria. | ||
| 23-25 | Shopping event and dollars spent are | |
| recorded over a period of time | ||
| sufficient in length to get a good | ||
| representation of the store's | ||
| customer base. | ||
| 31 | A file containing a complete list of | |
| residents in a predetermined | ||
| geographic area is obtained from a | ||
| third party. | ||
| 32 | Create an empty TARGET FILE for | |
| writing records of prospective | ||
| customers not appearing in store's | ||
| database. | ||
| 33 | Read FIRST record from the file | |
| containing a complete list of | ||
| residents in a predetermined | ||
| geographic area. | ||
| 36 | Search in the store's database for to | |
| determine if this household is | ||
| present in the store's database. | ||
| 38-42 | If this household is not contained in | |
| the store's database, write this | ||
| record said TARGET FILE of | ||
| prospective customers not appearing | ||
| in the store's database. | ||
| 45-47 | Read the NEXT record from said list | |
| of prospective customers in a | ||
| predetermined geographic area. If | ||
| END OF FILE marker is found then | ||
| proceed to step 48, otherwise LOOP | ||
| back up to step 36. | ||
| 48 | Said TARGET FILE now contains a list | |
| of prospective customers from a | ||
| predetermined geographic area that | ||
| were NOT contained in the store's | ||
| active list of customers. | ||
| 53 | Marketing may now be targeted toward | |
| this list of non-customers, such as | ||
| mailing of inducement coupons or | ||
| advertising. | ||
In summary, it may be seen that the technique of
The present system generates a non-customer database which would allow the mailing of advertising material in a geographic area to customers who have not previously shopped, or who have infrequently shopped at the retail store.
5.3. Infrequent Shopper Database And Marketing
Technique. Competition among retail stores has dramatically increased such that targeted marketing is becoming increasingly important. Historically, such retail stores such as grocery stores have relied upon a loyal base of shoppers who have shopped at that particular establishment over a long period of time. However, with increased competition, it has now been determined that many shoppers frequent many different stores, particularly grocery stores, based upon coupons or price differentials at the time.
For example, Table 5 attached hereto illustrates customer shopping frequency data which was accumulated by the present system at an actual grocery store over an eight week period in 1991. Surprisingly, it was found in this particular store that 55% of the store's customers during this period only visited the grocery store one time only a few percentage points of the customers visited the store over seven times during that period. Specifically, for a total number of almost 30,000 customers over the eight week period, 8,794 customers only visited the store one time, while 2,776 customers visited the store only twice. Over 20% of the store's revenue during the period was based upon a single visit by 8,794 customers.
Table 6 illustrates an infrequent customer analysis of a different grocery store over an eight week period. This table illustrates that 24.3% of the total customer base, or 5,581 customers, averaged visiting the grocery store only 1.08 times during the eight week period.
This shopping data, which was developed using the present invention, has come as a surprise to grocery store owners. Many owners did not previously understand the large percentage of their business which was coming from infrequent shoppers. A need has thus arisen for a marketing technique to target these infrequent shoppers to encourage them to visit the grocery store more often. It will be understood that many families visit a grocery store approximately one time per week, and thus a visit of only once every eight weeks means that the store is being visited by many infrequent shoppers who are shopping at different stores. It could substantially enhance the store's revenues if these infrequent shoppers could be induced to shop more often at a particular store.
A description of the routine as shown in
| Step | Description | |
| 3 | Beginning of process being flowed. | |
| 6 | Check is taken for tendering purchase | |
| at retail store. | ||
| 7 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed from the MICR band, they | ||
| are combined (transit number followed | ||
| by account number) to form the | ||
| customer's unique checking account | ||
| ID. This ID is used as the primary | ||
| key for a customer database on disk | ||
| indexed by checking account ID. | ||
| 8-15 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked out and the result is | ||
| signaled back to the operator. | ||
| Shopping event and dollars spent are | ||
| recorded in order to build a shopping | ||
| history for each customer's record. | ||
| 19-20 | If no record exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete of predetermined | ||
| identification criteria. | ||
| 21-27 | Shopping event and dollars spent are | |
| recorded over a period of time | ||
| sufficient in length to get a good | ||
| representation of the store's | ||
| customer base. | ||
| 33 | Create an empty TARGET FILE for | |
| writing records of customer's who | ||
| have not shopped this store since a | ||
| preselected shopping date. | ||
| 34 | Read FIRST record from the store's | |
| database of customer's check | ||
| information and related shopping | ||
| history. | ||
| 37-38 | Locate customer's LAST SHOPPING DATE | |
| from customer's shopping history and | ||
| compare with said preselected | ||
| shopping date. | ||
| 40-44 | If this customer's LAST SHOPPING DATE | |
| is prior to said preselected shopping | ||
| date, write this record to said | ||
| TARGET FILE of customer's who have | ||
| not shopped this store since a | ||
| preselected shopping date. | ||
| 47-49 | Read the NEXT record from said | |
| store's database of customer's check | ||
| information and related shopping | ||
| history. If END OF FILE marker is | ||
| found then proceed to step 50, | ||
| otherwise LOOP back up to step 37. | ||
| 50 | Said TARGET FILE now contains a list | |
| of the store's customers who have not | ||
| shopped this store since a | ||
| preselected shopping date, and may be | ||
| used for targeted marketing such as | ||
| mailings | ||
It may thus be seen that the program of
Alternatively, the system may use dollar amounts to determine an “infrequent shopper”. If the system determines that the cumulative dollars spent at the store by a specified customer is equal to or less than a predetermined dollar level within a predetermined time interval, the specified customer is designated as an “infrequent shopper”.
As another alternative, the database is maintained with the shopping history for each unique check identification. Each time the system detects a check with a unique check identification number, it is checked against the database. If the last date shopped is prior to a preselected date, a signal is generated and transmitted to the POS. The check is then marked or set aside to be used to create a mailing list. Alternatively, the signal may be used to prompt the store clerk to disburse incentive coupons at the POS.
5.4. Marketing Based On Range Of Last Shopping Dates. As noted above, it would be advantageous to be able to selectively market to infrequent shoppers.
In accordance with the techniques shown in
| Step | Description | |
| 3 | Beginning of process being flowed. | |
| 5 | Check is taken for tendering purchase | |
| at retail store. | ||
| 6 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed from the MICR band, they | ||
| are combined (transit number followed | ||
| by account number) to form the | ||
| customer's unique checking account | ||
| ID. This ID is used as the primary | ||
| key for a customer database on disk | ||
| indexed by checking account ID. | ||
| 7-14 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked and the result is signaled | ||
| back to the operator. Shopping event | ||
| and dollars spent are recorded in | ||
| order to build a shopping history for | ||
| each customer's record. | ||
| 18-19 | If no record exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete of predetermined | ||
| identification criteria. | ||
| 23-26 | Shopping event and dollars spent are | |
| recorded over a period of time | ||
| sufficient in length to get a good | ||
| representation of the store's | ||
| customer base. | ||
| 27 | Create an empty TARGET FILE for | |
| writing records of customer's who | ||
| last shopped this store within a | ||
| preselected shopping date range. | ||
| 33 | Read FIRST record from the store's | |
| database of customer's check | ||
| information and related shopping | ||
| history. | ||
| 36-37 | Locate customer's LAST SHOPPING DATE | |
| from customer's shopping history and | ||
| compare with said preselected | ||
| shopping date range. | ||
| 39-43 | If this customer's LAST SHOPPING DATE | |
| falls within the range of said | ||
| preselected shopping date range, | ||
| write this record to said TARGET FILE | ||
| of customer's who have last shopped | ||
| this store within a preselected | ||
| shopping date range. | ||
| 46-48 | Read the NEXT record from said | |
| store's database of customer's check | ||
| information and related shopping | ||
| history. If END OF FILE marker is | ||
| found then proceed to step 49, | ||
| otherwise LOOP back up to step 36. | ||
| 49 | Said TARGET FILE now contains a list | |
| of the store's customers whose LAST | ||
| SHOPPING DATE falls with a | ||
| preselected shopping date range. | ||
In addition to the above, the selection criteria for an “infrequent shopper” may also include a required minimum dollar amount in a preselected time range.
5.5. Dissemination Of Point-Of-Sale Coupons And Direct Mail Coupons Based Upon Shopping
History.
A detailed description of the operation of the technique illustrated by
| Step | Description | |
| 3 | Beginning of process being flowed. | |
| 5 | Check is taken for tendering purchase | |
| at retail store. | ||
| 6 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed from the MICR band, they | ||
| are combined (transit number followed | ||
| by account number) to form the | ||
| customer's unique checking account | ||
| ID. This ID is used as a primary key | ||
| for a customer database on disk | ||
| indexed by checking account ID. | ||
| 10 | If no records exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete of predetermined | ||
| identification criteria. | ||
| 13 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked and the result is signaled | ||
| back to the operator. Shopping event | ||
| and dollars spent are recorded in | ||
| order to build a shopping history for | ||
| each customer's record. | ||
| 14-15 | The store has on hand coupons to be | |
| handed out at the point-of-sale. | ||
| These coupons may be arranged into | ||
| varying value packages. We will | ||
| assume 3 different coupon packs for | ||
| point-of-sale dispersement: | ||
| Coupon VALUE A: | ||
| For customer who has been | ||
| determined to be a SECONDARY | ||
| shopper. This would be | ||
| incentive to make them become a | ||
| PRIMARY shopper. | ||
| Coupon VALUE B: | ||
| For customer who has been | ||
| determined to be a PRIMARY | ||
| shopper. This would be a lessor | ||
| incentive package to primarily | ||
| maintain a consistency whereby | ||
| everyone receives a package. | ||
| Coupon VALUE C: | ||
| For customer who has been | ||
| determined to be a HIGH VOLUME | ||
| shopper. This incentive would | ||
| be used as a means to hold on to | ||
| especially good shoppers. | ||
| 17 | There are two methods for determining | |
| the coupon package to be dispersed at | ||
| the point-of-sale. Steps 18-21 deal | ||
| with preselected criteria analyzed | ||
| OFF-LINE and downloaded to the front | ||
| end computer. Steps 23-34 deal with | ||
| ON-LINE determination based on prior | ||
| 30 days shopping VS two preselected | ||
| dollar LIMITS (LIMIT 1 and LIMIT 2). | ||
| 18 | OFF-LINE ANALYSIS: | |
| 19 | Preselected criteria such as shopping | |
| volume, frequency, demographics, etc. | ||
| along with how they relate to the | ||
| Coupon offerings are set for OFF-LINE | ||
| analysis. | ||
| 20 | Each record is analyzed against said | |
| preselected criteria and | ||
| corresponding Coupon VALUEs are | ||
| selected and flagged. Said Coupon | ||
| VALUE information is then downloaded | ||
| to the ON-LINE processor. | ||
| 21 | On the customer's next visit, ON-LINE | |
| processor uses said downloaded Coupon | ||
| VALUE information to flag to clerk | ||
| which point-of-sale Coupon VALUE | ||
| package to disperse to the customer. | ||
| Proceed to step 40 for METHOD OF | ||
| DISPERSEMENT. | ||
| 40-46 | Coupons are dispersed either with | |
| clerk manually handing indicated | ||
| packet to customer or by ON-LINE | ||
| processor spooling selected coupon | ||
| VALUE to a point-of-sale coupon | ||
| printer, or by having the clerk mark | ||
| the check with a code so that coupons | ||
| may be subsequently distributed to | ||
| the customer by direct mail. | ||
Many of the prior art marketing techniques require the mailing of coupons to customers after the targeted database has been developed. With the techniques shown in
A third technique of distributing coupons utilizes a system to actually print, at the point-of-sale, coupons bearing the desired information based upon selected criteria. Commercially available printers may be used for generating coupons at a point-of-sale, such as disclosed in U.S. Pat. No. 4,723,212 issued on Feb. 2, 1988 and entitled Method and Apparatus for Dispensing Discount Coupons or as further disclosed in U.S. Pat. No. 4,910,672 issued Mar. 20, 1990 and entitled Method and Apparatus for Dispensing Discount Coupons. As disclosed in the two aforesaid patents, systems may be provided to generate coupons at the point-of-sale based upon the type of product purchase. In the disclosures of the above-captioned two patents, a coupon relating to a particular type of a product is generated based upon a bar code reader determining that a triggering or competing product has just been purchased by the consumer. The same coupon dispensing apparatus described in the two aforesaid patents may be utilized to print the coupons as described in
The present invention looks at the history of the shopper in question and induces the shopper to return based upon preselected criteria such as has the customer purchased above a certain amount of dollars, has the customer purchased between certain amounts of dollars or less than a certain amount of dollars, or has the customer purchased over a certain amount of merchandise over a period of time, or has the customer not been at the store to shop within a predetermined time interval. The present system provides a more efficient distribution of point-of-sale coupons, as an alternative to the circuitous and expensive route of mailing coupons.
5.6. Dissemination Of Point-Of-Sale Coupons And Direct Mail Coupons Based Upon Scanned Data.
Similarly, the stored data in processor
The present invention differs from the systems disclosed in the above-identified patents because, among other things, the present system generates coupons based upon the lack of purchase of a particular item by comparing against stored history for unique customer IDs, rather than because of the purchase of a particular item.
A more detailed description of the technique of
| Step | Description | |
| 3 | Beginning of process being flowed. | |
| 5-9 | Customer's purchase is transacted | |
| using bar code scanning cash | ||
| register. As each item is scanned, | ||
| said cash register maintains a record | ||
| of preselected criteria for each item | ||
| such a product, product group, | ||
| department, etc. for the customer's | ||
| purchase. | ||
| 10 | Check is taken for tendering purchase | |
| at retail store. | ||
| 15-16 | Once the bank's transit number and | |
| customer's checking account number | ||
| are parsed from the MICR band, they | ||
| are combined (transit number followed | ||
| by account number) to form the | ||
| customer's unique checking account | ||
| ID. This ID is used as the primary | ||
| key for a customer database on disk | ||
| indexed by checking account ID. | ||
| 19 | If no record exists, one is created | |
| for this checking account ID and the | ||
| operator is signaled the record is | ||
| incomplete and predetermined | ||
| identification criteria. | ||
| 22 | Send scanned data of said preselected | |
| criteria to the ON-LINE front end | ||
| processor. | ||
| 23 | If a record exists in the database | |
| for the customer with this checking | ||
| account ID, the completeness of | ||
| predetermined identification criteria | ||
| is checked and the result is signaled | ||
| back to the operator. Shopping event | ||
| and dollars spent are recorded in | ||
| order to build a shopping history for | ||
| each customer's record. | ||
| 24 | Processor updates customer's record | |
| with the said scanned information of | ||
| preselected criteria. | ||
| 26-27 | The store has on hand coupons to be | |
| handed out at the point-of-sale. | ||
| These coupons may be arranged into | ||
| varying packages. We will assume 3 | ||
| different coupon packs for point-of- | ||
| sale dispersement: | ||
| Coupon VALUE A: | ||
| For customer who has been determined | ||
| to be a SECONDARY shopper. This | ||
| would be incentive to make them | ||
| become a PRIMARY shopper. | ||
| Coupon VALUE B: | ||
| For customer who has been determined | ||
| to be a PRIMARY shopper. This would | ||
| be a lessor incentive package to | ||
| primarily maintain a consistency | ||
| whereby everyone receives a package. | ||
| Coupon VALUE C: | ||
| For customer who has been determined | ||
| to be a HIGH VOLUME shopper. This | ||
| incentive would be used as a means to | ||
| hold on to especially good shoppers. | ||
| 29 | There are two methods for determining | |
| the coupon package to be dispersed at | ||
| the point-of-sale. Steps 30-33 deals | ||
| with preselected criteria analyzed | ||
| OFF-LINE and downloaded to the font | ||
| end computer. Steps 35-46 deals with | ||
| ON-LINE determination based on prior | ||
| 30 days shopping VS two preselected | ||
| dollar LIMITS (LIMIT 1 and LIMIT 2). | ||
| 30 | OFF-LINE ANALYSIS: | |
| 31 | Preselected criteria such as shopping | |
| volume, frequency, demographics, etc. | ||
| along with how they relate to the | ||
| Coupon offerings are set for OFF-LINE | ||
| analysis. | ||
| 32 | Each record is analyzed against said | |
| preselected criteria and | ||
| corresponding Coupon VALUEs are | ||
| selected and flagged. Said Coupon | ||
| VALUE information is then downloaded | ||
| to the ON-LINE processor. | ||
| 33 | On the customer's next visit, ON-LINE | |
| processor uses said downloaded Coupon | ||
| VALUE information to flag to clerk | ||
| which point-of-sale Coupon VALUE | ||
| package to disperse to the customer. | ||
| Proceed to step 40 for METHOD OF | ||
| DISPERSEMENT. | ||
| 35 | ON-LINE 30 DAY ANALYSIS: | |
| 36 | Two dollar limits are preselected, | |
| ie: | ||
| LIMIT 1 = 100.00 | ||
| LIMIT 2 = 350.00 | ||
| 37 | Prior dollars spent for the previous | |
| 30 days are calculated and compared | ||
| with said preselected dollar limits. | ||
| 38-39 | If prior dollars spent for previous | |
| 30 days is LESS THAN LIMIT 1, | ||
| customer is considered a SECONDARY | ||
| shopper; Coupon VALUE A is dispersed | ||
| to customer. Proceed to step 51 to | ||
| determine WHICH coupons to disperse. | ||
| 42-43 | If prior dollars spent for previous | |
| 30 days is GREATER THAN LIMIT 1, but | ||
| LESS THAN LIMIT 2, customer is | ||
| considered a PRIMARY shopper; Coupon | ||
| VALUE B is dispersed to customer. | ||
| Proceed to step 51 to determine WHICH | ||
| coupons to disperse. | ||
| 46 | If prior dollars spent for previous | |
| 30 days is GREATER THAN LIMIT 2, | ||
| customer is considered a HIGH VOLUME | ||
| shopper; Coupon VALUE C is dispersed | ||
| to customer. | ||
| 51-52 | Customer's database record contains | |
| fields to monitor preselected | ||
| shopping activities such as purchase | ||
| of particular products, product | ||
| groups, departments, etc. | ||
| 54 | Processor has determined what VALUE | |
| of coupons to be dispersed, now said | ||
| database fields monitoring | ||
| preselected shopping activities are | ||
| used to determine which coupons in | ||
| particular to disperse based upon | ||
| exception to previous shopping | ||
| activity. | ||
| 55 | MAX-SUB represents the number of said | |
| preselected items (products, product | ||
| groups, departments, etc.) being | ||
| maintained and monitored for shopping | ||
| activity. | ||
| 56 | TABLES represent a table of coupons | |
| that represent incentives for each | ||
| said preselected item (products, | ||
| products groups, departments, etc.). | ||
| TABLES are arranged in order of | ||
| decreasing priority. | ||
| 61-70 | Step through each said-preselected | |
| item in decreasing priority and check | ||
| for an exception in shopping | ||
| activity. If the customer has not | ||
| shopped this preselected item, this | ||
| particular Coupon is chosen for | ||
| dispersement. This process continues | ||
| through said preselected items until | ||
| the total value of Coupons chosen for | ||
| dispersement meets or exceeds said | ||
| VALUE as determined in steps 29-46. | ||
| 74-78 | If after stepping through said | |
| preselected items and the value of | ||
| dispersement does not meet or exceed | ||
| said VALUE as determined in steps 29- | ||
| 46, an alternate table of general | ||
| incentive coupons in order of | ||
| decreasing priority is stepped | ||
| through until said VALUE is met or | ||
| exceeded. | ||
| 83-88 | Coupons are dispersed either with ON- | |
| LINE processor spooling selected | ||
| Coupons to a point-of-sale coupon | ||
| printer or via Direct Mail. | ||
5.7 Second Alternate Embodiment of Payment Processing and Point-of-Sale Marketing System.
The previously described check verification system of FIGS.
The present system provides automatically printed coupons at the point-of-sale, or alternatively, later mailed coupons, which are particularly targeted to a customer based upon his prior shopping history. Alternatively, an output might be provided to a smart card by encoding the smart card with incentives for the next visit. Alternatively, an electronic incentive could be stored in the processor for use in conjunction with the user's identification such that credit can be automatically given at the subsequent purchase times.
The system shown in FIGS.
The present system also enables the tracking of customer buying to determine how they spend. Thus, the present system may be used to obtain an average which may be weighted in order to provide a base dollar spent per visit or per week on a particular product, in a particular store department, or in a particular store. This base may then be looked at by the present system and incremental increases may be added in order to provide a target for expected behavior. The system may then generate coupons or issue incentives to induce that higher level of performance by the customer. The performance of a customer is tracked and incentives are modified based upon the criteria of performance such that incentives are added or subtracted.
Further, the present system enables the tracking of products purchased by a customer. If a customer continuously buys a certain type of product, such as a certain type of coffee or a particular size of a brand of wieners, the system will track those purchases so that coupons can be printed out at the point-of-sale which relate to products which the customer has previously indicated a tendency to buy. It has been found that by storing a shopper's prior history and by generating coupons for particular products which he desires to buy, such coupons provide an increased inducement to shop more frequently or to spend more money in the store. Alternatively, it prevents the issuance of coupons which the customer has no interest in obtaining the product covered by the coupon, which does not enhance the value of the incentive.
The system can also predict a customer's next due date to purchase a type of product. If a customer begins a pattern of buying a certain type of diapers, but the customer is an infrequent shopper or sub-par spender, this system may induce that customer to shop more often or to spend more by issuing an incentive to the customer to purchase diapers at the time which the customer's history has indicated that the customer buys diapers. By tracking the purchase cycle of various products, the system can anticipate the next purchase date in order to issue incentives prior to that anticipated purchase date, or issue other incentives if the next purchase date passes and no purchase is made. The system also can provide inducement coupons that can be combined. For example, coupons may be generated for a detergent for customers who buy diapers. If a customer continuously buys coffee, a coupon can be generated by the system to provide an incentive on coffee filters. If a customer tends to buy spaghetti sauce at a particular time, the system can generate a coupon to provide a coupon on spaghetti. The system thus uses a prior shopping history of the customer in order to provide the type of coupon most likely to provide an incentive.
The system also enables the tracking of “bargain hunter” customers. Retail stores traditionally stock depending upon the size and amount of floor space. In grocery stores, between 30,000 and 60,000 items may be stocked at any point in time. Several hundreds of these items may be involved in some type of promotion by the manufacturer or distributors of the product, or the store. The present system stores a shopping history or spending history of the customer to identify whether or not the customer is a “bargain hunter” and to what degree the customer is price sensitive.
For example, the system might be loaded with one hundred different generic food items in the grocery store as leading indicators. For example, cola might be a leading indicator. Using these generic food items, the system can store the absolute number of generics purchased by a particular customer or the ratio of generics to non-generics, or alternatively the proportion of generic expenditures to total expenditures. This information enables the system to arrive at a picture of how price driven a particular customer is or how price motivated the customer is. This information is then used to determine how to best incent the customer.
Another aspect of the system is the detecting and storing of the amount of redemption of coupons by a customer. Customers who are obsessed with savings will clip more such coupons and redeem more coupons. By storing the number of deeply discounted items to set up a leading indicator of discounted items, customers who redeem such deeply discounted items may be detected to identify a “bargain shopper”, such that incentives may be generated at the point-of-sale in order to enable that customer to be incented. The electronic cash register detects such coupons by scanning and that information is monitored by the present system so that the coupon cashing history of a customer may be stored and maintained.
This technique for targeting customers who are price sensitive enables a retailer to better use the sales promotions provided to him. If a store owner has the opportunity to give a substantial cost reduction on a product, he may send out a large number of the coupons by direct mail and hope that very few of the coupons are returned, since people who buy their soap at full list price would tend to average the store's gross profit upward. Alternatively, the retailer could advertise the price reduction in a newspaper. However, with the use of the present system, coupons may be intelligently printed out at the point-of-sale based upon an index of pricing and spending that the customer has accumulated in order to provide those coupons only to price sensitive customers. For example, if $1 is being provided by the manufacturer as a promotional discount to the retailer on a box of soap, a very price sensitive customer may be given the full $1 rebate, as the system determines that these shoppers need the maximum inducement since that is what drives their purchases. However, when a customer has shown not to be price sensitive and coupon driven, that customer might be provided with only a 50¢ discount on the box of soap, thus enabling the retailer to maintain the other 50¢ as a gross profit. This will not affect the purchases by many customers who are not price sensitive.
Another aspect of the present invention is the generation of a random or lottery coupon. The system may be programmed to reward random customers with a particular reward. For example, every repeat customer might receive a coupon for a free turkey or six-pack of drinks by the coupon printer. Alternatively, the generation of such gifts could be randomly generated in order to provide more of a lottery atmosphere to the awards. Different types of shoppers, as determined by their shopping history, might be provided with different random prizes. Alternatively, a “grab bag” coupon may be issued which covers a group of incentives, which may be accessed in a random fashion as will be subsequently described.
The system may also be used to generate installment coupons, such that the customer does not get the ultimate prize but points toward a prize. For example, each shopping trip might result in five points given toward a prize, such that when the customer accumulates all twenty-five points he may obtain a free turkey or other food item.
As previously noted, the present system normally uses ID numbers obtained from financial instruments such as checks, rather than relying solely on store produced shopping cards. Such store produced cards have been found to have substantial barriers to their use. First of all, there is an overriding negative psychological impact in that there is an implied presumption that the customer does not have sufficient worth to tender currency for a transaction, if it is a requirement of the merchant that the customer belong to the “club”. Such a requirement may imply to the customer that his money is not good enough for the store; that is a strong psychological barrier to participation. It may also be an affront to customers when a visible system like prior card-based systems are employed that require the customer participate in the program in order to shop.
In addition, it provides a barrier to physical participation because building a database with a card based system is a two step process, as opposed to a one step process when one employs customer ID based on transactionism. First of all, the customer has to sign up at the store because the name and address have to be recorded and usually merchants ask for additional demographic data. There are a large number of customers who regard that as an invasion of privacy and so are very reluctant to provide that sort of personalized information. Whereas on the transparent system of the present invention using ID's issued by a financial institution, there is no perceived invasion of privacy. Additionally, there is a barrier to participation by merchant cards caused by the need to constantly carry and constantly produce that ID at the point-of-sale. It has been the experience of most retailers that with respect to store cards, if customers can be induced to sign up at all, in very short order there is an enormous attrition because people lose them or they simply lose patience with the system with the slow-down at the point-of-sale. Over a period of time, the attrition rate for such merchant cards means that there is a continued drive and cost associated with that drive to resolicit people with the signup. Failure to get participation means that the data is less valid and that the participation from the standpoint of marketing intracity is dramatically reduced. So, the stores wind up having a small customer base that is contingent upon voluntary active participation of customers on the one hand, versus near universal participation using the present system because it is invisible or transparent to the customer.
FIGS.
The outputs of each of the ECRs
The present system also couples to the conventional ECR network through a passive listening device
Alternatively, direct data transfer could be provided from each individual ECR to each individual AP/M terminal. Also, the function of controller
Also referring to
In operation of the system shown in
The advantage of using the account numbers on financial or transaction instruments is that the account numbers are preissued by companies other than the retail store, thus saving the store from the difficulty and expenses of issuing cards or identification numbers. Furthermore, all customers except those paying cash will have such preissued numbers. Further, the identification numbers can be automatically read during the payment cycle, thus saving time and facilitating targeted marketing during the sales procedure. Each of the present AP/M terminals
Data relating to the customer's unique identification code is applied from the individual AP/M
In dependence upon the credit check and the shopping history, as previously defined in this application and as will be subsequently described in greater detail with respect to this embodiment, the CVC controller
As will be described in greater detail, the present system thus enables a store to provide credit verification as well as to maintain accurate information regarding the shopping habits of its individual customers and to target marketing to those customers based upon the customer's individual shopping history. The present technique thus allows the targeting and incentive marketing of infrequent shoppers, as previously described and as will be described in subsequent detail.
Also coupled to the AP/M
In operation of the system shown in
For example, if a debit card is swiped through the debit card reader
If the customer provides a smart card for payment of the purchases just made, the smart card would be swiped through the smart card reader
If a credit card is used for payment at the POS, the credit card is swiped through the reader
As further shown in
Although various types of payment instruments and identification instruments have been illustrated for use with the AP/M in
| Step | Description | |
| 1 | Load Bar Code Tracking Table (“BCTT”) | |
| into CVC Master Controller 965. This | ||
| is a table of Universal Product Codes | ||
| (UPCs) from selected products and | ||
| coupons. This table signals the | ||
| processor to store the purchase of | ||
| these products for individual | ||
| accounts. In addition, this table | ||
| stores information about the product | ||
| to be used for marketing purposes | ||
| such as: | ||
| Incentive level from 1 to 10 | ||
| prioritizing store's inclination | ||
| to use product as an incentive. | ||
| A profile level from 1 to 10 | ||
| that would be used to indicate | ||
| the economical level of the | ||
| product or coupon redemption. | ||
| These levels are used to build | ||
| an economic profile on an | ||
| account based on historical | ||
| purchases | ||
| Product complements. These | ||
| complements provide references | ||
| to other products in the table | ||
| that could be used with this | ||
| product. | ||
| Retail cost of product | ||
| 2 | Clerk scans product with UPC Bar Code | |
| scanner 966 connected to ECR network. | ||
| 3 | As the UPC is sent to the ECR | |
| Controller, a passive listening | ||
| device 964 detects the product UPC | ||
| code and the ECR from which it was | ||
| sent. | ||
| 4 | The passive listening device 964 | |
| sends UPC code and source ECR to the | ||
| CVC controller 965. | ||
| 5 | Controller 965 checks for UPC in the | |
| BCTT. | ||
| 6 | If UPC is in the BCTT: | |
| 7 | If UPC is a redeemed NOW coupon which | |
| was dispensed to the customer on a | ||
| previous visit. | ||
| 8 | Controller 965 updates coupon | |
| databases to reflect redemption of | ||
| coupon. | ||
| 9 | Controller 965 has a holding | |
| workspace for each ECR where any | ||
| products scanned that contain matches | ||
| in the BCTT may be written and held | ||
| until the Customer's account number | ||
| is entered. | ||
| Write this UPC to the holding | ||
| workspace for this ECR. | ||
| 10 | If there are more items to scan, GOTO | |
| 2. | ||
| Step | Description |
| | |
| 11 | ECR 962 now sends the total for this |
| purchase to the AP/M. If the AP/M | |
| 963 and ECR are not integrated, the | |
| clerk enters the total by hand. | |
| 12 | AP/M 963 sends this total to the CVC |
| controller 965. | |
| 13 | Choose a method for paying. |
| 14 | If paying with a personal check: |
| 15 | Clerk runs check through the MICR |
| reader which sends the MICR code to | |
| the AP/M. | |
| 16 | AP/M sends the MICR code to the |
| controller 965. | |
| 17 | Controller parses the MICR removing |
| the sequence number to form an | |
| account number. | |
| 18 | Controller verifies the check's |
| account number against stored | |
| positive and negative databases. | |
| 19 | Controller sends verification back to |
| the AP/M 963 for display to the | |
| clerk. | |
| 20 | If paying with a credit card: |
| 21 | The credit card is swiped in the |
| magnetic card swipe which reads the | |
| account number and sents it to the | |
| AP/M 963. | |
| 22 | AP/M 963 sends the account number to |
| the controller 965. | |
| 23 | Controller 965 initiates a phone call |
| via modem to a payments processing | |
| switch. The credit card account | |
| number and amount to tender are sent | |
| for verification. | |
| 24 | Controller 965 sends result |
| verification to the AP/M 963 for | |
| display back to the clerk. | |
| 25 | A receipt is printed out on the |
| receipt printer, ECR printer, or | |
| coupon printer 976. | |
| 26 | If paying with a debit card: |
| 27 | Debit card is swiped in a magnetic |
| card swipe which reads the account | |
| number and sends to the AP/M 963. | |
| 28 | A message is sent to the PIN pad for |
| the customer to enter their PIN | |
| number. Customer enters PIN and it | |
| is sent to AP/M. | |
| 29 | AP/M 963 sends account number and PIN |
| to controller. | |
| 30 | Controller 965 initiates phone call |
| via modem to a payments processing | |
| switch. The customer's debit card | |
| bank number, PIN, amount, and store's | |
| bank account number for transfer of | |
| funds are sent to the switch for | |
| processing. | |
| 31 | Controller 965 sends the completion |
| status to the AP/M for display to | |
| clerk. | |
| 32 | Receipt is printed on receipt |
| printer, ECR printer, or coupon | |
| printer 976. | |
| 33 | If paying with an Automatic Clearing |
| House (ACH or electronic check) card. | |
| 34 | ACH card is swiped in a magnetic card |
| swipe which reads the account number | |
| and sends to the AP/M 963. | |
| 35 | A message is sent to the PIN pad for |
| the customer to enter their PIN | |
| number. Customer enters PIN and it | |
| is sent to the AP/M. | |
| 36 | AP/M sends account number and PIN to |
| controller. | |
| 37 | Controller initiates phone call via |
| modem to a payments processing | |
| switch. The customer's ACH card bank | |
| number, customer bank account number, | |
| PIN, amount, and store's bank account | |
| number for transfer of funds are sent | |
| to the switch for processing. | |
| 38 | Controller sends the completion |
| status to the AP/M for display to | |
| clerk. | |
| 39 | Receipt is printed on receipt |
| printer, ECR printer, or coupon | |
| printer. | |
| 40 | If paying with an Electronic Benefits |
| (EBS or electronic food stamps) Card: | |
| 41 | EBS card is swiped in a magnetic card |
| swipe which reads the account number | |
| and sends to the AP/M. | |
| 42 | A message is sent to the PIN pad for |
| the customer to enter their PIN | |
| number. Customer enters PIN and it | |
| is sent to AP/M. | |
| 43 | AP/M 963 sends account number and PIN |
| to controller. | |
| 44 | Controller initiates phone call via |
| modem to a payments processing | |
| switch. The customer's EBS card | |
| account number, PIN, and amount are | |
| sent to the switch for processing. | |
| 45 | Controller sends the completion |
| status to the AP/M for display to | |
| clerk. | |
| 46 | Receipt is printed on receipt |
| printer, ECR printer, or coupon | |
| printer 976. | |
| Step | Description | |
| 47 | If customer is paying with cash: | |
| 48 | Choose a shopping card: | |
| 49 | If shopping card has a magnetic | |
| stripe: | ||
| 50 | Swipe shopping card in magnetic card | |
| swipe which reads the account number | ||
| and sends it to the AP/M. | ||
| 51 | If shopping card is a “Smart” card. | |
| 52 | “Smart” card contains a computer chip | |
| that can be read and written to. | ||
| Slide “Smart” card into read/write | ||
| device which reads the information on | ||
| the card and sends it to the AP/M. | ||
| 53 | If shopping card is not machine | |
| readable: | ||
| 54 | Clerk keys card number into AP/M | |
| 55 | AP/M sends shopping card account | |
| number to controller. GOTO 60. | ||
| 56 | If shopping card has a UPC Bar Code: | |
| 57 | Scan UPC on ECR's scanner. | |
| 58 | Passive device reads UPC code and | |
| source ECR from ECR network. | ||
| 59 | UPC code and source ECR's register | |
| number are sent to the controller. | ||
| Step | Description | |
| 60 | If no account number from payment | |
| medium or shopping card: | ||
| 61 | Clerk obtains customer's phone | |
| number. | ||
| 62 | If no phone number obtained, GOTO 122 | |
| 63 | Clerk enters phone number into AP/M | |
| which is sent to the controller. | ||
| Controller builds a CASH account key | ||
| based on phone number and accesses | ||
| this record. GOTO 67. | ||
| 64 | A customer database resides on the | |
| mass storage device of the CVC | ||
| controller. This database is keyed | ||
| on an account number and contains | ||
| shopping history based on past visits | ||
| to the store. | ||
| Controller searches customer database | ||
| for account's record. | ||
| 65 | If account is not found: | |
| 66 | Account is added to customer | |
| database. | ||
| 67 | A secondary database resides on the | |
| mass storage device of the CVC | ||
| controller. This database contains | ||
| shopping history based on visits to | ||
| OTHER stores within a network of | ||
| grocery stores. This prevents stores | ||
| in a network from incenting customers | ||
| from each other. | ||
| Controller searches secondary | ||
| database for account's record. | ||
| 68 | If account has record(s) in secondary | |
| database: | ||
| 69 | History from customer database and | |
| secondary database are merged. | ||
| 70 | While products were scanned for this | |
| customer account, a holding workspace | ||
| was built to hold any matches from | ||
| products scanned in the BCTT as | ||
| described in steps 1-10. | ||
| Access first item from this holding | ||
| workspace. | ||
| 71 | If an item is accessed from the | |
| holding workspace: | ||
| 72 | The controller maintains for each | |
| account number a list of items (ITEM | ||
| LIST) that the customer has purchased | ||
| from the BCTT. This ITEM LIST | ||
| retains information such as: | ||
| Total purchases | ||
| Last purchase information | ||
| including date and quantity. | ||
| A running purchase frequency | ||
| reflecting the average days | ||
| between each purchase. | ||
| Update ITEM LIST to reflect this | ||
| purchase. | ||
| 73 | Access next item from holding | |
| workspace. GOTO 71. | ||
| Step | Description | |
| 74 | Any number of accounts may be | |
| combined for a single household if a | ||
| link exists. A telephone number is | ||
| often on personal checks, may be | ||
| required on credit and debit card | ||
| transactions, or may be volunteered | ||
| by the customer. The phone number is | ||
| used in this process to provide a | ||
| link. | ||
| Check account's customer record for a | ||
| phone number. | ||
| 75 | If no phone number: | |
| 76 | Send message to AP/M for clerk to | |
| obtain phone number and enter into | ||
| the system. | ||
| 77 | If phone number is NOT obtained, | |
| other accounts from customer's | ||
| household cannot be merged. GOTO 82. | ||
| 78 | A phone number has been used to build | |
| a secondary key index so that all | ||
| records with the same phone number | ||
| may be accessed very quickly. These | ||
| records will be combined to form a | ||
| single marketing record. | ||
| Build this secondary key and access | ||
| first record. | ||
| 79 | Merge history from this record into | |
| marketing record. | ||
| 80 | Access the next record keying on | |
| phone number. | ||
| 81 | If next record exists, GOTO 79. | |
| Step | Description | |
| 82 | Coupon “A” (for Absence) is used by | |
| the system to identify shoppers that | ||
| are determined to be infrequent. | ||
| Each store tailors and stores a | ||
| definition of the infrequent shopper | ||
| and a program to incent them which is | ||
| stored on-line as follows: | ||
| The method of determining | ||
| infrequent shopper: | ||
| 1. | Based on dollars spent in the | |
| prior specified number of days. | ||
| or, | ||
| 2. | An attendance record based on | |
| weekly attendance in the prior | ||
| specified number of weeks. | ||
| The level of incentive for | ||
| infrequent shopper: | ||
| 1. | Multiple levels based on average | |
| amount of purchases. For | ||
| example, an infrequent shopper | ||
| with an average purchase of $137 | ||
| would be incented more than an | ||
| infrequent shopper with an | ||
| average purchase of $23. | ||
| or, | ||
| 2. | Multiple levels based on the | |
| number of weeks attended in the | ||
| prior specified number of weeks. | ||
| For example, an infrequent | ||
| shopper that recorded an | ||
| attendance in 0 of the prior 8 | ||
| weeks could be incented more | ||
| than an infrequent shopper that | ||
| recorded an attendance in 3 of | ||
| the prior 8 weeks. | ||
| Coupons to be used for incenting | ||
| the infrequent shopper. | ||
| Once a customer is identified as an | ||
| infrequent shopper, the customer | ||
| record is updated with a Coupon “A” | ||
| status and level. For example, the | ||
| customer above attending 0 weeks in | ||
| the last 8 weeks may be identified as | ||
| an “A1” while the customer attending | ||
| 3 weeks in the last 8 weeks may be | ||
| identified as an “A4”. | ||
| Logically, the “A1” series of coupons | ||
| stored would be of higher incenting | ||
| value than “A4” series. | ||
| Each Coupon “A” level of coupons is | ||
| stored in a series based on 1 to 32 | ||
| shopping trips. For example, the | ||
| first trip that the “A1” level of | ||
| infrequent shopper is identified may | ||
| produce 8 coupons at a value of | ||
| $35.00. Subsequent trips #2, #3, and | ||
| #4 may produce 6 coupons valued at | ||
| $25.00. Subsequent trips #5 thru #10 | ||
| may produce 4 coupons valued at | ||
| $20.00, etc. | ||
| Criteria for Super “A” for | ||
| customers not responding to the | ||
| Coupon “A” program. | ||
| This criteria is based on a number of | ||
| days since the last incentives were | ||
| given to the customer. For example, | ||
| the level “A1” infrequent shopper | ||
| above is given the 8 coupons valued | ||
| at $35.00 and does not come back | ||
| until 8 weeks later. If the criteria | ||
| for Super “A” is 30 days, this | ||
| infrequent shopper is now branded | ||
| Super “A” level 1 (“SA1”) and will | ||
| receive heavier incentives. | ||
| Super “A” coupons are stored in the | ||
| same level and series method as | ||
| described for Coupon “A”. Upon | ||
| completion of a Super “A” program, | ||
| the infrequent shopper falls back | ||
| into the Coupon “A” program where | ||
| they became a Super “A”. | ||
| 83 | Each account record holds fields for | |
| tracking coupon programs. These | ||
| fields include: | ||
| Coupon type (“A1”, “A2”, etc.) | ||
| Number of trips for this | ||
| customer while in the coupon | ||
| program. | ||
| Super type (“SA1”, ”SA2, blank | ||
| if none) | ||
| Number of trips for this | ||
| customer while in the “super” | ||
| program. | ||
| 84 | If customer is currently in a Super | |
| “A” program: | ||
| 85 | Increment the field for number of | |
| trips in Super “A”. | ||
| 86 | If Super “A” program is complete, | |
| customer falls back into Coupon “A” | ||
| program where they left off. GOTO | ||
| 92. | ||
| If Super “A” program is NOT complete, | ||
| GOTO 89. | ||
| 87 | If customer is NOT currently in a | |
| Coupon “A” program, GOTO 93. | ||
| 88 | If number of days since last visit | |
| exceeds preset criteria for | ||
| determining Super “A” GOTO 89. | ||
| Otherwise, GOTO 90. | ||
| 89 | Mark account to receive Super “A” | |
| coupons. This information will be | ||
| used later when building a list of | ||
| coupons to be spooled to the | ||
| customer. GOTO 106. | ||
| 90 | Increment the field for number of | |
| trips as Coupon “A”. | ||
| 91 | If Coupon “A” program is complete, | |
| GOTO 106. | ||
| 92 | Mark account to receive Coupon “A” | |
| coupons. This information will be | ||
| used later when building a list of | ||
| coupons to be spooled to the | ||
| customer. GOTO 106. | ||
| Step | Description | |
| 93 | Choose the method to determine | |
| infrequent shopper. | ||
| 94 | If method is based on dollar volume: | |
| 95 | Sum dollars spent in prior specified | |
| number of days. | ||
| 96 | If dollars spent is less than preset | |
| value, | ||
| 97 | Initialize fields for tracking coupon | |
| programs to zeros and mark account as | ||
| Coupon “A”. GOTO 102. | ||
| Otherwise GOTO 106. | ||
| 98 | If method is based on weekly | |
| frequency: | ||
| 99 | Build a weekly attendance record in | |
| the last preset number of weeks based | ||
| on one or more visits during each | ||
| prior 1 week span. For example, if | ||
| in the last 8 weeks this shopper had | ||
| 3 trips, but they were all in the | ||
| same week, this customer's attendance | ||
| record would reflect 1 week's | ||
| attendance in the last 8 weeks. | ||
| 100 | If the number of weeks attending does | |
| not fall below the preset criteria, | ||
| GOTO 106. | ||
| 101 | Initialize fields for tracking coupon | |
| programs to zeros and mark account as | ||
| Coupon “A”. | ||
| 102 | Determine the incentive level to be | |
| stored with this Coupon “A” | ||
| infrequent shopper. | ||
| 103 | If the method to determine incentive | |
| level is based on the number of | ||
| weekly attendances: | ||
| Access preset criteria for assigning | ||
| an incentive level based on | ||
| attendance. For example, the | ||
| criteria may assign level 1 for 0 | ||
| weeks attended in the prior 8 weeks, | ||
| level 2 for 1 weeks attended in the | ||
| prior 8 weeks, level 3 for 2 weeks | ||
| attended in the prior 8 weeks, etc. | ||
| 104 | If the method to determine incentive | |
| level is based on the average dollars | ||
| spent per shopping visit: | ||
| Access preset criteria for assigning | ||
| an incentive level based on average | ||
| expenditures. For example, criteria | ||
| may assign level 1 for an account | ||
| with an average purchase of $100 or | ||
| more, level 2 for an average purchase | ||
| between $75 and $100, level 3 for an | ||
| average purchase between $50 and $75, | ||
| etc. | ||
| 105 | Store this level of coupon “A” in the | |
| account record. | ||
| Step | Description | |
| 106 | Coupon “M” (for Maximize) is used by | |
| the system to track average | ||
| expenditures and maintain a program | ||
| for increasing customers' average | ||
| purchases. Each store tailors | ||
| criteria for increasing average | ||
| purchases which are stored on-line as | ||
| follows: | ||
| Minimum number of trips to | ||
| qualify for Coupon “M” program. | ||
| This ensures that an account's | ||
| history has matured so that a | ||
| more accurate average may be | ||
| obtained. | ||
| Maximum dollar average to | ||
| qualify for Coupon “M” program. | ||
| This provides a ceiling to | ||
| prevent attempts to increase. | ||
| average purchases that are | ||
| considered sufficiently high. | ||
| For example, if a customer has | ||
| an average purchase of $125, it | ||
| may not be reasonable to spool | ||
| coupons incenting them to spend | ||
| $135. | ||
| Percentage to attempt increase | ||
| in average purchase. | ||
| Criteria for Super “M”. This | ||
| criteria is based on the failure | ||
| to increase average purchases by | ||
| a preset percentage of target | ||
| increase | ||
| Number of trips before testing | ||
| for Super “M” | ||
| Coupons to be used for incenting | ||
| the customer to increase | ||
| spending. These coupons are | ||
| tailored to the amount of the | ||
| customer's target value (base | ||
| average plus percentage | ||
| increase). Each coupon | ||
| contains a minimum target value | ||
| in order to trigger spooling. | ||
| For example, Customer A has an | ||
| average base of $40. Assume a | ||
| target increase of 10% to make a | ||
| target of $44 rounded to $45. | ||
| The first Coupon “M” incentive | ||
| holds a minimum target value of | ||
| $50. This coupon is NOT | ||
| spooled. The second Coupon “M” | ||
| incentive holds a minimum target | ||
| value of $45. This coupon IS | ||
| spooled with a minimum purchase | ||
| qualifier of $45. The third | ||
| Coupon “M” incentive holds a | ||
| minimum target value of $30. | ||
| This coupon IS spooled as well | ||
| with a minimum purchase | ||
| qualifier of $45. And so on for | ||
| the rest of the Coupon “M” | ||
| incentives all spooled with a | ||
| minimum purchase qualifier of | ||
| $45. | ||
| Customer B has a target value of $35. | ||
| For this customer, the first and | ||
| second Coupon “M” incentives are not | ||
| spooled because this target value | ||
| does not meet the minimum. The third | ||
| incentive with a $30 minimum target | ||
| value IS spooled with a minimum | ||
| purchase qualifier of $35. And so on | ||
| with the rest of the Coupon “M” | ||
| incentives as is done for Customer A, | ||
| except now the minimum purchase | ||
| qualifier will be $35. | ||
| 107 | As is done with Coupon “A”, each | |
| account record holds fields for | ||
| tracking coupon programs for Coupon | ||
| “M”. These fields include: | ||
| Coupon “M” base. The base | ||
| average arrived at when the | ||
| program was initiated. | ||
| Number of trips on Coupon “M” | ||
| program. | ||
| Super “M” flag to indicate | ||
| account is in Super “M” program. | ||
| Number of trips on Super “M” | ||
| program. | ||
| 108 | If account is currently on a Super | |
| “M” program: | ||
| 109 | Calculate average purchase amount of | |
| purchases since beginning Super “M”. | ||
| 110 | If average while on Super “M” exceeds | |
| preset criteria for percentage of | ||
| increase of base, GOTO 121. | ||
| 111 | Mark account to receive Super “M” | |
| coupons. Increment Super “M” | ||
| counter. GOTO 122. | ||
| 112 | If account is not currently in a | |
| Coupon “M” program: | ||
| 113 | If the number of trips does not meet | |
| the minimum trips specified to | ||
| qualify for Coupon “M”, GOTO 122. | ||
| 114 | Calculate a base average purchase | |
| amount for this account. Initialize | ||
| fields for Coupon “M” in account's | ||
| record to zeros and store base | ||
| average. | ||
| 115 | If base average is greater than | |
| preset ceiling criteria, GOTO 122. | ||
| 116 | Calculate a target value by adding | |
| preset percentage increase of base to | ||
| the base value. | ||
| 117 | Increment Coupon “M” program trip | |
| counter. If number of trips in | ||
| Coupon “M” program is greater than or | ||
| equal to preset criteria determining | ||
| number of trips before testing | ||
| results: | ||
| 118 | Calculate average purchases while | |
| onCoupon “M” program. | ||
| 119 | If average is less than preset | |
| criteria percentage increase for | ||
| Super “M”. GOTO 111 | ||
| 120 | If average is greater than target | |
| value, objective has been achieved. | ||
| GOTO 122 | ||
| 121 | Mark account to receive Coupon “M” | |
| Coupons. | ||
| EXAMPLE: Customer makes a purchase. | ||
| History shows this customer has made | ||
| 11 purchases including this purchase. | ||
| The preset criteria for minimum trips | ||
| required to qualify for Coupon is | ||
| set to 10, so this customer now | ||
| qualifies. Assume the average of | ||
| these 11 purchases is $25. This is | ||
| stored in the record as the base. | ||
| The preset criteria for maximum base | ||
| ceiling for Coupon “M” for this | ||
| example is $50. This means any | ||
| account with an average purchase of | ||
| $50 or more does not qualify for | ||
| Coupon “M”. This account's average | ||
| is less than $50 so the Coupon “M” | ||
| tracking counters are set to zero and | ||
| the program begins. | ||
| Assume the preset percentage increase | ||
| is 20%. A target is arrived at by | ||
| adding 20% of the base to the base | ||
| in this case $25 + $5 or a $30 | ||
| target. Coupons are spooled with a | ||
| minimum purchase qualifier of $30 as | ||
| described previously. | ||
| Assume the preset value for number of | ||
| trips before testing results is 5, | ||
| then on the fifth trip an average is | ||
| calculated for the trips since | ||
| beginning Coupon “M”, or in this case | ||
| the last 5 trips. If in this example | ||
| these last 5 trips averaged $35, the | ||
| Coupon “M” program would be complete. | ||
| If the average was still $25, and | ||
| preset criteria to determine Super | ||
| “M” specified that more than 50% of | ||
| target increase should be achieved | ||
| (in this case $27.50), then this | ||
| account falls into Super “M”. | ||
| Step | Description | ||
| 122 | Build a list of Coupons to be spooled | ||
| to the customer. Coupons are stored | |||
| and accessed based on type: | |||
| Standard - these are coupons that | |||
| everyone gets regardless of shopping | |||
| history, special coupon programs, | |||
| dollar range, etc. These are usually | |||
| the weekly specials found in the | |||
| store's other advertisement, coupons | |||
| from other merchants, and “billboard” | |||
| coupons that simply inform. This | |||
| standard series ensures that EVERYONE | |||
| receives something. | |||
| Coupon “A” and Super “A”- these are | |||
| coupons for infrequent shoppers as | |||
| previously discussed. | |||
| Coupon “B” thru Coupon “E”- these | |||
| are coupon classes based on preset | |||
| spending ranges. | |||
| Coupon “M” and Super UMU - these are | |||
| coupons designed to increase average | |||
| purchase amounts. | |||
| First in the customer's coupon list | |||
| will be the standard series run. Set | |||
| COUPON-TYPE to STANDARD. | |||
| 123 | PERFORM BUILD-COUPON-LIST (148-163B) | ||
| and RETURN AT 124. | |||
| 124 | Now a more targeted set of coupons | ||
| will be added to the list based on | |||
| spending levels. These levels are | |||
| determined from purchase history vs | |||
| preset dollar ranges. These coupon | |||
| types are Coupon “B” thru Coupon “E”. | |||
| For example, ranges could be set up | |||
| as follows: | |||
| First Range | $25-$50 | Coupon “B” | |
| Second Range | $51-$75 | Coupon “C” | |
| Third Range | $76-$100 | Coupon “D” | |
| Fourth Range | $101+ | Coupon “E” | |
| 125 | If spending level falls below all | ||
| preset dollar ranges, GOTO 135. | |||
| 126 | If spending level falls within the | ||
| first range: | |||
| 127 | Set COUPON-TYPE to COUPON-B. GOTO | ||
| 134. | |||
| 128 | If spending level falls within the | ||
| second range: | |||
| 129 | Set COUPON-TYPE to COUPON-C. GOTO | ||
| 134. | |||
| 130 | If spending level falls within the | ||
| third range: | |||
| 131 | Set COUPON-TYPE to COUPON-D. GOTO | ||
| 134. | |||
| 132 | If spending level falls with the | ||
| fourth range: | |||
| 133 | Set COUPON-TYPE to COUPON-E. GOTO | ||
| 134. | |||
| 134 | PERFORM BUILD-COUPON-LIST (148-163B) | ||
| and RETURN at 135. | |||
| Step | Description |
| 135 | Check for enrollment in a special |
| coupon program such as “A” or “M”. | |
| 136 | If account marked for Coupon “A” |
| 137 | Set COUPON-TYPE to COUPON-A. GOTO |
| 140. | |
| 138 | If account marked for Super “A” |
| 139 | Set COUPON-TYPE to SUPER-A. |
| 140 | Set COUPON-LEVEL to coupon level |
| stored in account record as | |
| determined in steps 98-105. | |
| 141 | PERFORM BUILD-COUPON-LIST (148-163B) |
| and RETURN AT 142. | |
| 142 | If account marked for Coupon “M” |
| 143 | Set COUPON-TYPE to COUPON-M. GOTO |
| 146. | |
| 144 | If account market for Super “M” |
| 145 | Set COUPON-TYPE to SUPER-M. |
| 146 | PERFORM BUILD-COUPON-LIST (148-163B) |
| and RETURN AT 164. | |
| 147 | No special coupon program for this |
| account. GOTO 164. | |
| Step | Description | |
| 148 | SUBROUTINE BUILD-COUPON-LIST. | |
| This routine is passed the COUPON- | ||
| TYPE and COUPON-LEVEL (if applicable) | ||
| and adds coupons to be spooled to a | ||
| COUPON LIST. | ||
| 149 | One or more coupons may be stored for | |
| each COUPON-TYPE. COUPON-CNTR is | ||
| used to sequentially access each | ||
| coupon for COUPON-TYPE. | ||
| SET COUPON-CNTR to 0. | ||
| 150 | Coupons are stored as follows: | |
| COUPON-TYPE - type of coupon | ||
| COUPON-LEVEL - level of this | ||
| particular type of coupon | ||
| COUPON-CNTR - sequential counter for | ||
| accessing coupons | ||
| NUMBER-ISSUED - counter for number of | ||
| coupons issued | ||
| NUMBER-REDEEMED - counter for number | ||
| redeemed | ||
| ECHO-FLAG - flags if this is an ECHO | ||
| COUPON | ||
| ECHO-VALUE - determines value of ECHO | ||
| COUPON | ||
| HIT-CNTR - used with RANDOM COUPONS | ||
| RND-SEED - used to determine random | ||
| frequency | ||
| COUPON-DATA - text and variables used | ||
| to make the coupon | ||
| Using COUPON-TYPE, COUPON-LEVEL, and | ||
| COUPON-CNTR build a key to access the | ||
| coupon from the coupon database | ||
| 151 | If the ECHO-FLAG is set for this | |
| record in the coupon database, it | ||
| means that an ECHO COUPON is to be | ||
| added to the COUPON LIST. | ||
| An ECHO coupon is a variable coupon | ||
| that is determined based on the | ||
| customer's list of items that have | ||
| been purchased that contained matches | ||
| in the BCTT as described in 1-10 and | ||
| 70-73. An Echo coupon simply | ||
| attempts to provide the customer with | ||
| a coupon for an item that the | ||
| customer has shown a propensity to | ||
| purchase. For example, a customer | ||
| has recently purchased disposable | ||
| diapers. Based on this information, | ||
| we can determine that the way to | ||
| incent this customer is with | ||
| disposable diapers and/or with | ||
| complements to this product such as | ||
| baby wipes, baby food, etc. | ||
| If the ECHO-FLAG is set for this | ||
| coupon record: | ||
| 152 | PERFORM ECHO-COUPONS (200-211) and | |
| RETURN AT 153. | ||
| 153 | Two varieties of coupons available | |
| are random coupons and installment | ||
| coupons. | ||
| 154 | Random coupons are produced at a set | |
| frequency as determined for each | ||
| random coupon. For example, a FREE | ||
| TURKEY coupon can be set to come out | ||
| every 50th time that the coupon | ||
| record is accessed for spooling. | ||
| If, for example, this coupon is | ||
| defined for Coupon “E”, then every | ||
| 50th customer that qualifies as a | ||
| Coupon “E” would receive a coupon for | ||
| a FREE TURKEY. | ||
| If this coupon is a RANDOM COUPON: | ||
| 155 | Increment HIT-CNTR in coupon record. | |
| 156 | If HIT-CNTR matches RND-SEED. GOTO | |
| 160 | ||
| Otherwise, GOTO 161. | ||
| 157 | Installment coupons are coupons whose | |
| value is determined by the amount of | ||
| purchase. For example, if the store | ||
| is running a promotion giving away a | ||
| $10.00 U.S. Savings Bond for every | ||
| 100 BOND BUCKS redeemed, a coupon | ||
| could be defined that is worth 1 BOND | ||
| BUCK for every dollar spent. That | ||
| is, a grocery order for $75 would | ||
| produce a coupon worth 75 BOND BUCKS. | ||
| If this coupon is an INSTALLMENT | ||
| COUPON: | ||
| 158 | Determine coupon's value based on | |
| this purchase. GOTO 160. | ||
| 159 | None of the above. | |
| 160 | Add this coupon to the list of | |
| coupons to be spooled for this | ||
| transaction. | ||
| 161 | Update the coupon record with updated | |
| information based on issuance and/or | ||
| hits (for random). | ||
| 162 | Increment COUPON-CNTR. | |
| 163 | If another Coupon for this COUPON- | |
| TYPE exists, loop back through to add | ||
| it to the list. GOTO 150. | ||
| 163B | RETURN TO CALLING ROUTINE | |
| Step | Description |
| | |
| 164 | Point-of-sale incentives may be |
| spooled or stored electronically. | |
| If insentives NOT previously stored | |
| electronically, GOTO 180. | |
| 165 | Electronic coupons were previously |
| stored and will now be redeemed. | |
| Choose media for previous storage of | |
| electronic coupons. | |
| 166 | If coupons stored on a “SMART” Card: |
| 167 | AP/M accesses first coupon from |
| “SMART” card using “SMART” card | |
| read/write device. | |
| 168 | If no more coupons GOTO 180. |
| 169 | AP/M sends coupon to CVC controller. |
| 170 | CVC controller checks coupon against |
| items purchased. | |
| If item was purchased: | |
| 171 | Coupon information is sent to ECR |
| Controller. | |
| 172 | ECR Controller credits customer's |
| purchase amount for value of coupon. | |
| 173 | CVC Controller updates coupon |
| database to reflect redemption. | |
| 174 | AP/M access next coupon from “SMART” |
| card. GOTO 168. | |
| 175 | If coupons stored on mass storage |
| device in CVC controller: | |
| 176 | CVC Controller accesses first coupon |
| from storage. | |
| 177 | If no more coupons GOTO 180. |
| 178 | CVC Controller checks coupon against |
| items purchased. | |
| If item was purchased: | |
| EXECUTE steps 171-173, THEN PROCEED | |
| WITH 179. | |
| 179 | Read next coupon from CVC |
| Controller's mass storage. GOTO 177. | |
| Step | Description | |
| 180 | A coupon list was built as described | |
| in steps 122-163B and will now be | ||
| spooled. | ||
| Access first coupon from the coupon | ||
| list. | ||
| 181 | If end of coupon list, GOTO 193. | |
| 182 | Choose medium for dispensing coupons. | |
| 183 | If spooling medium is POS printer: | |
| 184 | CVC Controller sends coupon to AP/M | |
| 185 | AP/M sends coupon to printer. GOTO | |
| 192. | ||
| 186 | If spooling medium is electronic | |
| coupon on a “SMART” card: | ||
| 187 | Controller encrypts the coupon | |
| identification data. Encryption will | ||
| prevent fraudulent coupons from being | ||
| written to the card. This method | ||
| optionally allows customer with | ||
| “SMART” card to redeem coupons at any | ||
| store from within a network. | ||
| 188 | Controller sends encrypted data to | |
| AP/M. | ||
| 189 | AP/M writes coupon to “SMART” card | |
| with read/write device. Coupon | ||
| description is sent to ECR for | ||
| display on purchase receipt tape. | ||
| GOTO 192. | ||
| 190 | If spooling medium is electronic | |
| coupon on CVC controller's mass | ||
| storage device: | ||
| 191 | CVC Controller writes coupon to an | |
| electronic coupon file with a primary | ||
| key based on account number. Coupon | ||
| description is sent to ECR for | ||
| display on purchase receipt tape. | ||
| 192 | Access next coupon from the coupon | |
| list. GOTO 181. | ||
| 193 | END | |
| Step | Description | |
| 200 | PROCESS ECHO-COUPONS. | |
| 201 | If this is the first ECHO COUPON for | |
| this account: | ||
| A “ECHO COUPON LIST” will be built | ||
| for this account based on items | ||
| historically purchased and contained | ||
| in this account's ITEM LIST described | ||
| in 1-10 and 70-73. Items are | ||
| prioritized based on values located | ||
| in the BCTT. These values include | ||
| the store's perception of the item's | ||
| incentive value and the timing based | ||
| on historical purchases of the item. | ||
| For Example, a customer has | ||
| previously bought disposable diapers. | ||
| The store has rated the incentive | ||
| value of disposable diapers as a 10 | ||
| (on scale of 1 to 10), this customer | ||
| buys disposable diapers every two | ||
| weeks, and last bought disposable | ||
| diapers 10 days ago. This item would | ||
| hold a very high priority and would | ||
| probably be first in line for | ||
| incenting this customer. | ||
| On the other hand, this customer just | ||
| bought 2 boxes of cereal that is on | ||
| promotion. Due to the cereal being | ||
| on promotion, the store may rate the | ||
| incentive value at a fairly high 9, | ||
| but since the customer just purchased | ||
| 2 boxes of the cereal, and | ||
| historically had not purchased it | ||
| before, this item would hold a low | ||
| priority. Alternatively, two boxes | ||
| of cereal might be considered | ||
| sufficient inventory for now and not | ||
| a timely inducement. | ||
| 202 | Access first item from account's ITEM | |
| LIST. | ||
| 203 | If end of ITEM LIST, GOTO 207 | |
| 204 | Assign item a priority. | |
| 205 | Add item to ECHO COUPON LIST. | |
| 206 | Access next item from account's ITEM | |
| LIST. GOTO 203 | ||
| 207 | Access highest priority item from | |
| ECHO COUPON LIST. | ||
| 208 | If end of ECHO COUPON LIST, no more | |
| echo coupons left. GOTO 211. | ||
| 209 | This item will be passed back to the | |
| calling routine. Place item's UPC | ||
| code in the parameter space for | ||
| passing values back to the calling | ||
| routine. | ||
| 210 | Remove item from ECHO COUPON LIST so | |
| it will not be available for choosing | ||
| the next time through. | ||
| 211 | RETURN TO CALLING PROGRAM. | |
| Step | Description | |
| 250 | An event manager executes within the | |
| CVC Marketing Systems software so | ||
| that recurring events may be | ||
| scheduled. For this process, an | ||
| event would be scheduled for the CVC | ||
| Controller at the hub store (Hub CVC | ||
| Controller) to dial out every hour to | ||
| CVC Controllers at remote stores | ||
| (Remote CVC Controllers) for the | ||
| interchange of that previous hour's | ||
| shopping data. | ||
| Access the first event for transfer | ||
| of marketing data. | ||
| 251 | Hub CVC Controller dials out to and | |
| makes connection with the Remote CVC | ||
| Controller. | ||
| 252 | Hub CVC Controller accesses in | |
| chronological sequence the next | ||
| marketing transaction record after | ||
| the last record sent to this Remote | ||
| CVC Controller. | ||
| 253 | If a next record does not exist, GOTO | |
| 255. | ||
| 254 | Marketing transaction record is sent | |
| from Hub CVC Controller to Remote CVC | ||
| Controller for update of Remote CVC | ||
| Controller's SECONDARY DATABASE. | ||
| GOTO 252. | ||
| 255 | Hub CVC Controller sends request to | |
| Remote CVC Controller for Remote's | ||
| next transaction record in | ||
| chronological sequence after the last | ||
| transaction record sent to Hub. | ||
| 256 | If a next record does not exist, GOTO | |
| 258 | ||
| 257 | Remote CVC Controller sends marketing | |
| transaction record back to Hub CVC | ||
| Controller for update of Hub's | ||
| SECONDARY DATABASE | ||
| GOTO 255. | ||
| 258 | Hub CVC Controller disconnects from | |
| Remote and looks for the next event | ||
| for calling the next Remote in the | ||
| network of CVC Controllers. | ||
| 259 | If a next event exists, GOTO 251. | |
| 260 | Transfer of marketing data is | |
| complete. | ||
| Step | Description | |
| 261 | This procedure is executed on | |
| account's ITEM LIST as discussed in | ||
| steps 1-10 and 70-73 previously | ||
| described. | ||
| Access first item from ITEM LIST. | ||
| 262 | If no items left in ITEM LIST, GOTO | |
| 266. | ||
| 263 | Access item in stored table BCTT. | |
| 264 | Factor profile level in BCTT into | |
| level held for this account. | ||
| 265 | Access next item from ITEM LIST. | |
| 266 | End of Process. | |
| Example: The BCTT contains a number | ||
| of generic brands and coupon UPC's | ||
| with a profile value indicative of | ||
| the “bargain hunter” value of the | ||
| product or coupon. Assume Customer A | ||
| purchases a large number of generic | ||
| items and redeems many coupons, this | ||
| customer on a scale of 1 to 10 may | ||
| have a profile value of 9. On the | ||
| other hand, Customer B purchases many | ||
| items that either have no match in | ||
| the BCTT, or items in the BCTT that | ||
| indicate that price is little or no | ||
| object for this consumer. Customer B | ||
| may have a profile value of 1. | ||
| Step | Description | |
| 267 | Access the target coupon from the | |
| Coupon Database. | ||
| 268 | This coupon has a variable value | |
| associated with it. Match this | ||
| account's profile value with the | ||
| range of values to determine the | ||
| value of the coupon. | ||
| 269 | If value is not greater than 0, GOTO | |
| 272. | ||
| 270 | Build coupon based on value. | |
| 271 | Pass coupon back to calling procedure | |
| so it may be added to the coupon list | ||
| for dispersement. | ||
| 272 | End of Process. | |
| These profile values may now be used | ||
| as an indication of how much value to | ||
| assign to individual coupons. The | ||
| assumption being that customers with | ||
| a high profile value require greater | ||
| incentive than those with lower | ||
| value. | ||
| Example: Assume a manufacturer is | ||
| promoting a particular product and is | ||
| selling the product to the store at | ||
| $1.00 off the regular cost. Using | ||
| profiles, the store can regulate the | ||
| amount off for each customer based on | ||
| their profile value. Assume both | ||
| customers in the previous example are | ||
| to receive this promotion at the | ||
| point-of-sale. Customer A has | ||
| demonstrated that he/she only buys | ||
| cut-rate products at the lowest price | ||
| (profile value of 9). If the value | ||
| of the coupon is set up on a straight | ||
| line relation to profile, then this | ||
| customer would receive a coupon | ||
| offering 90¢ off. In contrast, | ||
| Customer B has demonstrated little | ||
| sensitivity to price (profile of 1) | ||
| and therefore needs less incentive to | ||
| buy this product. He/she receives a | ||
| coupon for 10¢ off. | ||
The terminal further includes an EPROM
An 8-position DIP switch
A listing of the chip identification and model number for a specific embodiment of the schematic of
| DRAWING # | MFG. P/N | MANUFACTURER |
| 983 | RAPC712 | Switchcraft |
| 986 | DMC16207 | Optrex |
| 978 | TP11SH8ABE | Switchcraft |
| 979 | 27C64-2015J | Microchip |
| 977 | Z86C9320PSC | Zilog |
| 980 | SRM20256LC12 | S-MOS |
| 989 | TC74HC374AP | Toshiba |
| 990 | TC74HC139AP | Toshiba |
| 991 | SN75176BP | Texas Instruments |
| 981 | MAX232 | Maxim |
| 987 | LM2925T | Boums |
| 988 | MP9.8304MHZ | M-Tron |
Addresses for the manufacturer set forth above are as follows:
Bourns, 1200 Columbia Ave., Riverside, Calif. 92507 (714) 781-5050
M-Tron, 100 Douglas, Yankton, S.Dak. 57078 (605) 665-9321
Maxim, 120 San Gabriel Dr., Sunnyvale, Calif. 94086 (408) 737-7600
Microchip, 2355 West Chandler Blvd., Chandler, Ariz. 85224 (602) 963-7373
Optrex, div Asahi Glass, 44160 Plymouth Oaks Dr., Plymouth, Mich. 48170 (313) 416-8500
S-Mos, 2460 N 1st, San Jose, Calif. 95131 (408) 922-0200
Switchcraft, div Raytheon, 5555 N. Elston, Chicago, Ill. (312) 792-2700
Texas Instruments, 13510 N. Central Expressway, Dallas, Tex. 75243 (214) 995-2011
Toshiba, 1220 Midas Wy, Sunnyvale, Calif. 94088 (408) 739-0560
Zilog, 210 E. Hascienda Ave., Campbell, Calif. 95008 (408) 370-8000
| Step | Description | |
| 275 | The CVC AP/M terminal is powered up | |
| and boots into the AP/M program. | ||
| 276 | Initialize AP/M terminal. The AP/M | |
| address dip switches are read to | ||
| determine this AP/M's unique address. | ||
| Through-out the initialization | ||
| process the network is monitored to | ||
| ensure that no other AP/M is using | ||
| this AP/M's address. If another | ||
| AP/M is using the address, control | ||
| will jump to an infinite loop | ||
| displaying that this AP/M's address | ||
| is already being used. | ||
| The CVC Marketing Systems title is | ||
| displayed on the AP/M and the printer | ||
| if attached. Then a message | ||
| concerning issued patent protection | ||
| and patents pending is displayed and | ||
| printed as well. | ||
| 277 | Enter ID is prompted on the terminal | |
| screen to let the clerk know it is | ||
| ready to accept input. The following | ||
| steps are repeated as an infinite | ||
| loop. | ||
| The AP/M terminal resides on a | ||
| network in a STAR topology using a | ||
| single twisted pair balanced RS485 | ||
| communications standard. The hub of | ||
| the star is the CVC Controller which | ||
| acts as the master. Communications | ||
| is executed in a broadcast form with | ||
| a token passing protocol to determine | ||
| which AP/M is being addressed. In | ||
| other words, if there are 3 AP/M's on | ||
| the network, the Controller “polls” | ||
| each AP/M one at a time in order to | ||
| coordinate their activities. | ||
| When an AP/M receives a poll token | ||
| with its address, it responds with | ||
| either an ‘%’ which means “I'm here, | ||
| but I don't need anything”, or an ‘&’ | ||
| followed by data for the Controller. | ||
| The AP/M may also receive a data | ||
| token followed by data for display on | ||
| its screen or for sending to the | ||
| printer. | ||
| First the AP/M checks for data from | ||
| the RS485 network line. | ||
| 278 | If data is detected on the network: | |
| 279 | PERFORM the Polling Process (steps | |
| 288-307) and RETURN at step 280. | ||
| 280 | Peripherals such as a check reader, | |
| coupon printer, card swipe, etc. are | ||
| cabled to the AP/M terminal. These | ||
| peripherals use an RS232 | ||
| communications standard. | ||
| The AP/M checks for data coming in | ||
| from the RS232 port. | ||
| 281 | If data is detected, then GOTO 284. | |
| 282 | Data is entered from the clerk into | |
| the AP/M via a 19-key keypad on the | ||
| AP/M. | ||
| The AP/M checks for data coming from | ||
| its keypad. | ||
| 283 | If NO key has been pressed, then GOTO | |
| 277. | ||
| 284 | Data from the AP/M's keypad is | |
| terminated with a Carriage Return | ||
| (CR). Data from peripherals may be | ||
| terminated with a Carriage Return | ||
| (CR) or a Line Feed (LF). | ||
| Check now for an end of data | ||
| character. | ||
| 285 | If character is NOT a LF or CR, then | |
| GOTO 287. | ||
| 286 | End of data has been detected. Set a | |
| SEND DATA FLAG indicating that data | ||
| is to be sent to the CVC Controller | ||
| the next time the AP/M is polled. | ||
| GOTO 277. | ||
| 287 | This character will be added to the | |
| KEYPAD ENTRY PACKET which is a | ||
| holding buffer to hold data awaiting | ||
| a termination character. The AP/M | ||
| maintains separate holding buffers | ||
| for its keypad's entry and for data | ||
| coming in from the RS232 port. GOTO | ||
| 277. | ||
| Step | Description | |
| 288 | POLLING PROCESS SUBROUTINE. When a | |
| character is read off of the RS485 | ||
| network, it is analyzed to determine | ||
| if it is intended for this AP/M. The | ||
| following summarizes the polling | ||
| characters and their functions. | ||
| Assume this is an AP/M at address = 1. | ||
| Polling | ||
| Character | ||
| (Binary) Polling character's | ||
| function | ||
| 100aaaaa (0x80 | pad # (bit wise | ||
| boolean)) | ||
| This is a poll character from the | ||
| host requesting data from a specific | ||
| AP/M addressed by the binary address | ||
| ‘aaaaa’. If the addressed AP/M has | ||
| no data, it will reply with a ‘%’. | ||
| Data sent from the AP/M will be | ||
| preceded with an ‘&’. In the case of | ||
| an error in the previous command from | ||
| the host, the poll is answered with | ||
| an ‘*’. | ||
| This AP/M's poll token is 10000001 | ||
| (binary). | ||
| 101aaaaa (0xA0 | pad # (bit wise | ||
| boolean)) | ||
| This character precedes a string of | ||
| data to be displayed on the | ||
| addressed AP/M's display. | ||
| This AP/M's display data token is | ||
| 10100001 (binary) | ||
| 110aaaaa (0xC0 | pad # (bit wise | ||
| boolean) followed by 0x55 | ||
| (01010101 binary)) | ||
| These two characters precede a string | ||
| of data to be sent out of the | ||
| addressed AP/M's printer port. The | ||
| second character (0x55) is used to | ||
| ensure that the preceding token was | ||
| not arbitrary garbage. | ||
| The character string may contain the | ||
| following special function | ||
| characters: | ||
| NULL (0): Indicates that the | ||
| following character should | ||
| have the MSB set. | ||
| SOH (1): Indicates that the | ||
| following character is to | ||
| be passed to the printer if | ||
| it is a NULL or SOH. | ||
| If the following character is 2 thru | ||
| 15, then the contents of special | ||
| buffer addressed logical 1 thru 14 | ||
| respectively will be printed. If for | ||
| some reason the AP/M has no data in | ||
| the specified buffer, the next poll | ||
| request will be answered with an ‘*’. | ||
| If the following character is 16 thru | ||
| 29, then the following data stream is | ||
| to be stored in the appropriate | ||
| special buffer addressed 1 thru 14 | ||
| respectively. This data stream will | ||
| then be terminated with a combination | ||
| SOH (1) followed by either 16 thru 29 | ||
| to jump to another special buffer | ||
| address for loading a data stream, a | ||
| 2 thru 15 to jump to a special buffer | ||
| for spooling to the printer, or any | ||
| character greater than 29 to simply | ||
| terminate the load process. | ||
| This AP/M's print data tokens are | ||
| 11000001 (binary) followed by | ||
| 01010101 (binary) | ||
| 1110000000 (0xE0; followed by 0x55 | ||
| (01010101 binary)) | ||
| These two characters precede a string | ||
| of data to be sent out to all AP/M's | ||
| in broadcast fashion for display on | ||
| the terminal screen. | ||
| 11100001 (0xE1; followed by 0x55 | ||
| (01010101 binary)) | ||
| These two characters precede a string | ||
| of data to be sent out to all AP/M's | ||
| in broadcast fashion for spooling to | ||
| the printer. | ||
| 289 | As can be seen from studying the | |
| binary forms of the various tokens, | ||
| the first three bits from the left | ||
| indicate the function of the token | ||
| and the remaining five bits from the | ||
| AP/M address for which the token is | ||
| intended. | ||
| Check the poll character's first | ||
| three bits. | ||
| 290 | Case ON OFF OFF (or 100). This is a | |
| poll for service token. | ||
| 291 | The lower five bits of this character | |
| can make up to 32 ON/OFF | ||
| combinations. These combinations are | ||
| used to determine the AP/M address | ||
| for which polling is directed. In | ||
| the case of this AP/M address | ||
| the bit pattern would be OFF OFF OFF | ||
| OFF ON (00001) | ||
| If the lower five bits DO NOT EQUAL | ||
| 00001, then this token is for a | ||
| different AP/M. GOTO 307. | ||
| 292 | Token character is equal to 10000001 | |
| which is intended for this AP/M. | ||
| Check the SEND DATA FLAG to see if | ||
| data resides in a buffer for sending | ||
| to the Controller. | ||
| 293 | IF “SEND DATA FLAG” is NOT SET, then | |
| GOTO 295. | ||
| 294 | OUTPUT a ‘&’ character on the RS485 | |
| network. This tells the Controller | ||
| that data is to follow. Following | ||
| the ‘&’ character the AP/M sends the | ||
| data stored in the appropriate KEYPAD | ||
| ENTRY PACKET out on the RS485 network | ||
| to the Controller. GOTO 33. | ||
| 295 | OUTPUT a ‘%’ character on the RS485 | |
| network. This tells the Controller | ||
| “I'm Here, and I have nothing to | ||
| send”. GOTO 307. | ||
| 296 | Case ON OFF ON (or 101). This is a | |
| send to display token. | ||
| 297 | The lower five bits of this character | |
| can make up to 32 ON/OFF | ||
| combinations. These combinations are | ||
| used to determine the AP/M address | ||
| for which polling is directed. In | ||
| the case of this AP/M address = 1, | ||
| the bit pattern would be OFF OFF OFF | ||
| OFF ON (00001). | ||
| If the lower five bits DO NOT EQUAL | ||
| 0001, then this token is for a | ||
| different AP/M. GOTO 307. | ||
| 298 | Token character is equal to 10100001 | |
| which is intended for this AP/M. | ||
| Continue reading the rest of the | ||
| display data packet. | ||
| 299 | Send data from the display data | |
| packet to the AP/M'S LCD display. | ||
| GOTO 307. | ||
| 300 | Case ON ON OFF (or 110). This is a | |
| send to printer token. | ||
| 301 | The lower five bits of this character | |
| can make up to 32 ON/OFF | ||
| combinations. These combinations are | ||
| used to determine the AP/M address | ||
| for which polling is directed. In | ||
| the case of this AP/M address = 1, | ||
| the bit pattern would be OFF OFF OFF | ||
| OFF ON (00001) | ||
| If the lower five bits DO NOT EQUAL | ||
| 00001, then this token is for a | ||
| different AP/M. GOTO 307. | ||
| 302 | Token character is equal to 11000001 | |
| which is intended for this AP/M. | ||
| Continue reading the rest of the | ||
| print data packet. | ||
| 303 | Send data from the print data packet | |
| to the AP/M'S RS232 port for the | ||
| printer. GOTO 307. | ||
| 304 | Case ON ON ON (or 111). This is a | |
| BROADCAST token which is intended for | ||
| every AP/M on the network. | ||
| 305 | The lowest bit of this character | |
| determines whether the data following | ||
| is to be directed to the printer (bit | ||
| is ON) or to the display (bit is | ||
| OFF). | ||
| 306 | If the low order bit is ON (11100001) | |
| then GOTO 302. Otherwise (bit is OFF | ||
| (11100000)), then GOTO 298. | ||
| 307 | RETURN to calling program and resume | |
| at step 280. | ||
Whereas many of the examples described herein illustrate generation of coupons based upon dollar purchases by customer, it should be understood that similar types of targeted marketing will also be provided by the system based upon the types of products bought by the purchaser or the departments in the store from which the products were bought. As previously described, the system contemplates the use of the UPC data received by the passive listening device
It will now be described that it is important to monitor how a customer responds to the incentives generated by the present system. In reality, not every single customer responds to an incentive. Experience shows that perhaps 15-20% of the customers respond to the most lucrative incentives. Once the customer meets an infrequent shopping history criteria, the present system incents them. The system records that incentive in the database as part of the history file of that individual shopper's identification. Then the system takes an additional step of monitoring the activity of that shopper.
Any one incentive given to a multiplicity of shoppers is evaluated differently by each individual customer. Take two examples: (1) consider an incentive that provides $2 off on the next shopping visit, if the customer spends $25 and do it within a week. If the customer is a widowed, single woman living on a fixed income, that $2 might represent 10% of her weekly food budget and therefore be a pertinent valuable incentive to her. On the other hand, to a housewife who has five teenagers at home and spends $250 a week, $2 off may not be a sufficient incentive to modify her behavior in any significant way.
(2) In another example, on a product level, the same widow woman might consider an offer for a free 12-oz. box of detergent very pertinent, but the housewife with five dirty teenagers might not find that product volume a sufficient incentive to change brands.
So, each individual incentive given to a group of people is evaluated differently by those people. Assuming several thousand people shop a store twice in the prior 8 weeks, that is hardly a homogeneous group. So, it is important to provide an incentive to those who meet an infrequent shopping history criteria, but once that incentive is made, it should be recorded in the history file of that individual shopper.
In addition to recording that incentive in the database, the system monitors the activity of that customer in a subsequent period. Monitoring can take a couple of different avenues. First, the system can monitor customers to determine if they return to the store within the appropriate time limit of the incentive and do they spend the required amount (if there is a required amount) pursuant to the terms and conditions of the incentive. So, simply monitoring future activity is indirect evidence that the incentive was complied with. On another basis, the system can scan the redemption of a coupon through the bar code reader, or the redemption act itself can be manually entered.
In order to easily scan in the redemption of coupons, bar code data may be printed on the coupons. The bar code reader of the invention can then scan the coupons and the scanned information is stored in the customer's shopping history. In the alternative, a manual input, can be used, wherein a coupon is given an ID number and that ID number can be manually input into the cash register so that the pre-programmed discount is available. Either way, the coupon is either manually input or machine read so that there is a positive feedback that the redemption act itself occurred. Subsequent activity subsequent to the incentive can thus be monitored basically one or two ways, either through redemption or through monitored customer activity.
Once the system monitors a customer's subsequent activity, subsequent to the incentive, then the system can record the response. The system may then have a preset criteria of response and if that customer meets the preset response criteria, the system may either maintain that incentive over a preselected time interval or may initially or subsequently reduce that incentive over a preselected time interval. If the response criteria is favorably met, and the retail store is happy with the performance by the customer, then the store can either maintain or reduce or maintain and subsequently reduce the value of the incentive. On the other hand, if the customer fails to meet the response criteria, as is often the case, the incentive may be increased or changed.
For example, a store may offer an incentive to come back again in the next seven day period and if the customer does, the store gives $2 off the shopping visit. The store then monitors that customer to see if he performed according to the terms and conditions. Did he come back and do what the incentive provided that he should do? If not, then the value of the incentive may be increased.
Recognizing that every group of customers, and in fact, every individual customer has different valuations of an incentive, and depending on whether or not a store has the product or whether the store is short of on inventory a product, the incentive may be changed. If customer response is monitored and the customer does not respond, the incentive can be increased in successive layers until the store finally gets the desired response. This approach provides for an enormous amount of efficiency, because in the “$2 off your next shopping visit” example, if the store provided this incentive to the 2,767 customers that are in Table 5 who shopped only twice in the last 8 weeks, it is unlikely that greater than a 15% participation would be obtained. If so, that 15% may be left at a $2 incentive because it works for them. But the 85% that the program did not work for will need to have their incentive increased. The present system allows a store to customize the incentive, whether it is on a shopping visit criteria, or a product group, or a department, or an individual specific product basis.
With respect to Coupon “M” as described herein, a criteria is set of prior purchases and an attempt is made to incent someone to increase that historical level of prior purchases. Taking that historical purchase level as a base, Coupon “M” seeks to incent above that by providing customer response monitoring to each to an incentive. An incentive is provided to increase customer purchases, the system monitors and records that incentive in the customer history file, then the system monitors and records the response. If the customer meets that response criteria, the store can either maintain that incentive over a preselected time or the store can reduce that incentive over a preselected time either immediately or subsequently. Alternatively, t