| RHDB_CRINVENTORY_VIEW | ||
| Field | Characters | Description |
| Dialnbr | Varchar2(10) | A 10 digit Toll-Free Number (DIAL#). |
| Numberstatus | Varchar2(1) | Status of Dial Number in Number Administration. Valid values are:
|
| StatusChangeDate | Date | Date the Dial Number went Transitional |
| Entity | Varchar2(2) | The first two characters of the user’s Resp Org. |
| Resporg | Varchar2(5) | Control Resp Org that owns the Dial Number. |
| Update_Time | Timestamp(6) | The date and time the record was last updated in the SMS/800 TFN Registry. |
| Effectivedate | Date | The Effective Date of the Customer Record. |
| CRStatus | Varchar2(1) | The status of Customer Record. Status definitions are:
|
| CPRInd | Varchar2(1) | The Call Processing Record (CPR) indicator. Valid values are:
|
| InterLATAcarr | Varchar2(4000) | Twenty inter Local Access Transport Area (LATA) carriers, each having 7 bytes. If service covers interLATAs between LATA areas, the 7 bytes represent:
|
| IntraLATAcarr | Varchar2(4000) | 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. |
| TemplateName | Varchar2(15) | The Template Name if the record is a Routing Template. |
| AOSLabel | Varchar2(250) | Area of Service (AOS) Label. |
| Network | Varchar2(50) | The CCS network code. |
| LATA | Varchar2(250) | The LATA values. |
| NPA | Varchar2(250) | The NPA value. |
| State | Varchar2(250) | The State code. |
| Extractdate | Date | The date when the record was sent to the RHDB database. |