Table 100 RHDB_SCPSMSAUDITSUM
|
RHDB_SCPSMSAUDITSUM |
||
|
Field |
Characters |
Description |
|
ScpId |
varchar2(4) |
The SCP ID being audited. |
|
AuditDate |
Date |
The date and time when the batch SCP Reverse Audit was performed. |
|
AuditTapeDate |
Date |
The date and time when the SCP audit file was generated. |
|
Npa |
varchar2(3) |
The NPA of the Toll-Free Number (TFN). |
|
TotalDiscrepancy |
number(15) |
The total number of discrepancies found between the SCP records and the TFNRegistry. |
|
NbrsNotAudited |
number(15) |
The number of records that are not audited because their Eff. Date/Time was later than the start time of the SCP audit file (even though they met the other criteria for the audit). |
|
ExtractDate |
Date |
The date when the record was sent to the RHDB database. |
Index for RHDB_SCPSMSAUDITSUM Table
The index and fields used for the RHDB_SCPSMSAUDITSUM table are:
|
RHDB_SCPSMSAUDITSUM |
|
|
Index Name |
Fields Used |
|
rhdb_ SCPSMSAuditSum _idx1 |
|