iLevel
Explore the interactive ERD
Table & Field Reference
transaction_type_relationship
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
cash_transaction_type_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 |