Canadian Employer-Employee Dynamics Database Overview
Canadian Employer-Employee Dynamics Database (CEEDD) provides matched data between employees and employers in the Canadian labor market. Analysis can be done on a cross-sectional or longitudinal basis, utilizing various component files containing population data from administrative sources. The CEEDD includes individual-level data from T1 and IMDB files, family-level data from T1FF files, and job-level/firm-level data from T4, ROE, and T2 Schedule 50 files, offering opportunities for immigration-related research.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Canadian Employer-Employee Dynamics Database (CEEDD) www.statcan.gc.ca Telling Canada s story in numbers Social Analysis and Modelling Division (SAMD) March 2017
Outline Overview Component files Linkage environment Data structure Output analytical files Opportunities for immigration-related research Access March 2017 Statistics Canada Statistique Canada 2
The CEEDD --- Overview A set of linkable files to provide matched data between employees and employers in the Canadian labour market. Analysis can be done with the CEEDD data at 1. Cross-sectional basis: at a given point in time based on covariates drawn from the same year across different component files; or 2. Longitudinal basis: tracking firms and employees over time across different component files All CEEDD files contain 100% of the respective population from the administrative sources. March 2017 Statistics Canada Statistique Canada 3
The CEEDD --- Component files The CEEDD linkage environment contains information from the following component files from 2001 onwards: 1. T1 Personal Master File (T1PMF) 2. T1 Historical Personal Master File (T1H) 3. T1 Family File (T1FF) 4. T1 Financial Declaration File (T1FD) 5. T1 Business Declaration File (T1BD) 6. T2 Schedules (T2) 7. T2 Schedule 50 8. T4 Statement of Remuneration Paid Files (T4) 9. Record of Employment (ROE) 10. Raw Import Data for Research Purpose (Import data) 11. Trade by Exporter Characteristics (TEC) 12. National Accounts Longitudinal Microdata File (NALMF) 13. Longitudinal Immigration Database (IMDB) 14. Temporary Residents File (TR) March 2017 Statistics Canada Statistique Canada 4
The CEEDD --- Linkage environment March 2017 Statistics Canada Statistique Canada 5
The CEEDD --- Linkage environment Individual-level data: From T1 files: Demographic information and reported earnings of individual tax filers. Multiple SIN holders are processed in the files so that information from different SINs of the same individual can be linked over time. From IMDB files: Immigration-related information for foreign-born individuals who became landed immigrants in Canada. Family-level data: From T1FF files: Individual tax filers can be linked to their spouse and children at the census family level March 2017 Statistics Canada Statistique Canada 6
The CEEDD --- Linkage environment Job-level and Firm-level data: For employees: From T4 and ROE files, information related to payroll and job separation is available For incorporated business owners: Information from T2 Schedule 50, T1, and T4 are linked to identify information related to the business owners and their businesses including employment, revenue, profit, and industry code. For unincorporated business owners: Information from T1 self- employment income report is used to identify information related to the unincorporated business owners and information from T1BD can be used to extract information for the unincorporated businesses (2005 onwards). For firms: Information from the NALMF and Import and Export files. The NALMF is a comprehensive longitudinal database of Canadian enterprises that links annual employment and administrative data from T4, PD7, T2, T2 Schedule 50, GST, and Import & Export files. March 2017 Statistics Canada Statistique Canada 7
The CEEDD --- Linkage environment Geography data: Province variables are available from the T1 files for individual tax filers. Province of employment is available from the T4 files. Province of business for unincorporated firms is available from T1BD files. Province of operation for incorporated firms is available from Business Register through the NALMF. Sub-provincial variables based on standard geographical classification from Census are also available at individual level. March 2017 Statistics Canada Statistique Canada 8
The CEEDD --- Data structure A key feature of the CEEDD is that it is a set of linkable files from different sources instead of being a single linked file containing all variables. A single linked file contains one line of record for each unit of analysis with all available variables. File 1 File 2 File 3 Variable A1 Variable A2 Variable B1 Variable B2 Variable C1 Variable C2 Person A Person B March 2017 Statistics Canada Statistique Canada 9
The CEEDD --- Data structure A set of linkable files contains one or more lines of records for each unit of analysis in separate component files. File 1 Variable A1 Variable A2 Person A Person B File 2 Variable B1 Variable B2 Person A Person B March 2017 Statistics Canada Statistique Canada 10
The CEEDD --- Data structure File 3 Variable C1 Variable C2 Person A Person B The set of linkable files under the CEEDD allow researchers to add and process variables from different component files separately. Using the unique personal and firm identifiers available on each linkable file, information at the employee and employer level can be linked across different component files over time. March 2017 Statistics Canada Statistique Canada 11
The CEEDD --- Data structure To help users navigate between different files under the CEEDD linkable environment, a set of relational summary tables are currently under development. These tables allow users to learn more about a particular group of interest before working with the actual output analytical files, for example: 1. What is the sample size for tax filers who filed T1 every year from 2001 to 2013? 2. In which types of firms do immigrants work right after landing, compared with many years later? March 2017 These relational summary tables will be produced for the 2017 CEEDD data in Fall 2017. Statistics Canada Statistique Canada 12
The CEEDD --- Output analytical files Selected variables from different component files are available for CEEDD users. Variable lists for each output analytical files are available in the CEEDD overview document. A summary table with all output analytical files for 2015 & 2017 CEEDD data is in the next slide. March 2017 Statistics Canada Statistique Canada 13
Output Analytical Files Individual-level data T1 Personal Master Files T1 Historical Files Source Files 2015 vintage 2017 vintage T1 PMF T1 H Landing Files & Temporary Residents Files 2001 to 2013 2001 to 2011 2001 to 2015 2001 to 2013 IMDB Files 2001 to 2013 2004 to 2015 Family-level data T1 PMF, T4, Canada Child Tax Benefit (CCTB) Files T1 Family Files 2001 to 2013 2001 to 2015 Job-level data Edited T4 Files T4 T1 H, T1FD, T1BD, T2 Schedule 50, T2 Corporate Income Tax, T4, IMDB T4, ROE, LEAP Edited T4, ROE, NALMF 2001 to 2011 2001 to 2013 Business owners' module Raw T4 - ROE - LEAP Edited T4 - ROE - NALMF 2001 to 2011 2001 to 2013 2001 to 2013 2001 to 2015 2001 to 2015 Firm-level data BR, T2, T4, PD7, GST, Import & Export Files Raw import data for research purpose Trade by Exporter Characteristics NALMF 2001 to 2013 2001 to 2015 Import Files 2002 to 2012 2002 to 2012 Export Files 2010 to 2014 2010 to 2015 Geography data Postal code information from the T1 PMF March 2017 14 Sub-provincial indicators 2001 to 2013 2001 to 2015
The CEEDD --- Opportunities for immigration-related research The CEEDD data can be used to explore different topics in the immigrant research area including: 1. Immigrants as business owners 2. Immigrant labour market outcomes 3. Immigrant job dynamics 4. Immigrants and firm performance March 2017 Statistics Canada Statistique Canada 15
The CEEDD --- Opportunities for immigration-related research Immigrants as business owners Green et. al. (2016), Immigration, Business Ownership and Employment in Canada, Analytical Studies Branch Research Paper Series, No. 375, Statistics Canada Catalogue no. 11F0019M. Fairlie, Robert W. and Magnus Lofstrom (2013), Immigration and Entrepreneurship, In Handbook of the economics of international migration, Vol. 1B, ed. Barry Chiswick and Paul Miller, p. 877 911. North-Holland: Elsevier. Hou,Feng and Shunji Wang (2011) Immigrants in self-employment, Perspectives on Labour and Income, Vol. 23 (3), p. 5 16, Statistics Canada Catalogue no. 75-001-X. March 2017 Statistics Canada Statistique Canada 16
The CEEDD --- Opportunities for immigration-related research Immigrant labour market outcomes Ci, Wen and Feng Hou (2016), Immigrants Initial Firm Allocation and Earnings Growth, Analytical Studies Branch Research Paper Series, No. 378, Statistics Canada Catalogue no. 11F0019M. Tomaskovic-Devey, Donald, Martin Hallsten, and Dustin Avent-Holt (2015), Where Do Immigrants Fare Worse? Modeling Workplace Wage Gap Variation with Longitudinal Employer-Employee Data, American Journal of Sociology, Vol. 120 (4), p. 1095 1143. Garnett, Picot, Feng Hou, and Theresa Qiu (2014) The Human Capital Model of Selection and the Long-run Economic Outcomes of Immigrants, Analytical Studies Branch Research Paper Series, No. 361, Statistics Canada Catalogue no. 11F0019M. Statistics Canada Statistique Canada March 2017 17
The CEEDD --- Opportunities for immigration-related research Immigrant job dynamics Immigrants earnings trajectories: Job shopping or internal labour markets (Townsend, work-in-progress) Bijwaard, Govert E., Christian Schluter, and Jackline Wahba, The Impact of Labor Market Dynamics on the Return Migration of Immigrants, The Review of Economics and Statistics, Vol. 96 (3), p. 483 494. Skuterud, Mikal and Mingcui Su (2012), Immigrants and the Dynamics of High-Wage Jobs, ILR Review, Vol. 65 (2), p.377 397. March 2017 Statistics Canada Statistique Canada 18
The CEEDD --- Opportunities for immigration-related research Immigrants and firm performance Immigrant workers and firm productivity (Hou & Wulong, work-in- progress Ozgen, Ceren, Peter Nijkamp, and Jacques Poot (2013) The impact of cultural diversity on firm innovation: evidence from Dutch micro-data, IZAJournal of Migration, 2 (1), 18. Nakos George, Keith D. Brouthers, and Lance Eliot Brouthers (1998) The Impact of Firm and Managerial Characteristics on Small and Medium-Sized Greek Firms Export Performance, Journal of Global Marketing, Vol. 11 (4), p.23 47. March 2017 Statistics Canada Statistique Canada 19
The CEEDD --- Access The CEEDD files are housed in the Centre of Data Development and Economic Research (CDER) of Statistics Canada. External researchers will be able to access the linked data on Statistics Canada premises subject to CDER S costing structure, under the Policy on the Use of Deemed Employees and current MOUs with the CDER. Synthetic files will be created for external users for direct access, while the original files will only be accessed via batch mode with no viewing function. March 2017 Statistics Canada Statistique Canada 20
The CEEDD --- Contacts Danny Leung Economic Analysis Division Telephone: 613-951-2574 danny.leung@canada.ca Grant Schellenberg Social Analysis and Modelling Division Telephone: 613-951-9580 grant.schellenberg@canada.ca March 2017 Statistics Canada Statistique Canada 21
