To download the data set, please sign up or log in

002 -- Profit and loss accounts of employment pension companies

002 -- Profit and loss accounts of employment pension companies

Tables

Column Descriptions

Dim year, Statfinpas vato pxt 002 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2016.
label int 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 value is 2012 and maximum value is 2016.

Dim arvo, Statfinpas vato pxt 002 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvonkor and maximum string is Voitto_tilik_401.
label string The label for the dimension value. Column label has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustment for revaluatio... and first 25 characters of maximum string: Profit/loss for the accou...
orig_extractdate string The date when the data was originally fetched from the source.

Dim arvo, Statfinpas vato pxt 002 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvonkor and maximum string is Voitto_tilik_401.
label string The label for the dimension value. Column label has 32 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustment for revaluatio... and first 25 characters of maximum string: Profit/loss for the accou...

Dim year, Statfinpas vato pxt 002 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2016.
label int 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 value is 2012 and maximum value is 2016.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vato pxt 002 201600 px, Full history

Column Type Comment
arvo string Datasource did not contain a description for Arvo. Column arvo has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvonkor and maximum string is Voitto_tilik_401.
year int Datasource did not contain a description for Year. Column year has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2016.
profit_and_loss_accounts_of_employment_pension_companies int Datasource did not contain a description for Profit_and_loss_accounts_of_employment_pension_companies. Column profit_and_loss_accounts_of_employment_pension_companies has 160 rows, out of which 43 are empty, making the null percent 26.88. Minimum value is -26752356 and maximum value is 31271918.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vato pxt 002 201600 px, Latest

Column Type Comment
arvo string Datasource did not contain a description for Arvo. Column arvo has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvonkor and maximum string is Voitto_tilik_401.
year int Datasource did not contain a description for Year. Column year has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2016.
profit_and_loss_accounts_of_employment_pension_companies int Datasource did not contain a description for Profit_and_loss_accounts_of_employment_pension_companies. Column profit_and_loss_accounts_of_employment_pension_companies has 160 rows, out of which 43 are empty, making the null percent 26.88. Minimum value is -26752356 and maximum value is 31271918.

Additional Info

Last Updated July 21, 2019
Created July 13, 2019