Abstract: A system and method of managing telephone network facilities. A telephone network facilities database, such as LEIS, is accessed and selected information, including wire center location, equipment and slot information stored therein, is extracted and re-stored in a relational database. Additional fields in the relational database are populated based on the information extracted from the telephone network facilities database. The additional fields represent working ADSL and T1 facilities, ADSL and T1 capacity, and ADSL and T1 availability. A graphical user interface is provided that displays several views of the data in the relational database. Color coding aspects of the graphical user interface indicates capacity levels.

Abstract: The present invention is directed to a system and method for employing telecommunications capacity information. In an embodiment of the present invention as a computer system, a batch server retrieves data from various digital subscriber line (DSL) related data sources and stores that data in a database. The data sources contain data related to the supply and demand for DSL services. The data source includes hierarchical attributes, such as an indicator of the geography from which specific data originated. Another embodiment also includes an interdisciplinary attribute, such as a department name. An embodiment of the present invention also includes a web server. In response to a request, the web server extracts the data from the database, and if necessary, calculates information concerning future supply and demand for DSL services. The web server generates an HTML report containing this data and transmits the report to the originator of the request.