TFNRegistry Reporting: NPA-NXX Delete Schedule Customer Record Table (RHDB_NXXDELETE_SCHD)

NpaNxx

char(6)

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

RunDateTime

Date

The date and time the database is searched.

DialNbr

varchar2(15)

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

EffectiveDate

Date

The Effective Date/Time of the listed Customer Record.

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

CvStatus

char(4)

Identifies the conversion status.

• ILST - Illegal Status.
• RNFD - Record Not Found.
• MODI - Customer Record Modified. CR modified before conversion, manual updates may be needed.
• BKTD - Backtracked to DWNTM.
• UPDT - Copied and Scheduled.
• FAVL - Failed Validation.
• VLSC - Validation Successful.
• NOPR - No Processing Needed.
• CPFA - Copy Failed Validation.
• CNCP - Can’t Copy

RespOrg

char(5)

The Responsible Organization 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

rhdb_ NXXDelete_Schd _idx1

• NpaNxx
• DialNbr
• EffectiveDate

rhdb_ NXXDelete_Schd _idx2

• RespOrg

rhdb_ NXXDelete_Schd _idx3

• RespOrg
• NpaNxx