11 qn -- Employees aged 15 to 74 in permanent and temporary (fixed-term) work by employer sector and sex, 2005-2018

Tables

Dim employer sector, Statfin tyti pxt 11qn px, Full historyTSV
Dimension Employer_sector (Työnantajasektori)
Dim employer sector, Statfin tyti pxt 11qn px, LatestTSV
Dimension Employer_sector (Työnantajasektori)
Dim sex, Statfin tyti pxt 11qn px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfin tyti pxt 11qn px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin tyti pxt 11qn px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin tyti pxt 11qn px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin tyti pxt 11qn px, Full historyTSV
Employees aged 15 to 74 in permanent and temporary (fixed-term) work by Year, Sex, Employer sector and Information
Fact, Statfin tyti pxt 11qn px, LatestTSV
Employees aged 15 to 74 in permanent and temporary (fixed-term) work by Year, Sex, Employer sector and Information

Column Descriptions

Dim year, Statfin tyti pxt 11qn px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim employer sector, Statfin tyti pxt 11qn px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 2 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central government and maximum string is Public sector.

Fact, Statfin tyti pxt 11qn px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
sex	int	Datasource did not contain a description for Sex. Column sex has 210 rows, out of which 70 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
employer_sector	int	Datasource did not contain a description for Employer_sector. Column employer_sector has 210 rows, out of which 84 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
employees_total_1000_persons	int	Datasource did not contain a description for Employees_total_1000_persons. Column employees_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 64 and maximum value is 2207.
employees_permanent_work_total_1000_persons	int	Datasource did not contain a description for Employees_permanent_work_total_1000_persons. Column employees_permanent_work_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 48 and maximum value is 1874.
employees_temporary_fixedterm_work_total_1000_persons	int	Datasource did not contain a description for Employees_temporary_fixedterm_work_total_1000_persons. Column employees_temporary_fixedterm_work_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 15 and maximum value is 363.
permanent_work_total_proportion_of_employees	int	Datasource did not contain a description for Permanent_work_total_proportion_of_employees. Column permanent_work_total_proportion_of_employees has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72 and maximum value is 91.
temporary_fixedterm_work_total_proportion_of_employees	int	Datasource did not contain a description for Temporary_fixedterm_work_total_proportion_of_employees. Column temporary_fixedterm_work_total_proportion_of_employees has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8 and maximum value is 27.

Dim sex, Statfin tyti pxt 11qn px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.

Fact, Statfin tyti pxt 11qn px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
sex	int	Datasource did not contain a description for Sex. Column sex has 210 rows, out of which 70 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
employer_sector	int	Datasource did not contain a description for Employer_sector. Column employer_sector has 210 rows, out of which 84 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
employees_total_1000_persons	int	Datasource did not contain a description for Employees_total_1000_persons. Column employees_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 64 and maximum value is 2207.
employees_permanent_work_total_1000_persons	int	Datasource did not contain a description for Employees_permanent_work_total_1000_persons. Column employees_permanent_work_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 48 and maximum value is 1874.
employees_temporary_fixedterm_work_total_1000_persons	int	Datasource did not contain a description for Employees_temporary_fixedterm_work_total_1000_persons. Column employees_temporary_fixedterm_work_total_1000_persons has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 15 and maximum value is 363.
permanent_work_total_proportion_of_employees	int	Datasource did not contain a description for Permanent_work_total_proportion_of_employees. Column permanent_work_total_proportion_of_employees has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72 and maximum value is 91.
temporary_fixedterm_work_total_proportion_of_employees	int	Datasource did not contain a description for Temporary_fixedterm_work_total_proportion_of_employees. Column temporary_fixedterm_work_total_proportion_of_employees has 210 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8 and maximum value is 27.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin tyti pxt 11qn px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.

Dim sex, Statfin tyti pxt 11qn px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim employer sector, Statfin tyti pxt 11qn px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 2 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central government and maximum string is Public sector.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 20, 2019
Created	July 19, 2019