The Customer Record Reports Header table contains current Customer Record information, including (see Table 67 RHDB_CRREPHDR):
- Effective date and time for each record
- Carrier information for InterLATA and IntraLATA carriers
- Information on SCPs
Table 67 RHDB_CRREPHDR
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 SMS/800 TFN Registry user that created the record. |
Create_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Update_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
Update_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
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
The index and fields used for the RHDB_CRREPHDR table are:
RHDB_CRREPHDR |
|
Index Name |
Fields Used |
rhdb_CRRepHdr_idx1 |
DialNbr EffectiveDate |
rhdb_ CRRepHdr _idx2 |
ControlRespOrg |
rhdb_ CRRepHdr _idx2 |
ControlRespOrg CRStatus |