Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Date

Change

Knowledge Document

Comments

Apartment / Unit / Flat address types analysis

View file
nameCorrect Apartment_Unit formatting BUSINESS RULES __.msg

Miranda Adams - confirms agreed business format for unit addresses is with solidus (/)

View file
nameRE_ Correct Apartment_Unit formatting BUSINESS RULES __.msg

Yeng Sembrano - provided guide written before by our former database analyst.

View file
nameAddress and Phone formatting for Advance.docx

View file
nameRE_ Correct Apartment_Unit formatting BUSINESS RULES __.msg

Monica Kluegel & Ana Simic - provided TAP Agreed Business Rules.

View file
nameInternational Addresses_Formats from Pat.docx
View file
nameFormatting Guidelines for Data Cleanup_MA.docx

View file
nameRE_ _Confluence_ albie_roets shared “Address Formatting Business Rules” with you.msg

...

Address Line 1

City

Post Code

State

Country

Australia

  • Street: Full or Abbreviated

  • Units: use solidus (/) , i.e. 4/3 Pitt St,

  • Business Addresses: Suite 6, 22 Pitt St

  • PO Boxes: PO Box / GPO Box - no .'s

  • CAPITAL LETTERS

4 Digits

  • Abbreviated

  • CAPITAL LETTERS

  • Always Populated

  • CAPITAL LETTERS

Singapore

See below

  • CAPITAL LETTERS

  • SINGAPORE

  • Always Populated

  • CAPITAL LETTERS

  • SINGAPORE

Table of Contents
minLevel1
maxLevel7

...

Australian Address and Phone formatting for Advance

1.       Introduction 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.

...

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  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

...

  • 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 Addresses

Australian

An extensive list of address abbreviations in accordance with Australian Standards can be found on the following website:

...

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)

Code Block
Mr. Walter C. Brown
Code Block
49 Featherstone Street
Code Block
LONDON
Code Block
EC1Y 8SY
Code Block
UNITED KINGDOM

C) United States

...

D) Singapore

Generally, there are only two address formats in Singapore: one for buildings and another for landed properties:

...