[AusNOG] CDR Billing and how to determine type of call from called number

[Justin Twiss]

Hi guys,

I believe this is the document Peter was talking about - Gotta love GoogleFu :)

http://www.telstra.com.au/customer-terms/download/document/fixed-zones.pdf

It also looks like it's going to be a pig to convert to a database but its possible...

(The file was last updated 27 Feb 2012)



-JT


Justin Twiss
Hosting Manager


From: ausnog-bounces at lists.ausnog.net [mailto:ausnog-bounces at lists.ausnog.net] On Behalf Of Peter Blackford
Sent: Saturday, 10 March 2012 6:18 PM
To: Nathan Brookfield
Cc: AusNOG at lists.ausnog.net
Subject: Re: [AusNOG] CDR Billing and how to determine type of call from called number

Thinking back to it now (it has been a couple of years) the biggest issue I had was finding a publicly available list of adjoining SZU's. At the time I was toying with the idea of using our exchange geo data to work it out but in the end it was just cheaper and easier to bill nationally. I would be interested to see if someone can find the document that Peter Childs is talking about because I will kick myself.
On 10 March 2012 21:05, Nathan Brookfield <nathan.brookfield at serversaustralia.com.au<mailto:nathan.brookfield at serversaustralia.com.au>> wrote:
I take that back, they appear to have added the Full Download option back today.

Looks like its no longer a CSV though, will have to download and check!!!

Kindest Regards,
Nathan Brookfield

On 10/03/2012, at 18:58, Peter Childs <PChilds at internode.com.au<mailto:PChilds at internode.com.au>> wrote:

>
> http://web.acma.gov.au/numb/openAccess/menuInquiry.do
>
> Get the Full download which will assist in working out the SZU of the A and B party if you really need to know what a local call is.
>
> From my memory same and adjoining SZUs are considered a local call.   So you will need a data set that shows adjoining SZUs.... Telstra's SFOA one of the appendixes (J?) I think has this data.
>
>
> ________________________________________
> From: ausnog-bounces at lists.ausnog.net<mailto:ausnog-bounces at lists.ausnog.net> [ausnog-bounces at lists.ausnog.net<mailto:ausnog-bounces at lists.ausnog.net>] on behalf of Peter Blackford [peter at onemetric.com<mailto:peter at onemetric.com>]
> Sent: Saturday, 10 March 2012 5:24 PM
> To: samantha at smellyblackdog.com.au<mailto:samantha at smellyblackdog.com.au>
> Cc: AusNOG at lists.ausnog.net<mailto:AusNOG at lists.ausnog.net>
> Subject: Re: [AusNOG] CDR Billing and how to determine type of call from called number
>
> You biggest issue is going to be determining what a local call is. There appears to be a lot of definitions about what a local call is. I assume you are talking VOIP which in most cases there is no local rate it is just charged at a national rate.
>
> All the rest are easy, if it starts with 02, 03 etc or even 612, 613 then it is national, mobile is 04 or 614, 1300,13,1800 are the same. You can either look at the start of the phone number to determine it or use regex.
>
>
> On 10 March 2012 17:31, Sam Scafe <samantha at smellyblackdog.com.au<mailto:samantha at smellyblackdog.com.au><mailto:samantha at smellyblackdog.com.au<mailto:samantha at smellyblackdog.com.au>>> wrote:
> Guys
>
> I am looking for information on how to process telephone cdr's so I can do accurate billing.
> What I need to do from the called number is work out
>
>
> -          If it is local
>
> -          If it is a National Call
>
> -          If it is Mobile Call
>
> -          If it is a 1300/13/1800 etc
>
> I have been told of a beast on the ACMA website but unable to locate it. If anyone can help please contact off list
>
>
> Regards
>
> Sam
> System Admin
> The Smelly Black Dog Group of Companies
> D: 07 42424712
>
>
> _______________________________________________
> AusNOG mailing list
> AusNOG at lists.ausnog.net<mailto:AusNOG at lists.ausnog.net><mailto:AusNOG at lists.ausnog.net<mailto:AusNOG at lists.ausnog.net>>
> http://lists.ausnog.net/mailman/listinfo/ausnog
>
>
>
>
> --
> [http://www.onemetric.com.au/images/Signature.png]
> Peter Blackford
> Technical Director
> P: 02 4032 7940
> M:  0412 699 176
> E: peter at onemetric.com.au<mailto:peter at onemetric.com.au><mailto:peter at onemetric.com.au<mailto:peter at onemetric.com.au>>
> W: www.onemetric.com.au<http://www.onemetric.com.au><http://www.onemetric.com.au>
>
>
> _______________________________________________
> AusNOG mailing list
> AusNOG at lists.ausnog.net<mailto:AusNOG at lists.ausnog.net>
> http://lists.ausnog.net/mailman/listinfo/ausnog



--
[http://www.onemetric.com.au/images/Signature.png]
Peter Blackford
Technical Director
P: 02 4032 7940
M:  0412 699 176
E: peter at onemetric.com.au<mailto:peter at onemetric.com.au>
W: www.onemetric.com.au<http://www.onemetric.com.au>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ausnog.net/pipermail/ausnog/attachments/20120311/0440296d/attachment.html>