Patent ID: 7941520
Filing Date: 2011-05-10
Classification: H04M

Abstract:
1. A method of managing telephone network facilities, comprising: accessing a first computer having LEIS loaded thereon; extracting from LEIS information from a plurality of first tables, the information being in the form of individual records with each record including a field that includes a wire center identifier, wherein the wire center identifier identifies a geographical location of at least one central office which supplies a communications service to a plurality of remote terminals, the records specifying slots per piece of equipment, equipment per location, locations per wire center; formatting the extracted information into a pipe-delimited flat file, compressing the flat file, tarring the flat file, and porting the compressed and tarred information of the flat file to a second computer by a file transfer protocol; loading, from the second computer, the information of the compressed and tarred flat file into a relational database by untarring and uncompressing the flat file and storing the information from the table such that the information of the relational database is organized according to the wire center identifier of each of the records; manipulating the relational database to populate a plurality of second tables with data representative of telephone network facilities where such second tables are organized by wire center; displaying at least a portion of the data in the second tables via a graphical user interface, the graphical user interface providing a prompt for a district wherein multiple wire centers exist for each district, and in response to receiving a district, listing the available wire centers for the district, and upon receiving a selection of the available wire centers, accessing the information from the relational database based on the wire centers selected to thereby display for each selected location of the wire center the individual pieces of equipment, the T1 circuits available, the T1 circuits working, the total T1 circuits, the ADSL circuits available, the ADSL circuits working, and the total ADSL circuits, wherein the selected location is displayed against a colored background, the color corresponding to a range comprising a minimum percentage and a maximum percentage of the T1 circuits in use at the location, with the information of each location being displayed in a separate window, and with the windows of the locations being cascaded; and providing a matrix of feeder-distribution interface data in the telephone network, the matrix including a plurality of service type fields for identifying different telecommunications services provided in the telephone network, a plurality of facility type fields for identifying facilities having different transmission characteristics, and a spare field for identifying a number of spare circuits for each of the plurality of facility types, wherein the matrix displays a number of circuits for each of a plurality of service types which are being served from each of the plurality of facility types and a number of the different telecommunication services which are capable of being provisioned for each of the plurality of service types based on the number of spare circuits.