Correlating call detail records with telephony switch information

1. 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.

2. The method of claim 1 , further comprising:

iterating, using a current combination of the numbering plan area and central office exchange, through all distinct combinations of the numbering plan area and central office exchange in the local exchange routing guide, to populate the switch identification field based on a number of corresponding non-normalized local exchange routing guide records and 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 the current combination of the numbering plan area and central office exchange.

3. The method of claim 2 , wherein the iterating further comprises:

if a number of local exchange routing guide records having the current combination of the numbering plan area and central office exchange is one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the switch identification field from a first non-normalized local exchange routing guide record having the current combination of the numbering plan area and central office exchange.

4. The method of claim 2 , wherein the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange based on a number of distinct switch identification values in the corresponding non-normalized local exchange routing guide record.

5. The method of claim 2 , wherein the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one and a number of distinct switch identification value in the local exchange routing guide records with the current combination of the numbering plan area and central office exchange is one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the distinct switch identification value.

6. The method of claim 2 , wherein the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one and a number of distinct switch identification value in the local exchange routing guide records with the current combination of the numbering plan area and central office exchange is more than one, iterating through all block identification values in the local exchange routing guide records having the current combination of the numbering plan area and central office exchange and setting the switch identification value in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange, the setting based on the current combination of the numbering plan area and central office exchange and the iterated block identification value.

7. The method of claim 1 , wherein the local exchange routing guide table is a LERG6 table.

8. A computer program product, tangibly embodied on a non transitory computer readable medium, 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 computer program product including instructions that, when executed by a processor, cause the processor to initiate operations comprising:

joining all distinct combinations of three digit numbering plan area value and central office exchange in the non-normalized local exchange routing guide table to all valid 1-digit block identifications to produce a normalized local exchange routing guide table, wherein each subscriber number includes one of the block identifications;

populating a 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 and 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.

9. The computer program product of claim 8 , the operations further comprising:

iterating, using a current combination of the numbering plan area and central office exchange, through all distinct combinations of the numbering plan area and central office exchange in the local exchange routing guide, to populate the switch identification field based on a number of corresponding non-normalized local exchange routing guide records and 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 the current combination of the numbering plan area and central office exchange.

10. The computer program product of claim 9 , wherein the iterating further comprises:

determining a first number of local exchange routing guide records having the current combination of the numbering plan area and central office exchange; and

populating, if the first number is one, all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the switch identification field from a first non-normalized local exchange routing guide record having the current combination of the numbering plan area and central office exchange.

11. The computer program product of claim 9 , wherein the iterating further comprises:

determining a first number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange; and

populating, if the first number is more than one, all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange based on a number of distinct switch identification values in the corresponding non-normalized local exchange routing guide record.

12. The computer program product of claim 9 , wherein the iterating further comprises:

determining a first number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange;

determining a second number of distinct switch identification value in the local exchange routing guide records; and

populating, if the first and second numbers are one, all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the distinct switch identification value.

13. The computer program product of claim 9 , wherein the iterating further comprises:

determining a first number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange;

determining a second number of distinct switch identification value in the local exchange routing guide records; and

iterating, if the first and second numbers are one, through all block identification values in the local exchange routing guide records having the current combination of the numbering plan area and central office exchange and setting the switch identification value in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange, the setting based on the current combination of the numbering plan area and central office exchange and the iterated block identification value.

14. The computer program product of claim 8 , wherein the local exchange routing guide table is a LERG6 table.

15. A system 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 system comprising:

a memory having stored thereon program code; and

a processor programmed by the program code for initiating operations including:

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, 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 and 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.

16. The system of claim 15 , the operations further comprising:

iterating, using a current combination of the numbering plan area and central office exchange, through all distinct combinations of the numbering plan area and central office exchange in the local exchange routing guide, to populate the switch identification field based on a number of corresponding non-normalized local exchange routing guide records and 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 the current combination of the numbering plan area and central office exchange.

17. The system of claim 16 , the iterating further comprises:

if a number of local exchange routing guide records having the current combination of the numbering plan area and central office exchange is one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the switch identification field from a first non-normalized local exchange routing guide record having the current combination of the numbering plan area and central office exchange.

18. The system of claim 16 , the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange based on a number of distinct switch identification values in the corresponding non-normalized local exchange routing guide record.

19. The system of claim 16 , the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one and a number of distinct switch identification in the local exchange routing guide records with the current combination of the numbering plan area and central office exchange is one, populating all records in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange with the distinct switch identification.

20. The system of claim 16 , the iterating further comprises:

if a number of non-normalized local exchange routing guide records having the current combination of the numbering plan area and central office exchange is more than one and a number of distinct switch identification value in the local exchange routing guide records with the current combination of the numbering plan area and central office exchange is more than one, iterating through all block identification values in the local exchange routing guide records having the current combination of the numbering plan area and central office exchange and setting the switch identification value in the normalized local exchange routing guide having the current combination of the numbering plan area and central office exchange, the setting based on the current combination of the numbering plan area and central office exchange and the iterated block identification value.