Versions Compared

Old Version 62

changes.mady.by.user Karis Hathaway

Saved on

compared with

New Version 63

changes.mady.by.user Karis Hathaway

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 2019.7

...

This Import enters all Calls into the system and associates them with their respective Service IDs. The Imported Calls will then be processed according to the Call Processing and Rating Logic.

Fields

Originating Number

...

    • 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 not 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 Required if Call Date/Time is not provided.

Datatype is StringDate.

Call Time

Required Required if Call Date/Time is not provided.

Datatype is StringTime.

Call

...

Date/Time

Required if Call Date and Call Time are not provided.

Datatype is StringDateTime.

Call

...

Duration

Required

Datatype is String.

Auth Code

Datatype is String.

The Default value is blank.

Service Host

Datatype is String.

The Default value is blank.

The Call Rating needs to know the Service Host to use to assign Call Type and to Rate the call.  By default, the Service Host of the Service will be used.

This field allows you to override the Service's Service Host value. 

Service ID

Datatype is String.

...

This could be a Phone Number, Authcode, or any billable serviceTruck.  Other Service Types are not considered.  The Service must be Active or Inactive, and it must have a Service Host and Billing Group.

If one an Authcode is not provided, the call Service ID is billed set to the provided that Authcode.

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

Bill Date

Datatype is String.is Date.

Default value is Today's Date. 

Call Type

Datatype is String.

...

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

Toggle cloak
 Cloak
  • 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.
 Toggle cloak
 Cloak
  • 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
...
  • Value not present in Lists table
Rating Errors
An error during the rating process. This re-tries each night.
 Toggle cloak
 Cloak
  • 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.
 Toggle cloak
 Cloak
  • 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 Date and 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 are not considered in the Service ID lookup.
...