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.
| 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
| TFNRegistry Reporting: | |
| Index Name | Fields Used |
| rhdb_CRSumm_idx1 |
|