Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
Address Formatting Business Rules
- albie.roets
History
Date | Change | Knowledge Document | Comments |
|---|---|---|---|
Mar 7, 2023 | Apartment / Unit / Flat address types analysis |
|  |
Mar 8, 2023 | @Miranda Adams - confirms agreed business format for unit addresses is with solidus (/) |
|  |
Mar 9, 2023 | @Yeng Sembrano - provided guide written by former database analyst. |  |
|
Mar 9, 2023 | @Monica Kluegel & @Ana Simic - provided TAP Agreed Business Rules. |  |
Summary
| Address Line 1 | City | Post Code | State | Country |
|---|---|---|---|---|---|
Australia |
|
| 4 Digits |
|
|
Australian Address and Phone formatting for Advance
1. Introduction
Currently OCR’s used by Australia Post read the placename, State, postcode and other keywords from machine-addressed letters, and only the postcode from hand-addressed letters that has the postcode printed in the Postcode Squares. So until now Australia Post has essentially concentrated on encouraging the correct formatting of the last line of the address.
Australia Post is now introducing advanced letter sorting equipment which incorporates new multi- line OCRs (MLOCR). These new machines are able to read full address information, which will allow letters to be sorted to a finer level. To enable the MLOCRs to perform at high levels of efficiency, all lines of the address should be formatted correctly and in a consistent manner.
The Australia Post addressing standards document can be accessed on the following URL: https://auspost.com.au/media/documents/australia-post-addressing-standards-1999.pdf
The following standard outlines the correct format for addresses to be presented on letters, or the way in which address information is placed on envelopes. The standard has been based on two address data storage standards:
Australian Standard AS4212-1994 - “Geographic Information Systems - Data dictionary for transfer of street addressing information”; and,
Australian Standard AS4590-1999 “Interchange of Client Information”.
All abbreviations used are based on Australian Standard AS4590-1999. An extensive list of address abbreviations in accordance with Australian Standards can be found on the following website: http://www.ipaustralia.gov.au/about-us/doing-business-with-us/address-standards/
An extensive list of telephone country and area code formats in accordance with Australian Standards can be found on the following website:
http://www.australia.gov.au/about-australia/our-country/telephone-country-and-area-codes
International telephones are expressed using the ITU-T recommendation. E.164 is an
ITU-T recommendation, titled The international public telecommunication numbering plan, that defines a numbering plan for the world-wide public switched telephone network (PSTN) and some other data networks.
E.164 defines a general format for international telephone numbers. Plan-conforming numbers are limited to a maximum of 15 digits.[1] The presentation of numbers is usually prefixed with the character + (plus sign), indicating that the number includes the international country calling code(country code), and must typically be prefixed when dialing with the appropriate international call prefix, which is a trunk code to reach an international circuit from within the country of call origination. (Wiki) https://en.wikipedia.org/wiki/E.164 viewed 7 October 2015.
2. Consequences of incorrectly updated addresses
Returned mail, which in turn increases cost to the University of Sydney and increased workload
Delays in donors receiving tax receipts
Donors and alumni not receiving SAM and other University of Sydney communications
Poor customer experience
Possible lost alumni
3. Advance data entry standards
The below formatting is how addresses and telephones are currently being added to Advance by the Advancement Services Team to ensure that the data brought into Advance is more uniform. These are not exhaustive however Auspost may not guarantee the successful delivery of mail with variations the standard.
3.1. Telephone numbers
Australian
Australian landline updates should have an area code
Australian landlines should have the format +61 2 XXXX XXXX
Australian Mobiles should have the format +61 XXX XXX XXX
International
Int’l Landlines should have the format +65 XXXXXXXX…
Int’l Mobiles should have the format +65 XXXXXXXX…
Two important things to note: First of all, in the international E.164 notation a leading ‘0’ is removed. The UK mobile phone number ‘07911 123456’ in international format is ‘+44 7911 123456’, so without the first zero. Secondly in the E.164 notation all spaces, dashes [‘-‘] and parentheses [ ‘(‘ and ‘)’] are removed, besides the leading ‘+’ all characters should be numeric.
A telephone number can have a maximum of 15 digits
3.2. Addresses
Australian
An extensive list of address abbreviations in accordance with Australian Standards can be found on the following website:
3.2.1 The Street type can be abbreviated or written in full
61 Jones St or 61 Jones Street
61 Jones Rd or 61 Jones Road
61 Jones Ave or 61 Jones Avenue
3.2.2 The correct way to record a business address including suites, floors and levels are:
Suite 6, Ground Floor
7 Castlereagh Street
SYDNEY NSW 2000
Suite 6, Level 8 or SE 6, L8
22 Castlereagh Street 22 Castlereagh St
SYDNEY NSW 2000 SYDNEY NSW 2000
Level 2, 15 Castlereagh Street or L2 15 Castlereagh St
SYDNEY NSW 2000 SYDNEY NSW 2000
3.2.3 The correct way to record unit and street numbers
1/2 Sydney St this translates to unit 1 of number 2 Sydney Street
SYDNEY NSW 2000
(Australia Post Guidance - TAP business rules specifies the solidus (/) method be used)
The only exception to be above is in regards to nursing homes/business parks/complexes:
Unit 1B Waratah Building
2 Jones Avenue
MATRAVILLE NSW XXXX
This translates to unit 1B of Waratah Building. The Building Complex is the name used to identify the physical building or property. It is not abbreviated, and may include reference to a wing or other components of a building complex
3.2.4 The correct way to record a post office box number:
PO Box 1
SYDNEY NSW 2000
Additional notes
Please double-check the spelling of all Proper nouns
Punctuation in the address proper should be avoided. Punctuation in the “name line” and the use of - and / to separate defined address elements is acceptable.
Suburbs/cities/states must be in UPPER CASE
International
The most frequently international country address within DAD are those from China, GB and USA. It is imperative that these address formats are correct to ensure the successful delivery of any mail from the University’s DAD.
A) China
B) Great Britain United Kingdom, England, Scotland, Wales, Channel Islands, Isle of Man, U.K., Northern Ireland)
Mr. Walter C. Brown49 Featherstone StreetLONDON
C) United States
D) Singapore
Generally, there are only two address formats in Singapore: one for buildings and another for landed properties:
Buildings:
101 Marlow Street
#12-05 Clife Parkview
Singapore 059020
Landed Properties:
60 Aria Street
Singapore 602580
https://www.lingonomad.com/singapore/address-format
Coding to identify unit/flat/apartment data:
Format | Comments | Frequency |
6/65 Tania Dr, Aberfoyle Park, SOUTH | Solidus (/) to separate: Contains(“/”) | 40,906 |
Unit 4 62 Jacaranda Road, CARINGBAH | Contains(“Unit”) | 3,812 |
U 8 42-60 Capital Ave, GLEN WAVERLEY | Starts with “U_“ | 3,111 |
Flat C, 32/F, Blk 1, Hong Lai Gdn | Contains(“Flat”) | 2,473 |
F 20 27 Tor Rd, DEE WHY, NSW 2099 | Starts with “F_” | 16 |
Apartment 1901 1 Kings Cross Road, DARLINGHURST | Contains(“Apart”) | 28 |
Apt 63 2 Nadgee Street, RED HILL | Contains(“Apt”) | 328 |