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?
Does it only consolidate calls for accounts that have a FULL month
of calls?
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?
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.
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.
Thanks,
Tom