Data Cart

Your data extract

0 variables
0 samples
View Cart
WRKTENURE
Tenure in current job (months)

WRKTENURE is a 3-digit numeric variable.

Codes

480 = 480+ months
998 = Unknown
999 = NIU (not in universe)

Explore how IPUMS created this variable

Download


      class Wrktenure:public Editor {

public:
    Wrktenure(VarPointer varInfo) : Editor(varInfo) {}
    void edit() {

        long a = getRecoded();
        switch (dataSet) {
        case dataset_id::es2005h:
		case dataset_id::es2005i:
		case dataset_id::es2005j:
		case dataset_id::es2005k:
        case dataset_id::es2006h:
		case dataset_id::es2006i:
		case dataset_id::es2006j:
		case dataset_id::es2006k:
        case dataset_id::es2007h:
		case dataset_id::es2007i:
		case dataset_id::es2007j:
		case dataset_id::es2007k:
        case dataset_id::es2008h:
		case dataset_id::es2008i:
		case dataset_id::es2008j:
		case dataset_id::es2008k:
        case dataset_id::es2009h:
		case dataset_id::es2009i:
		case dataset_id::es2009j:
		case dataset_id::es2009k:
        case dataset_id::es2010h:
		case dataset_id::es2010i:
		case dataset_id::es2010j:
		case dataset_id::es2010k:
        case dataset_id::es2011h:
		case dataset_id::es2011i:
		case dataset_id::es2011j:
		case dataset_id::es2011k:
        case dataset_id::es2012h:
		case dataset_id::es2012i:
		case dataset_id::es2012j:
		case dataset_id::es2012k:
        case dataset_id::es2013h:
		case dataset_id::es2013i:
		case dataset_id::es2013j:
		case dataset_id::es2013k:
        case dataset_id::es2014h:
		case dataset_id::es2014i:
		case dataset_id::es2014j:
		case dataset_id::es2014k:
        case dataset_id::es2015h:
		case dataset_id::es2015i:
		case dataset_id::es2015j:
		case dataset_id::es2015k:
        case dataset_id::es2016h:
		case dataset_id::es2016i:
		case dataset_id::es2016j:
		case dataset_id::es2016k:
        case dataset_id::es2017h:
		case dataset_id::es2017i:
		case dataset_id::es2017j:
		case dataset_id::es2017k:
        case dataset_id::es2018h:
		case dataset_id::es2018i:
		case dataset_id::es2018j:
		case dataset_id::es2018k:
        case dataset_id::es2019h:
		case dataset_id::es2019i:
		case dataset_id::es2019j:
		case dataset_id::es2019k:
		case dataset_id::es2020h:
		case dataset_id::es2020i:
		case dataset_id::es2020j:
		case dataset_id::es2020k: {
			long tenure = valueFromFirstAvailable({
				ES2005H_0440_ref, ES2005I_0440_ref, ES2005J_0440_ref, ES2005K_0440_ref,
				ES2006H_0440_ref, ES2006I_0440_ref, ES2006J_0440_ref, ES2006K_0440_ref,
				ES2007H_0440_ref, ES2007I_0440_ref, ES2007J_0440_ref, ES2007K_0440_ref,
				ES2008H_0440_ref, ES2008I_0440_ref, ES2008J_0440_ref, ES2008K_0440_ref,
				ES2009H_0440_ref, ES2009I_0440_ref, ES2009J_0440_ref, ES2009K_0440_ref,
				ES2010H_0440_ref, ES2010I_0440_ref, ES2010J_0440_ref, ES2010K_0440_ref,
				ES2011H_0440_ref, ES2011I_0440_ref, ES2011J_0440_ref, ES2011K_0440_ref,
				ES2012H_0440_ref, ES2012I_0440_ref, ES2012J_0440_ref, ES2012K_0440_ref,
				ES2013H_0440_ref, ES2013I_0440_ref, ES2013J_0440_ref, ES2013K_0440_ref,
				ES2014H_0440_ref, ES2014I_0440_ref, ES2014J_0440_ref, ES2014K_0440_ref,
				ES2015H_0440_ref, ES2015I_0440_ref, ES2015J_0440_ref, ES2015K_0440_ref,
				ES2016H_0440_ref, ES2016I_0440_ref, ES2016J_0440_ref, ES2016K_0440_ref,
				ES2017H_0440_ref, ES2017I_0440_ref, ES2017J_0440_ref, ES2017K_0440_ref,
				ES2018H_0440_ref, ES2018I_0440_ref, ES2018J_0440_ref, ES2018K_0440_ref,
				ES2019H_0440_ref, ES2019I_0440_ref, ES2019J_0440_ref, ES2019K_0440_ref,
				ES2020H_0440_ref, ES2020I_0440_ref, ES2020J_0440_ref, ES2020K_0440_ref});
			if (tenure > 480 && tenure != 999) {
                a = 480;
			}
        }
		break;     
		case dataset_id::it2011h:
		case dataset_id::it2012h:
		case dataset_id::it2013h:
		case dataset_id::it2014h:
        case dataset_id::it2015h:
		case dataset_id::it2016h:
		case dataset_id::it2017h:
		case dataset_id::it2018h:
		case dataset_id::it2019h:
		case dataset_id::it2020h: {
			long tenure = valueFromFirstAvailable({
				IT2011H_0687_ref, IT2012H_0687_ref, IT2013H_0687_ref, IT2014H_0687_ref,
				IT2015H_0687_ref, IT2016H_0687_ref, IT2017H_0687_ref, IT2018H_0687_ref,
				IT2019H_0687_ref, IT2020H_0687_ref});
			if (tenure > 480 && tenure != 999 && tenure != 998) {
                a = 480;
			}
		}
        break;
		case dataset_id::uy2006a:
        {
            a = UY2006A_0564() + (UY2006A_0565() * 12);
			if (UY2006A_0564() == 99 && UY2006A_0565() == 99) 
				a = 999;
			if (UY2006A_0564() != 99 && UY2006A_0565() == 99)
				a = UY2006A_0564();
			if (UY2006A_0564() == 99 && UY2006A_0565() != 99)
				a = (UY2006A_0565() * 12);
			if (a > 480 && a != 999)
				a = 480;
        }
		break;   
        case dataset_id::mu1990a:
        {
			if (MU1990A_0448() > 480 && MU1990A_0448() < 998)
				a = 480;
        }
		break;  
		case dataset_id::mu2000a:
        {
			if (MU2000A_0458() > 40 && MU2000A_0458() < 98)
				a = 480;
			if (MU2000A_0458() > 0 && MU2000A_0458() <= 40)
				a = (MU2000A_0458() * 12);
        
		}
		break;
		case dataset_id::mu2011a:
        {
			if (MU2011A_0490() > 40 && MU2011A_0490() < 98)
				a = 480;
			if (MU2011A_0490() > 0 && MU2011A_0490() <= 40)
				a = (MU2011A_0490() * 12);
        
		}
		break;

        case dataset_id::mx2005h:
        case dataset_id::mx2005i:
        case dataset_id::mx2005j:
        case dataset_id::mx2005k:
        case dataset_id::mx2006h:
        case dataset_id::mx2006i:
        case dataset_id::mx2007i:
        case dataset_id::mx2008i:
        case dataset_id::mx2009h:
        case dataset_id::mx2010h:
        case dataset_id::mx2011h:
        case dataset_id::mx2012h:
        case dataset_id::mx2013h:
        case dataset_id::mx2014h:
        case dataset_id::mx2015h:
        case dataset_id::mx2016h:
        case dataset_id::mx2017h:
        case dataset_id::mx2018h:
        case dataset_id::mx2019h:
        case dataset_id::mx2020h: {
			long strprd = valueFromFirstAvailable({
				MX2005H_0668_ref, MX2005I_0668_ref, MX2005J_0668_ref, MX2005K_0668_ref,
				MX2006H_0668_ref, MX2006I_0668_ref, MX2007I_0668_ref, MX2008I_0668_ref,
				MX2009H_0668_ref, MX2010H_0668_ref, MX2011H_0668_ref, MX2012H_0668_ref,
				MX2013H_0668_ref, MX2014H_0668_ref, MX2015H_0668_ref, MX2016H_0668_ref,
				MX2017H_0668_ref, MX2018H_0668_ref, MX2019H_0668_ref, MX2020H_0668_ref});
			long stryear = valueFromFirstAvailable({
				MX2005H_0669_ref, MX2005I_0669_ref, MX2005J_0669_ref, MX2005K_0669_ref,
				MX2006H_0669_ref, MX2006I_0669_ref, MX2007I_0669_ref, MX2008I_0669_ref,
				MX2009H_0669_ref, MX2010H_0669_ref, MX2011H_0669_ref, MX2012H_0669_ref,
				MX2013H_0669_ref, MX2014H_0669_ref, MX2015H_0669_ref, MX2016H_0669_ref,
				MX2017H_0669_ref, MX2018H_0669_ref, MX2019H_0669_ref, MX2020H_0669_ref});
			long strmonth = valueFromFirstAvailable({
				MX2005H_0670_ref, MX2005I_0670_ref, MX2005J_0670_ref, MX2005K_0670_ref,
				MX2006H_0670_ref, MX2006I_0670_ref, MX2007I_0670_ref, MX2008I_0670_ref,
				MX2009H_0670_ref, MX2010H_0670_ref, MX2011H_0670_ref, MX2012H_0670_ref,
				MX2013H_0670_ref, MX2014H_0670_ref, MX2015H_0670_ref, MX2016H_0670_ref,
				MX2017H_0670_ref, MX2018H_0670_ref, MX2019H_0670_ref, MX2020H_0670_ref});
			long intyear = valueFromFirstAvailable({
				MX2005H_0027_ref, MX2005I_0027_ref, MX2005J_0027_ref, MX2005K_0027_ref,
				MX2006H_0027_ref, MX2006I_0027_ref, MX2007I_0027_ref, MX2008I_0027_ref,
				MX2009H_0027_ref, MX2010H_0027_ref, MX2011H_0027_ref, MX2012H_0027_ref,
				MX2013H_0027_ref, MX2014H_0027_ref, MX2015H_0027_ref, MX2016H_0027_ref,
				MX2017H_0027_ref, MX2018H_0027_ref, MX2019H_0027_ref, MX2020H_0027_ref});
			long intmonth = valueFromFirstAvailable({
				MX2005H_0029_ref, MX2005I_0029_ref, MX2005J_0029_ref, MX2005K_0029_ref,
				MX2006H_0029_ref, MX2006I_0029_ref, MX2007I_0029_ref, MX2008I_0029_ref,
				MX2009H_0029_ref, MX2010H_0029_ref, MX2011H_0029_ref, MX2012H_0029_ref,
				MX2013H_0029_ref, MX2014H_0029_ref, MX2015H_0029_ref, MX2016H_0029_ref,
				MX2017H_0029_ref, MX2018H_0029_ref, MX2019H_0029_ref, MX2020H_0029_ref});
			//Calculate months for people at current job less than 2 years
			if (strprd >= 1 && strprd <= 2 && strmonth != 99) {
				a = ((intyear - stryear)*12) + (intmonth - strmonth);
			}
			//Unknown months
			if (strprd >= 1 && strprd <= 2 && strmonth == 99) {
				a = 998;
			}
			//Calculate months for people at current job more than 2 years
			if (strprd == 3 && stryear != 99) {
				a = (intyear - stryear)*12;
			}
			//Unknown start period or unknown years
			if (strprd == 9 || stryear == 9999) {
				a = 998;
			}
			//Implausible values
			if (a < 0 || a >= 999) {
				a = 998;
			}
			//Top-code (periods longer than 997 months are sent to unknown not top-coded)
			if (a > 480 && a < 998) {
				a = 480;
			}
			if (strprd == 0) {
				a = 999;
			}
		}
        break;
		}

        setData(a);
    }
};
    

Description

WRKTENURE indicates the length of time (in months) workers have been in their current job or with their current employer.

Comparability — Index

GENERAL
Mauritius
Mexico
Uruguay

Comparability — General

The samples are generally comparable apart from small age differences in universes.

The variable is top-coded at 480 months (i.e. 40 years).

Comparability — Mauritius [top]

The 1990-2011 samples ask persons age 12+ who ever worked about their length of service. The enumeration instructions in 1990-2011 indicate that persons who had no job in the reference week should provide the length of service with their more recent employer.

The 1990 census collected the information in months for persons who worked less than a year and in years otherwise; while the length of service is represented only in years in 2000 and 2011. The data are converted to their equivalent in months in WRKTENURE.

Comparability — Mexico [top]

The Mexico labor force surveys asked about the year the respondents started their current jobs. The month information is only available for persons who started their current jobs in the year of data collection or the previous year. The year and month information is only available for survey quarters when the long form was applied. WRKTENURE uses this information to calculate the tenure duration in months for persons who worked up to one year and calculates months for persons who worked for more than one year.

Respondents significantly over-report beginning their jobs in the month of January.

The questionnaire also asked about the year and month of returning to work for persons who did not work continuously at their current jobs but started working again. This information is not taken into account in WRKTENURE, but this information is available in the unharmonized source variables for the Mexico labor force surveys.

Comparability — Uruguay [top]

The question in 2006 asked about the duration of employment in months or years of employment, which are all converted to their month equivalent in WRKTENURE.

Universe

  • Italy 2011Q1: Persons age 15+ who were employed
  • Italy 2012Q1: Persons age 15+ who were employed
  • Italy 2013Q1: Persons age 15+ who were employed
  • Italy 2014Q1: Persons age 15+ who were employed
  • Italy 2015Q1: Persons age 15+ who were employed
  • Italy 2016Q1: Persons age 15+ who were employed
  • Italy 2017Q1: Persons age 15+ who were employed
  • Italy 2018Q1: Persons age 15+ who were employed
  • Italy 2019Q1: Persons age 15+ who were employed
  • Italy 2020Q1: Persons age 15+ who were employed
  • Mauritius 1990: Persons age 12+ who ever worked
  • Mauritius 2000: Persons age 12+ who ever worked
  • Mauritius 2011: Persons age 12+ who ever worked
  • Mexico 2005Q1: Present persons age 12+ who were employed
  • Mexico 2005Q2: Present persons age 12+ who were employed
  • Mexico 2005Q3: Present persons age 12+ who were employed
  • Mexico 2005Q4: Present persons age 12+ who were employed
  • Mexico 2006Q1: Present persons age 12+ who were employed
  • Mexico 2006Q2: Present persons age 12+ who were employed
  • Mexico 2007Q2: Present persons age 12+ who were employed
  • Mexico 2008Q2: Present persons age 12+ who were employed
  • Mexico 2009Q1: Present persons age 12+ who were employed
  • Mexico 2010Q1: Present persons age 12+ who were employed
  • Mexico 2011Q1: Present persons age 12+ who were employed
  • Mexico 2012Q1: Present persons age 12+ who were employed
  • Mexico 2013Q1: Present persons age 12+ who were employed
  • Mexico 2014Q1: Present persons age 12+ who were employed
  • Mexico 2015Q1: Present persons age 12+ who were employed
  • Mexico 2016Q1: Present persons age 12+ who were employed
  • Mexico 2017Q1: Present persons age 12+ who were employed
  • Mexico 2018Q1: Present persons age 12+ who were employed
  • Mexico 2019Q1: Present persons age 12+ who were employed
  • Mexico 2020Q1: Present persons age 12+ who were employed
  • Spain 2005Q1: Persons age 16+ who were employed
  • Spain 2005Q2: Persons age 16+ who were employed
  • Spain 2005Q3: Persons age 16+ who were employed
  • Spain 2005Q4: Persons age 16+ who were employed
  • Spain 2006Q1: Persons age 16+ who were employed
  • Spain 2006Q2: Persons age 16+ who were employed
  • Spain 2006Q3: Persons age 16+ who were employed
  • Spain 2006Q4: Persons age 16+ who were employed
  • Spain 2007Q1: Persons age 16+ who were employed
  • Spain 2007Q2: Persons age 16+ who were employed
  • Spain 2007Q3: Persons age 16+ who were employed
  • Spain 2007Q4: Persons age 16+ who were employed
  • Spain 2008Q1: Persons age 16+ who were employed
  • Spain 2008Q2: Persons age 16+ who were employed
  • Spain 2008Q3: Persons age 16+ who were employed
  • Spain 2008Q4: Persons age 16+ who were employed
  • Spain 2009Q1: Persons age 16+ who were employed
  • Spain 2009Q2: Persons age 16+ who were employed
  • Spain 2009Q3: Persons age 16+ who were employed
  • Spain 2009Q4: Persons age 16+ who were employed
  • Spain 2010Q1: Persons age 16+ who were employed
  • Spain 2010Q2: Persons age 16+ who were employed
  • Spain 2010Q3: Persons age 16+ who were employed
  • Spain 2010Q4: Persons age 16+ who were employed
  • Spain 2011Q1: Persons age 16+ who were employed
  • Spain 2011Q2: Persons age 16+ who were employed
  • Spain 2011Q3: Persons age 16+ who were employed
  • Spain 2011Q4: Persons age 16+ who were employed
  • Spain 2012Q1: Persons age 16+ who were employed
  • Spain 2012Q2: Persons age 16+ who were employed
  • Spain 2012Q3: Persons age 16+ who were employed
  • Spain 2012Q4: Persons age 16+ who were employed
  • Spain 2013Q1: Persons age 16+ who were employed
  • Spain 2013Q2: Persons age 16+ who were employed
  • Spain 2013Q3: Persons age 16+ who were employed
  • Spain 2013Q4: Persons age 16+ who were employed
  • Spain 2014Q1: Persons age 16+ who were employed
  • Spain 2014Q2: Persons age 16+ who were employed
  • Spain 2014Q3: Persons age 16+ who were employed
  • Spain 2014Q4: Persons age 16+ who were employed
  • Spain 2015Q1: Persons age 16+ who were employed
  • Spain 2015Q2: Persons age 16+ who were employed
  • Spain 2015Q3: Persons age 16+ who were employed
  • Spain 2015Q4: Persons age 16+ who were employed
  • Spain 2016Q1: Persons age 16+ who were employed
  • Spain 2016Q2: Persons age 16+ who were employed
  • Spain 2016Q3: Persons age 16+ who were employed
  • Spain 2016Q4: Persons age 16+ who were employed
  • Spain 2017Q1: Persons age 16+ who were employed
  • Spain 2017Q2: Persons age 16+ who were employed
  • Spain 2017Q3: Persons age 16+ who were employed
  • Spain 2017Q4: Persons age 16+ who were employed
  • Spain 2018Q1: Persons age 16+ who were employed
  • Spain 2018Q2: Persons age 16+ who were employed
  • Spain 2018Q3: Persons age 16+ who were employed
  • Spain 2018Q4: Persons age 16+ who were employed
  • Spain 2019Q1: Persons age 16+ who were employed
  • Spain 2019Q2: Persons age 16+ who were employed
  • Spain 2019Q3: Persons age 16+ who were employed
  • Spain 2019Q4: Persons age 16+ who were employed
  • Spain 2020Q1: Persons age 16+ who were employed
  • Spain 2020Q2: Persons age 16+ who were employed
  • Spain 2020Q3: Persons age 16+ who were employed
  • Spain 2020Q4: Persons age 16+ who were employed
  • Uruguay 2006: Persons age 14+ who were employed

Availability

  • Italy: 2011Q1, 2012Q1, 2013Q1, 2014Q1, 2015Q1, 2016Q1, 2017Q1, 2018Q1, 2019Q1, 2020Q1
  • Mauritius: 1990, 2000, 2011
  • Mexico: 2005Q1, 2005Q2, 2005Q3, 2005Q4, 2006Q1, 2006Q2, 2007Q2, 2008Q2, 2009Q1, 2010Q1, 2011Q1, 2012Q1, 2013Q1, 2014Q1, 2015Q1, 2016Q1, 2017Q1, 2018Q1, 2019Q1, 2020Q1
  • Spain: 2005Q1, 2005Q2, 2005Q3, 2005Q4, 2006Q1, 2006Q2, 2006Q3, 2006Q4, 2007Q1, 2007Q2, 2007Q3, 2007Q4, 2008Q1, 2008Q2, 2008Q3, 2008Q4, 2009Q1, 2009Q2, 2009Q3, 2009Q4, 2010Q1, 2010Q2, 2010Q3, 2010Q4, 2011Q1, 2011Q2, 2011Q3, 2011Q4, 2012Q1, 2012Q2, 2012Q3, 2012Q4, 2013Q1, 2013Q2, 2013Q3, 2013Q4, 2014Q1, 2014Q2, 2014Q3, 2014Q4, 2015Q1, 2015Q2, 2015Q3, 2015Q4, 2016Q1, 2016Q2, 2016Q3, 2016Q4, 2017Q1, 2017Q2, 2017Q3, 2017Q4, 2018Q1, 2018Q2, 2018Q3, 2018Q4, 2019Q1, 2019Q2, 2019Q3, 2019Q4, 2020Q1, 2020Q2, 2020Q3, 2020Q4
  • Uruguay: 2006