Rate Schedules


API for browsing, adding, editing and deleting Rate Schedules.

URLs

Rate Schedules

Rate Schedule Items

References

Looking up a Resource (single objects, lists and tabular data)
Creating a Resource
Copying a Resource
Updating a Resource
Deleting a Resource

Notes

Rate Schedule Copy Object

{
  "RateScheduleId": 1,
  "NewRateScheduleName": ""
}

Rate Schedule Object

{
  "RateScheduleId": 0,
  "RateSchedule": "",
  "Description": "",
  "BillingPackageId": 0,
  "BillingPackageName": "",
  "MobileChargeScheduleId": 0,
  "MobileChargeScheduleName": ""
}

Rate Schedule Item Object

{
  "RateScheduleItemId": 0,
  "RateScheduleId": 0,
  "RateScheduleName": "",
  "MobileChargeScheduleId": 0,
  "MobileChargeScheduleName": "",
  "Description": "",
  "Origin": "",
  "CallType": "ctAny",
  "MobileProfileId": 0,
  "MobileProfileName": "",
  "Dnis": "",
  "Ani": "",
  "StartDate": "",
  "EndDate": "",
  "DayRange": "",
  "StartTime": "",
  "EndTime": "",
  "Priority": 0,
  "Enabled": false,
  "RatePlanId": 0,
  "RatePlanName": "",
  "OverrideGracePeriod": false,
  "GracePeriod": 0,
  "OverrideMinSecsBilled": false,
  "MinSecsBilled": 0,
  "OverrideShortestCallAllowed": false,
  "ShortestCallAllowed": 0,
  "OverrideBillingDelay": false,
  "BillingDelay": 0,
  "OverrideRateInterval": false,
  "RateInterval": 0,
  "OverrideSpeakRateInterval": false,
  "SpeakRateInterval": false,
  "OverrideDisconnectCharge": false,
  "DisconnectCharge": 0,
  "DisconnectChargeType": "dctFixedAmount",
  "OverrideDisconnectChargeCallEnd": false,
  "DisconnectChargeCallEnd": false,
  "OverrideSpeakDisconnectCharge": false,
  "SpeakDisconnectCharge": false,
  "ThresholdType": "ttCalls",
  "ThresholdValue": 0
}

Table Definitions

RATE_SCHEDULES

Rate Schedules allow you to assign one or more Rate Schedule Items that consist of a rate plan that is scheduled based on time of day, day of week, call origination and call termination so that different plans become active depending on certain criteria being met. Through the use of Rate Schedules and Rate Schedule Items you can create peak, off peak, weekend and holiday rates with the server application managing when the various underlying rate plans become
effective.

Field Name Type Size Description
RATE_SCHEDULE_ID smallint 2 Primary key.
RATE_SCHEDULE varchar 40 Unique name identifying this rate schedule.
DESCRIPTION varchar 40 Description of this entry.
BILLING_PACKAGE_ID bigint 8 Foreign key into the BILLING_PACKAGES table.
MOBILE_CHARGE_SCHEDULE_ID smallint 8 Foreign key into the MOBILE_CHARGE_SCHEDULES table.

RATE_SCHEDULE_ITEMS

Rate Schedule Items consist of a rate plan that is scheduled based on time of day, day of week, call origination and call termination so that different plans become active depending on certain criteria being met. Through the use of Rate Schedules and Rate Schedule Items you can create peak, off peak, weekend and holiday rates with the server application managing when the various underlying rate plans become effective.

Field Name Type Size Description
RATE_SCHEDULE_ITEM_ID smallint 2 Primary key.
RATE_SCHEDULE_ID smallint 2 Foreign key into the RATE_SCHEDULES table that references the Rate Schedule associated with this item.
DESCRIPTION varchar 40 Description of this entry.
ORIGIN varchar 40 Specifies the Inbound Node that this Rate Schedule entry will apply to.
ANI varchar 40 Specifies the ANI this entry applies to.
DNIS varchar 40 Specifies the DNIS this entry applies to.
START_DATE smalldatetime 4 Specifies the start of the date range for which this entry is valid.
END_DATE smalldatetime 4 Specifies the end of the date range for which this entry is valid.
DAY_RANGE char 7 Specifies the day range for which this entry is valid. Days are specified as a bitmap, where the first bit represents Monday and the last bit represents Sunday.
START_TIME varchar 8 Specifies the start of the time range for which this entry is valid.
END_TIME varchar 8 Specifies the end of the time range for which this entry is valid.
THRESHOLD_TYPE tinyint 1 Threshold type from THRESHOLD_TYPES table (e.g. ‘Calls’ or ‘Minutes’)
THRESHOLD_VALUE int 4 Value of threshold (e.g. 10 calls)
CALL_TYPE tinyint 1 Foreign key into the CALL_TYPES table.
MOBILE_PROFILE_ID smallint 2 Foreign key into the MOBILE_PROFILES table.
PRIORITY tinyint 1 When utilizing Rate Schedules with more than one member it is possible that two Rate Schedule entries are active and valid at the same time. By assigning one entry a higher priority you can ensure that it will take precedence over an equally valid Rate Schedule with a lower priority.
ENABLED bit 1 Specifies whether or not this Rate Schedule is an active member of the list of Rate Schedule entries or should be temporarily removed from the Rate Schedule during call processing.

0 – Disabled 1 – Enabled
RATE_PLAN_ID int 4 Foreign key into the RATE_PLANS table that references the Rate Plan associated with this entry.
OVERRIDE_GRACE_PERIOD bit 1 Specifies whether or not the GRACE_PERIOD in this entry will be used instead of the one in the RATE_PLANS table.
GRACE_PERIOD smallint 2 Specifies the duration (in seconds) threshold under which the user will not be Charged.
OVERRIDE_MIN_SECS_BILLED bit 1 Specifies whether or not the MIN_SECS_BILLED in this entry will be used instead of the one in the RATE_PLANS table.
MIN_SECS_BILLED smallint 2 Specifies the minimum duration (in seconds) that a user will be billed for a call.
OVERRIDE_SHORTEST_CALL_ALLOWED bit 1 Specifies whether or not the SHORTEST_CALL_ALLOWED in this entry will be used instead of the one in the RATE_PLANS table.
SHORTEST_CALL_ALLOWED smallint 2 Specifies the amount of time (in seconds) that the caller must be able to afford, or the call will not be allowed.
OVERRIDE_BILLING_DELAY bit 1 Specifies whether or not the BILLING_DELAY in this entry will be used instead of the one in the RATE_PLANS table.
BILLING_DELAY smallint 2 Specifies the amount of time (in seconds) after, which the billing will be started.
OVERRIDE_RATE_INTERVAL bit 1 Determine whether the Rate Plan’s rate interval should be overridden.
RATE_INTERVAL tinyint 1 Rate interval to use for billing purposes (default: 60 seconds).
OVERRIDE_SPEAK_RATE_INTERVAL bit 1 Determine whether the Rate Plan’s speak rate interval setting should be overridden.
SPEAK_RATE_INTERVAL bit 1 Sets whether the rate interval is to be used when calculating the number of minutes available to speak to the caller.
OVERRIDE_DISCONNECT_CHARGE bit 1 Determine whether the Rate Plan’s disconnect charge setting should be overridden.
DISCONNECT_CHARGE decimal (15,4) The disconnect charge (amount or percentage) to bill the caller.
DISCONNECT_CHARGE_TYPE tinyint 1 Sets how the disconnect charge is applied (i.e. 0=Fixed amount, 1=Percentage (%)).
OVERRIDE_DISCONNECT_CHARGE_END bit 1 Determine whether the Rate Plan’s disconnect charge end should be overridden.
DISCONNECT_CHARGE_CALL_END bit 1 Sets whether the disconnect charge is applied at the end of the call.
OVERRIDE_SPEAK_DISCONNECT_CHARGE bit 1 Determine whether the Rate Plan’s speak disconnect charge setting should be overridden.
SPEAK_DISCONNECT_CHARGE bit 1 Sets whether the disconnect charge is used when calculating the number of minutes available to speak to the caller.