3.8 ConfigureCallTypes

Use this Knowledge Script to configure the rules by which the Call Data Analysis module classifies the types of calls each CDR contains, such as configuring gateway rules that identify certain calls going through the gateway as local rather than long distance.

You specify the name of the gateway and the prefixes that indicate a call is local. The prefix is not limited to an area code, which helps in situations in which numbers within the same area code are treated differently. For example, if 919-767-0295 is a local call, but 919-252-7463 is long distance, specify 9197* or 919767* as the prefix pattern.

If all calls within an area code are to be classified as local, specify a “*” as the gateway pattern and specify 919* as the prefix pattern.

Because you may need to specify many gateways or gateway devices, you can create a file that contains a list of all gateways and devices. If you create a list, you do not have to specify each gateway and device separately in the Gateway names or patterns parameter. You can use the Full path to gateway rules file parameter to point to the file you created. You need to save this file on the Data Warehouse computer, not the Data Mart server.

You must create the gateway rules file in the following format:

A number sign (#) in the first column identifies a comment line.
The rule is four fields separated by semicolons (;).
The first field is the Gateway Name or Pattern.
The second field is the Prefix Pattern that identifies a local call.
The third field is the minimum number of digits that must be found in order for a call to be classified as a gateway call.
The fourth field is the maximum number of digits that can be found in order for a call to be classified as a gateway call.

You also use this script to specify external access codes. Most systems require an access code to be dialed before routing a call to a remote or local gateway. If you specify an access code, Call Data Analysis will remove it before determining a call’s classification. Keep this in mind when specifying other parameters. For example, if you want to add 1877* to the Toll Free call rules, and your external access code is 9, you need to add 1877* (not 91877*) as a pattern in the Configure toll free call rules parameters.

This script raises an event when the job succeeds or fails, when the Data Mart server is inaccessible, and when warnings are raised during an attempt to configure call types.

Resetting the ConfigureCallTypes Script

You can use SQL Query Analyzer on the Data Mart computer to return the parameters in the ConfigureCallTypes script to their original default values. In the Database Selection drop list in the Query Analyzer interface, select the Data Mart database for which you want to reset the call type rules. In the Query window, type the following command: exec dbo.SetCallTypeDefaults. To verify the call type rules have been reset, issue the following command in the Query window:

select * From CallTypeRules

Reviewing Call Classification Types

Use the ConfigureCallTypes Knowledge Script to configure the rules by which the Call Data Analysis module classifies the types of calls each CDR contains. The following table describes each classification type.

Classification Type	Description
Internal	Intracluster call that originated in the network and ended in the same network (no gateway was used). Both the called and calling numbers are internal numbers.
On-net	Call in which both the calling and called numbers are internal, and either the originating or destination device is a gateway.
Incoming	Call that originated outside of the network and whose called number is an internal number.
Conference bridge	Call whose destination device is a conference bridge.
Voice mail	Call whose destination device is a voice mail device.
Local	Call whose destination device is a gateway, and whose called number is not an internal number and does not have an area code (or includes one of the local area codes).
Tandem - local	Local call that originated outside of the network.
Long distance	Call whose destination device is a gateway, and whose called number is not an internal number and has an area code that is not one of the local area codes.
Tandem - long distance	Long distance call that originated outside of the network.
International	Call whose destination device is a gateway, and whose called number begins with the international access code.
Tandem - international	International call that originated outside of the network.
Tandem	If the Tandem Rule is “collapse,” this category is a combination of the Tandem - local, Tandem - long distance, and Tandem - international categories.
Service	Call to a service, usually three digits, such as 411 (Directory Service).
Emergency	Call to an emergency service, such as 911.
Toll free	Long distance call that is toll free, such as 1-800 calls.
Other	User-defined rule.
Unknown	Call that does not match any of the other categories.

Resource Objects

Call Data CallManager object

Call Data H.323 RADIUS object

Call Data CiscoCM object

Default Schedule

By default, this script runs once.

Setting Parameter Values

Set the following parameters as needed:

Parameter	How to Set It
Configure Call Classification Rules
Configure External Access Code
Action	Select whether you want to Replace, Remove All, or make No Change regarding the external access code. For more information, see Action Parameter. The default is No Change.
External access code	Specify the access code your system requires for routing calls to a remote or local gateway. The default is 9.
Configure Internal Call Rules
Action	Select whether you want to Append, Replace, Remove All, or make No Change regarding internal call rules. For more information, see Action Parameter. The default is No Change.
Internal numbers or patterns	Specify numbers or patterns that identify an internal call. Separate multiple entries with a semicolon (;). The default is [2-7]XX;[1-8]XXX;[1-8]XXXX;[1-8]XXXXX.
Minimum digits dialed for internal calls	Specify the minimum number of digits that must be found in order for a call to be classified as internal. The default is 3.
Maximum digits dialed for internal calls	Specify the maximum number of digits that must be found in order for a call to be classified as internal. The default is 6.
Configure International Call Rules
Action	Select whether you want to Append, Replace, or make No Change regarding international call rules. For more information, see Action Parameter. The default is No Change.
International dialing prefixes	Specify the prefix that identifies an international call. Do not include the external access code. The default prefixes are 011;00;010*. For more information, see Wildcard Characters.
Minimum digits dialed for international calls	Specify the minimum number of digits that must be found in order for a call to be classified as international. The default is 10.
Maximum digits dialed for international calls	Specify the maximum number of digits that must be found in order for a call to be classified as international. The default is 32. NOTE:You can specify a large value to indicate there is no maximum limit.
Configure Local Call Rules
Action	Select whether you want to Replace or make No Change regarding local call rules. For more information, see Action Parameter. The default is No Change.
Minimum digits dialed for local calls	Specify the minimum number of digits that must be found in order for a call to be classified as local. The default is 7.
Maximum digits dialed for local calls	Specify the maximum number of digits that must be found in order for a call to be classified as local. The default is 10.
Configure Long Distance Call Rules
Action	Select whether you want to Replace or make No Change regarding long distance call rules. For more information, see Action Parameter. The default is No Change.
Minimum digits dialed for long distance calls	Specify the minimum number of digits that must be found in order for a call to be classified as long distance. The default is 10.
Maximum digits dialed for long distance calls	Specify the maximum number of digits that must be found in order for a call to be classified as long distance. The default is 32. NOTE:You can specify a large value to indicate there is no maximum limit.
Configure Long Distance Access Code
Action	Select whether you want to Remove All, Replace, or make No Change regarding the long distance access code. For more information, see Action Parameter. The default is No Change.
Long distance dialing prefix	Specify the access code your system requires for routing long distance calls. The default is 1.
Configure Gateway Rules
Action	Select whether you want to Append, Remove All, Replace, or make No Change regarding the gateway rules. For more information, see Action Parameter. The default is No Change.
Gateway Rules File
Full path to gateway rules file	Type the fully qualified path to a file on the Data Warehouse computer that contains a list of gateway names, patterns, and prefixes that identify local calls.
Severity - File I/O problems	Set the severity level, from 1 to 40, to reflect the importance of an event in which the gateway rules file is inaccessible. The rules file could be unreachable for a number of reasons, including an incorrect fully qualified file path. The default is 20.
Gateway names or patterns	Specify the names or patterns of gateways to check. Use wildcards if necessary and use semicolons (;) to separate multiple entries. For more information, see Section 3.8.2, Wildcard Characters. If you specified a gateway rules file, you do not need to complete this parameter, but you can if you have rules to add in addition to what is in the rules file.
Prefix patterns	Specify numbers or patterns that identify local calls. Use semicolons (;) to separate multiple entries. If you specified a gateway rules file, you do not need to complete this parameter, but you can if you have rules to add in addition to what is in the rules file.
Minimum digits dialed for these patterns	Specify the minimum number of digits that must be found in order for a call to fit the gateway rules. The default is 7.
Maximum digits dialed for these patterns	Specify the maximum number of digits that must be found in order for a call to fit the gateway rules. The default is 32. NOTE:You can specify a large value to indicate there is no maximum limit.
Configure Service Call Rules
Action	Select whether you want to Append, Remove All, Replace, or make No Change regarding service calls. For more information, see Action Parameter. The default is No Change.
Service numbers or patterns	Specify the numbers or patterns that identify a service call. Use semicolons (;) to separate multiple entries. The default is [2-8]11.
Minimum digits dialed for service calls	Specify the minimum number of digits that must be found in order for a call to be classified as service. The default is 3.
Maximum digits dialed for service calls	Specify the maximum number of digits that must be found in order for a call to be classified as service. The default is 3.
Configure Toll Free Call Rules
Action	Select whether you want to Append, Remove All, Replace, or make No Change regarding toll free calls. For more information, see Action Parameter. The default is No Change.
Toll free numbers or patterns	Specify the numbers or patterns that identify a toll free call. Use semicolons (;) to separate multiple entries. The default is 1800;1855;1866;1877;1888. For more information, see Wildcard Characters.
Minimum digits dialed for toll free calls	Specify the minimum number of digits that must be found in order for a call to be classified as toll free. The default is 7.
Maximum digits dialed for toll free calls	Specify the maximum number of digits that must be found in order for a call to be classified as toll free. The default is 32. NOTE:You can specify a large value to indicate there is no maximum limit.
Configure Emergency Call Rules
Action	Select whether you want to Append, Remove All, Replace, or make No Change regarding emergency calls. For more information, see Action Parameter. The default is No Change.
Emergency numbers or patterns	Specify the numbers or patterns that identify an emergency call. Use semicolons (;) to separate multiple entries. The default is 911.
Minimum digits dialed for emergency calls	Specify the minimum number of digits that must be found in order for a call to be classified as emergency. The default is 3.
Maximum digits dialed for emergency calls	Specify the maximum number of digits that must be found in order for a call to be classified as emergency. The default is 3.
Configure Other Call Rules
Action	Select whether you want to Append, Remove All, Replace, or make No Change regarding other calls. For more information, see Action Parameter.The default is No Change.
Other numbers or patterns	Specify the numbers or patterns that identify other calls. Use semicolons (;) to separate multiple entries.
Minimum digits dialed for other calls	Specify the minimum number of digits that must be found in order for a call to be classified as other. The default is 3.
Maximum digits dialed for other calls	Specify the maximum number of digits that must be found in order for a call to be classified as other. The default is 24. NOTE:You can specify a large value to indicate there is no maximum limit.
Configure Tandem Rule
Action	Select whether you want to Remove All or make No Change regarding the tandem rule. For more information, see Action Parameter. The default is No Change. If you remove the tandem rule, calls are not classified as tandem. In other words, all Tandem-Local, Tandem-Long Distance, and Tandem-International calls will be classified simply as Local, Long Distance, and International.
Tandem rule	Set the tandem rule as follows: Select Expand to classify tandem calls as Tandem-Local, Tandem-Long Distance, and Tandem-International. The default is Expand. Select Collapse to classify tandem calls as Tandem, and not split into the three sub-categories.
Update Fact Data
Update existing fact data using updated rules?	Select Yes to instruct the Data Mart to update data immediately using the new or revised rules. This update does not affect the next scheduled collection.
Update previous n days of data	Specify the number of days’ worth of accumulated data you want the Data Mart to update using the new or revised rules. The default is 7 day’s worth of data.
Update all data?	Select Yes to instruct the Data Mart to update all of the data in the database. Caution You may have several months’ or years’ worth of accumulated data. Select this option only with the understanding that the process of updating a lot of data can be lengthy.
Event Notification
Event severity when job succeeds	Set the severity level, from 1 to 40, to reflect the importance of an event in which the ConfigureCallTypes job succeeds. The default is 25.
Event severity when data mart server inaccessible	Set the severity level, from 1 to 40, to reflect the importance of an event in which the Data Mart server is inaccessible. The default is 10.
Event severity for warnings	Set the severity level, from 1 to 40, to reflect the importance of warnings raised during an attempt to configure call types. The default is 20.
Event severity when job fails	Set the severity level, from 1 to 40, to reflect the importance of an event in which the ConfigureCallTypes job fails. The default is 5.

3.8.1 Action Parameter

In the list of parameters, each rule and access code folder contains an Action parameter you set to indicate the action you want to take regarding the rules and access codes for each call type. The following table describes the Action options you can select.

Action Parameter Option	Description
No Change	Indicates you do not want to change the rule or access code for this call type.
Append	Appends the new rule to any existing rules for this call type.
Replace	Replaces all existing rules with the new rule you are creating for this call type.
Remove All	Removes all existing rules for this call type. If you select this option, the Call Data Analysis module does not classify calls of this type.

3.8.2 Wildcard Characters

When specifying number patterns in parameters, you can use any of the following wildcards and special characters.

Character	Description	Example
X	The X wildcard matches any single digit in the range of 0 through 9.	70XXX matches numbers in the range of 70000 through 70999.
*	The asterisk () wildcard matches one or more digits in the range of 0 through 9. NOTE:*You can use an exclamation point (!) in place of an asterisk.	011* matches any number beginning with 011, such as 011447968587655.
[ ]	Square brackets ([ ]) enclose a range of values.	[4578]11 matches 411, 511, 711, and 811.
-	The hyphen (-) can be used within square brackets to indicate a sequential range of values.	[4-8]11 matches 411, 511, 711, and 811.