The Report Input Daily Segment Detail table contains the daily log summary for number administration, Customer Records and call sampling, by Login ID.
| RHDB_RIDSDETAIL | ||
| Field | Characters | Description |
| Entity | varchar2(2) | The first two characters in the Resp Org (Responsible Organization) field. Example: BR is the Entity in Resp Org BRNJ1. |
| Org | varchar2(3) | The last three characters in the Resp Org field, representing the organization. Example: NJ1 is the organization in Resp Org BRNJ1. |
| ActivityDate | Date | The date for the day requested. |
| LogonId | varchar2(3) | The assigned SMS/800 Login ID. The last three characters of the full Login ID. |
| NAReserved | number(12) | The Number Administration (NA) number that represents the total DIAL#s reserved for each Resp Org on the activity date. |
| NASpare | number(12) | The NA spare number that represents the total number of DIAL#s returned to spare for each Resp Org on the activity date. |
| NAOther | number(12) | The combined total of DIAL#s modified, such as CHG NOTES, RSV UNTIL, CHG RESP ORG, and DIAL#s made unavailable for each Resp Org on the activity date. |
| CRNewConnect | number(12) | The total number of new connects for each Resp Org on the activity date. |
| CRDisconnect | number(12) | The total number of disconnects for each Resp Org on the activity date. |
| CRResend | number(12) | The total number of resends and resends of deletes for each Resp Org on the activity date. |
| CRChanges | number(12) | The total number of changes, including transfers, copies, deletions, saves and modifies with future Effective Dates and updates to records with an Action code of C for each Resp Org on the activity date. |
| CSReqAdd_Chg | number(12) | The number of call sampling requests added or changed for each Resp Org on the activity date. |
| CSReqDeleted | number(12) | The total number of call sample requests deleted for each Resp Org on the activity date. |
| Download_date | Date | The date when the record was sent to the Reporting. |
| RespOrg | varchar2(5) | The Resp Org ID. Please Note: This field is only available in Reporting. |
| SelectDate | Date | Activity Date prompt. This is an object created specifically for Reporting to provide a date only prompt for the Activity Date, which is actually a timestamp field. Therefore, this field is not available in RHDB SQL*Net or SFTP. |
Index for RHDB_RIDSDETAIL Table
| RHDB_RIDSDETAIL | |
| Index Name | Fields Used |
| rhdb_ RIDSDetail _idx1 |
|