The Customer Record History table contains the history of each Customer Record and includes the Effective Date and time that the Customer Record was last updated.
| RHDB_CRHIST | ||
| Field | Characters | Description |
| 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. |
| TelNumber | varchar2(7) | The 7-digit NXX-LINE number. Example: In the Toll Free number 800-000-4444, the TelNumber is 0004444. |
| TelNumberSt | varchar2(2) | Please Note: This field will always be empty. |
| LastUpdate | date | The date that any History field was changed. |
| EffectiveDate | date | The date and time when the Customer Record becomes active. Format is in data format. If the value = 12/31/3999 and the CRStatus = ‘X’, this indicates that all Effective Dates for this DIAL# have been deleted. |
| CRStatus | varchar2(1) | The status of the Customer Record. Status definitions are:
|
| SvcOrderNum | varchar2(15) | The service order number. |
| SuppFormNum | varchar2(16) | The supplemental form number. |
| BillToNumber | varchar2(12) | The account number used for billing purposes. |
| PrevEntity | varchar2(2) | The Entity that previously owned the DIAL#. This data may not always be available. |
| PrevOrg | varchar2(3) | The organization that previously owned the DIAL#. |
| RAOCode | varchar2(3) | The 3-digit code for the Revenue Accounting Office (RAO) that is responsible for billing the customer for the DIAL#. |
| Download_date | Date | The date when the record was sent to the RHDB database. |
| CurrEntity | varchar2(2) | The Entity that currently owns the DIAL#. |
| CurrOrg | varchar2(3) | The organization that currently owns the DIAL#. |
| Template_Name | varchar2(15) | The Template Name if the record is a Routing Template. |
| Template_ID | varchar2(10) | The Template ID if the record is a Routing Template. |
Index for RHDB_CRHIST Table
| RHDB_CRHIST | |
| Index Name | Fields Used |
| rhdb_CRHist_idx1 |
|
| rhdb_CRHist_idx2 |
|