Re: Calls Consolidation question

Dale E. Reed Jr. ( (no email) )
Thu, 12 Jun 1997 00:03:35 -0700

Tom Bilan wrote:
> I have question on exactly what the calls consolidation does.
> I know it tallies calls from the calls table into one big lump time for
> a date range. What is the criteria for the date range, i.e. which field
> does it use for the date?

The MBR's Expire Date.

> Does it only consolidate calls for accounts that have a FULL month
> of calls?

Yes. 2.1 had a bug where it would consolidate some billing cycles
even if they were not complete. 2.2 correctly only consolidates
COMPLETED billing cycles.

> i.e.
> User A has a monthly date that lies on the 10th of the month. I do
> consolidation on the 9th of the month. Does A not get consolidated because
> the date is not > the 10th or does it consolidate what it knows now and
> then tack on the rest during a later consolidation, say on the 16th?

It will not consolidate it until after the 10th.

> What happens to usernames that don't exist as services? I have a few
> users who are not in emerald yet. (for reasons I don't want to get into
> here...) Does the consolidation routine delete them because they're not
> found or does it just skip over them? I would like it to skip over them
> so that when I consolidate AFTER I've added them into emerald and a
> consolidation will then tally up their totals.

It skips over them. I have a report that you can run to see them.
The new DB manager will allow you to clear out old entries, also.

> Is it ok to delete AcctStatusType=1 or will that mess up the consolidation
> routine? I would eventually like to add a trigger to blow those
> records away automatically.

Deleting those are fine. The consolidation will delete all records for
user (whether start or stop) for the completed billing cycles.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |