The Sending Customer Records table includes data related to the DIAL#s for a specified controlling Resp Org that were in a Sending status at the time of the last extract to the Web Based Reporting (see Table 102 RHDB_SENDINGCR).
Included in this table are the following fields:
- Control Resp Org that owns the Dial Number.
- Toll Free Service Dial Number.
- The Effective Date of the Dial Number.
- The current status of the Customer Record.
- The SCP IDs for those SCPs having a status other than OK or LO.
- A two-character SCP status code used to determine why the
- Record is not in the SCP. Possible status codes include:
- The date and time response received from the SCP ID.
- The date the record was last updated.
Table 102 RHDB_SENDINGCR
|
RHDB_SENDINGCR |
||
|
Field |
Characters |
Description |
|
RespOrg |
char(5) |
Controlling Resp Org that owns the CR. |
|
DialNbr |
varchar2(15) |
A 10 digit Toll-Free Number (DIAL#) or Template Name. |
|
EffectiveDate |
Date |
Effective Date of CR. |
|
CrStatus |
char(1) |
Status of Customer Record. |
|
ScpId |
char(4) |
SCP ID. |
|
ScpStatus |
char(2) |
Status returned by SCP ID.
|
|
ScpResponseDate |
Date |
Date and Time Response received from SCP ID. |
|
ExtractDate |
Date |
Date of the record when it was last added/updated in Reporting. |
|
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. |
Index for RHDB_SENDINGCR Table
The index and fields used for the RHDB_SENDINGCR table are:
|
RHDB_SENDINGCR |
|
|
Index Name |
Fields Used |
|
rhdb_ SendingCR _idx1 |
|