Patent ID: 8483370

Claim:
A method for processing a non-normalized local exchange routing guide table to produce a normalized local exchange routing guide table, the local exchange routing guide table having a three digit numbering plan area field, a central office exchange field within the numbering plan area, a block identification field, and a switch identification field, the method comprising: electronically joining all distinct combinations of the numbering plan area and the central office exchange in the non-normalized local exchange routing guide table to all valid 1-digit block identifications to produce the normalized local exchange routing guide table, wherein each subscriber number includes one of the block identifications; automatically populating the switch identification field, in each normalized local exchange routing guide record having a distinct combination of the numbering plan area and central office exchange, based on a number of corresponding non-normalized local exchange routing guide records, on the switch identification field in one of the corresponding non-normalized local exchange routing guide records, and on a number of distinct switch identification values in the corresponding non-normalized local exchange routing guide records, each of the corresponding non-normalized local exchange routing guide records having a same one of the combinations of the numbering plan area and central office exchange; and electronically accessing call detail records and correlating individual telephone numbers and their usage data to the switch identification values in a report showing actual workload of telephony switches; wherein the normalized local exchange routing guide table is used to correlate the call detail records with telephony switch information when generating the report.