Navigate to the Canadian Institute for Health Information home page

Logical Data Model

Project:

Canadian Postal Code
Appears In: Geography LDM Subject Area, CACDI LDM View, Address and Location LDM Subject Area
A six-character alphanumeric code defined and maintained by Canada Post Corporation for the purpose of sorting and delivering mail.<br/><br/>Defined based on Forward Sortation Area (FSA) and Local Delivery Unit (LDU). The Postal Code is a six-character uniformly structured, alphanumeric code in the form “ANA NAN” where “A” is an alphabetic character and “N” is a numeric character. <br/><br/>
  • Attributes
  • Associations To
  • Associations From
  • Constraints
Attribute Type
Canadian Postal Code Value String
Notes: The value of a postal code.<br/>
Canadian Postal Code Type Code Codeable Concept
Notes: A coded concept that specifies the type of addresses used to identify the points of call served by the postal code.<br/><br/>Value set: <br/><a href="https://www.canadapost-postescanada.ca/cpc/doc/en/marketing/postal-code-conversion-file-reference-guide.pdf"><font color="#0000ff"><u>https://www.canadapost-postescanada.ca/cpc/doc/en/marketing/postal-code-conversion-file-reference-guide.pdf</u></font></a> <br/>
Canadian Postal Code Latitude Decimal
Notes: The latitude of a postal code.<br/>
Canadian Postal Code Longitude Decimal
Notes: The longitude of a postal code.<br/>
Canadian Postal Code Birth Date Date
Notes: The approximate date when the postal code became effective. All postal codes created before April 1983 were given a birth date of ‘19830401’.<br/>
Canadian Postal Code Retired Date Date
Notes: The approximate date when a postal code was retired. All postal codes retired before April 1983 have ‘19830401’ as the retirement date. Some postal codes have been retired and reintroduced at a later date. Active postal codes have a retirement date of ‘19000001’.<br/>
Relationship Target Entity
has   Province Or Territory Forward Sortation Area
has   Dissemination Area
Relationship Target Entity
has
Optional since some addresses are not Canadian and therefore will not have a Canadian postal code<br/><br/>
Address
Constraint
Unique Key: Canadian Postal Code Value