The open data portal catalogue is a downloadable dataset containing some key metadata for the general datasets available on the Government of Canada's Open Data portal. Resource 1 is generated using the ckanapi tool (external link) Resources 2 - 8 are generated using the Flatterer (external link) utility. ###Description of resources: 1. Dataset is a JSON Lines (external link) file where the metadata of each Dataset/Open Information Record is one line of JSON. The file is compressed with GZip. The file is heavily nested and recommended for users familiar with working with nested JSON. 2. Catalogue is a XLSX workbook where the nested metadata of each Dataset/Open Information Record is flattened into worksheets for each type of metadata. 3. datasets metadata contains metadata at the dataset level. This is also referred to as the package in some CKAN documentation. This is the main table/worksheet in the SQLite database and XLSX output. 4. Resources Metadata contains the metadata for the resources contained within each dataset. 5. resource views metadata contains the metadata for the views applied to each resource, if a resource has a view configured. 6. datastore fields metadata contains the DataStore information for CSV datasets that have been loaded into the DataStore. This information is displayed in the Data Dictionary for DataStore enabled CSVs. 7. Data Package Fields contains a description of the fields available in each of the tables within the Catalogue, as well as the count of the number of records each table contains. 8. data package entity relation diagram Displays the title and format for column, in each table in the Data Package in the form of a ERD Diagram. The Data Package resource offers a text based version. 9. SQLite Database is a .db database, similar in structure to Catalogue. This can be queried with database or analytical software tools for doing analysis.

A positive LMIA will be issued by Service Canada if an assessment indicates that hiring a temporary foreign worker (TFW) will have a positive or neutral impact on the Canadian labour market. A positive LMIA must be obtained by an employer before hiring a TFW for a specific occupation. This list excludes all personal names, such as employers of caregivers or business names that use or include personal names. For this reason, the list is not complete and does not reflect all employers who requested or received an LMIA. The data provided in this report tracks TFW positions on Labour Market Impact Assessments only, not TFWs that are issued a work permit or who enter Canada. The decision to issue a work permit rests with Immigration, Refugees and Citizenship Canada (IRCC); therefore, not all positions approved result in a work permit or a TFW entering Canada. The data includes all positions on all positive LMIAs as issued, and therefore also includes any position that may have been subsequently cancelled by the employer. For information on the number of work permits issued, please consult Immigration, Refugee and Citizenship Canada (IRCC) Facts and Figures: http://www.cic.gc.ca/english/resources/statistics/menu-fact.asp. Note: From Q1 2018 to Q3 2023 data, LMIAs in support of Permanent Residence (PR) were excluded from published employer lists. As of the publication of Q4 2023 employer lists (published in April 2024) and going forward, all LMIAs in support of 'Permanent Residence (PR) Only' will be included in the employer lists. However, previous employer lists will not be updated. Should an employer wish to contact ESDC concerning the accuracy of this information, please contact NA-TFWP-PTET@hrsdc-rhdcc.gc.ca.

As of fiscal year 2019 to 2020 and under the new Treasury Board Secretariat Policy on Results (https://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=31300), all departments have implemented the new Departmental Results Framework. This framework, which replaces the Program Alignment Architecture (PAA), consists of departmental core responsibilities and their related program inventory. These codes are used to reflect the resources allocated to the achievement of government objectives. The format of these codes is composed of a 5 digit field: 3 alpha (capital letter) and 2 numeric digit codes. Example: ZZZ00 - represents a core responsibility. The first three digits are capital letters and the last two digits are zeros. ZZZ01 - this five digits alphanumeric code represents an individual program from the program inventory. The first 3 digits identify the core responsibility to which the program corresponds and the last two numbers is a combination between 01 and 99.

This dataset contains the object code classification structure and the descriptions for each of the object codes. The object code is a field in the government-wide coding block. It identifies the types of goods or services acquired, the transfer payments made, the source of revenue or the cause of increases or decreases in assets and liabilities. The object code information provides: * a structure for reporting the nature of transactions in the Estimates and in the Public Accounts * a standard classification of transactions for internal departmental analysis and use by central management * the basis used by Statistics Canada to more accurately determine and report the impact of government revenues and expenditures on the rest of the economy In addition, the object coding allows the information to be useable at a government-wide level, which reduces the number of individual requests central agencies must make to departments and agencies.

The Algorithmic Impact Assessment (AIA) is a mandatory risk assessment tool intended to support the Treasury Board’s Directive on Automated Decision-Making. The tool is a questionnaire that determines the impact level of an automated decision-system. It is composed of risk and mitigation questions. Assessment scores are based on many factors including systems design, algorithm, decision type, impact and data. The AIA was developed based on best practices in consultation with both internal and external stakeholders. It was developed in the open, and is available to the public for sharing and re-use under an open license. Its source code repository is publicly available.

The primary purpose of the authority codes is to identify expenditure transactions for accountability and reporting in the Public Accounts of Canada according to the specific votes and other authorities in the Estimates, other authorities included in specific statutes; and in addition, to identify the nature of revenue, by tax and non-tax revenue. Other authority codes (non-appropriated authorities) are also established by central agencies to facilitate the identification of various accounting transactions that do not require the use of appropriations. An appropriation is an authority of Parliament to pay money out of the Consolidated Revenue Fund (CRF) and as such, provides parliamentarians with control over most expenditures of the government. As a general rule, transactions are recorded against an appropriation on an expenditure basis; however, there are certain expenditures that are not charged to an appropriation until a payment is required. The authority code identify expenditures transactions as follows: Statutory expenditures Statutory expenditures are those that Parliament has approved through legislation (other than Appropriations Act) that set out the purpose of the expenditures and the terms and conditions under which they may be made. Non-statutory expenditures are those that Parliament approves annually through an Appropriation Act. Once approved the vote wording and the expenditure authority attributable to each vote become the governing conditions under which these expenditures may be made. Non-appropriated transactions Non-appropriated authority codes identify accounting transactions that do not require the use of appropriations (i.e., expenditure or revenue are already recognized [e.g., amortization expense or the receipt of revenue credited to vote] or expenditure is not charged to appropriations until the payment is required [e.g., severance pay]).

The Values and Ethics Code for the Public Sector (VECPS) came into effect in April 2012 as an overarching guide for employees, to help clarify the role and expected behaviours of public servants, and outlines the fundamental values of the public sector of Canada. The VECPS was developed in consultation with public servants, public sector organizations and bargaining agents. The Code applies to the entire public sector, including departments, crown corporations and separate agencies. Based on the VECPS and in accordance with Section 6 of the Public Servants Disclosure Protection Act (PSDPA), Shared Services Canada (SSC) has developed its own Organizational Code (The Code) to provide guidance on ethical behaviour and decision-making in the context of day to day operations at SSC. The SSC Organizational Code was developed in consultation with management, employees and union members from across the Department. The SSC Code outlines the values and department specific information on expected behaviours that guide SSC employees in all activities related to their professional duties. In particular, the Code recognizes the unique role our Department plays in activities related to procurement, hospitality and gifts, and information security. Guidelines on more specific activities and mandated services will be developed on an ongoing basis to accompany the Code. Adherence to both the VECPS and to the SSC Code is a condition of employment. The Codes will help us integrate these values to our decision making process and our actions, so that we can provide Canadians with the best possible programs, policies and services.

In 2021, an international goods and services classification for procurement called the United Nations Standard Products and Services Code (UNSPSC, v21) was implemented to replace the Government of Canada’s Goods and Services Identification Numbers (GSIN) codes for categorizing procurement activities undertaken by the Government of Canada. For the transition from GSIN to UNSPSC, a subset of the entire version 21 UNSPSC list was created. The Mapping of GSIN-UNSPSC file below provides a suggested linkage between the subset of UNSPSC and higher levels of the GSIN code list. As procurement needs evolve, this file may be updated to include other UNSPSC v21 codes that are deemed to be required. In the interim, if the lowest level values within the UNSPSC structure does not relate to a specific category of goods or services, the use of the higher (related) level code from within the UNSPSC structure is appropriate. --- >Please note: This dataset is offered as a means to assist the user in finding specific UNSPSC codes, based on high-level comparisons to the legacy GSIN codes. It should not be considered a direct one-to-one mapping of these two categorization systems. For some categories, the linkages were only assessed at higher levels of the two structures (and then simply carried through indiscriminately to the related lower categories beneath those values). But given that the two systems do not necessarily group items in the same way throughout their structures, this could result in confusing connections in some cases. Please always select the UNSPSC code that best describes the applicable goods or services, even if the associated GSIN value as shown in this file is not directly relevant. --- The data is available in Comma Separated Values (CSV) file format and can be downloaded to sort, filter, and search information. The United Nations Standard Products and Services Code (UNSPSC) page on CanadaBuys offers a comprehensive guide on how to use this reference file. The Finding and using UNSPSC Codes page from CanadaBuys also contains additional information which may be of use. This dataset was originally published on June 22, 2016. The format and contents of the CSV file were revised on May 12, 2021. A copy of the original file was archived as a secondary resource to this dataset at that time (labelled ARCHIVED - Mapping of GSIN-UNSPSC in the resource list below). --- As of March 23, 2023, the data dictionary linked below includes entries for both the current and archived versions of the datafile, as well as for the datafiles of Goods and Services Identification Number (GSIN) dataset and the archived United Nations Standard Products and Services Codes (v10, released 2007) dataset.

List of departments and organizations registered on the Open Government Portal. Columns include: * uuid * title_en: Title in English * title_fr: Title in French * short_form_en: Short form in English * short_form_fr: Short form in French * department_number: Historical department number * umd_number: Unified department number * open_canada_id: Department identifier on https://open.canada.ca

In an effort to increase transparency and to facilitate access to information on substances in commerce in Canada, the Government of Canada is publishing a summary of the information received in response to the Notice to provide information for the risk management of certain coal tars and their distillates. The notice was published on December 1, 2018 in the Canada Gazette, Part I, Vol. 152, No. 48, pursuant to paragraph 71(1)(b) of the Canadian Environmental Protection Act, 1999 (CEPA). Information gathered under the notice will be considered to determine whether to control, or the manner in which to control the risks posed by the substance. This summary offers an overview of the information gathered under the initiative and includes general information on what was received from persons subject to the notice, including: number and type of submissions; substances reported; activities (manufacture, import, use to manufacture); quantities; industry classification; and applications. The draft screening assessment report on certain coal tars and their distillates can be found on the Stream 0 substances in the Petroleum Sector Stream Approach webpage. To complement this summary, data compilation tables, containing additional details on the non-confidential information received, are available for download in Microsoft Excel and comma-separated value (CSV) format. Important information about this summary: In order to protect confidential business information (CBI), quantity ranges and exclusion of qualitative data elements have been applied in some cases. Qualitative data includes information that characterizes and categorizes information [e.g. company names, North American Industry Classification System (NAICS) codes, specified uses, and Application codes]. The dataset does not include CBI, consequently, the figures presented may be an underestimate. Code C999 "Other" was provided for an Application code, it indicates that the codes listed in the notice did not apply and a description was required. Please refer to the notice for the full list of codes and their corresponding descriptions. Supplemental Information Useful links: https://gazette.gc.ca/rp-pr/p1/2018/2018-12-01/html/notice-avis-eng.html https://www.canada.ca/en/environment-climate-change/services/evaluating-existing-substances/coal-tars-guidance-summary.html https://www.canada.ca/en/health-canada/services/chemical-substances/petroleum-sector-stream-approach/stream-0.html https://www.canada.ca/en/health-canada/services/chemical-substances/petroleum-sector-stream-approach/stream-0/coal-tars-distillates.html

Prior to 2021, the Government of Canada used Goods and Services Identification Number (GSIN) codes to identify generic product descriptions for its procurement activities. GSIN codes were used to connect all of the procurement information, including Tender Notices, Award Notices, Standing Offers and Supply Arrangements, and Contract History. The GSIN CSV file published on this page is updated on an “as needed” frequency, when codes are either created or deactivated. >Please see the Mapping of Goods and Services Identification Number to United Nations Standard Products and Services Code dataset for a resource that compares GSIN codes to a subset of the United Nations Standard Products and Services Codes, version 21 (UNSPSC, v21) that are in use by the Government of Canada currently. As of March 23, 2023, the data dictionary linked below includes entries for this dataset, as well as for the datafiles of the Mapping of Goods and Services Identification Number to United Nations Standard Products and Services Code dataset and the archived United Nations Standard Products and Services Codes (v10, released 2007) dataset.

As indicated in the Notice with respect to certain quaternary ammonium compounds in Canadian commerce — Phase 1 (the Notice), and in accordance with section 49 of the Canadian Environmental Protection Act, 1999 (CEPA), the Government of Canada is providing a summary of the information received in response to the Notice, which was published in the Canada Gazette, Part I, on November 17, 2018 under section 46 of CEPA. The Notice collected information from manufacturers and importers (e.g., quantities and uses) on approximately 800 quaternary ammonium compounds (QACs) for the 2017 calendar year. The information will be used to support priority setting, and inform future risk assessments. The files in the resources section below offer an overview of the information gathered under this initiative including: type of submission; reported substances; substances that are manufactured or imported; industrial sectors involved; substance functions and commercial applications; and intended use (in commercial activity, in consumer activity, and by children). It should be noted that these documents do not include an assessment of the potential risks these substances may pose to the environment or to the health of Canadians. To complement the information summary document, a compilation of the non-confidential information received is available for download in Excel and CSV formats and includes a list of the substances for which no information was submitted. Important information about this summary: To protect confidential business information, in some cases quantitative data is presented in ranges and qualitative data is excluded. Qualitative data includes information that characterizes and categorizes information [e.g., company names, North American Industry Classification System (NAICS) codes, specified uses, Substance Function Codes, and Application Codes]. Since the dataset does not include confidential business information, the figures presented may be an underestimate. Code 999 "Other" was provided for a Substance Function Code or an Application Code, it indicates that the codes listed in the Notice did not apply and a description of the function or use was required. Please refer to the Notice or guidance document for further details on data collected. Supplemental Information Useful links: https://gazette.gc.ca/rp-pr/p1/2018/2018-11-17/html/notice-avis-eng.html https://www.canada.ca/en/health-canada/services/chemical-substances/chemicals-management-plan/initiatives/transparency-risk-assessment-activities.html https://www.canada.ca/en/health-canada/services/chemical-substances/inventory-updates.html https://www.canada.ca/content/dam/eccc/documents/pdf/pded/quats/Guidance-manual-QAC.pdf https://www.canada.ca/content/dam/eccc/documents/pdf/pded/quats/20190312-QAC-s-46-substances-en-fr.xlsx

Introduction This reference data provides a standard list of values for all Canadian provinces and territories. The list reflects Canada’s 13 major political units. There are many coding systems for Canadian provinces and territories. The data standard shows the relationships among the recommended code and other common codes. Purpose This list is intended to standardize the way Canadian provinces and territories are described in datasets to enable data interoperability and improve data quality. Not included in this standard are previous names, abbreviations and codes for provinces and territories. When changes occur in the future, version history will be maintained. Applicability Use of the codes within the “Alpha Code” column is recommended when sharing data within the federal government or publishing data to the Open Government Portal. This alpha code was chosen for three reasons: 1. it is comprehensible for users 2. it is closely aligned with the ISO 3166-2 code for subdivision and is identical to the Canada Post abbreviation 3. it has already been adopted by a number of federal departments The Alpha Code exactly matches the set of codes created and managed by Canada Post. If Canada Post changes its codes, the Government of Canada will review and separately approve any changes to this reference standard. If it is necessary to use a numerical code in a data system, then the numerical code created by Statistics Canada is included in the table. Roles and responsibilities Data Standard Stewards Statistics Canada Statistical Geomatics Centre, Analytical Studies, Methodology and Statistical Infrastructure Field Natural Resources Canada Geographical Names Board of Canada Secretariat Data Standard Custodian Treasury Board of Canada Secretariat Office of the Chief Information Officer, Data and Digital Policy Sector Recommended Review Period The reference data standard will be reviewed as required. The expected frequency of change is low.

Information received in response to the 2017 Inventory Update (chemicals and polymers) To increase transparency and to facilitate access to information on manufactured and/or imported substances in Canada, the Government of Canada is providing a summary of the information received in response to the Notice with respect to substances included as part of the 2017 Inventory Update, (the Notice) which was published in the Canada Gazette, Part I in January 2017 under section 71 of the Canadian Environmental Protection Act, 1999. The Notice was applicable to the 2014 and 2015 calendar years with the requirement to report for the most recent calendar year. The information will be used to update the commercial status of these substances, to inform priority setting, and to support risk assessment and risk management activities. In line with communicating information received in response to information gathering initiatives, the Government of Canada published the Approach to disclose confidential information and promote transparency in chemicals management. The files in the resources section below offer an overview of the information gathered under this initiative including: • type of submission; • reported substances; • substances that are manufactured or imported; • industrial sectors involved; • substance functions and commercial uses reported; and • intended use (in commercial activity, in consumer activity, and by children). It should be noted that these documents do not include an assessment of the potential risks these substances may pose to the environment or to the health of Canadians. To complement the information summary document, a compilation of the non-confidential information received is available for download in Excel and CSV format and includes a list of the substances for which no information was submitted. Important information about this summary: In order to protect confidential business information, quantity ranges and exclusion of qualitative data elements have been applied in some cases. Qualitative data includes information that characterizes and categorizes information [e.g., company names, North American Industry Classification System (NAICS) codes, specified uses, Substance Function Codes, and Consumer and Commercial Codes]. The dataset does not include confidential business information; consequently, the figures presented may be an underestimate. Code 999 "Other" was provided for a Substance Function Code or a Consumer and Commercial Code, it indicates that the codes listed in the Notice did not apply and a description of the function or use was required. Please refer to the Notice or guidance document for the full list of codes and their corresponding descriptions. Supplemental Information Useful links: https://www.gazette.gc.ca/rp-pr/p1/2017/2017-01-14/html/notice-avis-eng.html https://www.gazette.gc.ca/rp-pr/p1/2017/2017-04-22/html/notice-avis-eng.html https://www.canada.ca/en/health-canada/services/chemical-substances/chemicals-management-plan/initiatives/transparency-risk-assessment-activities.html https://www.canada.ca/en/health-canada/services/chemical-substances/inventory-updates.html https://www.canada.ca/en/environment-climate-change/services/evaluating-existing-substances/guidanceresponding-tonoticerespectsubstances-includedpart-of2017-inventory-update-the-notice.html

This code is accompanied by the Technical Guide for Interpretation and Compliance Assessment of Health Canada's Radiofrequency Exposure Guidelines, to assist users in understanding and assessing the safety of electromagnetic exposures in working and living environments.

The National Ecological Framework for Canada's "Land Cover by Ecoregion” dataset provides land cover information within the ecoregion framework polygon. It provides landcover codes and their English and French language description as well as information about the percentage of the polygon that the component occupies.

This dataset provides a standard list of values for two coding systems to describe levels of security screening. The data reference table shows the relationship among a simplified code and the 2014 Standard on Security screening.

Canadian airports served by NAV CANADA control towers or flight service station.

The AIRS registration code must be submitted in the commodity details section of the declaration as per the rules in the Canada Border Services Agency (CBSA) Electronic Commerce Client Requirements Document (ECCRD), the CFIA appendix, and AIRS.

This table provides statistics on the Top 20 Fee for Services Codes by Expenditure under the Alberta Health Care Insurance Plan (AHCIP). These reports include payment and service information for services provided by Alberta physicians to people registered with the Alberta Health Care Insurance Plan (AHCIP). Payments and Services provided to Albertans while they are out of country or out of province are excluded from these reports.