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.
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.
| 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 TFNRegistry user that created the record. |
| Create_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Update_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
| Update_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
Index for RHDB_SENDINGCR Table
| RHDB_SENDINGCR | |
| Index Name | Fields Used |
| rhdb_ SendingCR _idx1 |
|