System and method for auditing and reconciliation of telephone service provider's databases with a regional or central data repository

A method for facilitating an auditing and reconciliation process of telephone service providers' databases with a data repository, the databases and repository each storing telephone data records, the method comprising the steps of:

• (a) prompting a user to make a first selection from one of an on demand auditing time and a scheduled auditing time;
• (b) prompting a user to select from one of auditing a subset of data in a telephone service provider's database and auditing all of the data in the database;
• (c) prompting a user to select an instruction for executing one of a plurality of auditing subroutines, the auditing subroutines comprising data record processing applications that audit data in the service provider's database based upon data in a telephone data repository database;
• (d) executing, at the time selected in step (a), the auditing subroutine selected in step (c) on the data set selected in step (b);
• and
• (e) receiving results from the auditing subroutine selected in step (c);
• (f) extracting information from the results responsive to the data processing application selected in step (c);
• (g) formatting the results and extracted information for facilitating electronic medium storage;
• (h) writing the formatted results and formatted extracted information into an electronic storage medium;
• (i) formatting the results for electronic transmission to the user;
• (j) electronically transmitting the formatted results to the user;
• (k) repeating steps (a) through (j) until a termination signal is received, wherein the termination signal is generated either by user input or as an integral part of the auditing and reconciliation process.

An interface system for facilitating auditing and reconciliating of a telephone service providers database and a telephone data repository, the interface system comprising:

• a telephone data repository containing data records, the data records comprising telephone number portability information;
• a telephone service provider database containing data records, the database and service provider in electrical communication with the repository;
• a plurality of distinct data pipes for facilitating electrical communication of data records, a first end of the pipes in electrical communication with the repository;
• and
• a plurality of data records processing applications for facilitating the extraction of data records from the repository and communication of data records to the database, a second end of the pipes in electrical communication with the applications such that requests for data extraction are received from the telephone service provider in the database and in response to the request at least one of the applications facilitates retrieval of data records and communication of data records to the database.

An interface system for facilitating auditing and reconciliating of a telephone service providers database and a telephone data repository, the interface system comprising:

• a telephone data repository means for containing data records comprising telephone number portability information;
• a telephone service provider database means for containing data records, the database and service provider in communication with the repository;
• a plurality of distinct data pipes means for facilitating communication of data records between the telephone data repository means and the telephone service provider database means, a first end of the pipes in electrical communication with the repository;
• and
• a plurality of data records processing means for facilitating the extraction of data records from the repository and communication of data records to the database, a second end of the pipe means in communication with the data records processing means such that requests for data extraction are received from the telephone service provider means in the repository means and in response to the request at least one of the data records processing means facilitates retrieval of data records from the repository means and communication of data records to the telephone service providers database means.