Section 625-2-6 - ALI DATABASE REQUIREMENTSA.General Requirements of the Database Management System Provider (DMSP)1. The DMSP shall construct the database to be redundant and fault tolerant and shall include safeguards to ensure the security of the data.2. The DMSP shall prevent unauthorized access to, or alteration of, any data or databases used in conjunction with E9-1-1 service.3. The data format used by the DMSP shall follow National Emergency Number Association (NENA 2) or standards as otherwise approved by the Bureau.4. Data transfers between the DMSP and all other data providers shall follow the NENA 2 or higher standards or standards as otherwise approved by the Bureau.5. The DMSP shall process order updates received from data providers within one business day of receipt by electronic file transfer.6. The DMSP shall maintain an audit trial of all database changes and provide source documentation to identify the time, date, and origin of any database change to the Bureau upon request.B.General Requirements of Data Providers1. Each data provider shall use a unique NENA Company Identifier for each operating company for which it provides ALI records.2. The data format used by data providers shall follow NENA 2 or standards as otherwise approved by the Bureau.3. Data transfers between the DMSP and all other data providers shall follow the NENA 2 or standards as otherwise approved by the Bureau.4. Each data provider shall work directly with Addressing Officers for database error resolution and verifying problematic addresses at the time of service order provisioning.5. Each data provider shall use error correction codes provided by the Bureau when reporting resolution of data base errors.6. Each data provider shall Master Street Address Guide (MSAG) validate its own customer 9-1-1 service addresses before transmitting them to the DMSP.7. Each data provider shall deliver E9-1-1 service order updates to the DMSP within one business day of the close of service order activity.C.Service Order Error Correction Requirements1.Requirements of DMSP The DMSP shall distribute errors from E9-1-1 updates to the appropriate data provider within one business day of detection.
2.Requirements of Data Providersa. Each data provider shall retrieve E9-1-1 error files each business day as distributed by the DMSP from E9-1-1 update processing.b. Each data provider shall correct all E9-1-1 database processing errors within three business days of retrieval of the error file by the data provider.c. After making three unsuccessful attempts to reach either the customer or the Addressing Officer of the affected town to correct E9-1-1 database processing errors, each data provider shall refer such errors to the Bureau for assistance with resolution.3.Service Quality Requirement for Data Providers Service Order (SO) accuracy for data providers on a monthly basis should be 97 percent or higher as measured by the following formula (this does not include informational errors, only hard errors):
Data Provider Total SO Records Processed - Company's Total SO Errors / Company's Total SO processed = % SO Accuracy
D.No Record Found Conditions1.Requirements of DMSP The DMSP shall identify No Record Found conditions through the ALI audit trail. Such conditions shall be distributed to the appropriate data provider within one business day of identification.
2.Requirements of Data Providersa. Each data provider shall resolve each No Record Found condition within three business days of notification to the data provider by the DMSP.b. Each No Record Found condition shall be considered resolved when the corrected record via the service order process successfully updates the ALI Database.c. Each data provider shall refer unresolved No Record Found database errors and inquiries to the Bureau if not resolved within three working days of receipt.3.No Record Found Quality Standard for Data Providers A data provider's percentage of all No Record Founds in a month shall not exceed its percentage of records in the ALI database. If a data provider's six-month average exceeds such percentage, it shall submit a corrective action plan to the Bureau.
E.ALI Discrepancy Standards1.Requirements of DMSPa. The DMSP shall use an electronic form developed by the Bureau for reporting inaccuracies of ALI information and the misrouting of 9-1-1 calls, and for distribution of the ALI discrepancy to the appropriate database provider for resolution. The form shall include, but not be limited to, a description of the problem, appropriate corrective action or information.b. The DMSP shall inform a data provider of any resulting form problems with a data provider's records within one business day of receipt.2.Requirements of Data Providersa. A data provider shall resolve each ALI discrepancy within three business days of receipt. Such discrepancies will be considered to be resolved either when the appropriate Addressing Officer denies a suggested change or when the correction successfully updates the ALI Database.b. A data provider shall refer unresolved ALI discrepancies to the Bureau if not resolved within three working days of receipt.F.Database Reconciliation Standards1.Requirement of DMSP The DMSP shall provide, on an annual basis, to each data provider a copy such data provider's data that resides on the ALI system such that the data provider is able to validate the accuracy of the data.
2.Requirement of Data Providers Each data provider shall schedule a date for its annual data validation by June 30th of each year. Each data provider shall have completed its annual data validation by December 31st of each year.
G.Master Street Address Guide (MSAG)1.Requirement of DMSPa. The DMSP shall provide to each data provider a copy of the MSAG at least quarterly.b. The DMSP shall provide Data Providers access to electronic MSAG delta files each business day and a fill MSAG extract on a weekly basis.2.Requirements of Data Providersa. Each data provider shall reload its internal MSAG at least quarterly.b. Each data provider shall establish a documented process to receive and use weekly MSAG updates provider by the DMSP.65- 625 C.M.R. ch. 2, § 6