The Carrier Info table contains information on the carrier:
- Carrier Name and Carrier Code
- Translation preference(s)
- Status, Effective Date and download date (record extraction date)
| 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
| RHDB_CARRINFO | |
| Index Name | Fields Used |
| rhdb_ Carrinfo _idx1 |
|