The Misrouted Queries table contains data when a specified SCP has received a call processing query on an DIAL# whose NXX is not in its database (the call has been misrouted to the wrong SCP).
| RHDB_MISROUTEDQUERY | ||
| Field | Characters | Description |
| ScpId | varchar2(4) | The SCP that generated the exception report data. |
| ClliCode | varchar2(11) | The 11 character Common Language code for the SCP ID. |
| QueryDate | Date | The date and time the misrouted query took place. |
| DialNbr | varchar2(12) | The NPA-NXX-XXXX for which the misrouted query was received. |
| ExtractDate | Date | The date when the record was sent to the RHDB database. |
Index for RHDB_MISROUTEDQUERY Table
| RHDB_MCC_SCHD | |
| Index Name | Fields Used |
| rhdb_MisroutedQuery_idx1 |
|