Routing of calls is an important part of any system and ICTBroadcast has a powerful routing system as well as It process Call Detail record for rating purpose
ICTBroadcast GUI help user to create and manage countries, destinations, rates, and routes and provide interface to search/filter destination based on country
Following are two important functions of GUI.
When users select a country ICTBroadcast uses country dialing_code to fetch all matching prefixes from the destination table. When the user selects a region ICTBroadcast uses region id to fetch all matching countries and also triggers above mentioned action.
Show Country Name
In Rate and Route lists system shows destination name i.e Pakistan > Ufone (92333) the country name along with destination name are being fetched as following
System use destination prefix and look for matching dialing_code in-country and fetch all countries, if more than one country match then it repeats the route, rate for each country while keeping the destination same.
Known Problem: whenever there is a problem in route and rate it is due to missing dialing_code in a related country. uniquely matching digits must exist as dialing_code in the country table.
Following are steps ICTBroadcast perform to find rate and routes
ICTBroadcast looks into the destination table to match the phone number prefix.
ICTBroadcast looks into the route table for the previously matched prefix (destination) and fetches all matching records with the respective trunk / VoIP provider and matching service (voice, SMS, fax, or email ).
ICTBroadcast looks into the rate table for the previously matched prefix (destination) and fetch all matching rates along with the respective rate plan.
OCN Based Routing
ICTBroadcast facilitates its users to implement the LCR technique in Routing. LCR synonym of Least Cost Routing is a process to find the most inexpensive way to route phone calls. It is the process of analyzing and selecting the most economical path of outbound and inbound communications traffic. LCR can be configured in ICTBroadcast by adding the prefixes of available networks. When a number is dialed, ICTBroadcast chooses the route which has the same prefix as a number with the most economical rates.
However, in case of number portability, LCR could not be implemented and in such case CNAME module provide solutions. CNAM query gets the information about that number through OCN, on the basis of that information route is selected.
NOTE: Call will be rejected if no destination found also call will be rejected if long prefix (more specific like 92333) is found in destination table but there is no matching route or rate exist for said destination ( there need an exact match like 92333 to exist in both routing and rating tables and 9233 or 923 will not work).
NOTE: To utilize the referencing features of the DB engine we are using the country_area table to save comma-separated dialing_code field from the country table