# iLevel schema ERD

Table and field reference for the Fivetran iLevel connector.

## Table & Field Reference

### transaction_type_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cash_transaction_type_id | Unknown | PK, FK |
| type | Unknown |  |

### cash_transaction_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calculation_type | Unknown |  |
| can_be_deleted | Unknown |  |
| can_be_renamed | Unknown |  |
| category | Unknown |  |
| data_item_name | Unknown |  |
| is_exposed | Unknown |  |
| is_positive_operator | Unknown |  |
| name | Unknown |  |
| preferred_currency | Unknown |  |
| require_alignment | Unknown |  |
| require_rmv | Unknown |  |

### valuation_iteration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| valuation_period | Unknown |  |

### periodic_data_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| periodic_data_id | Unknown | PK, FK |
| type | Unknown |  |

### periodic_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| as_of_date | Unknown |  |
| comment | Unknown |  |
| currency | Unknown |  |
| data_item | Unknown |  |
| data_source | Unknown |  |
| data_value_type | Unknown |  |
| investment | Unknown |  |
| is_relationship_deleted | Unknown |  |
| last_modified_date | Unknown |  |
| owner | Unknown |  |
| period_end | Unknown |  |
| period_length | Unknown |  |
| period_length_code | Unknown |  |
| relationship_path | Unknown |  |
| scenario | Unknown |  |
| security | Unknown |  |
| segment | Unknown |  |
| submitted_by | Unknown |  |
| submitted_date | Unknown |  |
| value | Unknown |  |

### entity_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| acquisition_as_of | Unknown |  |
| acquisition_date | Unknown |  |
| asset_type | Unknown |  |
| calendar_type | Unknown |  |
| excel_ticker | Unknown |  |
| exit_as_of | Unknown |  |
| exit_date | Unknown |  |
| geography | Unknown |  |
| industry | Unknown |  |
| initial_period | Unknown |  |
| is_public | Unknown |  |
| last_modified_date | Unknown |  |
| lead_investment_professional | Unknown |  |
| long_description | Unknown |  |
| name | Unknown |  |
| reporting_currency | Unknown |  |
| short_description | Unknown |  |
| status | Unknown |  |
| website | Unknown |  |

### entity_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicable_to | Unknown |  |
| entities_count | Unknown |  |
| entity_category_type | Unknown |  |
| entity_group_category_data_id | Unknown |  |
| entity_group_category_data_type | Unknown |  |
| entity_ids | Unknown |  |
| name | Unknown |  |

### entity_fund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| benchmark_vintage | Unknown |  |
| calendar_type | Unknown |  |
| commitment | Unknown |  |
| default_pme_index | Unknown |  |
| default_pme_liquidity_premium | Unknown |  |
| description | Unknown |  |
| final_close_date | Unknown |  |
| fund_size | Unknown |  |
| general_partner | Unknown |  |
| include_in_workflow | Unknown |  |
| initial_close_date | Unknown |  |
| initial_poeriod | Unknown |  |
| last_modified_date | Unknown |  |
| long_name | Unknown |  |
| name | Unknown |  |
| owner_type | Unknown |  |
| reporting_currency | Unknown |  |
| status | Unknown |  |
| strategy | Unknown |  |
| sub_strategy | Unknown |  |
| total_committed_capital | Unknown |  |
| vintage | Unknown |  |

### document_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| document_id | Unknown | PK, FK |
| type | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| available_for_publishing | Unknown |  |
| event_date | Unknown |  |
| is_available_to_all_users | Unknown |  |
| last_modified_by | Unknown |  |
| location | Unknown |  |
| period_end | Unknown |  |
| period_length | Unknown |  |
| size | Unknown |  |
| tags | Unknown |  |
| upload_date | Unknown |  |
| uploaded_by | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| symbol | Unknown |  |

### document_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_date | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| parent_folder_id | Unknown |  |
| parent_folder_type | Unknown |  |

### segment_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| segment_id | Unknown | PK, FK |
| type | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_active | Unknown |  |
| is_allow_rollup | Unknown |  |
| is_global | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| null_replacement | Unknown |  |

### data_item_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_item_id | Unknown | PK, FK |
| type | Unknown |  |

### data_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| aggregation_null_replacement | Unknown |  |
| aggregation_type | Unknown |  |
| applied_to_all_asset | Unknown |  |
| calculation_type | Json |  |
| category | Unknown |  |
| description | Unknown |  |
| excel_ticker | Unknown |  |
| exchange_rate | Unknown |  |
| format_type | Unknown |  |
| is_carrybackward | Unknown |  |
| is_carryover | Unknown |  |
| is_monetary | Unknown |  |
| is_number_comma_separated | Unknown |  |
| is_putable | Unknown |  |
| is_scalable | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| number_of_decimal_place | Unknown |  |
| option | Json |  |
| rc_resolves_to | Unknown |  |
| value_type | Unknown |  |

### data_item_category_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_item_category_id | Unknown | PK, FK |
| type | Unknown |  |

### data_item_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| sequence_number | Unknown |  |

### valuation_static_detal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_entity_data_id | Unknown | FK |
| security_data_id | Unknown | FK |
| to_entity_data_id | Unknown | FK |
| acquisition_date | Unknown |  |
| currency | Unknown |  |
| deal_type | Unknown |  |
| exit_date | Unknown |  |
| from_entity_data_type | Unknown |  |
| investment_amount | Unknown |  |
| investment_name | Unknown |  |
| last_modified_date | Unknown |  |
| object_relationship_data_id | Unknown |  |
| object_relationship_data_type | Unknown |  |
| owner_name | Unknown |  |
| ownership | Unknown |  |
| security_data_type | Unknown |  |
| security_name | Unknown |  |
| status | Unknown |  |
| to_entity_data_type | Unknown |  |

### cash_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| investment_object_data_id | Unknown | FK |
| owner_object_data_id | Unknown | FK |
| scenario_object_data_id | Unknown | FK |
| security_object_data_id | Unknown | FK |
| transaction_type_object_data_id | Unknown | FK |
| as_of_date | Unknown |  |
| base_amount | Unknown |  |
| base_currency | Unknown |  |
| client | Unknown |  |
| client_object_data_id | Unknown |  |
| client_object_data_type | Unknown |  |
| cost_per_share | Unknown |  |
| custom_1 | Unknown |  |
| custom_2 | Unknown |  |
| custom_3 | Unknown |  |
| custom_4 | Unknown |  |
| custom_5 | Unknown |  |
| custom_6 | Unknown |  |
| description | Unknown |  |
| group_id | Unknown |  |
| investment | Unknown |  |
| investment_object_data_type | Unknown |  |
| last_modified_by | Unknown |  |
| last_modified_date | Unknown |  |
| local_amount | Unknown |  |
| local_currency | Unknown |  |
| original_id | Unknown |  |
| owner | Unknown |  |
| owner_object_data_type | Unknown |  |
| scenario | Unknown |  |
| scenario_object_data_type | Unknown |  |
| security | Unknown |  |
| security_object_data_type | Unknown |  |
| share | Unknown |  |
| transaction_category | Unknown |  |
| transaction_date | Unknown |  |
| transaction_type | Unknown |  |
| transaction_type_object_data_type | Unknown |  |
| type | Unknown |  |
| value_per_share | Unknown |  |

### valuation_dataitem

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| name | Unknown |  |
| value_type | Unknown |  |

### security_ownership

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | Unknown | PK |
| security_id | Unknown | PK, FK |
| amount_held | Unknown |  |
| cost_basis | Unknown |  |
| entity_name | Unknown |  |
| shares_held | Unknown |  |

### security

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_data_id | Unknown | FK |
| asset_data_type | Unknown |  |
| asset_name | Unknown |  |
| dividends_days_in_year | Unknown |  |
| dividends_frequency | Unknown |  |
| dividends_paid_upon | Unknown |  |
| dividends_type | Unknown |  |
| fundamental_authorized_option | Unknown |  |
| fundamental_closed_date | Unknown |  |
| fundamental_commencement_date | Unknown |  |
| fundamental_conversion_ratio_denominator | Unknown |  |
| fundamental_conversion_ratio_numerator | Unknown |  |
| fundamental_converts_to | Unknown |  |
| fundamental_currency | Unknown |  |
| fundamental_exercise_price | Unknown |  |
| fundamental_maturity_date | Unknown |  |
| fundamental_options_available_for_grant | Unknown |  |
| fundamental_options_issued | Unknown |  |
| fundamental_outstanding_principal | Unknown |  |
| fundamental_outstanding_share | Unknown |  |
| fundamental_outstanding_unit | Unknown |  |
| fundamental_outstanding_warrant | Unknown |  |
| fundamental_price_per_share | Unknown |  |
| has_ownership | Unknown |  |
| interest_days_in_year | Unknown |  |
| interest_frequency | Unknown |  |
| interest_type | Unknown |  |
| is_active | Unknown |  |
| last_modified_date | Unknown |  |
| liquidation_preference_price_per_share | Unknown |  |
| liquidation_preference_type | Unknown |  |
| name | Unknown |  |
| participation_include_dividends | Unknown |  |
| participation_price_per_share | Unknown |  |
| participation_type | Unknown |  |
| rank | Unknown |  |
| short_name | Unknown |  |
| subtype | Unknown |  |
| type | Unknown |  |

### scenario

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| short_name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advanced_role | Json |  |
| business_unit | Unknown |  |
| cell_phone | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| federation_id | Unknown |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| last_modified_by | Unknown |  |
| last_modified_date | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| office_address | Unknown |  |
| phone | Unknown |  |
| roles | Json |  |
| title | Unknown |  |

## Relationships

- transaction_type_relationship(cash_transaction_type_id) → cash_transaction_type(id)
- periodic_data_relationship(periodic_data_id) → periodic_data(id)
- document_relationship(document_id) → document(id)
- segment_relationship(segment_id) → segment(id)
- data_item_relationship(data_item_id) → data_item(id)
- data_item_category_relationship(data_item_category_id) → data_item_category(id)
- deal(from_entity_data_id) → entity_fund(id)
- deal(to_entity_data_id) → entity_asset(id)
- deal(security_data_id) → security(id)
- cash_transaction(owner_object_data_id) → entity_fund(id)
- cash_transaction(investment_object_data_id) → entity_asset(id)
- cash_transaction(security_object_data_id) → security(id)
- cash_transaction(scenario_object_data_id) → scenario(id)
- cash_transaction(transaction_type_object_data_id) → cash_transaction_type(id)
- security_ownership(security_id) → security(id)
- security(asset_data_id) → entity_asset(id)