002 -- Palkansaajien kokonaisansiot tunnissa ammattiluokituksen (AML 2010), työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2011

Tables

Dim ammattiluokka, Statfinpas pra pxt 002 201100 fi px, Full historyTSV
Dimension Ammattiluokka (Ammattiluokka)
Dim ammattiluokka, Statfinpas pra pxt 002 201100 fi px, LatestTSV
Dimension Ammattiluokka (Ammattiluokka)
Dim osaaikaisuus, Statfinpas pra pxt 002 201100 fi px, Full historyTSV
Dimension Osaaikaisuus (Osa-aikaisuus)
Dim osaaikaisuus, Statfinpas pra pxt 002 201100 fi px, LatestTSV
Dimension Osaaikaisuus (Osa-aikaisuus)
Dim tiedot, Statfinpas pra pxt 002 201100 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas pra pxt 002 201100 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tyonantajasektori, Statfinpas pra pxt 002 201100 fi px, Full historyTSV
Dimension Tyonantajasektori (Työnantajasektori)
Dim tyonantajasektori, Statfinpas pra pxt 002 201100 fi px, LatestTSV
Dimension Tyonantajasektori (Työnantajasektori)
Fact, Statfinpas pra pxt 002 201100 fi px, Full historyTSV
Palkansaajien kokonaisansiot tunnissa ammattiluokituksen (AML 2010), työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2011 muuttujina Ammattiluokka, Työnantajasektori, Osa-aikaisuus ja Tiedot
Fact, Statfinpas pra pxt 002 201100 fi px, LatestTSV
Palkansaajien kokonaisansiot tunnissa ammattiluokituksen (AML 2010), työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2011 muuttujina Ammattiluokka, Työnantajasektori, Osa-aikaisuus ja Tiedot

Column Descriptions

Dim osaaikaisuus, Statfinpas pra pxt 002 201100 fi px, Full history

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

Dim tiedot, Statfinpas pra pxt 002 201100 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
label	string	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...

Dim ammattiluokka, Statfinpas pra pxt 002 201100 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 179 rows, out of which 2 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 179 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 011 Upseerit and maximum string is X Tuntematon.

Dim ammattiluokka, Statfinpas pra pxt 002 201100 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 179 rows, out of which 2 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 179 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 011 Upseerit and maximum string is X Tuntematon.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas pra pxt 002 201100 fi px, Latest

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 17184 rows, out of which 192 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 17184 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
osaaikaisuus	int	Datasource did not contain a description for Osaaikaisuus. Column osaaikaisuus has 17184 rows, out of which 8592 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 17184 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011	int	Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011 has 17184 rows, out of which 5031 are empty, making the null percent 29.28. Minimum value is 1 and maximum value is 1642724.

Dim tyonantajasektori, Statfinpas pra pxt 002 201100 fi px, Full history

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

Fact, Statfinpas pra pxt 002 201100 fi px, Full history

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 17184 rows, out of which 192 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 17184 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
osaaikaisuus	int	Datasource did not contain a description for Osaaikaisuus. Column osaaikaisuus has 17184 rows, out of which 8592 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 17184 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011	int	Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2011 has 17184 rows, out of which 5031 are empty, making the null percent 29.28. Minimum value is 1 and maximum value is 1642724.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas pra pxt 002 201100 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
label	string	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tyonantajasektori, Statfinpas pra pxt 002 201100 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuntasektori and maximum string is Valtio.

Dim osaaikaisuus, Statfinpas pra pxt 002 201100 fi px, Latest

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

Additional Info

Last Updated	July 20, 2019
Created	June 11, 2019