Release Notes
August 2024
Effective August 12, 2024 we use a new August 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We are making these schema changes to improve schema usability.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.155 total changes • 149 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CASH_TRANSACTION | |||||
column | Rename Column | attributes_as_of_date | as_of_date | ||
column | Rename Column | attributes_base_amount | base_amount | ||
column | Rename Column | attributes_base_currency | base_currency | ||
column | Rename Column | attributes_client | client | ||
column | Rename Column | attributes_cost_per_share | cost_per_share | ||
column | Rename Column | attributes_custom_1 | custom_1 | ||
column | Rename Column | attributes_custom_2 | custom_2 | ||
column | Rename Column | attributes_custom_3 | custom_3 | ||
column | Rename Column | attributes_custom_4 | custom_4 | ||
column | Rename Column | attributes_custom_5 | custom_5 | ||
column | Rename Column | attributes_custom_6 | custom_6 | ||
column | Rename Column | attributes_description | description | ||
column | Rename Column | attributes_group_id | group_id | ||
column | Rename Column | attributes_investment | investment | ||
column | Rename Column | attributes_last_modified_by | last_modified_by | ||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_local_amount | local_amount | ||
column | Rename Column | attributes_local_currency | local_currency | ||
column | Rename Column | attributes_original_id | original_id | ||
column | Rename Column | attributes_owner | owner | ||
column | Rename Column | attributes_scenario | scenario | ||
column | Rename Column | attributes_security | security | ||
column | Rename Column | attributes_share | share | ||
column | Rename Column | attributes_transaction_category | transaction_category | ||
column | Rename Column | attributes_transaction_date | transaction_date | ||
column | Rename Column | attributes_transaction_type | transaction_type | ||
column | Rename Column | attributes_value_per_share | value_per_share | ||
CURRENCY | |||||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_symbol | symbol | ||
DATA_ITEM | |||||
column | Rename Column | attributes_aggregation_null_replacement | aggregation_null_replacement | ||
column | Rename Column | attributes_aggregation_type | aggregation_type | ||
column | Rename Column | attributes_applied_to_all_asset | applied_to_all_asset | ||
column | Rename Column | attributes_calculation_type | calculation_type | ||
column | Rename Column | attributes_category | category | ||
column | Rename Column | attributes_description | description | ||
column | Rename Column | attributes_excel_ticker | excel_ticker | ||
column | Rename Column | attributes_exchange_rate | exchange_rate | ||
column | Rename Column | attributes_format_type | format_type | ||
column | Rename Column | attributes_is_carrybackward | is_carrybackward | ||
column | Rename Column | attributes_is_carryover | is_carryover | ||
column | Rename Column | attributes_is_monetary | is_monetary | ||
column | Rename Column | attributes_is_number_comma_separated | is_number_comma_separated | ||
column | Rename Column | attributes_is_putable | is_putable | ||
column | Rename Column | attributes_is_scalable | is_scalable | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_number_of_decimal_place | number_of_decimal_place | ||
column | Rename Column | attributes_option | option | ||
column | Rename Column | attributes_rc_resolves_to | rc_resolves_to | ||
column | Rename Column | attributes_value_type | value_type | ||
DATA_ITEM_CATEGORY | |||||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_sequence_number | sequence_number | ||
DATA_ITEM_CATEGORY_RELATIONSHIP | |||||
table | New Table | DATA_ITEM_CATEGORY_RELATIONSHIP | |||
DATA_ITEM_RELATIONSHIP | |||||
table | New Table | DATA_ITEM_RELATIONSHIP | |||
DEAL | |||||
column | Rename Column | attributes_acquisition_date | acquisition_date | ||
column | Rename Column | attributes_currency | currency | ||
column | Rename Column | attributes_deal_type | deal_type | ||
column | Rename Column | attributes_exit_date | exit_date | ||
column | Rename Column | attributes_investment_amount | investment_amount | ||
column | Rename Column | attributes_investment_name | investment_name | ||
column | Rename Column | attributes_owner_name | owner_name | ||
column | Rename Column | attributes_ownership | ownership | ||
column | Rename Column | attributes_security_name | security_name | ||
column | Rename Column | attributes_status | status | ||
DOCUMENT_FOLDER | |||||
column | Rename Column | attributes_created_date | created_date | ||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | parent_folderid | parent_folder_id | ||
column | Rename Column | parent_foldertype | parent_folder_type | ||
DOCUMENT_RELATIONSHIP | |||||
table | New Table | DOCUMENT_RELATIONSHIP | |||
ENTITY_ASSET | |||||
column | Rename Column | attributes_acquisition_as_of | acquisition_as_of | ||
column | Rename Column | attributes_acquisition_date | acquisition_date | ||
column | Rename Column | attributes_asset_type | asset_type | ||
column | Rename Column | attributes_calendar_type | calendar_type | ||
column | Rename Column | attributes_excel_ticker | excel_ticker | ||
column | Rename Column | attributes_exit_as_of | exit_as_of | ||
column | Rename Column | attributes_exit_date | exit_date | ||
column | Rename Column | attributes_geography | geography | ||
column | Rename Column | attributes_industry | industry | ||
column | Rename Column | attributes_initial_period | initial_period | ||
column | Rename Column | attributes_is_public | is_public | ||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_lead_investment_professional | lead_investment_professional | ||
column | Rename Column | attributes_long_description | long_description | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_reporting_currency | reporting_currency | ||
column | Rename Column | attributes_short_description | short_description | ||
column | Rename Column | attributes_status | status | ||
column | Rename Column | attributes_website | website | ||
ENTITY_FUND | |||||
column | Rename Column | attributes_benchmark_vintage | benchmark_vintage | ||
column | Rename Column | attributes_calendar_type | calendar_type | ||
column | Rename Column | attributes_commitment | commitment | ||
column | Rename Column | attributes_default_pme_index | default_pme_index | ||
column | Rename Column | attributes_default_pme_liquidity_premium | default_pme_liquidity_premium | ||
column | Rename Column | attributes_description | description | ||
column | Rename Column | attributes_final_close_date | final_close_date | ||
column | Rename Column | attributes_fund_size | fund_size | ||
column | Rename Column | attributes_general_partner | general_partner | ||
column | Rename Column | attributes_include_in_workflow | include_in_workflow | ||
column | Rename Column | attributes_initial_close_date | initial_close_date | ||
column | Rename Column | attributes_initial_poeriod | initial_poeriod | ||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_long_name | long_name | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_owner_type | owner_type | ||
column | Rename Column | attributes_reporting_currency | reporting_currency | ||
column | Rename Column | attributes_status | status | ||
column | Rename Column | attributes_strategy | strategy | ||
column | Rename Column | attributes_sub_strategy | sub_strategy | ||
column | Rename Column | attributes_total_committed_capital | total_committed_capital | ||
column | Rename Column | attributes_vintage | vintage | ||
ENTITY_GROUP | |||||
column | Rename Column | attributes_applicable_to | applicable_to | ||
column | Rename Column | attributes_entities_count | entities_count | ||
column | Rename Column | attributes_entity_category_type | entity_category_type | ||
column | Rename Column | attributes_entity_ids | entity_ids | ||
column | Rename Column | attributes_name | name | ||
column | Primary Key Change | relationships_entity_group_category_data_id 🔑 | entity_group_category_data_id | No longer primary key. | |
column | Rename Column | relationships_entity_group_category_data_id 🔑 | entity_group_category_data_id | ||
column | Rename Column | relationships_entity_group_category_data_type | entity_group_category_data_type | ||
OVERALL_RELATIONSHIP | |||||
table | Deprecated Table | OVERALL_RELATIONSHIP | Data now available in the SEGMENT_RELATIONSHIP , PERIODIC_DATA_RELATIONSHIP , TRANSACTION_TYPE_RELATIONSHIP , DOCUMENT_RELATIONSHIP , DATA_ITEM_RELATIONSHIP , and DATA_ITEM_CATEGORY_RELATIONSHIP tables. | ||
PERIODIC_DATA_RELATIONSHIP | |||||
table | New Table | PERIODIC_DATA_RELATIONSHIP | |||
SCENARIO | |||||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_short_name | short_name | ||
SECURITY | |||||
column | Rename Column | authorized_option | fundamental_authorized_option | ||
column | Rename Column | closed_date | fundamental_closed_date | ||
column | Rename Column | commencement_date | fundamental_commencement_date | ||
column | Rename Column | conversion_ratio_denominator | fundamental_conversion_ratio_denominator | ||
column | Rename Column | conversion_ratio_numerator | fundamental_conversion_ratio_numerator | ||
column | Rename Column | converts_to | fundamental_converts_to | ||
column | Rename Column | currency | fundamental_currency | ||
column | Rename Column | exercise_price | fundamental_exercise_price | ||
column | Rename Column | maturity_date | fundamental_maturity_date | ||
column | Rename Column | options_available_for_grant | fundamental_options_available_for_grant | ||
column | Rename Column | options_issued | fundamental_options_issued | ||
column | Rename Column | outstanding_principal | fundamental_outstanding_principal | ||
column | Rename Column | outstanding_share | fundamental_outstanding_share | ||
column | Rename Column | outstanding_unit | fundamental_outstanding_unit | ||
column | Rename Column | outstanding_warrant | fundamental_outstanding_warrant | ||
column | Rename Column | price_per_share | fundamental_price_per_share | ||
SEGMENT | |||||
column | Rename Column | attributes_is_active | is_active | ||
column | Rename Column | attributes_is_allow_rollup | is_allow_rollup | ||
column | Rename Column | attributes_is_global | is_global | ||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_null_replacement | null_replacement | ||
SEGMENT_RELATIONSHIP | |||||
table | New Table | SEGMENT_RELATIONSHIP | |||
TRANSACTION_TYPE_RELATIONSHIP | |||||
table | New Table | TRANSACTION_TYPE_RELATIONSHIP | |||
VALUATION_DATAITEM | |||||
column | Rename Column | attributes_category | category | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_value_type | value_type | ||
VALUATION_ITERATION | |||||
column | Rename Column | attributes_last_modified_date | last_modified_date | ||
column | Rename Column | attributes_name | name | ||
column | Rename Column | attributes_status | status | ||
column | Rename Column | attributes_valuation_period | valuation_period | ||
VALUATION_STATIC_DETAL | |||||
column | Rename Column | attributes_name | name |
April 2024
Effective April 16, 2024 we use a new April 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
These schema changes are necessary because certain columns have been deprecated from the source. We have also added a new column.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.4 total changes • 3 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CASH_TRANSACTION | |||||
column | Deprecated Column | from_entity_dataid | We have removed the column from the schema as iLevel no longer supports it. | ||
column | Deprecated Column | security_data_id | We have removed the column from the schema as iLevel no longer supports it. | ||
column | Deprecated Column | to_entity_data_id | We have removed the column from the schema as iLevel no longer supports it. | ||
column | New Column | type | We have added a new column that indicates the type of transaction. |
December 2023
Lite connectors are now available for the following sources: