<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>Hi guys,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>I believe this is the document Peter was talking about – Gotta love GoogleFu </span><span style='font-size:11.0pt;font-family:Wingdings;color:black'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><a href="http://www.telstra.com.au/customer-terms/download/document/fixed-zones.pdf">http://www.telstra.com.au/customer-terms/download/document/fixed-zones.pdf</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>It also looks like it’s going to be a pig to convert to a database but its possible…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>(The file was last updated 27 Feb 2012)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>-JT<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-family:"Calibri","sans-serif";color:#373737'>Justin Twiss</span></b><span style='color:black'><br></span><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#7D7D7D'>Hosting Manager</span><span style='color:black'><o:p></o:p></span></p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> ausnog-bounces@lists.ausnog.net [mailto:ausnog-bounces@lists.ausnog.net] <b>On Behalf Of </b>Peter Blackford<br><b>Sent:</b> Saturday, 10 March 2012 6:18 PM<br><b>To:</b> Nathan Brookfield<br><b>Cc:</b> AusNOG@lists.ausnog.net<br><b>Subject:</b> Re: [AusNOG] CDR Billing and how to determine type of call from called number<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>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.<o:p></o:p></p><div><p class=MsoNormal>On 10 March 2012 21:05, Nathan Brookfield <<a href="mailto:nathan.brookfield@serversaustralia.com.au">nathan.brookfield@serversaustralia.com.au</a>> wrote:<o:p></o:p></p><p class=MsoNormal>I take that back, they appear to have added the Full Download option back today.<br><br>Looks like its no longer a CSV though, will have to download and check!!!<o:p></o:p></p><div><p class=MsoNormal><br>Kindest Regards,<br>Nathan Brookfield<br><br>On 10/03/2012, at 18:58, Peter Childs <<a href="mailto:PChilds@internode.com.au">PChilds@internode.com.au</a>> wrote:<br><br>><o:p></o:p></p></div><div><div><p class=MsoNormal>> <a href="http://web.acma.gov.au/numb/openAccess/menuInquiry.do" target="_blank">http://web.acma.gov.au/numb/openAccess/menuInquiry.do</a><br>><br>> 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.<br>><br>> 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.<br>><br>><br>> ________________________________________<br>> From: <a href="mailto:ausnog-bounces@lists.ausnog.net">ausnog-bounces@lists.ausnog.net</a> [<a href="mailto:ausnog-bounces@lists.ausnog.net">ausnog-bounces@lists.ausnog.net</a>] on behalf of Peter Blackford [<a href="mailto:peter@onemetric.com">peter@onemetric.com</a>]<br>> Sent: Saturday, 10 March 2012 5:24 PM<br>> To: <a href="mailto:samantha@smellyblackdog.com.au">samantha@smellyblackdog.com.au</a><br>> Cc: <a href="mailto:AusNOG@lists.ausnog.net">AusNOG@lists.ausnog.net</a><br>> Subject: Re: [AusNOG] CDR Billing and how to determine type of call from called number<br>><br>> 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.<br>><br>> 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.<br>><br>><br>> On 10 March 2012 17:31, Sam Scafe <<a href="mailto:samantha@smellyblackdog.com.au">samantha@smellyblackdog.com.au</a><mailto:<a href="mailto:samantha@smellyblackdog.com.au">samantha@smellyblackdog.com.au</a>>> wrote:<br>> Guys<br>><br>> I am looking for information on how to process telephone cdr’s so I can do accurate billing.<br>> What I need to do from the called number is work out<br>><br>><br>> - If it is local<br>><br>> - If it is a National Call<br>><br>> - If it is Mobile Call<br>><br>> - If it is a 1300/13/1800 etc<br>><br>> I have been told of a beast on the ACMA website but unable to locate it. If anyone can help please contact off list<br>><br>><br>> Regards<br>><br>> Sam<br>> System Admin<br>> The Smelly Black Dog Group of Companies<br>> D: 07 42424712<br>><br>><br>> _______________________________________________<br>> AusNOG mailing list<br>> <a href="mailto:AusNOG@lists.ausnog.net">AusNOG@lists.ausnog.net</a><mailto:<a href="mailto:AusNOG@lists.ausnog.net">AusNOG@lists.ausnog.net</a>><br>> <a href="http://lists.ausnog.net/mailman/listinfo/ausnog" target="_blank">http://lists.ausnog.net/mailman/listinfo/ausnog</a><br>><br>><br>><br>><br>> --<br>> [<a href="http://www.onemetric.com.au/images/Signature.png" target="_blank">http://www.onemetric.com.au/images/Signature.png</a>]<br>> Peter Blackford<br>> Technical Director<br>> P: 02 4032 7940<br>> M: 0412 699 176<br>> E: <a href="mailto:peter@onemetric.com.au">peter@onemetric.com.au</a><mailto:<a href="mailto:peter@onemetric.com.au">peter@onemetric.com.au</a>><br>> W: <a href="http://www.onemetric.com.au" target="_blank">www.onemetric.com.au</a><<a href="http://www.onemetric.com.au" target="_blank">http://www.onemetric.com.au</a>><br>><br>><br>> _______________________________________________<br>> AusNOG mailing list<br>> <a href="mailto:AusNOG@lists.ausnog.net">AusNOG@lists.ausnog.net</a><o:p></o:p></p></div></div><p class=MsoNormal>> <a href="http://lists.ausnog.net/mailman/listinfo/ausnog" target="_blank">http://lists.ausnog.net/mailman/listinfo/ausnog</a><o:p></o:p></p></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <br><img border=0 id="_x0000_i1025" src="http://www.onemetric.com.au/images/Signature.png"><o:p></o:p></p><div><p class=MsoNormal><b><span style='font-size:24.0pt'>Peter Blackford</span></b><o:p></o:p></p></div><div><p class=MsoNormal><b>Technical Director</b><o:p></o:p></p></div><div><p class=MsoNormal><b><span style='color:#33CC00;background:white'>P: </span></b>02 4032 7940<o:p></o:p></p></div><div><p class=MsoNormal><b><span style='color:#33CC00;background:white'>M:</span></b> 0412 699 176<o:p></o:p></p></div><div><p class=MsoNormal><b><span style='color:#33CC00;background:white'>E:</span></b> <a href="mailto:peter@onemetric.com.au" target="_blank">peter@onemetric.com.au</a><o:p></o:p></p></div><div><p class=MsoNormal><b><span style='color:#33CC00;background:white'>W:</span></b> <a href="http://www.onemetric.com.au" target="_blank">www.onemetric.com.au</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>