JP2009175874A - Point management device and method, and computer program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide integrated point service allowing a total and use of points applied in a plurality of business groups while performing point application at different point application rates to the same commodity or service according to strategy of each business group. <P>SOLUTION: A point management device 1 stores: a customer table indicating correspondence between an integrated customer ID and a business-classified customer ID in each business group; a point conversion condition table indicating correspondence among the business group, a transaction item, and a point application condition; and a point management table indicating the number of points of each customer. The point management device 1 receives transaction information from a business system, reads the integrated customer ID corresponding to the business-classified customer ID inside the transaction information from the customer table, reads the point application condition corresponding to the transaction item and the business group inside the transaction information, determines the number of the points applied based on the point application condition, and adds it to the point management table associatively with the integral customer ID. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a point management apparatus and method, and a computer program.

  In recent years, so-called point services are generally implemented to keep customers in touch. This point service gives points to customers who purchase products or use services as benefits according to their purchase amount or the number of times they use them. It can be exchanged for prizes or used for discounts when purchasing products.

2. Description of the Related Art Conventionally, business groups that provide a plurality of businesses, such as sales, finance, insurance, etc., have integrated within the business group or provided unique point services for each business. However, if the points earned in different business groups can be added up rather than accumulating points for each business group or business, the customer can accumulate points quickly, and the number of points until the privilege is received does not accumulate The points will not expire and the chances of receiving benefits will increase. Therefore, the integration of point services between different business groups has been desired.
Patent Document 1 describes a point grant service system that absorbs a difference in point rate of points given by an issuer depending on the amount of use by integrating points from different issuers and using a point exchange rate between issuers. ing.
JP 2004-227209 A

  Even if a business group wants to integrate point services with other business groups, its business strategy will be different for each business group. Therefore, there is a demand to set a point grant rate independently for the business group even for the same product or service. For example, a business group with a strategy that focuses on the sales business wants to set a higher point grant rate for product purchases than other business groups. Toru business group wants to set a higher point grant rate for deposits, etc. than other business groups. However, in the above-described conventional technology, point services in a plurality of business groups are not integrated while giving different points for each business group to the same product or service.

  The present invention has been made to solve the above-mentioned problem, and its purpose is to give points to the same product or service at different point grant rates in accordance with the strategies of each business group, while a customer has multiple business groups. It is an object to provide a point management apparatus and method for realizing an integrated point service that can be used by adding together the points granted in (1) and a computer program.

  In order to solve the above-described problem, the present invention is a point management device that is connected to a plurality of business systems owned by each business group and provides a point service integrated with respect to the plurality of business groups. Customer table showing correspondence between integrated customer identifier for identifying customers in the entire group and customer identifiers by business for identifying the customers in each business group, business groups, transaction items, and point granting conditions for the transaction items A storage unit for storing a point condition table indicating the correspondence with the customer, an integrated customer identifier of the customer, and a point management table indicating the correspondence with the number of points given to the customer, and the business system from the business system A business group that holds a transaction item, a transaction item indicating a transaction performed in the business group, and a transaction Transaction information including information on the customer-specific customer identifier of the received customer, and reading out an integrated customer identifier corresponding to the business-specific customer identifier in the transaction information from the customer table, and a business group in the transaction information and Read the point granting condition corresponding to the transaction item, determine the number of points to be granted based on the point granting condition, and associate the read integrated customer identifier with the number of points determined to be given as the point management table And a point management unit to be added to the point management device.

  In order to solve the above-described problems, the present invention is a point management device that is connected to a plurality of business systems used in each business of each business group and provides a point service integrated with respect to the plurality of business groups A customer table indicating correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business of each business group, a business group and a business type, and a transaction A memory for storing a point condition table indicating correspondence between the item and the point granting condition of the transaction item, a point management table indicating correspondence between the integrated customer identifier of the customer and the number of points given to the customer Department, the business group of the business using the business system, the business type, and the business The transaction information including the transaction item indicating the transaction performed in the transaction and the business customer identifier of the customer who performed the transaction is received, and the business group, business type and business customer identifier in the transaction information are supported. The integrated customer identifier is read from the customer table, the point granting conditions corresponding to the business group, business type, and transaction item in the transaction information are read from the point conversion condition table and given based on the point granting conditions A point management apparatus comprising: a point management unit that adds information that associates the integrated customer identifier that has been determined and read and the number of points that has been determined to be added to the point management table.

  Further, the present invention is the point management device described above, wherein the transaction information further includes information on an amount related to the transaction, and the point granting condition is the number of points to be granted corresponding to the amount. It is characterized by showing information.

  Further, the present invention is the point management apparatus described above, wherein the transaction information further includes information indicating a transaction usage status, and the point granting condition is granted in accordance with the transaction usage status. It is characterized by indicating information on the number of points to be calculated.

  Further, the present invention is the point management apparatus described above, wherein the point management unit receives the transaction information, and integrates corresponding to a business group, a business type, and a business-specific customer identifier in the received transaction information A customer identifier is read from the customer table, and a record including information on a business group, a business type, a transaction item, and an amount of money or a transaction usage status in the transaction information is associated with the read integrated customer identifier. Add to the table, search the point management table at a predetermined time corresponding to the business group or business group and business type, and correspond to the business group or the business group and business type, and , Identify records for which points have not been awarded, and business groups included in the identified records Read the point granting conditions corresponding to the business type and transaction item from the pointization condition table, determine the number of points to be granted based on the point granting conditions and the amount of money in the specified record or transaction usage, Information on the determined number of granted points is added to the specified record.

  In addition, the present invention is the point management apparatus described above, wherein a change request including information on a business group, a business type, a transaction item, and changed point grant conditions is received from the business system, and the received change request A pointing condition setting unit that rewrites the point granting condition in the pointing condition table corresponding to the business group, the business type, and the transaction item indicated by the item to the changed point granting condition indicated by the change request. It is characterized by that.

  In addition, the present invention is the point management device described above, and receives a query request including information on a search condition indicating a target for point query, a business operator group, and a business type, and the customer table and the point With reference to the management table, the integrated customer identifier corresponding to the search condition, the operator group, and the business type in the inquiry request is specified, and the information on the number of points associated with the specified integrated customer identifier is the point. It further comprises a point inquiry unit that reads out and outputs from the management table.

  In addition, the present invention is the point management device described above, and receives a query request including information on a search condition indicating a target for point query, a business operator group, and a business type, and the customer table and the point With reference to the management table, the integrated customer identifier corresponding to the search condition, the operator group, and the business type in the inquiry request is specified, and the information on the number of points associated with the specified integrated customer identifier is the point. It further comprises a point inquiry unit that reads out and outputs from the management table.

  In order to solve the above-described problems, the present invention is a point management device that is connected to a plurality of business systems used in each business of each business group and provides a point service integrated with respect to the plurality of business groups The point management device shows correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business of each business group A customer table, a business group and business type, a transaction item, and a pointed condition table indicating correspondence with the point granting condition of the transaction item, an integrated customer identifier of the customer, and the number of points given to the customer A point management table indicating the correspondence between the point management device, the point management unit of the point management device From the business system, the information includes the business group and business type of the business using the business system, the transaction item indicating the transaction performed in the business, and the customer identifier by business of the customer who performed the transaction. Receives transaction information, reads the integrated customer identifier corresponding to the business group, business type and business-specific customer identifier in the transaction information from the customer table, and corresponds to the business group, business type and transaction item in the transaction information The point granting condition is read from the pointing condition table, the number of points to be given is determined based on the point granting condition, and the information that associates the read integrated customer identifier with the number of points decided to be given is the point The point management method is characterized by being added to a management table.

  In order to solve the above-described problems, the present invention is a point management device that is connected to a plurality of business systems used in each business of each business group and provides a point service integrated with respect to the plurality of business groups A customer table indicating correspondence between an integrated customer identifier for identifying a customer in the entire business group and a business-specific customer identifier for identifying the customer in each business of each business group, a business group, and Point management condition table indicating correspondence between business type, transaction item, and point granting conditions for the transaction item, point management table indicating correspondence between customer integrated customer identifier and the number of points given to the customer Business unit using the business system from the business system Receives transaction information including information on loops and business types, transaction items indicating transactions performed in the business, and customer identifiers by business of the customers who performed the business, and the business group and business type in the transaction information And the integrated customer identifier corresponding to the business-specific customer identifier is read from the customer table, and the point granting conditions corresponding to the business group, business type and transaction item in the transaction information are read from the pointed condition table, and the point granting is performed. Determining the number of points to be granted based on the conditions, and causing the computer to function as a point management unit that adds information that associates the read integrated customer identifier and the number of points determined to be given to the point management table. It is a computer program characterized.

  ADVANTAGE OF THE INVENTION According to this invention, it becomes possible to give a customer a point with the point grant rate set according to the strategy of each business group with respect to the same goods and service, integrating the point service in a some business group. Therefore, it is possible to support the sales promotion of the business that each business group focuses on. In addition, customers can add and use points earned in different business groups, and it becomes easier to accumulate points, so the opportunity to use benefits increases. As a result, the entire business group providing the point service can be encouraged to use the customer.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is an overall configuration diagram of a point management system according to an embodiment of the present invention. In the figure, the point management system includes a point management device 1 that provides an integrated point service to a plurality of business groups, a business system 2 of each business group, a web system 6 that can be accessed by customers, and a customer terminal 7. It is connected via a network N composed of a public network such as the Internet or a private network such as a dedicated line. In the figure, only one customer terminal 7 is shown, but a plurality of customer terminals 7 are connected.

  The business system 2 is a system used in each business of a business group, and is a database (hereinafter referred to as “DB”) that stores customer information that is information about customers who use the business and information related to transactions with customers. 3) and the business terminal 4 used by the staff in the business concerned. Here, a plurality of business groups are designated as A regional business group, B regional business group, etc. that are developing business in each region, and each regional business group includes financial business, insurance business, sales business, membership management business, etc. It is assumed that there are multiple businesses. The business systems 2 owned by the financial business, insurance business, sales business, and member management business are respectively the financial business system 2-1, insurance business system 2-2, sales business system 2-3, and member management business system 2. -4. The financial business system 3-1, the insurance business system 2-2, the sales business system 2-3, and the member management business system 2-4 have the DBs 3 respectively, the financial business DB 3-1, the insurance business DB 3-2, and the sales business. The business terminal 4 is a financial business terminal 4-1, an insurance business terminal 4-2, a sales business terminal 4-3, and a member management terminal 4-4.

  The business system 2 notifies the point management device 1 of transaction information generated when a transaction is performed or when a transaction status is confirmed. The time when the transaction is performed is, for example, when a customer purchases a product or uses a service. In addition, transaction status confirmation is a process of confirming the status of service usage and the amount of usage, etc., for each predetermined period. Or confirming the registered members and their investment amount.

  The customer terminal 7 is a computer terminal owned by the customer, and is, for example, a personal computer or a mobile phone. The web system 6 provides the customer terminal 7 with a product sales service through online shopping, a point inquiry service, and the like.

FIG. 2 is a block diagram showing the internal configuration of the point management device 1.
In FIG. 1, the point management apparatus 1 includes a communication unit 11, a name identification processing unit 12, an integrated customer DB 13, a pointing condition setting unit 14, a pointing condition DB 15, a point management unit 16, a point management DB 17, and a point inquiry unit 18. .

  The communication unit 11 transmits and receives data via the network N. The name identification processing unit 12 receives customer information stored in the DB 3 from the business system 2 of each regional business group, integrates the received customer information, generates a customer table, and writes it into the integrated customer DB 13.

  The pointization condition setting unit 14 inputs registration and change of a pointization condition table in which transaction items indicating product sales and services to which points are granted and point granting conditions for the transaction items are determined for each regional business group In response, the pointing condition table is registered in the pointing condition DB 15 or the registered content is changed. In addition, there are a use point, a stage point, and a manual grant point as points given to customers. A use point is a point given every time a transaction is performed, and is given every predetermined period such as every month or every use. A stage point is a point that is given when the usage status exceeds a certain level during a specified period, and is given every period such as monthly, semi-annual, or yearly. The manual grant points are points that are not manually determined by the point management device 1 and are manually input by the staff or the like using the business terminal 4, but are associated with products in advance in online shopping provided by the web system 6. It can also be a point. Information on the use point and stage point grant timing and point expiration date determination conditions is stored in the pointization condition DB 15 corresponding to the business group, business group and business type, or business group, business type and transaction item. Remembered.

  The point management unit 16 uses the business system 2 and the web system 6 to identify the business group and business type in which transactions such as product sales and service use have occurred, the customer ID for each business, and the transaction item that identifies the customer who has performed the transaction in the business. The transaction information including information such as the amount, additional information, and date is received, the point granted condition is determined with reference to the pointed condition table in the pointed condition DB 15 and written in the point management DB 17. In addition, when giving a point manually, the information of a manual grant point is contained in transaction information, and the determination of the grant point using a point conversion condition table is not performed at this time. Additional information is added according to the transaction item.For example, if the transaction item is a `` time deposit '', information on the date of deposit, maturity date, number of months of deposit, etc. as additional data, If it is “insurance”, it can be information such as a contract date.

  The point inquiry unit 18 receives the point inquiry request and the history inquiry request from the business terminal 4 of the business system 2, directly from the customer terminal 7 or via the web system 6, and receives the customer from the pointization condition DB 15. Returns the number of points currently held and the history of granting and using points.

FIG. 3 shows an example of customer table data stored in the integrated customer DB 13.
In the figure, the customer table includes an integrated customer ID that is information for identifying a customer in the entire point management system, and the customer rank, name, reading, gender, date of birth, address, and the customer specified by the integrated customer ID. It consists of information such as a telephone number, a business group and business type in which the customer is registered as a customer, and a business-specific customer ID that is information for identifying a customer in the business group and business type. The customer rank is a rank determined by conditions such as annual usage amount, for example, and point granting conditions can be set for each rank. For example, if the business-specific customer ID is a financial business, a passbook number may be used.

FIG. 4 shows a data example of the pointing condition table stored in the pointing condition DB 15.
In the same figure, the point conversion condition table includes information on a business type, a transaction item in the business type, a use point grant condition for the transaction item, and a stage point grant condition for each regional business group. For example, if the business type is “Financial Business” for the business group “A Region Business Group” and the transaction item is “Time Deposit”, the usage point granting condition is 5 points / 100,000 yen for 6 months or more, 6 months or more If it is less than 1 year, it is 10 points / 100,000 yen, if it is 1 year or more, it is 20 points / 100,000 yen, and the stage point grant condition is 5 points / 50 if the balance is 500,000 yen or more and less than 10 million yen If the balance is 10 million yen or more and less than 30 million yen, 150 points, and if the balance is 30 million yen or more, it is 200 points. In addition, if the business type “sales business” of the business group “A region business group” and the transaction item “sales”, the usage point granting conditions are 7 points / 1,000 yen for customers with customer rank A and customers with customer rank B 5 points / 1000 yen is 10 points / 100,000 yen for 6 months or more and less than 1 year, 20 points / 100,000 yen for 1 year or more, and no stage points are granted. In addition, the thing without designation | designated of a customer rank shall be common to all the customer ranks. Usage point granting conditions and stage point granting conditions include a predetermined number of points according to the amount of money, a predetermined number of points according to the number of product purchases and the number of times services are used, and continuous use of services. A predetermined number of points can be given according to the state (for example, the balance of savings or the contribution of continuing members).

FIG. 5 shows a data example of the point management table stored in the point management DB 17.
In the figure, the point management table confirmed the integrated customer ID and the date when the customer specified by the integrated customer ID has made a transaction such as purchase of a product, use of a service, exchange of points, etc. or the status of the transaction. The date indicating the date, the regional business group and business type in which the transaction was performed, the transaction item that identifies the transaction, the amount, additional information, the number of points given by the transaction (use points, stage points, manual points) , The expiration date of the points, and a record indicating the information on the number of points of the digestion points used in exchange for the benefits.

Next, the operation of the point management device 1 will be described.
The point management apparatus 1 performs the following name identification process before starting the provision of the point service. That is, the name identification processing unit 12 of the point management device 1 receives the regional business group and business type and customer information registered in the DB 3 from the business systems 2 of all the regional business groups. The customer information includes a record including information such as business customer ID, name, reading, gender, date of birth, address, and telephone number of each customer. The name identification processing unit 12 specifies, from all customer information received from each business system 2, a record in which predetermined data items, for example, name, reading, and address all match, as the same customer information. However, the difference between the old kanji and the common kanji in the name and the difference between the X-chome Y address and XY in the address are regarded as the same. In addition, in the name, a reading that includes a space between the last name and the first name deletes the space. For example, “XXX YYY” and “XXXXYYY” are all “XXXXYYY”. The name identification processing unit 12 assigns an integrated customer ID, generates a record of the customer table from information read from the record of customer information specified as belonging to the same customer, and registers it in the integrated customer DB 13.
In addition, the point management device 1 executes this name identification process before starting the provision of the point service in the point management device 1, and also provides customer information about new customers every predetermined period such as once a month. Receive and execute from each business of each regional business group.

  In addition, the point management apparatus 1 also registers the pointization condition table before starting to provide the point service. That is, the pointing condition setting unit 14 of the point management apparatus 1 receives information on the pointing condition table to be registered from the business terminal 4 and writes it in the pointing condition DB 15. In addition, after the pointing condition table is registered, the pointing condition setting unit 14 appropriately receives a request for changing the pointing condition table from the business terminal 4 and changes the pointing condition table in the pointing condition DB 15. . Specifically, when changing the pointization condition table, the pointization condition setting unit 14 receives a change request indicating the business group, the business type, the transaction item, and the changed point grant condition. The pointization condition setting unit 14 rewrites the point grant conditions in the pointization condition table corresponding to the business group, the business type, and the transaction item indicated by the change request with the changed point grant conditions indicated by the change request. The registration and change of the pointing condition table may be input by an input means such as a keyboard (not shown) or may be read from a computer-readable recording medium.

FIG. 6 is a diagram showing a processing flow of transaction recording processing. The point management device 1 is a business system 2 of each business of each regional business group, or the web system 6 is in real time every time a transaction is performed or periodically such as once a day, once a month, Alternatively, transaction information is received after the name identification process (step S110). The point management device 1 performs the following process for each transaction information of one transaction.
That is, first, the point management unit 16 of the point management apparatus 1 uses the business group, business type, and business-specific customer ID set in the transaction information as a key from the customer table stored in the integrated customer DB 13. The integrated customer ID is read out (step S120).

  The point management unit 16 determines whether or not the transaction item set in the received transaction information indicates the use of points (step S130). When it is determined that the point is not used (step S130: NO), the date acquired from the transaction information in the point management table stored in the point management DB 17 in correspondence with the integrated customer ID read in step S120, the business group A record in which information such as business type, transaction item, amount, additional information, number of points, etc. is set is added (step S140). Note that the number of points is included in the transaction information only in the case of manual grant, and is registered in the point management table.

  On the other hand, when it is determined in step S130 that the point is used (step S130: YES), the point management unit 16 stores the point management stored in the point management DB 17 in association with the integrated customer ID read in step S120. A record in which information such as the date acquired from the transaction information, the business group, the business type, the transaction item, the additional information, and the number of points of the digestion point is set is added to the table (step S150). Furthermore, among the records in the point management table corresponding to the integrated customer ID, the expiration date is after the current date and time, and the grant point (usage point, stage point, manual grant point) with the oldest expiration date may be used. The number of digestion points is logically deleted in this order.

  In addition, the transaction recording process mentioned above is a process about the transaction information of one transaction, and when the transaction information about a some transaction is received, a transaction recording process is performed about each transaction.

  FIG. 7 is a diagram illustrating a processing flow of the use point provision processing. This use point grant processing is performed according to the activation conditions stored in the pointization condition DB 15, that is, at a time determined for each business group, for each business group and business type, or for each business group, business type and transaction item. to start.

  First, the point management unit 16 uses a business group, business group and business type as a starting condition, or a business group, business type and transaction item as a key from a point management table stored in the point management DB 17. , The record whose date is after the previous use point grant process start date and for which the number of use points is not set (no use point granted) (hereinafter referred to as a target record) is specified (step S210).

  When the target record is detected in step S210 (step S220: YES), the point management unit 16 uses the integrated customer ID set in the target record as a key from the customer table stored in the integrated customer DB 13. The customer rank is read (step S230). The point management unit 16 uses the point grouping condition table stored in the pointing condition DB 15 using the business group, the business type, the transaction item set in the target record, and the customer rank read in step S230 as a key. Point grant conditions are read (step S240).

  The point management unit 16 determines the number of points to be given as usage points from the usage point granting conditions, the amount set in the target record, and the customer rank (step S250). If there is no corresponding usage point grant condition, no usage point is granted. The point management unit 16 writes the number of used points determined in step S250 into the target record in the point management table stored in the point management DB 17 (step S260). If no use point is given, NULL may be written. Then, the process returns to step S210 to search for the next record, and the process is repeated until there are no more target records (step S220: NO).

  In addition, after performing the transaction recording process of FIG. 6 about one transaction information, when performing a use point process subsequently, the process from step S230 to step S260 is performed, and it complete | finishes without performing the next record search. .

  FIG. 8 is a diagram showing a process flow of the stage point giving process. This stage point grant processing is performed according to the activation conditions stored in the pointization condition DB 15, that is, at a time determined for each business group, for each business group and business type, or for each business group, business type and transaction item. to start.

  First, the point management unit 16 uses a business group, business group and business type as a starting condition, or a business group, business type and transaction item as a key from a point management table stored in the point management DB 17. , A record (hereinafter referred to as a target record) in which the date is after the start date of the previous stage point assignment process and the stage point is not set (stage point not assigned) is specified (step S310).

  When the target record is detected in step S310 (step S320: YES), the point management unit 16 obtains the customer rank from the customer table in the integrated customer DB 13 using the integrated customer ID set in the target record as a key. Read (step S330). The point management unit 16 performs a stage from the pointed condition table stored in the pointed condition DB 15 using the business group, business type, transaction item set in the target record and the customer rank read in step S330 as a key. Point grant conditions are read (step S340).

  The point management unit 16 determines the number of points to be given as stage points by further using additional information, if necessary, from the stage point granting conditions, the amount set in the target record, and the customer rank (step) S350). For example, when the stage point granting condition includes a period from service registration, the use continuation period set in the additional information, the date on which the transaction was performed, or the like is used. If there is no corresponding stage point granting condition, no usage points are granted. The point management unit 16 writes the number of points of the stage points determined in step S350 into the target record in the point management table stored in the point management DB 17 (step S360). If no stage point is given, NULL may be written. Then, the process returns to step S310 to search for the next record, and the process is repeated until there are no more target records (step S320: NO).

  In addition, after performing the transaction recording process of FIG. 6 for one transaction information, or after performing the transaction recording process of FIG. 6 and the usage point granting process of FIG. Then, the process from step S330 to step S360 is performed, and the process ends without performing the next record search.

  FIG. 9 is a diagram illustrating a process flow of the expiration date management process. This expiration date management process is activated in accordance with the activation conditions stored in the pointization condition DB 15, that is, at a time determined for each business group or for each business group and business type.

  First, the point management unit 16 is given use points or stage points from the point management table stored in the point management DB 17 using the business group as a starting condition or the business group and the business type as a key. And a record to which an expiration date has not been granted (hereinafter referred to as a target record) is specified (step S410).

  When the target record is detected in step S410 (step S420: YES), the point management unit 16 determines whether the business group, the business type, and the date set in the target record are different from the use point or the stage point. The expiration date is determined from the expiration date determination condition information stored in the pointization condition setting unit 14 (step S430). In the point conversion condition DB 15, the deadline for determining the expiration date for each use point and stage point for each business group, for each business group and business type, or for each business group, business type and transaction item Determination condition information is stored. For example, if the date determining condition information is dated from January 1, 2007 to December 31, 2007, the expiration date is December 31, 2008, or one year after the date is the expiration date. To indicate. The point management unit 16 reads the time limit determination condition information corresponding to the business group, business type, transaction item, and usage point or stage point acquired from the target record from the pointization condition DB 15, and is set in the target record. The expiration date is determined based on the date and the expiration date determination condition information. Note that the effective period may be common to the usage points and stage points, or may be common to all regional business groups.

  The point management unit 16 writes the information on the expiration date determined in step S430 into the target record in the point management table stored in the point management DB 17 (step S440). Then, the process returns to step S410 to search for the next record, and the process is repeated until there are no more target records (step S420: NO).

  In addition, after performing the transaction recording process of FIG. 6 for one transaction information, the use point process of FIG. 7 and the stage point process of FIG. 8 are subsequently performed, and then the expiration date management process is performed. Steps S430 to S440 are performed, and the process ends without performing the next record search.

  Further, the point management unit 16 periodically searches the point management table and logically deletes records whose expiration date is before the current date.

FIG. 10 is a diagram illustrating a processing flow of search processing.
The point inquiry unit 18 of the point management device 1 receives the search condition from the business terminal 4 of the business system 2, from the customer terminal 7, or from the web system 6 that has received the search request from the customer terminal 7 ( Step S510). The point inquiry unit 18 specifies a record that matches the received search condition in the point management table stored in the point management DB 17 (step S520). The point inquiry unit 18 generates and returns search result display screen data for displaying the contents of the record specified in step S520 (step S530). At this time, information read from the customer table stored in the integrated customer DB 13 may be displayed together. When the business terminal 4 or the customer terminal 7 receives the search result display screen data returned by the point management device 1, the business terminal 4 or the customer terminal 7 displays the received screen data.

A specific example of search processing will be described below.
FIG. 11 shows a search processing result display screen displayed on the business terminal 4.
When the point inquiry unit 18 of the point management device 1 receives a point inquiry request from the business terminal 4 and information on the local business group and business type to which the business terminal 4 belongs, a point inquiry screen for inputting search conditions is displayed. Display. On the point inquiry screen, fields for inputting search conditions such as name, reading, telephone number, address, point range, and a search button are displayed. When a staff member inputs a search condition to the business terminal 4 and clicks a search execution button, the business terminal 4 transmits information on the input search condition to the point management device 1 (FIG. 10: Step S510).

  The point inquiry unit 18 of the point management device 1 matches the received local business group and business type, and the name, reading, phone number, and address indicated by the search condition from the customer table stored in the integrated customer DB 13. Identify the record. Further, the point inquiry unit 18 is a point range that is specified by the integrated customer ID in the specified record from the point management table stored in the point management DB 17 and that the current number of possessed points is indicated by the search condition. A certain record is specified (FIG. 10: step S520). Note that the number of possessed points is calculated by the sum of the number of usage points, stage points, and manually granted points that have an expiration date on and after the current date and for which logical deletion by point digest has not been performed.

  When the point inquiry unit 18 acquires the integrated customer ID and the number of possessed points from the specified record of the point management table, the name, reading, gender, date of birth, Reads address and phone number information. The point management unit 16 generates search processing result display screen data for displaying information on the business-specific customer ID, name, reading, gender, date of birth, address, telephone number, and the number of possessed points, to the business terminal 4. Return (FIG. 10: Step S530). When receiving the search processing result display screen data, the business terminal 4 displays the search processing result display screen shown in FIG.

FIG. 12 shows a point history display screen displayed on the business terminal 4 or the customer terminal 7.
The point inquiry unit 18 of the point management apparatus 1 receives a point history inquiry request from the business terminal 4 or the customer terminal 7 or from the web system 6 that has received a request from the customer terminal 7, information on the local business group and business type, Is received, a point history inquiry screen for inputting search conditions is displayed. On the point history inquiry screen, a field for inputting a business customer ID and a search target period and a search button are displayed. When a staff member or a customer inputs a search condition and clicks a search execution button, the business terminal 4 or the customer terminal 7 transmits information on the input search condition to the point management apparatus 1 (FIG. 10: Step S510). . The point inquiry unit 18 specifies a record that matches the received regional business group and business type and the business-specific customer ID indicated by the search condition from the customer table stored in the integrated customer DB 13, and the integrated customer ID, Read name, address, phone number, date of birth information. Further, the point inquiry unit 18 specifies a record in the point management table stored in the point management DB 17 using the read integrated customer ID as a key (FIG. 10: step S520).

  The point inquiring unit 18 refers to the record of the specified point management table, calculates the current number of retained points in the same manner as described above, calculates the number of used points that is the total number of digest points, and retains The total number of granted points that is the sum of the number of points and the number of used points is calculated. The point inquiry unit 18 further calculates the number of retained points for each expiration date. Subsequently, the point inquiring unit 18 selects the date and type of point (usage point / stage point / manually granted point / digestion point) from the records included in the search target period in which the date is received, among the records of the specified point management table. ) And the number of points, business type, transaction items, etc., and a history table is generated. The point inquiry unit 18 includes business-specific customer ID, name, address, telephone number, date of birth, search period, history table, total number of points granted, number of points already consumed, number of points currently held, holdings by expiration date History inquiry result screen data for displaying the number of points is generated and returned (FIG. 10: step S530). When receiving the history inquiry result display screen data, the business terminal 4 or the customer terminal 7 displays the point history inquiry result display screen shown in FIG.

  According to the embodiment described above, the point granting condition used for the business group can be set in the point management device 1 from the business terminal 4 of each regional business group, and the point grant according to the strategy of each business group It is possible to give points to customers depending on the conditions. For example, in a business group that has a strategy that focuses on the sales business, a business group that has a higher point grant rate than the other business groups in terms of product purchases, and that has a strategy that focuses on the financial business. Therefore, a higher point grant rate can be set for deposits than for other business groups. In addition, the customer can add and use the points granted in a plurality of business groups, and the opportunity for receiving benefits increases. Furthermore, it becomes possible to promote an increase in the use of customers as a whole business group in which the point service is provided by the point management device 1.

  In addition, the point management apparatus 1, DB3, business terminal 4, web system 6, and customer terminal 7 have a computer system inside. And the process of operation | movement of the name identification process part 12, the point conversion condition setting part 14, the point management part 16, the point inquiry part 18, DB3, the business terminal 4, the web system 6, and the customer terminal 7 of the point management apparatus 1 mentioned above is as follows. The program is stored in a computer-readable recording medium in the form of a program, and the above processing is performed by the computer system reading and executing the program. Here, the computer system includes a CPU, various memories, an OS, and hardware such as peripheral devices.

Further, the “computer system” includes a homepage providing environment (or display environment) if a WWW system is used.
The “computer-readable recording medium” refers to a portable medium such as a flexible disk, a magneto-optical disk, a ROM, and a CD-ROM, and a storage device such as a hard disk built in the computer system. Furthermore, the “computer-readable recording medium” dynamically holds a program for a short time like a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line. In this case, a volatile memory in a computer system serving as a server or a client in that case, and a program that holds a program for a certain period of time are also included. The program may be a program for realizing a part of the functions described above, and may be a program capable of realizing the functions described above in combination with a program already recorded in a computer system.

It is a figure showing the whole point system composition by one embodiment of the present invention. It is a functional block diagram of the point management device by the same embodiment. It is a figure which shows the data structural example of the customer table by the embodiment. It is a figure which shows the data structural example of the pointization condition table by the embodiment. It is a figure which shows the example of a data structure of the point management table by the embodiment. It is a figure which shows the processing flow of the transaction recording process by the embodiment. It is a figure which shows the processing flow of the use point provision process by the embodiment. It is a figure which shows the processing flow of the stage point provision process by the embodiment. It is a figure which shows the processing flow of the expiration date management process by the embodiment. It is a figure which shows the processing flow of the search process by the embodiment. It is a figure which shows the display image of the point search result by the embodiment. It is a figure which shows the log | history display image by the same embodiment.

Explanation of symbols

1 ... Point management device 2-1 ... Financial business system (business system)
2-2 ... Insurance business system (business system)
2-3 ... Sales business system (business system)
2-4. Member management business system (business system)
3-1. Financial business DB (DB)
3-2 ... Insurance Business DB (DB)
3-3 Sales business DB (DB)
3-4. Member DB (DB)
4-1 ... Financial business terminal (business terminal)
4-2 ... Insurance business terminal (business terminal)
4-3. Sales business terminal (business terminal)
4-4… Member management terminal (business terminal)
6 ... Web system 7 ... Customer terminal 11 ... Communication unit 12 ... Name identification processing unit 13 ... Integrated customer DB
14 ... Pointing condition setting unit 15 ... Pointing condition DB
16 ... Point management unit 17 ... Point management DB
18 ... Point inquiry section

Claims (10)

A point management device that is connected to a plurality of business systems owned by each business group and provides integrated point services for the plurality of business groups,
A customer table indicating correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business group;
Pointing condition table showing correspondence between business group, transaction item, and point granting condition of the transaction item;
A storage unit for storing a customer's integrated customer identifier and a point management table indicating a correspondence between the number of points given to the customer;
From the business system, transaction information including information on a business group that owns the business system, a transaction item indicating a transaction performed in the business group, and a customer identifier for each business of the customer who performed the transaction is received. And reading out the integrated customer identifier corresponding to the business-specific customer identifier in the transaction information from the customer table, reading out the point grant conditions corresponding to the business group and the transaction item in the transaction information, and based on the point grant conditions A point management unit that adds information that associates the read integrated customer identifier and the number of points determined to be granted to the point management table.
A point management device characterized by that. A point management device that is connected to a plurality of business systems used in each business of each business group and provides a point service integrated with respect to the plurality of business groups,
A customer table indicating correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business of each business group;
Pointing condition table showing correspondence between business group and business type, transaction item, and point granting condition of the transaction item,
A storage unit for storing a customer's integrated customer identifier and a point management table indicating a correspondence between the number of points given to the customer;
From the business system, the information includes the business group and business type of the business using the business system, the transaction item indicating the transaction performed in the business, and the customer identifier by business of the customer who performed the transaction. Receives transaction information, reads the integrated customer identifier corresponding to the business group, business type and business-specific customer identifier in the transaction information from the customer table, and corresponds to the business group, business type and transaction item in the transaction information The point granting condition is read from the pointing condition table, the number of points to be given is determined based on the point granting condition, and the information that associates the read integrated customer identifier with the number of points decided to be given is the point A point management unit to be added to the management table;
A point management device comprising: The transaction information further includes information on the amount related to the transaction,
The point grant condition indicates information on the number of points to be granted in accordance with the amount of money,
The point management apparatus according to claim 2. The transaction information further includes information indicating the usage status of the transaction,
The point grant condition indicates information on the number of points that should be granted in accordance with the transaction usage status.
The point management apparatus according to claim 2, wherein the point management apparatus is a point management apparatus. The point management unit
The transaction information is received, an integrated customer identifier corresponding to a business group, a business type, and a business-specific customer identifier in the received transaction information is read from the customer table, the corresponding integrated customer identifier is read, and the transaction Add a record containing information on business group, business type, transaction item, amount of money or transaction usage in the information to the point management table,
The point management table is searched at a predetermined time corresponding to a business group or a business group and a business type, and the point corresponding to the business group or the business group and the business type is granted. While specifying a record that has not been performed, the point granting conditions corresponding to the business group, business type, and transaction items included in the identified record are read from the pointed condition table, and the point granting condition and the specified record Determine the number of points to be granted based on the amount of money or the usage status of the transaction, and add information on the determined number of granted points to the identified record.
The point management apparatus according to claim 3 or 4, characterized by the above. A change request consisting of information on business group, business type, transaction item, and point grant condition after change is received from the business system, and it corresponds to the business group, business type, and transaction item indicated by the received change request A pointing condition setting unit that rewrites the point granting condition in the pointed condition table to the changed point granting condition indicated by the change request,
The point management device according to claim 2, wherein the point management device is a point management device. Receiving an inquiry request including information on a search condition indicating a point inquiry target and an operator group and business type, referring to the customer table and the point management table, the search condition in the inquiry request Further comprising a point inquiry unit that identifies an integrated customer identifier corresponding to the business group and business type, and reads and outputs information on the number of points associated with the identified integrated customer identifier from the point management table.
The point management apparatus according to claim 2, wherein the point management apparatus is a point management apparatus. The transaction information further includes date information,
The point management unit further adds date information to the point management table in association with the integrated customer identifier,
The point inquiry unit receives a history inquiry request including a search condition indicating an object for which point history inquiry is performed, an operator group, and a business type, and refers to the customer table and the point management table, The integrated customer identifier corresponding to the search condition, the operator group and the business type in the history inquiry request is specified, and is associated with the specified integrated customer identifier, and includes at least the date and the number of points given by the transaction on the date. Read and output information from the point management table,
The point management apparatus according to claim 7. A point management method used for a point management device that is connected to a plurality of business systems used in each business of each business group and provides a point service integrated with a plurality of the business groups,
The point management device
A customer table indicating correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business of each business group;
Pointing condition table showing correspondence between business group and business type, transaction item, and point granting condition of the transaction item,
A storage unit for storing a customer's integrated customer identifier and a point management table indicating a correspondence between the number of points given to the customer;
The point management unit of the point management device, from the business system, the business group and business type of the business using the business system, the transaction items indicating the transactions performed in the business, and the customers who performed the business Transaction information including information with the business-specific customer identifier, and reading out the integrated customer identifier corresponding to the business group, business type and business-specific customer identifier in the transaction information from the customer table, The point granting conditions corresponding to the business group, business type, and transaction item are read from the point conversion condition table, the number of points to be granted is determined based on the point granting conditions, the read integrated customer identifier, and the points determined to be given Adding information associated with the number to the point management table;
A point management method characterized by that. A computer program used in a point management device connected to a plurality of business systems used in each business of each business group and providing a point service integrated with respect to a plurality of the business groups,
A customer table indicating correspondence between an integrated customer identifier that identifies a customer in the entire business group and a business-specific customer identifier that identifies the customer in each business of each business group;
Pointing condition table showing correspondence between business group and business type, transaction item, and point granting condition of the transaction item,
A storage unit for storing a customer's integrated customer identifier and a point management table indicating a correspondence between the number of points given to the customer;
From the business system, the information includes the business group and business type of the business using the business system, the transaction item indicating the transaction performed in the business, and the customer identifier by business of the customer who performed the transaction. Receives transaction information, reads the integrated customer identifier corresponding to the business group, business type and business-specific customer identifier in the transaction information from the customer table, and corresponds to the business group, business type and transaction item in the transaction information The point granting condition is read from the pointing condition table, the number of points to be given is determined based on the point granting condition, and the information that associates the read integrated customer identifier with the number of points decided to be given is the point Point management unit to be added to the management table,
A computer program for causing a computer to function as:

Images