The Report Input Daily Segment Detail table contains the daily log summary for number administration, Customer Records and call sampling, by Login ID (see Table 94 RHDB_RIDSDETAIL).
Table 94 RHDB_RIDSDETAIL
|
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
The index and fields used for the RHDB_RIDSDETAIL table are:
|
RHDB_RIDSDETAIL |
|
|
Index Name |
Fields Used |
|
rhdb_ RIDSDetail _idx1 |
|