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.
| 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 TFNRegistry. |
| ExtractDate | date | The date when the record was sent to the RHDB database. |
Index for RHDB_CRAUDITRESULTS Table
| RHDB_CRAUDITRESULTS | |
| Index Name | Fields Used |
| rhdb_CRAuditResults_idx1 |
|
| rhdb_CRAuditResults_idx2 |
|