[cisco-voip] Re: cisco-voip Digest, Vol 36, Issue 36

[Mike Armstrong]

I use the UCT dateTimeDisconnect field (adjusted for our time zone) as the 
official call time, and duration for the duration.  So, using your example, 
the call would be charged to February.  No matter how you define the billing 
period, you're going to have to tapdance a little bit to accomodate calls 
that bridge the boundary.  I don't mechanically cut off things at exactly 
midnight, but if I did then I would by definition account for all calls in 
the billing period, unless one were to last longer than the billing period. 
As for Standard Time vs Saving Time, I use that for display purposes, which 
can lead to some confusion in very limited circumstances, but that's the 
purpose of Saving Time anyway.

Having said all that, we don't actually bill for telephone service, but do 
archive the CDR data (as Access databases)  and occasionally check for abuse 
or specific usage on request of a supervisor.

Mike Armstrong
UF/IFAS CREC
Lake Alfred, FL

 > Date: Wed, 8 Feb 2006 10:06:58 -0500
> From: "Lelio Fulgenzi" <lelio at uoguelph.ca>
> Subject: [cisco-voip] CDRs and billing
> To: <cisco-voip at puck.nether.net>
> Message-ID: <013801c62cc1$4f005550$30196883 at cfs.uoguelph.ca>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I have a question for the group regarding billing. If you have a billing 
> date that ends January 31st at midnite, do you include calls that are 
> initiated before this time or only end before this time? For example, if 
> you have a call that begins at 11:55pm and ends at 5am on the 1st of 
> February, does that call get charged to the January or February bill?
>
> We currently use the initiated before criteria and wait until the next day 
> at midnite to cut the CDRs to file to have an exhaustive list of calls. 
> What are other people doing for this?
>
>
> --------------------------------------------------------------------------------
> Lelio Fulgenzi, B.A.
> Network Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> "I had a coffee and Coke at lunch today...and now, I've got more jitter 
> than an
> IP phone on a long haul 10base2 connection" 
> LFJ
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> https://puck.nether.net/pipermail/cisco-voip/attachments/20060208/094df8ad/attachment.html
>
> ------------------------------
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
> End of cisco-voip Digest, Vol 36, Issue 36
> ******************************************