The Customer Record Audit Results table contains the results of a comparison between the two versions of the Customer Record: the translated SMS version and the SCP version (see Table 64 RHDB_CRAUDITRESULTS).
Table 64 RHDB_CRAUDITRESULTS
|
RHDB_CRAUDITRESULTS |
||
|
Field |
Characters |
Description |
|
DialNbr |
varchar2(15) |
The Dial# or Template Name on which the audit was performed. |
|
RequestDate |
date |
The date and time the audit request was issued. |
|
SequenceNbr |
number(5) |
Data value to maintain uniqueness of table data. |
|
LogonId |
varchar2(8) |
The Login ID of the person who issued the audit request. |
|
ScpId |
varchar2(4) |
The SCP ID audited. |
|
EffectiveDate |
date |
Effective date and time of the Customer Record. |
|
Resporg |
varchar2(5) |
The controlling Resp Org of the dialed number. |
|
AuditResult |
varchar2(72) |
The results from each of the audited SCPs. Possible value: 503100 AUDIT COMPLETED. RECORDS MATCH |
|
ResponseDate |
date |
Date and time when SCP response received by the SMS/800 TFN Registry. |
|
ExtractDate |
date |
The date when the record was sent to the RHDB database. |
Index for RHDB_CRAUDITRESULTS Table
The index and fields used for the RHDB_CRAUDITRESULTS table are:
|
RHDB_CRAUDITRESULTS |
|
|
Index Name |
Fields Used |
|
rhdb_CRAuditResults_idx1 |
|
|
rhdb_CRAuditResults_idx2 |
|