TFNRegistry Reporting: Daily Customer Record Activation Summary Table (RHDB_DAILYCRACTIVATION)

ActivationDate

date

The date the Customer Record was activated at the SCPs.

DialNbr

varchar2(15)

The Dial# or Template Name for which a Customer Record became Active or was updated at the SCPs on the given day.

EffectiveDate

Date

The Effective Date and Time of the Customer Record.

Resporg

varchar2(5)

The organization responsible for the Customer Records listed in the report.

Agent

varchar2(5)

The Customer or Agent ID of the record as entered on the CAD (will only be present for Customer or Agent Dial#s). This field only appears on the Resp Org version.

ScpId

varchar2(4)

The identification codes of the SCPs where the specified Customer Records were activated. When the report is requested for a specific network, all the SCPs in the specified network that were affected by Customer Record activations are listed for each record. When the report is requested for a specific SCP, then only the Customer Records activated in the specified SCP are listed.

ScpResponse

varchar2(1)

The Action occurring to the Customer Record at the SCP. One of the following:

• N - Loaded new record loaded into specific SCP(s).
• C - Changed record loaded into specified SCP(s).
• D - Disconnect record (no referral).
• I - On intercept record (disconnect record with referral).
• X - Deleted record from specified SCP(s).
• R - Removed record from specified SCP(s) after the end-intercept date has been reached.

For example, if a record initially had an AOS of BA and was updated to now have an AOS of BA and AM, then on the report for BA the Action would be “C” whereas on the report for AM the Action would be “N”.

ExtractDate

Date

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

Network

Varchar2(2)

Network ID of the SCP. This is an object created only for Reporting to aid in generating the report.

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.

rhdb_ DailyCRActivation _idx1

• Activation
• DialNbr
• EffectiveDate
• ScpId

rhdb_ DailyCRActivation _idx2

• RespOrg
• ActivationDate
• DialNbr
• EffectiveDate

rhdb_ DailyCRActivation _idx2

• ScpId
• ActivationDate
• DialNbr
• EffectiveDate