Question:
A researcher is searching for a data source where he can get “employee pay frequency”, see figure 1 below, for the following variables:
- for private and public companies,
- industries at the 2 digit NAICS code level, &
- provinces and territories (or provinces).
Figure 1, e.g., two questions asked so that StatCan can calculate employees’ weekly earnings or hourly earnings
_____________________________________________________________
LFI_Q202 — [Including tips and commissions,] what is his/her hourly rate of pay? Go to 220
If no hourly rate then next question is …
LFI_Q204 — What is the easiest way for you to tell us his/her wage or salary, [including tips and commissions,] before taxes and other deductions? Would it be yearly, monthly, weekly, or on some other basis?
If “Yearly”, go to 209
If “Monthly”, go to 208
If “Semi-monthly”, go to 207
If “Bi-weekly”, go to 206
If “Weekly” or “Other”, go to 205
_____________________________________________________________
Source, Labour Force Survey user guide
I wasn’t able to find other surveys (other than the Survey of Employment, Payrolls and Hours) which ask about pay frequency, but then this was not an exhaustive search.
And please see U.S. example:- link: “How frequently do private businesses pay workers?” [https://www.bls.gov/opub/btn/volume-3/how-frequently-do-private-businesses-pay-workers.htm] Beyond the Numbers, May 2014, BLS
Re: Figure 2 … *Email included an attached screen capture of Fig. 2
Any leads would be appreciated. It would be great if this could be retrieved from a PUMF or RTRA, but if not, what are the options.
Follow-Up Question:
This is in follow-up to this data request (pay frequency…) below. The researcher just specified to me that he wants to obtain firm-level data. Noting that this would likely require the Survey of Employment, Payrolls and Hours (SEPH), I am looking for validation please on whether SEPH it is available in the RDC’s or CDER. I don’t find it on either the page of survey data sources for the RDC’s or CDER.
Answer:
The SEPH data is unfortunately not available in the RDCs, and is not currently available in CDER, however they have been in discussions with the SEPH manager about including it in CDER and he was open to the idea, provided there is a demand for it. He noted that it would take some time to prepare the files for use though.
Follow-up Question:
Thank you so much for confirming information about access to SEPH data. This is what I had thought could be the answer. And although we have at least one request a year for SEPH data, how that would translate to CDER users I am not sure J
In the meantime, it would be great to find out more about another possible source or sources for tabulations.
On a pure curiosity level, could DLI contacts request information on CDER researchers from their institutions, e.g., numbers?
Follow-up Answer:
Unfortunately it doesn’t look as if we’ll be able to get this particular bit of information:
“In theory the data is available but not something that we publish. Also the concept is not quite what the researcher is looking for. There is a difference in “employee pay frequency” and “easiest way to tell us your wage/salary”.
I am also not sure how CDER numbers would work, but I can look into that for you!
Follow-up Question:
Thank you so much for looking into data sources for this research question.
The researcher would like to please inquire into the possibility of using multiple years of SEPH data for pay frequency at the firm level in CDER. The researcher acknowledges that the SEPH measure of “easiest way to tell us your wage/salary” would only be a proxy for pay frequency. Given this somewhat restrictive definition, and the fact that SEPH is not currently available in CDER, what would be the next steps for inquiring about the possibility of using SEPH in CDER? Does the researcher need to provide any specific information at this stage and would it be acceptable for me to be looped in the discussions?
Follow-up Answer:
Our CDER contact has replied with the following:
“Do you know a bit more about the scope of the project? CDER only provides access to business microdata for research projects and not custom tabulations. If this is indeed the case, I will get in touch with the manager of SEPH and perhaps we can organize a call with the researcher.”
Showing posts with label Employment. Show all posts
Showing posts with label Employment. Show all posts
Monday, February 25, 2019
Friday, June 15, 2018
Stats on Employment of Victims of Domestic Abuse
Question:
Can anyone help me to find statistics regarding employment services (employability, those working fulltime or part-time, and services to help them find employment, etc.) for victims of domestic violence in Canada? This can range to include any and all stats related to employment for men or women or children who are affected by domestic abuse.
Answer:
I have contacted various Subject Matter divisions and we do not seem to collect data primarily on domestic violence. However, I have navigated Nesstar and found the following surveys that might be of interest.
The GSS Victimization datasets capture information on the experiences of victimization:
- General Social Survey, Cycle 13, 1999 [Canada]: Victimization Main File
- General Social Survey, Cycle 18, [Canada] 2004: Victimization, Main File
- General Social Survey, Cycle 23, 2009 [Canada]: Victimization, Main File
- General Social Survey, Cycle 28, 2014 [Canada]: Victimization, Main File
Upon perusing the contents of the General Social Survey, Cycle 28, I found the following variables/variable groups that might be of interest:
Variables/Variable groups related to victimization:
Variable CEX_040C: Childhood victimization - Relations between adult and respondent (physical included)
Variable CEX_065C: Childhood victimization - Relations between adult and respondent (sexual included)
Variable CEXTALK: Childhood victimization - Talked to someone
Variable group: NCP: Likelihood neighbours would call the police
Variable group: VST: Criminal victimization screening: Total
Variable groups related to employment:
Variable group: WET: Work activities - Employment type
Variable group: WHW: Work activities - Hours worked
Variable group: WLY: Work activities - Last year employer information
Additionally, the Violence Against Women Survey, 1993 [Canada] dataset includes a large repertoire of data on victimization. It also includes a variable group related to employment: Variable E4: Respondent worked full-time or part-time.
Finally, we can also refer you to Public Safety and Justice Canada. Public safety has been responsible for the policies and victims programs in Canada; it can be found on their website. Justice Canada has what they call the Victim Services Directory, which lists all the services available. You should be able to find some major resources in the list. At Justice Canada, you can contact the policy centre for victim issues at: pcvi-cpcv@justice.gc.ca.
Can anyone help me to find statistics regarding employment services (employability, those working fulltime or part-time, and services to help them find employment, etc.) for victims of domestic violence in Canada? This can range to include any and all stats related to employment for men or women or children who are affected by domestic abuse.
Answer:
I have contacted various Subject Matter divisions and we do not seem to collect data primarily on domestic violence. However, I have navigated Nesstar and found the following surveys that might be of interest.
The GSS Victimization datasets capture information on the experiences of victimization:
- General Social Survey, Cycle 13, 1999 [Canada]: Victimization Main File
- General Social Survey, Cycle 18, [Canada] 2004: Victimization, Main File
- General Social Survey, Cycle 23, 2009 [Canada]: Victimization, Main File
- General Social Survey, Cycle 28, 2014 [Canada]: Victimization, Main File
Upon perusing the contents of the General Social Survey, Cycle 28, I found the following variables/variable groups that might be of interest:
Variables/Variable groups related to victimization:
Variable CEX_040C: Childhood victimization - Relations between adult and respondent (physical included)
Variable CEX_065C: Childhood victimization - Relations between adult and respondent (sexual included)
Variable CEXTALK: Childhood victimization - Talked to someone
Variable group: NCP: Likelihood neighbours would call the police
Variable group: VST: Criminal victimization screening: Total
Variable groups related to employment:
Variable group: WET: Work activities - Employment type
Variable group: WHW: Work activities - Hours worked
Variable group: WLY: Work activities - Last year employer information
Additionally, the Violence Against Women Survey, 1993 [Canada] dataset includes a large repertoire of data on victimization. It also includes a variable group related to employment: Variable E4: Respondent worked full-time or part-time.
Finally, we can also refer you to Public Safety and Justice Canada. Public safety has been responsible for the policies and victims programs in Canada; it can be found on their website. Justice Canada has what they call the Victim Services Directory, which lists all the services available. You should be able to find some major resources in the list. At Justice Canada, you can contact the policy centre for victim issues at: pcvi-cpcv@justice.gc.ca.
Wednesday, May 30, 2018
Economic Performance of Ontario Graduates
Question:I have a Masters student who is interested in looking at how Ontario graduates perform economically pre 2003 and post 2003. She seems pretty wedded to using the Census and DoB to differentiate between pre/post graduates-- in addition to including place of origin, language, income and marital status.
Does Ontario have a suitably anonymized dataset that might meet her needs? Another option would be to apply to the RDC but I don't think her timeline would accommodate that.
Answer:“The National Graduates Survey (NGS) has data regarding students who graduated in 2000 and in 2005.
The following link provides a list of CANSIM tables that provide data from the survey:
http://www5.statcan.gc.ca/COR-COR/COR-COR/objList?lang=eng&srcObjType=SDDS&srcObjId=5012&tgtObjType=ARRAY
Please see the attached CANSIM table user guide. In each table, click the ‘Add/Remove data’ tab to uncheck ‘Canada’ and check ‘Ontario’. Scroll down and click ‘Apply’.”
The DLI has the NGS PUMFS from 1982-2013 available through Nesstar Webview. The following are direct links to the cycles that Subject Matter has referenced: National Graduate Survey, 2000 - Follow-up and National Graduate Survey, 2005.
If the student wanted to explore the variables available on the master file, they are also available through Nesstar. The following are direct links to the zero frequency master files: National Graduate Survey, 2002 - Follow-up and National Graduate Survey, 2005.
The NGS is also available on the EFT at: /MAD_PUMF_FMGD_DAM/Root/5012_NGS_END/
Does Ontario have a suitably anonymized dataset that might meet her needs? Another option would be to apply to the RDC but I don't think her timeline would accommodate that.
Answer:“The National Graduates Survey (NGS) has data regarding students who graduated in 2000 and in 2005.
The following link provides a list of CANSIM tables that provide data from the survey:
http://www5.statcan.gc.ca/COR-COR/COR-COR/objList?lang=eng&srcObjType=SDDS&srcObjId=5012&tgtObjType=ARRAY
Please see the attached CANSIM table user guide. In each table, click the ‘Add/Remove data’ tab to uncheck ‘Canada’ and check ‘Ontario’. Scroll down and click ‘Apply’.”
The DLI has the NGS PUMFS from 1982-2013 available through Nesstar Webview. The following are direct links to the cycles that Subject Matter has referenced: National Graduate Survey, 2000 - Follow-up and National Graduate Survey, 2005.
If the student wanted to explore the variables available on the master file, they are also available through Nesstar. The following are direct links to the zero frequency master files: National Graduate Survey, 2002 - Follow-up and National Graduate Survey, 2005.
The NGS is also available on the EFT at: /MAD_PUMF_FMGD_DAM/Root/5012_NGS_END/
Tuesday, May 8, 2018
Recoding occupations into social classes
Question
Basic sociology question. I have a student asking me how to recode professions (NOC-S) into "social classes" (upper, middle, working class). He wanted to do it with those 10 categories. I told him there is no way you can do that with such broad domains of activity since the lawyer is in the same category as the legal assistant and an administrator is in the same group as the secretary. So he asked me what about those 30 categories. It still looks problematic to me. You have more distinctions between professional and technical occupations but how do you define what fits into "middle class"? So to anyone who is familiar with this, my question is are there "official norms" to divide the National Occupational Classification into "social classes" and what level of detail is necessary to do so? I found this article of Boyd in the Canadian Review of Sociology (appendix B) that defines the Boyd-NP scores for the 2001 census. Are those « officially » recognized and can they be adapted to the 2011 NHS?
Basic sociology question. I have a student asking me how to recode professions (NOC-S) into "social classes" (upper, middle, working class). He wanted to do it with those 10 categories. I told him there is no way you can do that with such broad domains of activity since the lawyer is in the same category as the legal assistant and an administrator is in the same group as the secretary. So he asked me what about those 30 categories. It still looks problematic to me. You have more distinctions between professional and technical occupations but how do you define what fits into "middle class"? So to anyone who is familiar with this, my question is are there "official norms" to divide the National Occupational Classification into "social classes" and what level of detail is necessary to do so? I found this article of Boyd in the Canadian Review of Sociology (appendix B) that defines the Boyd-NP scores for the 2001 census. Are those « officially » recognized and can they be adapted to the 2011 NHS?
A Socioeconomic Scale for Canada: Measuring Occupational Status from the Census
Monica Boyd, University of Toronto
Canadian Review of Sociology
https://doi.org/10.1111/j.1755-618X.2008.00003.x
Answer 1:
There used to be two scales - Pineo-Porter classifications, and the Blishen scale – each SOC code was assigned a value which mapped to “class”. If there is a crosswalk between NOC and SOC, it might be able to update Pineo-Porter classifications or the Blishen codes to the NOC … or someone might even have already done so!
Take a look at https://www.jstor.org/stable/20460616?seq=1#page_scan_tab_contents –
A Scale of Occupational Prestige in Canada, Based on NOC Major Groups
John Goyder and Kristyn Frank
The Canadian Journal of Sociology / Cahiers canadiens de sociologie
Vol. 32, No. 1 (Winter, 2007), pp. 63-83
Published by: Canadian Journal of Sociology
DOI: 10.2307/20460616
Stable URL: http://www.jstor.org/stable/20460616
Page Count: 21
Answer 2:
Subject Matter does not use the term ‘social classes’ when classifying occupations so there is no ‘official norm’ at Statistics Canada.
For the ‘Canadian Review of Sociology’ article we couldn’t open the full article and not sure what is mentioned in appendix B.
But from the text in the ‘Abstract’ it looks like the article mentioned ‘Nam-powers-Boyd’ method was used for Census of Occupation and not Census of Population.”
Answer 1:
There used to be two scales - Pineo-Porter classifications, and the Blishen scale – each SOC code was assigned a value which mapped to “class”. If there is a crosswalk between NOC and SOC, it might be able to update Pineo-Porter classifications or the Blishen codes to the NOC … or someone might even have already done so!
Take a look at https://www.jstor.org/stable/20460616?seq=1#page_scan_tab_contents –
A Scale of Occupational Prestige in Canada, Based on NOC Major Groups
John Goyder and Kristyn Frank
The Canadian Journal of Sociology / Cahiers canadiens de sociologie
Vol. 32, No. 1 (Winter, 2007), pp. 63-83
Published by: Canadian Journal of Sociology
DOI: 10.2307/20460616
Stable URL: http://www.jstor.org/stable/20460616
Page Count: 21
Answer 2:
Subject Matter does not use the term ‘social classes’ when classifying occupations so there is no ‘official norm’ at Statistics Canada.
For the ‘Canadian Review of Sociology’ article we couldn’t open the full article and not sure what is mentioned in appendix B.
But from the text in the ‘Abstract’ it looks like the article mentioned ‘Nam-powers-Boyd’ method was used for Census of Occupation and not Census of Population.”
Thursday, February 2, 2017
Employment Figures for all Manufacturing Plants Over Time
Question
Does anyone know of a resource that would allow someone to track employment figures for all manufacturing plants over time (including plant opening/closures, etc.)? The student would want to be able to merge these data with data from other sources (particularly Compustat), so would need geographic and SIC characteristics, etc.
I doubt that this would be available through Statistics Canada due to confidentiality restrictions, but would be delighted to hear otherwise!
Would CDER be able to assist with this request?
Answer
I doubt that this would be available through Statistics Canada due to confidentiality restrictions, but would be delighted to hear otherwise!
Would CDER be able to assist with this request?
Answer
I will look into it here to confirm if the data would be available or not. I am not sure CDER would be the best option regardless as access is rather restrictive:
The CDER operates entirely on a cost-recovery basis. Researchers wishing to access data must submit a research proposal and be able to cover all project costs, including a peer review of their project proposal and a review to ensure that the project falls under Statistics Canada's mandate.
All microdata files used for approved projects are only accessible at Statistics Canada's head office, located at Tunney's Pasture in Ottawa, Ontario. Once a project is approved, researchers will have to complete the security screening process and take the Statistics Canada Oath of office in Section 6(1) of the Statistics Act.
From Manufacturing and wholesale trade division:
The ASML principal statistics are available in CANSIM table 301-0008. As for the commodities produced, we have an internal database from which we extract the codes the client needs. We ask that the client sends us the list of codes, geographical areas and reference periods he needs and we can provide him with a cost estimate and a sample of what is available. Therefore, he can see in advance if there will be any confidential cells in the set of data he asked for.
Employment figures are available in CANSIM except for reference years 2013 and 2014 where they were not collected. Please note that there will be breaks in the series throughout those years.
CANSIM tables:
[Geography seems to be at the provincial level only]
301-0008 RY 2012 to 2015
301-0006 RY 2004 to 2012
301-0003 RY 1990 to 2003
301-0001 RY 1981 to 1997
From Labour Statistics Division:
SEPH and LFS does not produce detailed data for manufacturing plants per say and could not provide any information pertaining to ‘’plant opening/closures’’.
We can however provide monthly or annual employment estimates by industry i.e. 31-33 Manufacturing.
Data of employment for all employees is available at a 4 digit level on CANSIM with the Survey of Employment, Payrolls and Hours (SEPH).
For monthly seasonally adjusted data the client can access CANSIM table: 281-0063 from jan. 2001 to nov. 2016
The annual data can be accessed on CANSIM table: 281-0024 from 2001 to 2015; 2016 data will be available March 31st 2017.
For the monthly table he will have to access the ‘’add/remove data’’ feature tab at the top of the page and then select each individual 4 digit North American Industry Classification System (NAICS) variant under manufacturing sector in step 3 starting at Manufacturing code 31-33
As for the LFS data on CANSIM, the North American Industry Classification System (NAICS) for manufacturing is limited to a 2 digit level.
For annual data, the client can consult table 282-0008
For monthly seasonality adjusted data, he can consult table 282-0088
The CDER operates entirely on a cost-recovery basis. Researchers wishing to access data must submit a research proposal and be able to cover all project costs, including a peer review of their project proposal and a review to ensure that the project falls under Statistics Canada's mandate.
All microdata files used for approved projects are only accessible at Statistics Canada's head office, located at Tunney's Pasture in Ottawa, Ontario. Once a project is approved, researchers will have to complete the security screening process and take the Statistics Canada Oath of office in Section 6(1) of the Statistics Act.
From Manufacturing and wholesale trade division:
The ASML principal statistics are available in CANSIM table 301-0008. As for the commodities produced, we have an internal database from which we extract the codes the client needs. We ask that the client sends us the list of codes, geographical areas and reference periods he needs and we can provide him with a cost estimate and a sample of what is available. Therefore, he can see in advance if there will be any confidential cells in the set of data he asked for.
Employment figures are available in CANSIM except for reference years 2013 and 2014 where they were not collected. Please note that there will be breaks in the series throughout those years.
CANSIM tables:
[Geography seems to be at the provincial level only]
301-0008 RY 2012 to 2015
301-0006 RY 2004 to 2012
301-0003 RY 1990 to 2003
301-0001 RY 1981 to 1997
From Labour Statistics Division:
SEPH and LFS does not produce detailed data for manufacturing plants per say and could not provide any information pertaining to ‘’plant opening/closures’’.
We can however provide monthly or annual employment estimates by industry i.e. 31-33 Manufacturing.
Data of employment for all employees is available at a 4 digit level on CANSIM with the Survey of Employment, Payrolls and Hours (SEPH).
For monthly seasonally adjusted data the client can access CANSIM table: 281-0063 from jan. 2001 to nov. 2016
The annual data can be accessed on CANSIM table: 281-0024 from 2001 to 2015; 2016 data will be available March 31st 2017.
For the monthly table he will have to access the ‘’add/remove data’’ feature tab at the top of the page and then select each individual 4 digit North American Industry Classification System (NAICS) variant under manufacturing sector in step 3 starting at Manufacturing code 31-33
As for the LFS data on CANSIM, the North American Industry Classification System (NAICS) for manufacturing is limited to a 2 digit level.
For annual data, the client can consult table 282-0008
For monthly seasonality adjusted data, he can consult table 282-0088
Friday, November 13, 2009
Music Grads and Employment
Question
Can the DLI resources answer the following question: "the number of music majors who get jobs when they graduate?"
Answer
This may be available as a custom extraction (for a fee) from the National graduates Survey (NGS). The variables in the NGS survey PUMFs unfortunately wouldn't allow you to answer the question as the industry and instructional program groupings are too large. Visual and performing arts, and communications technologies instructional programs seem to be grouped together as are Occupations in art, culture, recreation and sport.
The music department at UVic or an industry association may have statistics on this subject. Other DLI Contacts may have some helpful suggestions for your as well.
Can the DLI resources answer the following question: "the number of music majors who get jobs when they graduate?"
Answer
This may be available as a custom extraction (for a fee) from the National graduates Survey (NGS). The variables in the NGS survey PUMFs unfortunately wouldn't allow you to answer the question as the industry and instructional program groupings are too large. Visual and performing arts, and communications technologies instructional programs seem to be grouped together as are Occupations in art, culture, recreation and sport.
The music department at UVic or an industry association may have statistics on this subject. Other DLI Contacts may have some helpful suggestions for your as well.
Subscribe to:
Posts (Atom)