TFNRegistry Reporting: NPA-NXX Delete Affected Customer Record Table (RHDB_NXXDELETE_AFFECTED)

NpaNxx

char(6)

The NPA-NXX to be deleted from SMS/800 TFN Registry.

RunDateTime

Date

The date and time the database is searched to generate the report.

DialNbr

varchar2(15)

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

EffectiveDate

Date

The Effective Date/Time of the listed Customer Record.

AutoManualFlag

char(1)

Indicates if the Customer Record will be converted by the NPA-NXX Delete process or if manual conversion will be required.

CrStatus

char(1)

The status of the Customer Record. Status and definitions are:

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

RespOrg

char(5)

The Resp Org for the DIAL#.

AosLabelAff

char(1)

Indicates if the Area of Service label field is affected by the NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

TerminatingNbrAff

char(1)

Indicates if the Terminating Nbr field is affected by the NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

LsoAff

char(1)

Indicates if the LSO field is affected by the NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

FsoAff

char(1)

Indicates if the FSO field is affected by the NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

NPhoneAff

char(1)

Indicates if the NPhone field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

CprSixAff

char(1)

Indicates if the CPR six digit field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

CprNxxAff

char(1)

Indicates if the CPR NXX field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

CprTenAff

char(1)

Indicates if the CPR Ten Digit field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

CprTelnoAff

char(1)

Indicates if the CPR Telephone Number (Tel#) Node is affected by the NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

LadSixAff

char(1)

Indicates if the LAD Six digit field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

LadNxxAff

char(1)

Indicates if the LAD NXX field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

LadTenAff

char(1)

Indicates if the LAD Ten Digit field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

LadTelnoAff

char(1)

Indicates if the LAD Tel# field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

BillTnAff

char(1)

Indicates if the BILLTN field is affected by NXX Delete. Values are:

• 0 = Not Affected
• 1 = Affected

DeleteDate

Date

Date the NXX will no longer be valid in SMS/800 TFN Registry.

rhdb_ NPAOpen_Schd _idx1

• NewNpa
• DialNbr
• EffectiveDate

rhdb_NPAOpen_Schd_idx2

• RespOrg

rhdb_NPAOpen_Schd_idx3

• RespOrg
• NewNpa