Address Data Standard

Intended Audience and Contact Information

Contact Chief Data Officer, Office of the CIO
UDM Domain Location
Intended Audience Internal UBC

Change Log

Standard Version Date Change Log
2022-07-11

1.0 Addition of list of address data elements/attributes

2.0 Simplification of Workday address data elements mapping for integrations

3.0 Removal of:

  • 3.1 Government of BC Office of the CIO Address Standards,
  • 3.2 Canada Post Address Guidelines,
  • 3.3 The United States Postal Service Address Standards, and
  • 3.4 Universal Postal Union Standards.
2022-03-09 Reference Data Compliance for Data Integration sub-section of Compliance section added

Purpose

This standard aims to achieve consistency around the data collected for postal address and the format in which it is collected and stored across the University. This standard does not apply to addresses issued by the University, for these addresses refer to the UBC Campus Address Standard.

This standard applies to all UBC applications collecting Postal Address. Exceptions are listed in the Dispensation section.

Standard

An Address may represent a location that is in Canada, in the United States, or International (non-Canadian and non-United-States). The following are the data attributes that should be used to describe an address:

Address attributes
Attribute Name Requirement Example Notes
Civic Number Optional 123 or 33B Street Number - including Civic Number Suffix
Street Name Optional University Blvd.  
Site/Unit Number Required 421 A including Site/Unit Number Suffix
Rural Route Identifier Required RR 4  
Rural Route Station Required LCD Main  
Postal Box Number Required 1234  
Postal Installation Type Required Stn. C Optional - filled only if Postal Box Number is provided
Additional Address Information 1 Required c/o Recipient name, Klinck Bldg.
or
Site C Comp 10		 Additional information including care of information, house number extension/complex/block/building name and number, floor, stairway number, etc.
Additional Address Information 2 Required District Any other address information that is not captured in Address line 1 or Address line 2.
City/Town/Municipality Name Optional Vancouver See Canadian City for list of accepted values for Canadian cities
See US City for list of accepted values for US cities
See World City for list of accepted values for international cities
Province/State/Region/County Optional BC ISO 3166-2
Postal/Zip Code Optional V3X 2A8 List from US Postal Services/Canada Post
Country Optional Canada ISO 3166-1

Compliance

This standard about postal address must be complied with through every stage of the data lifecycle with the exception of any dispensations (see Dispensation section):

  • All applications must collect postal address as recommended in this standard.
  • Enterprise Data Integration must adopt this standard.

Dispensation

Workday

Workday address components

Workday address components are presented in various formats dynamic based on selected country. Address elements can include multiple of the following:

  • Address lines 1 to 9
  • City
  • Municipality
  • Sub-municipality
  • Region1
  • Sub-region(s)2 1 to 3
  • Postal code

This standard aims at providing guidance for how UBC Address attributes map to address lines and attributes in Workday. For all available attributes, populate the respective fields in the order shown below, and separate each value with a comma:

Workday Address Element UBC Address Attribute Name(s)
Line 1 Civic Number, Street Name, Site/Unit Number, Rural Route Identifier, Rural Route Station, Postal Box Number, Postal Installation Type
Line 2

Additional Address Information 1
Note: The data elements in this attribute include: Care of information, house number, extension/complex/block/building name and number, floor, room, stairway number, etc.
Lines 3-9

Additional Address Information 2
Note: Any values entered into Lines 3-9 will be concatenated and each value separated with a semicolon.
City City/Town/Municipality Name
Region1 or Region Subdivision2 Province/State/Region/County
Postal Code Postal/Zip Code
Country Country

1For a list of accepted values for region click here
2For a list of accepted values for sub-division hierarchy click here

Legacy Systems

Legacy systems are exempt from this data standard. Examples of legacy systems are:

  • Student Information System (SIS)

As systems are replaced, adoption of this standard is required.

As existing systems change to adopt this standard, the Enterprise Data Governance team needs to be informed.

Related Documents

  1. Government of British Columbia Office of the CIO - Address Data Standards
  2. Address Data Standards: Mailing, Delivery and Residential - Office of the CIO, Province of BC
  3. Canada Post Addressing Guidelines
  4. https://pe.usps.com/cpim/ftp/pubs/Pub28/pub28.pdf
  5. Universal Postal Union - International Addressing Standards
  6. Campus Address Standard