Method, system and computer product for strategic priority order tracking

• US 20040249691A1
• Filed: 06/05/2003
• Published: 12/09/2004
• Est. Priority Date: 06/05/2003
• Status: Abandoned Application

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Schell, H. Mike, Majure, Dustin
• Application Number:
  US10/456,657
• Publication Number:
  US 20040249691A1
• Time in Patent Office: Days
• US Class Current: 705/8
• CPC Class Codes: G06Q 10/06311 Scheduling, planning or task assignment for a person or group
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management

Abstract

A method for strategic priority order tracking comprising receiving a request from a user system to access an order tracking database. The data contained in the order tracking database is sourced from at least one legacy database. Order status data for a customer order is transmitted to the user system in response to a request from the user system to display the order status data for the customer order. The order status data is responsive to data included in the order tracking database corresponding to the customer order and the order status data is displayable as a single screen on the user workstation. A customized report is created in response to a request from the user system to create the customized report. The customized report is responsive to data included in the order tracking database, a data field, a filter option and a sorting option. The customized report is transmitted to the user system in response to the creating a customized report. The order status data for the customer order is updated in response to a request from the user system. The updating includes updating data in the at least one legacy database. The order status data is transmitted to a provisioning group responsible for performing labor requested on the customer order in response to updating the order status data. A priority level associated with the customer order is escalated in response to a request to escalate the customer order.

Claims

1. A method for strategic priority order tracking, the method comprising:

receiving a request to access an order tracking database from a user system, wherein the data contained in said order tracking database is sourced from at least one legacy database;

transmitting order status data for a customer order to said user system in response to a request from said user system to display said order status data for said customer order, wherein said order status data is responsive to data included in said order tracking database corresponding to said customer order and said order status data is displayable as a single screen on said user workstation;

creating a customized report in response to a request from said user system to create the customized report, wherein said customized report is responsive to data included in said order tracking database, a data field, a filter option and a sorting option;

transmitting said customized report to said user system in response to said creating a customized report;

updating said order status data for said customer order in response to a request from said user system, wherein said updating includes updating data in said at least one legacy database;

transmitting said order status data to a provisioning group responsible for performing labor requested on said customer order in response to said updating said order status data; and

escalating a priority level associated with said customer order in response to a request to escalate said customer order.

2. The method of claim 1 wherein said at least one legacy database includes a TIRKS database, a SOAC database, a SOCS database, a WFA database, a DPRO database and a LFACS database.

3. The method of claim 2 wherein said at least one legacy database further includes a BOSIP database.

4. The method of claim 1 wherein said at least one legacy database includes a total circuit provisioning process database, a service order receiver and assignment database, a routing of service orders database, a service order personnel assignment database and a loop facility assignment control system database.

5. The method of claim 1 wherein said order status data includes a text document created by a legacy system and stored in said legacy database.

6. The method of claim 5 wherein said legacy system is a DPRO system and said legacy database is a DPRO database.

7. The method of claim 1 wherein said order status data includes a database file created by a legacy system and stored in said legacy database.

8. The method of claim 1 wherein said request from said user system to display said order status data for said customer order includes an electronic spreadsheet including one or more of said customer orders and said transmitting order status data includes transmitting said order status data for said one or more said customer orders.

9. The method of claim 1 wherein said creating a customized report includes:

transmitting a list of optional data fields included in said order tracking data base to said user system, wherein said optional data elements include said data field;

transmitting a list of filter selections to said user system, wherein said list of filter selections includes said filter option;

transmitting a list of sorting selections to said user system, wherein said list of sorting selections includes said sorting option;

receiving said data field, said filter option and said sorting option from said user system;

automatically generating a query in response to said data field, said filter option and said sorting option; and

executing said query against said order tracking database.

10. The method of claim 9 wherein said filter option includes an account executive employee number.

11. The method of claim 9 wherein said filter option includes a sales consultant employee number.

12. The method of claim 1 further comprising performing an instant messaging function in response to a request from said user system to perform said instant messaging function.

13. The method of claim 1 wherein access to said order tracking database is restricted to a subset of said order tracking database responsive to a user identification associated with the user of said user system.

14. The method of claim 1 further comprising creating a project report in response to a request from said user system to create the project report, wherein said project report includes order status data for a customer order associated with a project number received by said user system.

15. The method of claim 1 wherein said customer order includes a field to specify if said customer order refers to an unbundled network element.

16. The method of claim 1 further comprising creating a project report in response to a request from said user system to create the project report, wherein said project report includes order status data for a customer order associated with a project number received by said user system.

17. The method of claim 1 wherein said user system is accessed by a network provisioning resolution center user.

18. The method of claim 1 wherein said user system is accessed by a customer.

19. The method of claim 1 wherein escalating a priority level associated with the order comprises determining an interval of time by which the labor requested on the order must be completed.

20. The method of claim 1, wherein escalating a priority level associated with the order comprises determining whether a critical date has been reached.

21. The method of claim 1, wherein escalating a priority level associated with the order comprises:

determining whether said provisioning group is responsible for performing the labor requested on the order received the order within a specified period of time; and

in response, adjusting the priority level associated with the order according to whether the provisioning group received the order within the specified time.

22. A system for strategic priority order tracking, the system comprising:

a network;

a first storage device in communication with said network, wherein said first storage device includes an order tracking database;

a second storage device in communication with said network, wherein said second storage device includes at least one legacy database;

a user system in communication with said network; and

a host system in communication with said network, said host system including application software to implement a strategic priority order tracking method comprising;

receiving a request to access said order tracking database from said user system, wherein the data contained in said order tracking database is sourced from said at least one legacy database;

transmitting order status data for a customer order to said user system in response to a request from said user system to display said order status data for said customer order, wherein said order status data is responsive to data included in said order tracking database corresponding to said customer order and said order status data is displayable as a single screen on said user workstation;

creating a customized report in response to a request from said user system to create the customized report, wherein said customized report is responsive to data included in said order tracking database, a data field, a filter option and a sorting option;

transmitting said customized report to said user system in response to said creating a customized report;

updating said order status data for said customer order in response to a request from said user system, wherein said updating includes updating data in said at least one legacy database;

transmitting said order status data via said network to a provisioning group responsible for performing labor requested on said customer order in response to said updating said order status data; and

escalating a priority level associated with said customer order in response to a request to escalate said customer order.

23. The system of claim 22 wherein said host system comprises a first central processing unit and a second central processing unit wherein said first central processing unit reads data from said at least one legacy database and updates said order tracking database and wherein said second central processing unit updates said at least one legacy database.

24. The system of claim 22 wherein said order tracking database includes a current order tracking database and an archive order tracking database.

25. The system of claim 22 wherein said network is the Internet.

26. The system of claim 22 wherein said network is an intranet.

27. The system of claim 22 wherein said order tracking database is a relational database.

28. A computer program product for strategic priority order tracking, the computer program product comprising:

a storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising;

receiving a request to access an order tracking database from a user system, wherein the data contained in said order tracking database is sourced from at least one legacy database;

transmitting order status data for a customer order to said user system in response to a request from said user system to display said order status data for said customer order, wherein said order status data is responsive to data included in said order tracking database corresponding to said customer order and said order status data is displayable as a single screen on said user workstation;

creating a customized report in response to a request from said user system to create the customized report, wherein said customized report is responsive to data included in said order tracking database, a data field, a filter option and a sorting option;

transmitting said customized report to said user system in response to said creating a customized report;

updating said order status data for said customer order in response to a request from said user system, wherein said updating includes updating data in said at least one legacy database;

transmitting said order status data to a provisioning group responsible for performing labor requested on said customer order in response to said updating said order status data; and

escalating a priority level associated with said customer order in response to a request to escalate said customer order.