.Calls Imports v2019.2

Capability

This Import enters all Calls into the system and associate them with their respective Service IDs.

Fields

Originating Number

Required

Datatype is String.

The From Number is sometimes looked up in VH Data table.

The following factors determine if and how this is done:

• • If the From City, State, and LATA are provided, the lookup is not done.
  • If the From Number is 4 digits long, the default NPA-NXX set in the Tenant Management grid is used.
  • If the From Number is 7 digits long, the default NPA set in the Tenant Management grid is used.
  • If the From Number length is not 4, 7, or 10, the From Number lookup is not done.

Dialed Number

Required

Datatype is String.

The To Number is sometimes looked up in VH Data table.

The following factors determine if and how this is done:

• • If the To City, State, and LATA are provided, the lookup is not done.
  • If the To Number starts with 011, the call is marked as International. Then, the VH lookup is done.
  • If the Call Type has already been determined to be International, Emergency, Mexico, Toll-Free, or Info, the VH lookup is not done.
  • If the To Number is 4 digits long, the default NPA-NXX set in the Tenant Management grid is used.
  • If the To Number is 7 digits long, the default NPA set in the Tenant Management grid is used.
  • If the To Number is 11 digits long and starts with a 1, the 1 is removed before the lookup.
  • If the To Number length is not 4, 7, 10 or greater, the To Number lookup is not done.

Call Date

Required

Datatype is String.

Call Time

Required

Datatype is String.

Call Duration

Required

Datatype is String.

Call Date/Time

Required

Datatype is String.

Auth Code

Datatype is String.

The Default value is blank.

Service ID

Datatype is String.

The Service ID To Bill the Call.

The call is billed to the provided Service ID value.

This could be a Phone Number, Authcode, or any billable service.

If one is not provided, the call is billed to the provided Authcode.

If there is no Authcode, it is billed to the Originating Number for Outgoing Calls or Dialed Number for Incoming Calls.

Bill Date

Datatype is String.

Call Type

Datatype is String.

Must be one of the CALLTYPE List Type values.

Common values are Local, Incoming, Intrastate, Interstate, International as well as others.

Cost

Datatype is String.

The Default value is $0.00.

Dialed City

Datatype is String.

The Default value is blank.

Dialed State

Datatype is String.

The Default value is blank.

Dialed LATA

Datatype is String.

The Default value is blank.

Originating LATA

Datatype is String.

Default value is blank.

Originating City

Datatype is String.

The Default value is blank.

Originating State

Datatype is String.

The Default value is blank.

Incoming Trunk

Datatype is String.

The Default value is blank.

Outgoing Trunk

Datatype is String.

Default value is blank.

Rating Method Inputs

Rate Tables

Maps to given Rate Table defined in Admin.

The rate must be found in the Call Rates Table.

Pass through cost in file

The costs for the call will come from the file that is being imported.

Flat Rate

Adds additional dialogue to set a flat rate. 

The additional information comes from the fields in the Initial and Additional sections.

Errors

Because of the very large volume of Imported data that can occur for Calls and Usage Imports, the Error reporting is done very differently. For other Imports, if an Error happens, the Error is reported in the Imported Records grid. For Calls and Usage, the Error is stored as a code in the Call or Usage record. The available codes are in this list. This list is shared for Calls and Usage. Some of these are specifically for Calls and never happen for Usage.

Errors

An error occurred during the Import File Processing. This re-tries each night.

• • No Service record for Service ID
  • No Service record for Originating Phone Number
  • No Service record for terminating Phone Number
  • No Expense GLAs for Service
  • No Service record for Authcode
  • Multiple Service records for Service ID
  • Multiple Service records for Originating Phone Number
  • Can't determine Origination Location
  • Can't determine Termination Location
  • Zero or multiple matching Tenants

Unrecoverable Errors

An error occurred that cannot be fixed. It does not try again each night.

• • Missing end for split record
  • Column position not present in line
  • Originating Phone Number not set
  • Terminating Phone Number not set
  • Error reading column using format mask
  • Invalid duration
  • Invalid date
  • Invalid time
  • Column defined as a number contains non-numeric data
  • Unable to determine Call Type
  • Service ID not set
  • Value not present in Lists table

Rating Errors

An error during the rating process. This re-tries each night.

• • No Rate defined for this Call Type
  • Missing Service, Service Host
  • Missing Service, Billing Group
  • Missing Service, Rating Group

Billing Errors

Indicates an error occurred during the billing process.

• • Missing Revenue GLAs for Service Catalog and Charge Catalog
  • Missing Billing Group for Service
  • Unknown Error

Notes

• The Call Date and Time can be provided by the separate Date and Time fields or by the combined DateTime field.

• The Call Time is considered invalid if it is more than 2 days in the future or if it is more than importFiles.ini.constants.CALL_MAX_AGE_DAYS old.

• The internal Call Processing logic does not determine if a Call is Incoming. If the Call type is Incoming, it must be assigned in the Conditional Logic.

• Either the From Number or the To Number MUST an existing Service ID.

• A Service must exist for each Call. The Service must exist as a Phone, an Authcode, or a Trunk. The other Service Types is not considered in the Service ID lookup.

• If a Service ID is provided, that value must exist as a Service.
  • else for Incoming Calls, the Dialed Number must exist as a Service ID.
  • else if an Authcode is provided, the Authcode Service ID must exist.
  • else for all other Outgoing Calls, the From Number must exist as a Service ID.