The Customer Record Reports Header table contains current Customer Record information, including:
- Effective date and time for each record
- Carrier information for InterLATA and IntraLATA carriers
- Information on SCPs
| RHDB_CRREPHDR | ||
| Field | Characters | Description |
| DialNbr | varchar2(12) | A 10 digit Toll-Free Number (DIAL#) in the format NPANXXLINE without any dashes or blank spaces. A DIAL# is comprised of a Number Plan Area (NPA) and a seven-digit NXX- LINE number. Example: 8770004444. |
| EffectiveDate | Date | The date and time when the Customer Record becomes active. Format is in data format. |
| CRStatus | varchar2(1) | The status of the Customer Record. Status definitions are:
|
| Hold_dd | varchar2(1) | The hold indicator. Valid values are:
|
| SvcOrderNum | varchar2(15) | The service order number. |
| SuppFormNum | varchar2(6) | The supplemental form number. |
| CPRInd | varchar2(1) | The Call Processing Record (CPR) indicator. Valid values are:
|
| PrevRespOrg | varchar2(5) | The Resp Org that previously owned the DIAL#. This data may not always be available for this table. |
| BillToNumber | varchar2(12) | The account number used for billing purposes. |
| RAOCode | varchar2(3) | A 3-digit code for the Revenue Accounting Office (RAO) responsible for billing the customer for the DIAL#. |
| InterLataCarr | varchar2(140) | Twenty inter Local Access Transport Area (LATA) carriers, each having 7 bytes. If service covers InterLATAs between LATA areas, the 7 bytes represent:
The order of the carriers is always in the same order as the order that they are saved on the corresponding Customer Record. |
| IntraLataCarr | varchar2(140) | Intra LATA carriers within the LATA areas. Valid values are:
The order of the carriers is always in the same order as the order that they are saved on the corresponding Customer Record page. |
| ExtractDate | Date | The date when the record was sent to the RHDB database. |
| ControlRespOrg | char(5) | The Resp Org that currently owns the DIAL#. |
| Create_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user that created the record. |
| Create_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Update_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
| Update_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Cr_view provides Resp Orgs with the ability to query a Customer Record (CR) that they do not own and see the following data fields: control Resp Org ID, Effective Date and Time, and Dial#, somewhat similar to what Resp Orgs can see if they queried a CR via the REC page. Unlike the REC page, R does not show Carrier Approval Status because that fields is not stored in the RHDB field. |
Index for RHDB_CRREPHDR Table
| RHDB_CRREPHDR | |
| Index Name | Fields Used |
| rhdb_CRRepHdr_idx1 | DialNbr EffectiveDate |
| rhdb_ CRRepHdr _idx2 | ControlRespOrg |
| rhdb_ CRRepHdr _idx2 | ControlRespOrg CRStatus |