SYSTEM AND METHOD FOR GENERATING A MESSAGE FOR A CUSTOMER UTILIZING DATA FROM A DATABASE
First Claim
1. A system for generating a message for a customer utilizing data from a first database, comprising:
- a computer configured to retrieve the data associated with a vehicle dealership ID from the first database;
the data including a repair order table and a customer table;
the repair order table including a first record having a repair order ID, a repair order status, a customer ID, and the vehicle dealership ID;
the customer ID being associated with the customer, the vehicle dealership ID being associated with a vehicle dealership;
the customer table having a second record including the customer ID, the vehicle dealership ID, and a customer telephone number;
the computer further configured to store the data in a second database;
the computer further configured to retrieve the first record from the repair order table in the second database; and
the computer further configured to compare the repair order status from the first record to a first order status, and if the repair order status corresponds to the first order status the computer further configured to generate a first formatted message utilizing the vehicle dealership ID, the customer ID, and the customer telephone number.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and a method for generating a message for a customer are provided. The method includes retrieving data associated with a vehicle dealership ID from the first database. The data includes a repair order having a first record having a repair order ID, a repair order status, a customer ID, and the vehicle dealership ID. The data further includes a customer table having a second record including the customer ID, the vehicle dealership ID, and a customer telephone number. The method includes storing the data in a second database, and retrieving the first record from the repair order table in the second database. If the repair order status corresponds to the first order status, the method includes generating a first formatted message, based on the vehicle dealership ID, the customer ID, and the customer telephone number.
5 Citations
20 Claims
-
1. A system for generating a message for a customer utilizing data from a first database, comprising:
-
a computer configured to retrieve the data associated with a vehicle dealership ID from the first database;
the data including a repair order table and a customer table;
the repair order table including a first record having a repair order ID, a repair order status, a customer ID, and the vehicle dealership ID;the customer ID being associated with the customer, the vehicle dealership ID being associated with a vehicle dealership;
the customer table having a second record including the customer ID, the vehicle dealership ID, and a customer telephone number;the computer further configured to store the data in a second database; the computer further configured to retrieve the first record from the repair order table in the second database; and the computer further configured to compare the repair order status from the first record to a first order status, and if the repair order status corresponds to the first order status the computer further configured to generate a first formatted message utilizing the vehicle dealership ID, the customer ID, and the customer telephone number. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A method for generating a message for a customer utilizing data from an first database, comprising:
-
retrieving the data associated with a vehicle dealership ID from the first database utilizing a computer;
the data including a repair order table and a customer table;
the repair order table including a first record having a repair order ID, a repair order status, a customer ID, and the vehicle dealership ID;
the customer ID being associated with the customer, the vehicle dealership ID being associated with a vehicle dealership;
the customer table having a second record including the customer ID, the vehicle dealership ID, and a customer telephone number;storing the data in a second database utilizing the computer; retrieving the first record from the repair order table in the second database utilizing the computer; and comparing the repair order status from the first record to a first order status utilizing the computer, and if the repair order status corresponds to the first order status then generating a first formatted message utilizing the computer, based on the vehicle dealership ID, the customer ID, and the customer telephone number. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20)
-
Specification