---

Editing a Term Prefix Entry

• Select the Rate Plan you want to Add via Rating --> Rate Plans --> View (on the row you want)
• You will be displayed a list sorted by Term Prefix, please pick the Term Prefix you want to edit.
• Under one Term Prefix you can have any number of entries under that Prefix. This page will display all of them.
• Click "edit" on the exact row you wish to edit. You will be taken to a page similar to the picture shown under Creating a Term Prefix Entry

---

Structure of Rate Table Entry

RateEntryID (INT) 

A system-wise unique ID for this Rate Entry

RatePlan (VARCHAR) 

Name of the Rate Plan that this entry belong to

Domain (VARCHAR) 

Domain of the Rate Plan that this entry belong to

TermPrefix (VARCHAR) 

Termination Prefix (“*” for all)

TermDomain (VARCHAR) 

Termination Domain (“*” for all)

OrigPrefix (VARCHAR) 

Origination Prefix (“*” for all)

OrigDomain (VARCHAR) 

Origination Domain (“*” for all)

DayOfWeek (VARCHAR) (currently broken)

Day of Week Match pattern (0..6, Sunday==0, or “*” for all)

HourOfDay (VARCHAR) (currently broken)

Hour of Day Match pattern (A..X, or “*” for all)

Bucket ID (VARCHAR) 

Bucket that rate can be charged against. Used for post paid billing. (A..Z are valid)

Tax ID (VARCHAR) 

Tax ID, Used to match a Tax entry from a service plan. (A..Z are valid)

Rate (DOUBLE) 

Charge per second (dollar)

MinDuration (INT) 

Minimum charged duration(second). See duration calculation

UnitDuration (INT) 

Charged duration increment(second). See duration calculation

MinCharge (DOUBLE) 

Minimum charge (dollar)

ExtraCharge (DOUBLE) 

Extra charge, aplied once for each call hitting rate entry(dollar)

Tax (DOUBLE) 

Tax to apply to all charges

LongCallExtra (DOUBLE) 

Long Call Extra Charge (dollar)

LongCallStart (INT) 

Time threshold to apply Long Call Charge (sec)

LongCallInc (INT) 

Time increment for each additional Long Call Charge (sec)

LongDiscExtra (DOUBLE) 

Disconnect Fee applied at disconnect after LongDiscStart elapsed (dollar)

LongDiscStart (INT) 

Time threshold to apply Disconnect Fee (sec)

ValidFrom (DATETIME) 

Start of effective date (yyyy-mm-dd hh:mm:ss)

ValidTo (DATETIME) 

End of Effective date (yyyy-mm-dd hh:mm:ss)

EntryStatus (ENUM) 

“active” or “inactive”

Calculation Logic

Duration

if (actual_duration <= min_duration)

duration = min_duration)

else

duration =< round up to duration_increment>(actual_duration – min_duration) + min_duration

Charge

if (duration * rate <= min_charge)

charge = min_charge + ExtraCharge

else

charge = duration * rate + ExtraCharge

Long Call Charges

if (duration >= LongCallStart)

charge += LongCallExtra

if (duration - LongCallStart > LongCallInc * N)

charge += ExtraCharge * N

{where N is amount of increments over the start time}

Disconnect Fees

if (duration >= LongDiscStart

charge += LongDiscExtra

Taxes

charge = charge + (charge * tax)