Business licence attributes

  • LicenceRSN: Unique identifier for each business licence generated by the system
  • LicenceNumber:  This is a 9 character field consisting of a two digit number indicating the year issued followed by a hyphen and a six digit system-generated number.
    Note:  There is a small chance that a licence number can be reused more than once within a given year.  LicenceRSN is an unique identifier.
  • LicenceRevisionNumber: A 2 digit field generated by the system that represents the licence version
    Note: 00 means the original version and this number increases as new revisions are created. 
  • BusinessName: The ownership of the business
  • BusinessTradeName: Name under which business is usually conducted
  • Status: Current status of the business licence, as follows:
    • Cancelled: Licence is cancelled due to various reasons
    • GOB: Gone Out of Business. A business is no longer operating
    • Inactive: Licence is no longer active
    • Issued: Licence is issued with no status change (e.g., GOB) for the displayed year or the review of a Liquor licence application is completed
    • Pending: Licence is in an application, incomplete or under review stage for the displayed year (e.g., pending approval, renewal, payment, under review)
  • IssuedDate: The date when the business licence is issued and printed
    This field is in YYYY-MM-DD HH:MM:SS format.
  • ExpiryDate: The date that the business licence expires. Most licences expire on December 31st.
    This field is in YYYY-MM-DD HH:MM:SS format.
  • BusinessType: Description of the business activity, usually in accordance with the definition in the Licence By-Law No. 4450
    Note:
      • Business type names that have a notation of “Historic” at the end signified retired business licence types. These are business licence types that were once active but have since been retired
      • Due to privacy concern, some business types do not have address data.
  • BusinessSubType: Sub-category(s) of the main business type
    Note: business sub type names that have a notation of “Historic” at the end signified retired business licence sub types. These are business licence sub types that were once active but have since been retired
  • Unit: Official space identifier for a building. This is an alphanumeric field.
  • UnitType: Description of a location other than a house or building with a simple street address where the business is located. i.e., Block, Suite, Apartment (Apt.), etc.
  • House: The number assigned to an address where the business is located.
  • Street: The name of the street where the business is located.
  • City: Name of the municipality where the business is located
  • Province: Name of the province or state where the business is located
  • Country: A three character field that signifies the name of the country where the business is located
  • PostalCode: A series of letters and/or digits that is attached to the address of a business
  • Latitude: Follows World Geodetic System 84 (WGS 84) standard. Latitude is measured from the equator in degrees , with positive values going north and negative values going south.
  • Longitude: Follows World Geodetic System 84 (WGS 84) standard. Longitude is measured in degrees from the Zero Meridian (which is the longitude that runs through Greenwich, England), with positive values going east and negative values going west.
  • LocalArea: In 1969, City Council approved twenty-two local areas as a basis for the organization of community services and city departments. In 1970, local areas were used for the establishment of local area planning programs. For more information, see the Local Area Boundary Data page.
  • NumberofEmployees: Number of staff employed with the business
    Note: 0 means information received from applicant indicates the business does not have any employees. 000 means information unknown.
  • FeePaid: Total amount of licence fee paid in Canadian dollars
    Note: This field will be blank if the information is unavailable or unspecified.
  • ExtractDate: Date when data was extracted from source data system.
    This field is in YYYY-MM-DD format.