Official Statistics

Pension funds consolidated data metadata: 2023 to 2024

Updated 24 October 2024
Download CSV 7.25 KB

Variable Description
Authority_Name Name of authority
Ecode Ecode for the authority, used by DLUHC for unique indentification
ONSCode Ecode for the authority, used across government for unique indentification
pension Expenditure on pension or annuities for members and dependants
lump_retire Expenditure on lump sums on retirement (including deferred)
lump_opt Expenditure on optional lump sums, for retirements in the financial year
lump_death Expenditure on lump sums on death
othben Expenditure on any other benefits charged to the fund
transf_out Expenditure on transfers out of the fund, including apportionments out
penprem Expenditure on Pensions Act premiums
mgmtexp Expenditure on administration and fund management costs, inccluding costs that may be netted off from investment income from fund managers
othexp Other expenditure, primarily including refunds of contributions, including any interest
totpens_exp Total expenditure (sum of rows 1 to 9 of section 1)
contrib_empee Income from employee contributions
contrib_emper Income from employer contributions
invinc Income from investment gross of tax, before deduction of fund management costs (included in mgmtexp) but net of any collection costs
transf_in Income from transfers into the fund
othinc Other income, excluding profit on realisation of assets
totpens_inc Total income (sum of rows 11 to 15 of section 1)
empler_gp1 Total employers in group 1 (local authorities and connected bodies)
empler_gp2 Total employers in group 2 (centrally funded public sector bodies)
empler_gp3 Total employers in group 3 (other public sector bodies)
empler_gp4 Total employers in group 4 (private sector, voluntary sector, and other)
empler_tot Total number of employers
contmem_gp1 Total contributing members in group 1 (local authorities and connected bodies)
contmem_gp2 Total contributing members in group 2 (centrally funded public sector bodies)
contmem_gp3 Total contributing members in group 3 (other public sector bodies)
contmem_gp4 Total contributing members in group 4 (private sector, voluntary sector, and other)
contmem_tot Total number of contributing members
pensioner_gp1 Total pensioners in group 1 (local authorities and connected bodies)
pensioner_gp2 Total pensioners in group 2 (centrally funded public sector bodies)
pensioner_gp3 Total pensioners in group 3 (other public sector bodies)
pensioner_gp4 Total pensioners in group 4 (private sector, voluntary sector, and other)
pensioner_tot Total number of pensioners
defmemb_gp1 Total former members entitled to deferred benefits in group 1 (local authorities and connected bodies)
defmemb_gp2 Total former members entitled to deferred benefits in group 2 (centrally funded public sector bodies)
defmemb_gp3 Total former members entitled to deferred benefits in group 3 (other public sector bodies)
defmemb_gp4 Total former members entitled to deferred benefits in group 4 (private sector, voluntary sector, and other)
defmemb_tot Total number of former members entitled to deferred benefits
flexret_gp1 Total flexible retirees in group 1 (local authorities and connected bodies)
flexret_gp2 Total flexible retirees in group 2 (centrally funded public sector bodies)
flexret_gp3 Total flexible retirees in group 3 (other public sector bodies)
flexret_gp4 Total flexible retirees in group 4 (private sector, voluntary sector, and other)
flexret_tot Total number of flexible retirees
totmember_gp1 Total members in group 1 (local authorities and connected bodies)
totmember_gp2 Total members in group 2 (centrally funded public sector bodies)
totmember_gp3 Total members in group 3 (other public sector bodies)
totmember_gp4 Total members in group 4 (private sector, voluntary sector, and other)
totmember_tot Total number of members
fundprofit Profit on realisation of fund assets
fundloss Loss on realisation of fund assets
netprofit Net profit on realisation of fund assets
contrib_prim Employers' primary contributions
contrib_rate Employers' primary conribution rate as a percentage of pensionable employees' remuneration
contrib_second Employers' secondary contributions
contrib_s162b Employers' secondary contributions of which subject to regulation 16(2)(b) of the Local Government Act 2003
contrib_emper_calc Total employers' contributions, equal to contrib_emper except for rounding differences
invinc_prop Income from investments of which is from properties, net of collection costs
invinc_oth Other investment income
invinc_divi Income from dividents receivable on investments
invinc_interest Income from interest receivable on cash and interest bearing securities
mktval_startyr Market value of the fund at the start of the financial year (1 April)
mktval_endyr Market value of the fund at the end of the financial year (31 March)
penspay_tot Pension increase payments eimbused by emploters
staff_admin Number of full-time equivalent staff in pension administation duties within the authority
staff_fund Number of full-time equivalent staff in fund management duties within the authority
mgmtexp_invest Management expenses of which investment management expenses
mgmtexp_admin Management expenses of which administration expenses
mgmtexp_gov Management expenses of which oversight and governance expenses
retire_redund Number of members made redundant in the financial year
retire_ill Number of members who took ill health retirement in the financial year
retire_tier1 Number of Tier 1 ill health retirements
retire_tier1_m Number of Tier 1 ill health retirements of which were male members
retire_tier1_f Number of Tier 1 ill health retirements of which were female members
retire_tier1_age Average age of members who took Tier 1 ill health retirement. This data point is suppressed if it concerns three or less members
retire_tier2 Number of Tier 2 ill health retirements
retire_tier2_m Number of Tier 2 ill health retirements of which were male members
retire_tier2_f Number of Tier 2 ill health retirements of which were female members
retire_tier2_age Average age of members who took Tier 2 ill health retirement. This data point is suppressed if it concerns three or less members
retire_tier3 Number of Tier 3 ill health retirements
retire_tier3_m Number of Tier 3 ill health retirements of which were male members
retire_tier3_f Number of Tier 3 ill health retirements of which were female members
retire_tier3_age Average age of members who took Tier 3 ill health retirement. This data point is suppressed if it concerns three or less members
tier3_stop Number of Tier 3 payments which were stopped under Regulation 37(3) and 37(7)(c) in the financial year
tier3_uplift Number of Tier 3 payments were uplifted to Tier 2 under Regulation 37(7)(b) and 37(10) in the financial year
age45protect Number of awards which made use of the age 45 protection in Transitional Regulation 12 in the financial year
earlypay_choice Number of members who took early payment of pension per Regulation 30(5) of the 2013 regulations
earlypay_ill Number of members who took early payment of pension due to ill health per Regulation 38 of the 2013 regulations
retire_subtot Total number of redundancies, ill health retirements and early payments of pensions
retire_normal Number of "normal" retirements in the financial year
retire_tot Total number of all retirements