The Report Input Daily Segment Header table contains a summary of daily activity information, summed by Resp Org (see Table 95 RHDB_RIDSHDR).
Table 95 RHDB_RIDSHDR
|
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
The index and fields used for the RHDB_RIDSHDR table are:
|
RHDB_RIDSDETAIL |
|
|
Index Name |
Fields Used |
|
rhdb_ RIDSHdr _idx1 |
|