Organization Currency Metric
The organisation currency metric table provides organization-level size and scale indicators, including market valuation, asset base, assets under management, and revenue, that can be used to compare the overall economic scale and financial footprint of organizations.
Data Field | Key Type | Data Field Type | Recommended Character Limit |
|---|---|---|---|
organization_id | Primary Key | String | |
organization_currency_metric_measurement_date | | Date | 10 |
organization_currency_metric_measurement_type | Primary Key | String | |
usd_value_min | | Decimal(27,4) | 27,4 |
usd_value_max | | Decimal(27,4) | 27,4 |
organization_currency_metric_period_name | Primary Key | String | |
organization_currency_unit_type | | | |
Organization Currency Metric Field Descriptions
organization_id (PK) Unique ID assigned within the Altrata Organization. These IDs enable mapping to other tables or other entity IDs within Altrata. Example: 1-org-14994
organization_currency_metric_measurement_date The date of the financial metric.
organization_currency_metric_measurement_type (PK) The specific type of organization metric. It is one of the following types:
- Market Cap , which is the total market value of a company’s equity, calculated as current share price × number of shares outstanding.
- Total_Assets, which is the sum of all assets a company reports on its balance sheet at a point in time—everything it owns or controls with economic value (e.g., cash, receivables, investments, property/equipment, intangibles).
- Assets_Under_Management, which is the total market value of assets that the organization (a financial institution) manages on behalf of clients (often includes iscretionary and sometimes non-discretionary mandates, depending on the firm’s definition).
- Revenue: The total income from a company’s primary business activities over a period (e.g., sales of goods/services), typically reported before deducting expenses (i.e., “top line”).
usd_value_min The minimum value of the currency metric.
usd_value_max The maximum value of the currency metric.
organization_currency_metric_period_name (PK) Name of the financial period of the measurement data. Example: Annual
organization_currency_unit_type
This is the unit of measurement for the currency metric.
Example: Currency