METHODS, SYSTEMS, AND COMPUTER PROGRAM PRODUCTS FOR PROVIDING CONSOLIDATED ORDER INFORMATION

• US 20080222098A1
• Filed: 03/06/2007
• Published: 09/11/2008
• Est. Priority Date: 03/06/2007
• Status: Abandoned Application

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Simpson, Joseph
• Application Number:
  US11/682,411
• Publication Number:
  US 20080222098A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0603 Catalogue ordering

Abstract

Exemplary embodiments relate to methods, systems, and computer program products for providing consolidated order information. Methods include receiving one or more order numbers corresponding to customer orders for network provider services. Information corresponding to the orders numbers are retrieved from a plurality of sources including order summary data, order detail data, customer data and network data. The retrieved information is stored as consolidated order data. A request for a report is received from a user. The request includes selection criteria specifying a subset of the consolidated order data. The report is created by applying the selection criteria to the consolidated order data and the report is transmitted to the user.

Claims

1. A method for providing order information, the method comprising:

receiving one or more order numbers corresponding to customer orders for network provider services;

retrieving information corresponding to the order numbers from a plurality of sources, the sources including order summary data, order detail data, customer data and network data;

storing the retrieved information as consolidated order data;

receiving a request from a user for a report, the request including selection criteria specifying a subset of the consolidated order data;

creating the report by applying the selection criteria to the consolidated order data; and

transmitting the report to the user.

2. The method of claim 1 wherein the one or more order numbers are generated by extracting the order numbers from the order summary data.

3. The method of claim 1 wherein the retrieved information includes historical information about closed orders.

4. The method of claim 1 wherein the retrieved information includes information about open orders.

5. The method of claim 1 wherein the order summary data includes one or more of a department, a region, a due date, an order type, a status and a project for each of the order numbers.

6. The method of claim 1 wherein the order detail data includes one or more of a customer identifier, a rework required indicator, a due date, a date received, a date closed, a status, an order type, an order description, a department, a region, an estimated resource required, and an actual resource required for each of the order numbers.

7. The method of claim 1 wherein the customer data includes one or more of a customer name, a customer address, a geographic location, and a type of service for each of the customer identifiers.

9. The method of claim 1 wherein the selection criteria specifies all of the consolidated order data.

10. The method of claim 1 wherein the selection criteria includes a due date range, a status, and a department and the report includes consolidated order data for order numbers assigned to the department that have due dates that fall within the due date range with the specified status.

11. The method of claim 1 wherein the selection criteria includes a status, a closed date range, and a department and the report includes consolidated order data for order numbers assigned to the department that have a closed date that falls within the date closed range with the specified status.

12. The method of claim 1 wherein the selection criteria includes a received date range, a status, and a department and the report includes consolidated order data for order numbers assigned to the department that have received dates that fall within the received date range with the specified status.

8. The method of claim 8 wherein the network data includes one or more of a circuit detail, a network detail and an equipment type for each of the types of service at each of the geographic locations.

13. A system for providing order information, the system comprising:

a processor; and

software instructions executing on the processor for facilitating;

receiving one or more order numbers corresponding to customer orders for network provider services;

retrieving information corresponding to the order numbers from a plurality of sources, the sources including order summary data, order detail data, customer data and network data;

storing the retrieved information as consolidated order data;

receiving a request from a user for a report, the request including selection criteria specifying a subset of the consolidated order data;

creating the report by applying the selection criteria to the consolidated order data; and

transmitting the report to the user via a network.

14. The system of claim 13 wherein the retrieving is via the network.

15. They system of claim 13 wherein the consolidated order data is stored as one or more of a database and a spreadsheet on a storage device.

16. The system of claim 13 wherein the report is transmitted in a spreadsheet format.

17. A computer program product for providing order information, the computer program product comprising a storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for facilitating a method comprising:

receiving one or more order numbers corresponding to customer orders for network provider services;

retrieving information corresponding to the order numbers from a plurality of sources, the sources including order summary data, order detail data, customer data and network data;

storing the retrieved information as consolidated order data;

receiving a request from a user for a report, the request including selection criteria specifying a subset of the consolidated order data;

creating the report by applying the selection criteria to the consolidated order data; and

transmitting the report to the user.

18. The computer program product of claim 17 wherein the retrieved information includes wherein the retrieved information includes information about closed orders and information about open orders.