VSECAT Structure and Keys
This section presents the structure and keys of the VSECAT database. It contains 592,802 rows and 39 variables. There are no missing values in any variable; therefore, value tables below do not include any Not available nor NA row. All earnings are expressed in EUR (using 2018 exchange rates applied during preprocessing).
Overview
- Rows: 592,802
- Columns: 39
- Countries present (24): IT, DE, AT, PL, HU, CH, SE, RO, ES, DK, FR, SI, PT, LT, BE, HR, CY, FI, BG, EL, EE, LU, NO, LV
Keys
| Variable Name | Proposed Description |
|---|---|
| ISCO-08 | ISCO-08 2-digit occupational code (sub-major group). |
| ISCO-08_Title | ISCO-08 sub-major group title corresponding to ISCO-08 code. |
| COUNTRY | Country of survey (ISO-like 2-letter code). |
| SEX | Sex of the respondent (Male/Female). |
| AGE | Age in completed years at reference time. |
| AGE_GROUPS | Age bands (14–19, 20–29, 30–39, 40–49, 50–59, 60+). |
| ORIGIN | National or Foreigner, derived from parents’ countries. |
| COUNTRY_BIRTH | Country of birth (SCL GEO apha-2 code). |
| COUNTRY_MOTHER | Mother’s country (SCL GEO apha-2 code). |
| COUNTRY_FATHER | Father’s country (SCL GEO apha-2 code). |
| CITIZENSHIP | Citizenship code — country codes and supra-national groupings. |
| HATLEVEL | Highest level of education grouped by ISCED-11 (see #Annex A). |
| HATFIELD | Highest attained education. |
| EMPSTAT | Employment status. |
| ILOSTAT | ILO employment status. |
| MAINSTAT | Self-declared main status at reference time. |
| JOBSTAT | Status in employment — Employee, Self-employed, Family worker. |
| TEMP | Contract type — Permanent, Fixed-term, or Not applicable. |
| TEMPDUR | Duration band for fixed-term contracts. |
| NUMJOB | Number of simultaneous jobs held. |
| HOMEWORK | Frequency of working from home. |
| FTPT | Working time — Full-time or Part-time. |
| LOCSIZEFIRM | Size of the employing local unit by number of employees. |
| N_instances | Number of source-identical rows collapsed into this record. |
| ANNUAL_EARNINGS_mean | Mean annual earnings (EUR). |
| ANNUAL_EARNINGS_median | Median annual earnings (EUR). |
| ANNUAL_EARNINGS_std | Standard deviation of annual earnings (EUR). |
| ANNUAL_EARNINGS_min | Minimum observed annual earnings (EUR). |
| ANNUAL_EARNINGS_max | Maximum observed annual earnings (EUR). |
| MONTHLY_EARNINGS_mean | Mean monthly earnings (EUR). |
| MONTHLY_EARNINGS_median | Median monthly earnings (EUR). |
| MONTHLY_EARNINGS_std | Standard deviation of monthly earnings (EUR). |
| MONTHLY_EARNINGS_min | Minimum observed monthly earnings (EUR). |
| MONTHLY_EARNINGS_max | Maximum observed monthly earnings (EUR). |
| HOURLY_EARNINGS_mean | Mean hourly earnings (EUR). |
| HOURLY_EARNINGS_median | Median hourly earnings (EUR). |
| HOURLY_EARNINGS_std | Standard deviation of hourly earnings (EUR). |
| HOURLY_EARNINGS_min | Minimum observed hourly earnings (EUR). |
| HOURLY_EARNINGS_max | Maximum observed hourly earnings (EUR). |