Labs Data Extensions
Labs fields let us expose experimental attributes before they become part of the core portfolio, account, or investment payloads. Every labs attribute is delivered beneath the labs object on the corresponding resource (for example portfolio.labs.customer.name). These properties are optional and may change as the feature graduates; rely on the descriptions below to understand the current structure.
Working With Labs Data
- Labs fields are additive. They never remove or rename existing available fields.
- A labs object may be absent or partially populated when the upstream institution does not provide the data.
- Once a labs field becomes part of the stable model, the entry remains available for a grace period so you can migrate.
- Treat numeric values as raw amounts unless a unit is specified in the description.
- Any product may contain an
extrakey underlabs. This is a free-form dictionary populated with institution-specific fields that do not fit any standardized labs key. Its contents are not fixed and vary by institution.
Portfolio Labs Fields
customer
|
Field |
Type |
Description |
|
name * |
|
Customer name as provided by the institution. |
|
type * |
|
Indicates whether the customer is |
* Can be null
pension_plan
|
Field |
Type |
Description |
|
birth_date * |
|
Birth date of the plan holder. |
|
policy_number * |
|
Contract reference supplied by the pension provider. |
|
product_provider * |
|
Name of the company offering the plan. |
|
retirement_options * |
|
High-level description of permitted retirement options. |
|
retirement_suboptions * |
|
Additional detail for the retirement options. |
|
retirement_age * |
|
Target retirement age for the plan. |
|
fund_charges * |
|
Annualized fund fees. |
|
adviser_charges * |
|
Adviser fees attached to the plan. |
|
platform_charges * |
|
Platform-level fees. |
|
total_contributions * |
|
Lifetime contributions made to the plan. |
|
initial_date * |
|
Contract start date. |
|
valuation_date * |
|
Date of the latest valuation. |
|
uk |
|
Additional attributes for UK wrappers (see below). |
* Can be null
pension_plan.uk
|
Field |
Type |
Description |
|
type * |
|
Wrapper-specific plan type (SIPP, RIA, ISA, GIA, PIMS, or Other). |
|
employer_contributions * |
|
Amount funded by the employer. |
|
employee_contributions * |
|
Amount funded by the employee. |
|
partially_transferable * |
|
Indicates if part of the funds can be transfered to another Plan. |
|
tax_relief * |
|
Tax relief credited to the plan. |
|
transfer_value * |
|
Lump-sum transfer value. |
|
crystallised * |
|
Amount already crystallised. |
|
fund_status * |
|
Accepts "Crystallised", "Uncrystallised", "Partially crystallised". |
|
plan_value * |
|
Current value of the wrapper. |
|
transfer_charges * |
|
Fees for transfering the PP to another provider. |
|
flexible_drawdown * |
|
Indicates if the plan allows for income to be withdrawn flexibly. |
|
policyserving_charges * |
|
Administration maintenance fees. |
|
beneficiary_nominated * |
|
Beneficiary nominated for death benefits. |
|
beneficiary_relation * |
|
Relationship of the beneficiary to the holder. |
|
other_charges * |
|
Other charges related to the pension plan. |
|
paid_up_date * |
|
Date when the policy stopped receiving contributions. |
* Can be null
assurance_vie
|
Field |
Type |
Description |
|
insurer * |
|
Insurance company issuing the contract. |
|
beneficiaries |
|
List of designated beneficiaries. |
|
pledge * |
|
Indicates if the contract is pledged. |
|
pledge_ratio * |
|
Portion of the contract that is pledged. |
|
broker * |
|
Broker associated with the contract. |
|
custodian * |
|
Custodian handling the assets. |
|
management_fees * |
|
Annual management fees. |
|
insurance_manager * |
|
Name of the insurance manager. |
|
management_mode * |
|
Portfolio management style (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
paid_premium * |
|
Total premiums paid. |
|
historical_performance * |
|
Historical return of the contract. |
|
subscriber_birth_date * |
|
Subscriber date of birth. |
|
contract_duration * |
|
Duration in years. |
|
initial_date * |
|
Contract start date. |
|
valuation_date * |
|
Latest valuation date. |
|
contract_status * |
|
Current status of the contract (active, closing, closed, or transferred). |
|
close_date * |
|
Date when the contract closed, if applicable. |
|
management_profile * |
|
Risk profile set by the provider (prudent, balanced, dynamic, or offensive). |
* Can be null
per
|
Field |
Type |
Description |
|
beneficiaries |
|
Beneficiary list for the PER contract. |
|
pledge * |
|
Indicates if the contract is pledged. |
|
pledge_ratio * |
|
Portion pledged. |
|
management_mode * |
|
Management strategy (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
birth_date * |
|
Participant birth date. |
|
exit_mode * |
|
Exit option chosen for the contract ( |
|
type * |
|
Contract type ( |
|
deductible_payments * |
|
Indicates whether contributions are deductible. |
|
funding_type * |
|
Origin of the contributions. |
* Can be null
pea and pea-pme
|
Field |
Type |
Description |
|
pledge * |
|
Indicates if the plan is pledged. |
|
pledge_ratio * |
|
Portion pledged. |
|
management_mode * |
|
Management strategy (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
eligible_assets * |
|
Assets eligible under the plan rules. |
|
opening_date * |
|
Account opening date. |
|
deposit_limit * |
|
Contribution cap. |
* Can be null
cto
|
Field |
Type |
Description |
|
pledge * |
|
Indicates if the account is pledged. |
|
pledge_ratio * |
|
Portion pledged. |
|
management_mode * |
|
Management strategy (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
broker * |
|
Introducing broker. |
* Can be null
contrat_capitalisation
|
Field |
Type |
Description |
|
insurer * |
|
Insurer name. |
|
pledge * |
|
Indicates if the contract is pledged. |
|
pledge_ratio * |
|
Portion pledged. |
|
broker * |
|
Broker associated with the contract. |
|
custodian * |
|
Custodian handling the assets. |
|
management_fees * |
|
Annualized fees. |
|
insurance_manager * |
|
Insurance manager name. |
|
management_mode * |
|
Management strategy (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
paid_premium * |
|
Total premiums paid. |
|
historical_performance * |
|
Historical return. |
|
contract_duration * |
|
Contract length in years. |
* Can be null
FIS, FAS, FIC, FID
Dynamic keys mirroring the underlying French fund type.
|
Field |
Type |
Description |
|
pledge * |
|
Indicates if the fund is pledged. |
|
pledge_ratio * |
|
Portion pledged. |
|
management_mode * |
|
Management strategy (Horizon, Mandat, Dédiée, Libre, Pilotée, Profilée, or Conseillée). |
|
lockin_period * |
|
Lock-up period in years. |
* Can be null
ref_accounts_ids
|
Field |
Type |
Description |
|
ref_accounts_ids * |
|
Internal account identifiers linked to this portfolio wrapper. |
* Can be null
extra
|
Field |
Type |
Description |
|
(any key) * |
|
Custom fields populated with institution-specific data not covered by any standardized labs key. Contents vary by institution. |
* Can be null
Account Labs Fields
customer
|
Field |
Type |
Description |
|
name * |
|
Customer name when provided by the institution. |
|
type * |
|
Indicates whether the account belongs to a |
* Can be null
portfolio_id
|
Field |
Type |
Description |
|
portfolio_id * |
|
Identifier of the linked portfolio when the account is attached to one. |
* Can be null
included_in_portfolio_balance
|
Field |
Type |
Description |
|
included_in_portfolio_balance |
|
|
interest_rate
|
Field |
Type |
Description |
|
interest_rate |
|
Interest rate applied to the account, when disclosed by the institution. |
French savings products (livret_A, PEL, CEL, CELP, CSL, LDDS, LEP, LI, LJ)
Each key represents the corresponding savings product payload.
|
Field |
Type |
Description |
|
eligibility_conditions * |
|
Text describing who can open the product. |
|
taxation * |
|
Applicable tax rate. |
|
deposit_limit * |
|
Maximum allowed balance or contributions. |
* Can be null
valuation_date
|
Field |
Type |
Description |
|
valuation_date * |
|
Date of the latest account valuation when provided by the institution. |
* Can be null
extra
|
Field |
Type |
Description |
|
(any key) * |
|
Custom fields populated with institution-specific data not covered by any standardized labs key. Contents vary by institution. |
* Can be null
Card Labs Fields
limit
|
Field |
Type |
Description |
|
limit * |
|
Credit limit of the card, when disclosed by the institution. Only
populated for |
* Can be null
used_balance
|
Field |
Type |
Description |
|
used_balance * |
|
Outstanding balance already drawn on the card (used credit), as a positive
amount. Only populated for |
* Can be null
extra
|
Field |
Type |
Description |
|
(any key) * |
|
Custom fields populated with institution-specific data not covered by any standardized labs key. Contents vary by institution. |
* Can be null
Liability Labs Fields
portfolio_id
|
Field |
Type |
Description |
|
portfolio_id * |
|
Identifier of the portfolio the liability hangs from, when the institution
discloses the link. Matches the |
* Can be null
extra
|
Field |
Type |
Description |
|
(any key) * |
|
Custom fields populated with institution-specific data not covered by any
standardized labs key. Contents vary by institution. For UBS Switzerland
it carries |
* Can be null
Investment Labs Fields
pension_plan
|
Field |
Type |
Description |
|
policy_number * |
|
Plan policy reference. |
|
retirement_age * |
|
Target age for withdrawals. |
|
fund_charges * |
|
Annualized fund fees. |
|
total_contributions * |
|
Lifetime contributions. |
|
uk |
|
Additional fields for UK securities (see below). |
* Can be null
pension_plan.uk
|
Field |
Type |
Description |
|
employer_contributions * |
|
Employer-funded amount. |
|
employee_contributions * |
|
Employee-funded amount. |
|
partially_transferable * |
|
Indicates if transfers out are restricted. |
|
tax_relief * |
|
Tax relief credited. |
|
sedol |
|
SEDOL identifier for the pension security. |
* Can be null
sedol
|
Field |
Type |
Description |
|
sedol * |
|
Security identifier provided when the instrument has a SEDOL. |
* Can be null
scpi
|
Field |
Type |
Description |
|
type * |
|
SCPI type. |
|
management_company * |
|
Managing company. |
|
capital_structure * |
|
Capital structure of the fund ( |
|
inception_date * |
|
Fund inception date. |
|
redemption_value * |
|
Redemption value per share. |
|
subscription_price * |
|
Subscription price. |
|
minimum_subscription_amount * |
|
Minimum commitment allowed. |
|
distribution_frequency * |
|
Frequency of distributions. |
|
distribution_yield * |
|
Yield description or percentage. |
|
internal_rate_of_return * |
|
Provided IRR. |
|
market_capitalization * |
|
Market capitalization text. |
|
shareholders_number * |
|
Number of shareholders. |
|
recommended_holding_period * |
|
Recommended holding period (years). |
|
subscription_fees * |
|
Subscription fees. |
|
management_fees * |
|
Management fees. |
|
risk_level * |
|
Risk scale reported by the provider. |
|
geographic_allocation * |
|
Description of the geographic allocation. |
|
sector_allocation * |
|
Description of the sector allocation. |
|
financial_occupancy_rate * |
|
Financial occupancy rate. |
|
assets_under_management * |
|
Assets under management text. |
|
leverage * |
|
Leverage ratio. |
|
life_ensurance_eligibility * |
|
Eligibility for life insurance wrappers. |
|
applicable_tax_regime * |
|
Tax regime description. |
* Can be null
sci
|
Field |
Type |
Description |
|
company_registration_number * |
|
Registration number of the company. |
|
registered_office_address * |
|
Official registered address. |
|
corporate_purpose * |
|
Corporate purpose statement. |
|
incorporation_date * |
|
Incorporation date. |
|
manager_name * |
|
Manager name. |
|
partners |
|
Partner names (may be empty). |
|
type * |
|
SCI type. |
|
share_capital * |
|
Share capital. |
|
form_of_contribution * |
|
Description of contributions. |
|
asset_valuation * |
|
Asset valuation. |
|
number_and_nature_of_properties * |
|
Properties covered by the SCI. |
|
debt_level * |
|
Debt level. |
|
gross_net_rental_yield * |
|
Rental yield. |
|
share_of_profit * |
|
Share of profit. |
|
taxation_regime * |
|
Tax regime. |
|
occupancy_rate * |
|
Occupancy rate. |
|
net_book_value * |
|
Net book value. |
|
partner_taxation * |
|
Tax treatment for partners. |
|
donation_usufruct_eligibility * |
|
Eligibility details for donations or usufruct. |
|
fiscal_year_end * |
|
Fiscal year end text. |
* Can be null
structured_product
|
Field |
Type |
Description |
|
issue_price * |
|
Initial issue price. |
* Can be null
depot_a_terme
|
Field |
Type |
Description |
|
early_redemption_conditions * |
|
Qualifying conditions for early redemption. |
|
early_redemption_penalty * |
|
Indicates whether penalties apply on early exit. |
|
renewal_method * |
|
Method used when renewing the term deposit. |
|
interest_rate_type * |
|
Type of interest rate ( |
|
initial_amount * |
|
Principal deposited when the term deposit was opened. |
|
accrued_interest_date * |
|
Date as of which the accrued interest is computed. |
|
next_interest_payment_date * |
|
Next scheduled interest payment date. |
|
last_interest_payment_date * |
|
Last scheduled interest payment date. |
* Can be null
fonds_euro
|
Field |
Type |
Description |
|
capital_guarantee * |
|
Details on the capital guarantee. |
|
redemption_mode * |
|
Redemption mode description. |
|
profit_sharing * |
|
Profit-sharing rate. |
|
guaranteed_minimum_return * |
|
Guaranteed minimum return. |
* Can be null
option
|
Field |
Type |
Description |
|
underlying_asset_symbol |
|
Symbol of the underlying instrument. |
|
underlying_asset_isin * |
|
ISIN of the underlying instrument, when available. |
|
strike_price |
|
Strike price. |
|
expiration_date |
|
Expiration date. |
|
type |
|
Option type ( |
|
multiplier |
|
Contract multiplier (defaults to 100). |
|
market * |
|
ISO MIC code (ISO 10383) of the market where the option trades. |
* Can be null
warrant
|
Field |
Type |
Description |
|
underlying_asset_symbol |
|
Symbol of the underlying instrument. |
|
strike_price |
|
Strike price. |
|
expiration_date |
|
Expiration date. |
|
type |
|
Warrant type ( |
|
issuer * |
|
Issuer name. |
|
conversion_rate * |
|
Conversion rate. |
|
nature * |
|
Exercise style ( |
* Can be null
future
|
Field |
Type |
Description |
|
underlying_asset_symbol * |
|
Symbol of the underlying asset. |
|
price * |
|
Contract price. |
|
expiration_date * |
|
Expiration date. |
* Can be null
forex_option
|
Field |
Type |
Description |
|
underlying_asset_symbol |
|
Symbol of the currency pair. |
|
strike_price |
|
Strike price. |
|
expiration_date |
|
Expiration date. |
|
type |
|
Option type ( |
|
base_currency |
|
ISO 4217 code of the base currency. |
|
quote_currency |
|
ISO 4217 code of the quote currency. |
|
nature * |
|
Exercise style ( |
* Can be null
private_equity
|
Field |
Type |
Description |
|
capital_called * |
|
Total capital called. |
|
capital_committed * |
|
Total capital committed. |
|
capital_distribution * |
|
Capital returned to investors. |
|
capital_pending * |
|
Committed capital not yet called. |
|
recallable_distributions * |
|
Distributions the manager can call again. |
|
tvpi * |
|
Total value to paid-in of the client, as reported by the institution. |
|
dpi * |
|
Distributed to paid-in of the client, as reported by the institution. |
|
rvpi * |
|
Residual value to paid-in of the client, as reported by the institution. |
|
net_irr * |
|
Net IRR of the client, as a percentage. |
|
management_fees_gross * |
|
Management fees before offsets, waivers and rebates. |
|
management_fees * |
|
Management fees net of offsets, waivers and rebates. |
|
fund_expenses * |
|
Fund expenses allocated to the investor. |
|
carried_interest * |
|
Carried interest accrued, earned or paid. |
|
nav_gross_of_carry * |
|
NAV before carried interest. |
|
unit_price * |
|
Current unit price. |
|
share_class * |
|
Share class held, as named by the institution. |
|
pe_vehicle_type * |
|
Vehicle category ( |
|
pe_legal_form * |
|
Legal wrapper ( |
|
valuation_type * |
|
Valuation basis: |
|
program_id * |
|
Programme the vehicle belongs to, when the institution groups them. |
|
pe_underlying * |
|
List of underlying funds and their companies (see below). |
* Can be null
Fee, carry and recallable fields are cumulative since inception, reported as positive amounts in the
position currency. balance remains the NAV net of carried interest.
private_equity.pe_underlying
Each entry groups the portfolio companies behind one underlying fund, or the companies the vehicle holds directly, in
which case the fund fields are null. Amounts prefixed with fund_ belong to the underlying fund, not to the position.
|
Field |
Type |
Description |
|
fund_id * |
|
Fund identifier. Null when the vehicle holds the companies directly. |
|
fund_name * |
|
Fund name. Null when the vehicle holds the companies directly. |
|
scope |
|
Whose amounts these are ( |
|
fund_type * |
|
Fund category ( |
|
fund_strategy * |
|
Investment strategy declared by the manager. |
|
main_focus * |
|
Main geography of the fund. |
|
investment_date * |
|
Date the fund was entered (YYYY-MM-DD). |
|
quarter * |
|
Reference date of the reported figures (YYYY-MM-DD). |
|
fund_size * |
|
Total size of the fund. |
|
fund_committed * |
|
Capital committed to the fund by the manager. |
|
fund_drawdown * |
|
Capital drawn down by the fund. |
|
fund_pending * |
|
Commitment not yet drawn down. |
|
manager_percentage * |
|
Manager's weight in the fund, as a percentage. |
|
fund_valuation * |
|
Valuation of the manager's stake in the fund. |
|
fund_distributed * |
|
Distributions received by the manager. |
|
fund_capital_calls * |
|
Capital contributed by the manager. |
|
fund_total_value * |
|
Sum of |
|
fund_tvpi * |
|
Total value to paid-in of the fund. |
|
fund_dpi * |
|
Distributed to paid-in of the fund. |
|
fund_rvpi * |
|
Residual value to paid-in of the fund. |
|
companies |
|
List of the portfolio companies of the fund (see below). |
* Can be null
private_equity.pe_underlying.companies
|
Field |
Type |
Description |
|
company |
|
Company name. |
|
previous_names * |
|
Former names the company was known by. |
|
sector * |
|
Business sector. |
|
country * |
|
Country of the company. |
|
purchase_date * |
|
Date the fund entered the company (YYYY-MM-DD). |
|
invested * |
|
Amount invested in the company by the fund. |
|
moic * |
|
Multiple on invested capital reported by the manager. |
|
manager_opinion * |
|
One of |
|
ownership_pct * |
|
Percentage of the company held. |
|
irr * |
|
IRR of the investment in the company, as a percentage. |
|
fair_value * |
|
Current fair value of the stake in the company. |
|
realized_value * |
|
Value already realized from the company. |
|
status * |
|
One of |
|
exit_date * |
|
Date the fund exited the company (YYYY-MM-DD). |
|
web * |
|
Corporate website. |
|
description * |
|
Description of the business. |
* Can be null
real_estate
|
Field |
Type |
Description |
|
funded * |
|
Amount funded. |
|
funded_date * |
|
Date of funding. |
|
property * |
|
Details of the underlying property (see below). |
|
acquisition_price * |
|
Purchase price of the property. |
|
acquisition_date * |
|
Date the property was acquired. |
|
cadastral_reference * |
|
Official cadastral/land-registry reference. |
|
asset_type * |
|
Property category (e.g. residential, commercial). |
|
address * |
|
Street address. |
|
zip_code * |
|
Postal code. |
|
municipality * |
|
City or municipality. |
|
province * |
|
Province or region. |
|
floor_area_m2 * |
|
Usable floor area in square metres. |
|
ownership_percentage * |
|
Ownership share (0–100). |
|
annual_rent * |
|
Gross rent collected per year, in the investment currency. |
|
annual_expenses * |
|
Yearly running costs (taxes, upkeep, insurance), sign as reported. |
|
usage * |
|
How the asset is used, as labelled by the source (e.g. rented, vacant). |
|
tenant * |
|
Current tenant as reported by the source. |
|
contract_expiration * |
|
End date of the current lease contract (YYYY-MM-DD). |
|
country * |
|
Country where the property is located. |
|
geographic_zone * |
|
Regional bucket assigned by the source (e.g. developed Europe). |
|
wault * |
|
Weighted Average Unexpired Lease Term in years, as reported by the source. |
* Can be null
real_estate.property
|
Field |
Type |
Description |
|
price * |
|
Purchase price. |
|
valuation * |
|
Latest valuation. |
|
location * |
|
Location of the property. |
|
rented * |
|
Indicates if the property is rented (defaults to false). |
|
bedrooms * |
|
Number of bedrooms. |
* Can be null
crowdfunding
|
Field |
Type |
Description |
|
status * |
|
Project status ( |
|
cf_type * |
|
Crowdfunding type ( |
|
project_value * |
|
Project value. |
|
sponsor * |
|
Project sponsor. |
|
interest_payment_frequency * |
|
Interest payment frequency. |
|
interest_paid * |
|
Interest paid to date. |
|
principal_repayment_type * |
|
When is the capital repaid (monthly, quarterly, at maturity... ) |
* Can be null
crowdlending
|
Field |
Type |
Description |
|
status * |
|
Loan status ( |
|
underlying_loan_type * |
|
Type of the underlying loan (e.g. personal, business, real estate). |
|
project_value * |
|
Total value of the funded project or loan. |
|
outstanding_principal * |
|
Principal amount still pending repayment. |
|
payments_received * |
|
Amount of payments received to date. |
|
pending_payments * |
|
Indicates if there are payments pending. |
|
lending_entity * |
|
Lending platform or entity servicing the loan. |
|
issuer * |
|
Issuer of the underlying loan. |
|
collateral * |
|
Indicates if the loan is backed by collateral. |
* Can be null
forex_forward
|
Field |
Type |
Description |
|
settlement_date * |
|
Settlement date of the forward contract. |
|
base_currency |
|
ISO 4217 code of the base currency. |
|
quote_currency |
|
ISO 4217 code of the quote currency. |
|
forward_rate * |
|
Agreed exchange rate for the forward contract. |
* Can be null
extra
|
Field |
Type |
Description |
|
(any key) * |
|
Custom fields populated with institution-specific data not covered by any standardized labs key. Contents vary by institution. |
* Can be null
Transaction-sourced labs fields
Labs keys below originate from investment transactions but are surfaced within investment payloads for convenience.
|
Field |
Type |
Description |
|
account_number * |
|
Cash account number used for the transaction when available. |
|
cusip * |
|
Transaction-level CUSIP when it differs from the ISIN. |
* Can be null
Labs Data Example
Here is an example of what labs would look like under an Assurance Vie Portfolio:
{
"id": "P12345Uttt",
"balance": 40.1,
"currency": "EUR",
"name": "Assurance Vie Portfolio",
"numOwners": 0,
"owners": [],
"refAccount": null,
"refAccounts": [],
"refValores": "12345",
"type": null,
"tax_type": null,
"holders": [
{
"holder_name": "John Doe",
"relation": "Titular"
}
],
"labs": {
"customer": {
"name": "John Doe",
"type": "physical"
},
"assurance_vie": {
"insurer": "insurer",
"beneficiaries": [
"Jane Doe",
],
"pledge": true,
"pledge_ratio": 0.4,
"broker": "creditagricole",
"custodian": "lcl",
"management_fees": 0.01,
"insurance_manager": "mr manager",
"management_mode": "Libre",
"paid_premium": 0.0,
"historical_performance": 0.0,
"subscriber_birth_date": "1965-01-01",
"contract_duration": 30,
"initial_date": "2000-01-01",
"valuation_date": "2025-01-01",
"contract_status": "active",
"close_date": null,
"management_profile": "offensive"
}
}
}