The following table 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.
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 |