Identifiers: how the files link
The share-class key is the ISIN, and the files that record the ISIN call the column fund_isin. Match your book against fund_isin, and the share-class files follow.
Three identifiers link the files.
- The share class. fund_isin: the share-class ISIN, present on fund reference, fund liquidity, fund fees, fund analytics, fund class periods, fund profile, fund managers, and fund proxy summary.
- The portfolio. portfolio_id. Holdings are reported at portfolio level, so a book covers all the share classes of a fund. Portfolio holdings, fund portfolio analytics, and fund portfolio breakdown key on portfolio_id. Fund reference, fund liquidity, fund profile, fund managers, and fund proxy summary print portfolio_id beside the share class, so a class in your book leads straight to the portfolio record.
- The firm. fund_parent_id keys fund parent reference and appears on fund reference and fund advisers.
Fund advisers keys on regulator_ref alongside the regulator column; adviser_file_no on the profile and manager files links to the adviser's SEC entries.
Key column per file, from the August 31, 2026 delivery:
fund_adviser | regulator_ref |
|---|---|
fund_analytics | fund_isin |
fund_class_periods | fund_isin |
fund_fees | fund_isin |
fund_liquidity | fund_isin |
fund_manager | fund_isin |
fund_parent_reference | fund_parent_id |
fund_portfolio_analytics | portfolio_id |
fund_portfolio_breakdown | portfolio_id |
fund_profile | fund_isin |
fund_proxy_summary | fund_isin |
fund_reference | fund_isin |
portfolio_holdings | portfolio_id |
Where a file has several entries per key — a prospectus date, a period and comparand, a bucket family and bucket, a manager and capacity, a proxy year and category — the columns that complete an entry's identity are listed in the file's data dictionary section.
Matching your book. Match your ISIN to fund reference first. That file gives the portfolio_id and the fund_parent_id, and the remaining files follow from those three values. Holdings are published under portfolio_id, so match the holdings file on that column.