TFNRegistry Reporting: Number AOS and CIC Table (RHDB_CRINVENTORY_VIEW)

Dialnbr

Varchar2(10)

A 10 digit Toll-Free Number (DIAL#).

Numberstatus

Varchar2(1)

Status of Dial Number in Number Administration. Valid values are:

• A (Assigned) - Associated with a pending Customer Record that has been established in SMS/800 TFN Registry, but is not yet active in the Service Control Point (SCP)
• P (Suspend) - Disconnected but scheduled to be reactivated
• D (Disconnect) - Service has been terminated
• R (Reserved) - Holding for future use by a customer
• T (Transitional) - Service has been terminated for less than the specified number of months and is no longer on intercept
• U (Unavailable) - Removed from use and cannot be assigned until it is released
• W (Working) - Has a Customer Record status of active or sending

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:

• A – Active
• D - Disconnect
• F - Failed
• H - Hold
• I - Invalid
• M - Must Check
• O - Old
• P - Pending
• S - Sending
• U – Saved

CPRInd

Varchar2(1)

The Call Processing Record (CPR) indicator. Valid values are:

• Y - The Customer Record or Template Record has a CPR
• N - The Customer Record or Template Record does not have a CPR

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:

• a 3-letter Access Customer Name Abbreviation (ACNA)
• a 4-digit Carrier Identification Code (CIC)
• 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(4000)

Intra LATA carriers within the LATA areas. Valid values are:

• 4-digit CIC
• 3-alphabetic ACNA

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.