TFNRegistry Reporting: Customer Record History Table (RHDB_CRHIST)

NPA

varchar2(3)

Number Plan Area. This field specifies the NPA of the DIAL# being requested. The first three digits of a DIAL#. Examples: 800, 888, 877, 866, 855, 844 and 833.

TelNumber

varchar2(7)

The 7-digit NXX-LINE number. Example: In the Toll

Free number 800-000-4444, the TelNumber is 0004444.

TelNumberSt

varchar2(2)

Please Note: This field will always be empty.

LastUpdate

date

The date that any History field was changed.

EffectiveDate

date

The date and time when the Customer Record becomes active. Format is in data format. If the value = 12/31/3999 and the CRStatus = ‘X’, this indicates that all Effective Dates for this DIAL# have been deleted.

CRStatus

varchar2(1)

The status of the 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
•  X - Indicates that the Customer Record was deleted. If the Effective Date of this entry is 12/31/3999, this indicates that all Effective Dates for this DIAL# have been deleted.

SvcOrderNum

varchar2(15)

The service order number.

SuppFormNum

varchar2(16)

The supplemental form number.

BillToNumber

varchar2(12)

The account number used for billing purposes.

PrevEntity

varchar2(2)

The Entity that previously owned the DIAL#. This data may not always be available.

PrevOrg

varchar2(3)

The organization that previously owned the DIAL#.

RAOCode

varchar2(3)

The 3-digit code for the Revenue Accounting Office (RAO) that is responsible for billing the customer for the DIAL#.

Download_date

Date

The date when the record was sent to the RHDB database.

CurrEntity

varchar2(2)

The Entity that currently owns the DIAL#.

CurrOrg

varchar2(3)

The organization that currently owns the DIAL#.

Template_Name

varchar2(15)

The Template Name if the record is a Routing Template.

Template_ID

varchar2(10)

The Template ID if the record is a Routing Template.