The number List Change table contains the changes to the following types of lists (see Table 89 RHDB_NUMBERLISTCHG):
- Dest Control
- Dest Surveil - CAC Off
- Dest Surveil - CAC On
- Out of Area
- Vacant Number
Table 89 RHDB_NUMBERLISTCHG
|
RHDB_NUMBERLISTCHG |
||
|
Field |
Characters |
Description |
|
ScpId |
varchar2(4) |
The SCP that generated the exception report data. |
|
ChangeDate |
Date |
The month, day, hour and minute in Central time that the event occurred. |
|
ListType |
varchar2(22) |
The types of lists are:
This indicates that the number was put under surveillance and the Mass Calling Control Override (CAC) feature for the carrier was off in that SCP.
This indicates that the number was put under surveillance and, at the request of the Carrier that controls routing, the Calling Control Override (CAC) feature was on in that SCP.
|
|
DialNbr |
varchar2(12) |
The number added or removed. This can be either a 10-digit number or 6-digit number for vacant numbers and 10-digit only for the remaining list types. |
|
Results |
varchar2(13) |
The results of an attempt to automatically add or remove a number from one of the control or surveillance lists. The possible results are:
|
|
ExtractDate |
Date |
The date when the record was sent to the Reporting. |
Index for RHDB_NUMBERLISTCHG Table
The index and fields used for the RHDB_NUMBERLISTCHG table are:
|
RHDB_NUMBERLISTCHG |
|
|
Index Name |
Fields Used |
|
rhdb_ NumberListChg _idx1 |
|