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 |
|