The Carrier Info table contains information on the carrier (see Table 113 RHDB_CARRINFO):
- Carrier Name and Carrier Code
- Translation preference(s)
- Status, Effective Date and download date (record extraction date)
Table 113 RHDB_CARRINFO
|
RHDB_CARRINFO |
||
|
Field |
Characters |
Description |
|
CarrName |
varchar2(3) |
The three-letter alpha ACNA for the carrier, listed vertically. If the sort is by Carrier, the carrier names are listed alphabetically in the left column. |
|
CarrCode |
varchar2(4) |
The CIC for the carrier, listed vertically. If the sort is by:
|
|
Translation |
varchar2(1) |
The Translation column contains one of the following:
|
|
Action |
varchar2(1) |
This column displays the status of the Carrier, indicating whether the carrier is pending, a deletion or an addition. |
|
EffectiveDate |
Date |
The Effective Date for the Action of the Carrier. The date is either a PENDING DELETION or a PENDING ADDITION. Format is in date format. |
|
Download_date |
Date |
The date when the record was sent to the RHDB database. |
|
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. |
Index for RHDB_CARRINFO Table
The index and fields used for the RHDB_CARRINFO table are:
|
RHDB_CARRINFO |
|
|
Index Name |
Fields Used |
|
rhdb_ Carrinfo _idx1 |
|