Interstate

This is a first-release of the documentation. Additional detail will be added as the project matures.

• Rate interstate calls on NPANXXX/NPANXX.
• Use a default rate for CDR that don't match on NPANXXX/NPANXX. (optional)
• Date-based rate sheets.
• Bill on LRN instead of Dialed if this value is supplied in the CDR.
• Bill for CNAM dips.
• Bill for LRN dips.

This call type requires loading your interstate rates, per customer, into the [InterstateRateMaster] table. You can also load your rates via the [PHP Admin Portal] by clicking 'Customer Rates' on the main page then going into 'Interstate'.

Please see our [CallRecordMaster_TBR] table documentation for information on how to load interstate CDR into our system.

Once the rates and CDR are loaded, you can execute the fnRateInterstateCDR function. Calls that have been rated will go into the [CallRecordMaster] table. Unratable calls will go into the [CallRecordMaster_HELD] and can be rated at a later date.

By default, the system will rate 100,000 CDR at a time. This is adjustable per site.

This process will record its run-time in [ProcessHistory].

Rating Logic

1. Determine the date of the oldest unrated interstate CDR in the [CallRecordMaster_TBR] table.

2. Generate an interstate rate sheet for all rates effective on that date.

3. Collect 100,000 (or more) unrated interstate records and put them into a temporary table for processing.

4. Attempt to identify the CustomerID of the CDR using the IP address supplied in the CDR. This only applies to records who do not have a CustomerID already supplied in their CDR.

5. Move any CDR to the [CallRecordMaster_HELD] table that we don't have a CustomerID for.

6. Calculate the Billable Duration based on the Raw Duration in the CDR.

7. Determine if the CDR will be billed based on LRN or Dialed Number.

8. Attempt to massage source number, destination number and LRN into E.164 format.

9. Move any CDR to the [CallRecordMaster_HELD] table if their destination number does not meet the E.164 format requirements.

10. Attempt to determine rate based on NPANXXX.

11. Attempt to determine rate based on NPANXX.

12. Apply default rate to any CDR with no rate from step 10 and 11. This only applies to customers who are configured with a default rate.

13. Move any CDR to the [CallRecordMaster_HELD] table that we could not determine a rate for.

14. Retrieve the CNAM dip rate for any CDR that were dipped for CNAM.

15. Retrieve the LRN dip fee for any CDR that were dipped for LRN.

16. Calculate the total call price taking usage, CNAM and LRN fees into account.

17. Move the rated records to the [CallRecordMaster] table. These records will be billed on the customer's next billing cycle.

If you have any questions, please contact [Support].

-The OpenCDRRate team.

Follow us on twitter to receive new feature notifications: http://www.twitter.com/opencdrrate/

Join our LinkedIn group to open discussions on features you would like to see in the system. http://www.linkedin.com/groups/OpenCDRRate-4381972