The Customer Record Summary Counts table contains a summary, by NPA and Resp Org, of total number of Customer Records, complex Customer Records, active Customer Records, and record extract dates (see Table 68 RHDB_CRSUMM).
Table 68 RHDB_CRSUMM
|
RHDB_CRSUMM |
||
|
Field |
Characters |
Description |
|
Entity |
varchar2(2) |
The first two characters in the Resp Org (Responsible Organization) field. Example: BR is the Entity in Resp Org BRNJ1. |
|
Org |
varchar2(3) |
The last 3 characters in the Resp Org field, representing the organization. Example: ZA1 is the organization in Resp Org ZATST. |
|
NPA |
varchar2(3) |
Number Plan Area. This field specifies the NPA of the DIAL# being requested. The first three digits of a DIAL#. Examples: 800, 888, 877, 866, 855, 844 and 833. |
|
NumCR |
number(10) |
The total number of Customer Records. |
|
NumActiveCR |
number(10) |
The total number of Active Customer Records. |
|
NumComplexCR |
number(10) |
The total number of complex Customer Records. |
|
Download_date |
Date |
The date when the record was sent to the RHDB database. |
Index for RHDB_CRSUMM Table
The index and fields used for the RHDB_CRSUMM table are:
|
TFNRegistry Reporting: |
|
|
Index Name |
Fields Used |
|
rhdb_CRSumm_idx1 |
|