The Report Input Daily Segment Header table contains a summary of daily activity information, summed by Resp Org.
| RHDB_RIDSHDR | ||
| 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. |
| 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. |
Index for RHDB_RIDSHDR Table
| RHDB_RIDSDETAIL | |
| Index Name | Fields Used |
| rhdb_ RIDSHdr _idx1 |
|