The table below identifies the security restriction and refresh rates for each RHDB table. As a general rule, RHDB security for tables uses the CONTROLRESPORG or RESPORG fields, although there are exceptions as noted in the table below (see Table 2 Data Source Security and Refresh Intervals).
Table 2 Data Source Security and Refresh Intervals
|
Data Source Security and Refresh Intervals |
||
|
Data Source |
User Security Restrictions |
Refresh Interval |
|
RHDB_ALLOWABLECICS |
Restricted at Entity Level |
Realtime |
|
RHDB_AOSLABELS |
Unrestricted |
Realtime |
|
RHDB_AOSLABELTODIALNBR |
Restricted at Entity Level |
Realtime |
|
RHDB_ASSIGNEDNUMBERS |
Restricted at Entity Level |
Realtime |
|
RHDB_CAGIMPACT |
Restricted at Entity Level |
Daily |
|
RHDB_CARRINFO |
Unrestricted |
Realtime |
|
RHDB_CHANGEDNPANXX |
Unrestricted |
Daily |
|
RHDB_CRACTLOG |
Restricted at Entity Level |
Realtime |
|
RHDB_CRAUDITRESULTS |
Restricted at Entity Level |
Daily |
|
RHDB_CRDESTNUM |
Restricted at Entity Level |
Daily |
|
RHDB_CRHIST |
Restricted at Entity Level |
Live |
|
RHDB_CRREPHDR RHDB_CRREPHDR_DEFICIENT |
Restricted at Entity Level |
Realtime |
|
RHDB_CRSUMM |
Restricted at Entity Level |
Realtime |
|
RHDB_DAILYCRACTIVATION |
Restricted at Entity Level |
Realtime |
|
RHDB_DESTNPANXX RHDB_DESTNPANXX_Destination |
Restricted at Entity Level |
Realtime |
|
RHDB_EXECUTIONERRORS |
Restricted at Entity Level |
Daily |
|
RHDB_INVALID6D_AOSLABEL |
Restricted at Entity Level |
Batch Daily |
|
RHDB_INVALID6D_CRAFFECT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_INVALID6D_CRCONVERT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_INVALID6D_CRREJECT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_LOGONID_HISTORY |
Restricted at Entity Level |
Realtime |
|
RHDB_LOWSAMPLESPACE |
Restricted at Entity Level |
Daily |
|
RHDB_MASSCALLINGDATA |
Restricted at Entity Level |
Daily |
|
RHDB_MCC_AFFECTED_POST |
Restricted at Entity Level |
Batch Daily |
|
RHDB_MCC_AFFECTED_PRIOR |
Restricted at Entity Level |
Batch Daily |
|
RHDB_MCC_RJCT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_MCC_SCHD |
Restricted at Entity Level |
Batch Daily |
|
RHDB_MISROUTEDQUERY |
Restricted at Entity Level |
Daily |
|
RHDB_NAACTLOG |
Restricted at Entity Level |
Realtime |
|
RHDB_NAHIST |
Unrestricted |
Live |
|
RHDB_NAREP |
Restricted at Entity Level |
Realtime, Weekly Snapshot and Monthly Snapshot |
|
RHDB_NASUMM |
Restricted at Entity Level |
Realtime |
|
RHDB_NBR_INVTRY_CR_TYPE_REP |
Restricted at Entity Level |
Realtime |
|
RHDB_NETWORKLATA |
Unrestricted |
Daily |
|
RHDB_NETWORKSTATENPA |
Unrestricted |
Daily |
|
RHDB_NPAOPEN_AFFECTED |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NPAOPEN_RJCT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NPAOPEN_SCHD |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NUMBERLISTCHG |
Restricted at Entity Level |
Daily |
|
RHDB_NXXDELETE_AFFECTED |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NXXDELETE_RJCT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NXXDELETE_SCHD |
Restricted at Entity Level |
Batch Daily |
|
RHDB_NXXUSED |
Restricted at Entity Level |
Realtime |
|
RHDB_PARAMETERS |
Restricted at Entity Level |
Daily |
|
RHDB_RACHISTORY |
Restricted at Entity Level |
Realtime |
|
RHDB_RDCHISTORY |
Restricted at Entity Level |
Realtime |
|
RHDB_RESERVEDNUMBERS |
Restricted at Entity Level |
Realtime |
|
RHDB_RESPORG |
Unrestricted |
Realtime |
|
RHDB_RESPORG_SPARENUM_HIST |
Unrestricted |
Realtime |
|
RHDB_RIDSDETAIL |
Restricted at Entity Level |
Realtime |
|
RHDB_RIDSHDR |
Restricted at Entity Level |
Realtime |
|
RHDB_SCPAOSEXP_AFFECTED |
Restricted at Entity Level |
Batch Daily |
|
RHDB_SCPAOSEXP_RJCT |
Restricted at Entity Level |
Batch Daily |
|
RHDB_SCPLIST |
Unrestricted |
Daily |
|
RHDB_SCPNPANXX |
Restricted at Entity Level |
Realtime |
|
RHDB_SCPSMSAUDITRESULTS |
Restricted at Entity Level |
Batch Daily |
|
RHDB_SCPSMSAUDITSUM |
Restricted at Entity Level |
Batch Daily |
|
RHDB_SCPSTATUS |
Restricted at Entity Level |
Daily |
|
RHDB_SECURITYUSERDATA |
Restricted at Entity Level |
Realtime |
|
RHDB_SENDINGCR |
Restricted at Entity Level |
Daily |
|
RHDB_SMSLOGONS |
Unrestricted |
Realtime |
|
RHDB_SPECIALSTUDIES |
Restricted at Entity Level |
Daily |
|
RHDB_SSP |
Restricted at Entity Level |
Realtime |
|
RHDB_SSPOVERFLOW |
Restricted at Entity Level |
Daily |
|
RHDB_TELCO |
Unrestricted |
Daily |
|
RHDB_TEMPLATE_DIALNBR |
Restricted at Entity Level |
Realtime |
|
RHDB_TEMPLATE_HISTORY |
Restricted at Entity Level |
Realtime |
|
RHDB_TEMPLATES |
Restricted at Entity Level |
Realtime |
|
RHDB_TEMPLATES_CARRINFO |
Restricted at Entity Level |
Realtime |
|
RHDB_TRANSITIONALNUMBERS |
Restricted at Entity Level |
Realtime |
|
RHDB_UNAVAILABLENUMBERS |
Restricted at Entity Level |
Realtime |
|
RHDB_UNREFERENCED_TMPL_REP |
Restricted at Entity Level |
Realtime |
|
RHDB_USERS |
Restricted at Entity Level |
Realtime |
|
RHDB_CRINVENTORY_VIEW |
Restricted at Entity Level |
Realtime, Weekly Snapshot and Monthly Snapshot |
|
RHDB_SPARE_FORECAST |
Unrestricted |
Realtime |
|
RHDB_NEW_POINTER_RECORD_LIST_VIEW |
Restricted at Entity Level |
Realtime |
|
RHDB_TMPL_UTILIZATION_DATA_RESPORG |
Restricted at Entity Level |
Realtime |
|
RHDB_RESPORG_CHANGE_REPORT |
Restricted at Entity Level |
Realtime |
|
RHDB_CROSS_ENTITY_ACTIVITY_REPORT_VIEW |
Restricted at Entity Level |
Realtime |
The table below identifies the Data Source (RHDB table) for each Reporting report. A users customized reports will not be in the list below (see Table 3 Report and Data Source Mapping).
Table 3 Report and Data Source Mapping
|
Report and Data Source Mapping |
|
|
Report Name |
Data Source |
|
Approaching Due Number Report |
RHDB_RESERVEDNUMBERS |
|
Assigned Numbers Report |
RHDB_ASSIGNEDNUMBERS |
|
Daily Log Number Administration Summary Report |
RHDB_NAACTLOG |
|
Destination NPA-NXX Report |
RHDB_DESTNPANXX |
|
Number Administration Summary Report |
RHDB_NASUMM |
|
POTS to TFN Report |
RHDB_DESTNPANXX |
|
Reserved Numbers Report |
RHDB_RESERVEDNUMBERS |
|
Number Inventory Report |
RHDB_CRINVENTORY_VIEW |
|
Transitional Numbers Report |
RHDB_TRANSITONALNUMBERS |
|
Unavailable Numbers Report |
RHDB_UNAVAILABLNUMBERS |
|
Affected Customer Records by Invalid 6-Digit Report |
RHDB_INVALID6D_CRAFFECT |
|
Affected Customer Records SCP AOS Expansion Report |
RHDB_SCPAOSEXP_AFFECTED |
|
Allowable CICs for Customer Record Input and Approval Report |
RHDB_ALLOWABLECICS |
|
AOS to TFN Report |
RHDB_AOSLABELTODIALNBR |
|
Customer Record Audit Results Report |
RHDB_CRAUDITRESULTS |
|
Customer Records Affected by NPA Code Opening Report |
RHDB_NPAOPEN_AFFECTED |
|
Customer Records Rejected by Conversion for NPA Code Opening Report |
RHDB_NPAOPEN_RJCT |
|
Customer Records Scheduled by Conversion for NPA Code Opening Report |
RHDB_NPAOPEN_SCHD |
|
Daily Customer Record Activation Summary Report |
RHDB_DAILYCRACTIVATION |
|
Daily Log Customer Record Report |
RHDB_CRACTLOG |
|
Daily Log Customer Record Summary Report |
RHDB_RIDSDETAIL |
|
Deficient Customer Records Report |
RHDB_CRREPHDR |
|
Mass Carrier Change Converted Customer Records Report |
RHDB_MCC_SCHD |
|
Mass Carrier Change RccID Post to Conversion Report |
RHDB_MCC_AFFECTED_POST |
|
Mass Carrier Change RccID Prior to Conversion Report |
RHDB_MCC_AFFECTED_PRIOR |
|
Mass Carrier Change Rejected customer Records Report |
RHDB_MCC_RJCT |
|
Pointer Records List Report |
RHDb_TEMPLATE_DIALNBR |
|
Rejected Customer Records by SCP AOS Expansion Report |
RHDB_SCPAOSEXP_RJCT |
|
SCP-TFN Registry Audit Results Report |
RHDB_SCPSMSAUDITRESULTS |
|
Sending Customer Records Report |
RHDB_SENDINGCR |
|
Template Record List Report |
RHDB_Templates |
|
CAG Change Impact Report |
RHDB_CAGIMPACT |
|
CAG Change Impact Summary Report |
RHDB_CAGIMPACT |
|
Carrier Information List Report |
RHDB_CARRINFO |
|
AOS Label List - All Report |
RHDB_AOSLABELS |
|
Changed NPA-NXXs Report |
RHDB_CHANGEDNPANXX |
|
CCS Network LATA Report |
RHDB_NETWORKLATA |
|
CCS Network State-NPA Report |
RHDB_NETWORKSTATENPA |
|
SCP Admin List Report |
RHDB_SCPLIST |
|
SSP List Report |
RHDB_SSP |
|
Resp Org List Report |
RHDB_RESPORG |
|
Telephone Company List Report |
RHDB_TELCO |
|
Login ID List Report |
RHDB_SMSLOGONS |
|
Number Inventory by Customer Record Type |
RHDB_NBR_INVTRY_CR_TYPE_REP |
|
Number AOS and CIC Report |
RHDB_CRINVENTORY_VIEW |
|
Unreferenced Templates Report |
RHDB_UNREFERENCED_TMPL_REP |
|
Spare Number Control Resp Org History Report |
RHDB_RESPORG_SPARENUM_HIST |
|
Spare Number Forecast Report (120 Day Future View) |
RHDB_SPARE_FORECAST |
|
Pointer Record List Report - Enhanced Filtering |
RHDB_NEW_POINTER_RECORD_LIST_VIEW |
|
Resp Org Template Utilization Report |
RHDB_TMPL_UTILIZATION_DATA_RESPORG |
|
Resp Org Change Report |
RHDB_RESPORG_CHANGE_REPORT |
|
Cross-Entity Activity Report |
RHDB_CROSS_ENTITY_ACTIVITY_REPORT_VIEW |