Data Dictionary of UK Alternative Investment Fund Managers

1.

Data Dictionary

The dataset's list of data fields and their descriptions, structured by categories.

Field name	Type	Description
`frn`	int	FCA Firm Reference Number (e.g. 123467)
`name`	str	Firm’s legal name (e.g. ABC Ltd)
`class`	str	AIFM classification (Options: Full-Scope, Small Authorised, Small Registered)
`aif_permission`	str	Type of fund(s) the firm is authorised to manage (Managing an authorised AIF, Managing an unauthorised AIF, Both)
`status_aifm`	str	Authorisation status under AIFMD (Options: Authorised, Registered)
`status_firm`	str	Authorisation status under FCA (e.g. Authorised, Authorised – applied to cancel)
`status_effective_date`	date	Date the firm’s current `status_firm` became effective
`firm_type`	str	Firm's regulated type (e.g. Regulated)
`principal`	boolean	Indicates if the firm is a principal under the Appointed Representative regime. True = Principal, False = Not Principal
`appointed_rep_count`	int	Number of appointed representatives managed by the firm
`small_reg_cat`	str	Registration category of small registered AIFMs (e.g. EuVECA, Property AIFM, Internally Managed AIFM)
`employee_size`	str	Employee size group based on firm’s LinkedIn page (e.g. 1–10, 11–50, 51–200, etc.)
`website`	str	Firm’s corporate website URL (e.g. www.website.com)
`domain`	str	Domain of the website (e.g. example.com)
`linkedin`	str	Firm's LinkedIn company URL (e.g. www.linkedin.com/company/abc)

Field name	Type	Description
`managing_authorised_aif`	boolean	Managing an authorised AIF
`managing_unauthorised_aif`	boolean	Managing an unauthorised AIF
`advising_on_investments`	boolean	Advising on investments (except on Pension Transfers and Pension Opt Outs)
`arranging_investments`	boolean	Arranging (bringing about) deals in investments
`dealing_as_agent`	boolean	Dealing in investments as agent
`dealing_as_principal`	boolean	Dealing in investments as principal
`establish_operate_wind_cis`	boolean	Establishing, operating or winding up a collective investment scheme
`making_arrangements`	boolean	Making arrangements with a view to transactions in investments
`managing_investments`	boolean	Managing investments
`p2p_advising`	boolean	Advising on P2P agreements
`safeguarding`	boolean	Arranging safeguarding and administration of assets
`safeguarding_without_arranging`	boolean	Safeguarding and administration of assets (without arranging)
`ucits`	boolean	Managing a UK UCITS
`mifid_client_types`	str	MiFID client categories served (e.g. Eligible Counterparty, Professional, Retail)
`s21_approver`	boolean	Can approve financial promotions for unauthorised persons (True/False)
`s21_investment_types`	str	Investment types permitted for Section 21 approval (e.g. Units, Warrants, Debentures)

Field name	Type	Description
`cf_headcount`	int	Count of unique individuals holding controlled functions
`smf_headcount`	int	Count of unique individuals holding Senior Management Functions (SMFs)
`smf17_mlro`	int	Count of SMF17 Money Laundering Reporting Officer (MLRO)
`smf16_compliance_oversight`	int	Count of SMF16 Compliance Oversight
`smf1_chief_executive`	int	Count of SMF1 Chief Executive
`smf3_executive_director`	int	Count of SMF3 Executive Director
`smf27_partner`	int	Count of SMF27 Partner
`smf9_chair_governing_body`	int	Count of SMF9 Chair of the Governing Body
`smf2_chief_finance`	int	Count of SMF2 Chief Finance
`smf24_chief_operations`	int	Count of SMF24 Chief Operations
`smf4_chief_risk`	int	Count of SMF4 Chief Risk
`smf18_other_overall`	int	Count of SMF18 Other Overall Responsibility
`smf5_head_internal_audit`	int	Count of SMF5 Head of Internal Audit
`smf7_group_entity_senior_mgr`	int	Count of SMF7 Group Entity Senior Manager
`smf12_chair_remuneration_comm`	int	Count of SMF12 Chair of the Remuneration Committee
`smf10_chair_risk_comm`	int	Count of SMF10 Chair of the Risk Committee
`smf11_chair_audit_comm`	int	Count of SMF11 Chair of the Audit Committee
`smf13_chair_nominations_comm`	int	Count of SMF13 Chair of the Nominations Committee
`smf14_senior_independent_director`	int	Count of SMF14 Senior Independent Director
`smf19_head_overseas`	int	Count of SMF19 Head of Overseas Branch/Head of Overseas

Field name	Type	Description
`chn`	str	Companies House Number
`ch_name`	str	Companies House Name
`ch_status`	str	Companies House Status (e.g. Active, Liquidation)
`ch_type`	str	Companies House Legal Form (e.g. LTD, LLP)
`date_of_creation`	date	Companies House Incorporation Date
`sic_codes`	str	Standard Industrial Classification (SIC) codes (e.g. 64999)

Field name	Type	Description
`turnover`	int	Reported turnover in GBP
`cash_in_bank`	int	Reported cash in bank in GBP
`total_assets`	int	Reported total assets in GBP (e.g. 1,500,000)
`total_liabilities`	int	Reported total liabilities in GBP (e.g. 900,000)
`net_assets`	int	Reported net assets in GBP
`debt_ratio`	float	Debt ratio = total liabilities ÷ total assets × 100 (e.g. 60)
`accounts_year_ended`	str	Financial year-end date (e.g. 31 Mar 2025)

Field name	Type	Description
`address_line_1`	str	Primary address line
`address_line_2`	str	Secondary address line (if applicable)
`address_line_3`	str	Additional address line (if applicable)
`postcode`	str	UK postcode
`area`	str	Local area/district (e.g. City of London)
`region`	str	UK region (Options: London, Scotland, Northern Ireland, Wales, South East, North West, East of England, South West, Yorkshire & The Humber, West Midlands, East Midlands, North East)
`country`	str	Country of registration (United Kingdom)