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) (see Table 82 RHDB_MISROUTEDQUERY).
Table 82 RHDB_MISROUTEDQUERY
|
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
The index and fields used for the RHDB_MISROUTEDQUERY table are:
|
RHDB_MCC_SCHD |
|
|
Index Name |
Fields Used |
|
rhdb_MisroutedQuery_idx1 |
|