Municipal Fiscal Indicators: Pension Funding Information For Defined Benefit Pension Plans, 2020
data.ct.gov | Last Updated 30 Jan 2024Municipal Fiscal Indicators is an annual compendium of information compiled by the Office of Policy and Management, Office of Finance, Municipal Finance Services Unit (MFS). Municipal Fiscal Indicators contains the most current financial data available for each of Connecticut's 169 municipalities. The data contained in Indicators provides key financial and demographic information on municipalities in Connecticut. The data includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition. Pension Funding Information For Defined Benefit Pension Plans of Connecticut Municipalities, compiled by the CT Office of Policy and Management in the annual Municipal Fiscal Indicators report. Post-employment benefits are typically provided by municipalities to former employees or their beneficiaries as compensation for services rendered while these employees were still active. These benefits are generally divided into two broad categories – pension benefits (retirement income) and Other Post-employment Benefits (postemployment benefits other than pensions, referenced as OPEB). Forms of OPEB typically include healthcare benefits and benefits such as disability and life insurance provided outside of the pension plan. The majority of this data was compiled from the audited financial statements that are filed annually with the State of Connecticut, Office of Policy and Management, Office of Finance. Unlike prior years' where the audited financial information was compiled by OPM, the FY 2020 information in this edition was based upon the self-reporting by municipalities of their own audited data. The most recent edition is for the Fiscal Years Ended 2016-2020 published in July 2022. Data on the 2020 Municipal Fiscal Indicators is included in the following datasets: 1. <a href="https://data.ct.gov/d/aiwt-8yhn">Municipal Fiscal Indicators, 2020</a> 2. <a href="https://data.ct.gov/d/wb9r-t4hp">Municipal Fiscal Indicators: Uniform Chart of Accounts - Expenditures by Town, 2020</a> 3. <a href="https://data.ct.gov/d/dxx8-78jr">Municipal Fiscal Indicators: Uniform Chart of Accounts - Expenses by Function, 2020</a> 4. <a href="https://data.ct.gov/d/5xsg-8hur">Municipal Fiscal Indicators: Pension Funding Information For Defined Benefit Pension Plans, 2020</a> 5. <a href="https://data.ct.gov/d/u6w3-tea4">Municipal Fiscal Indicators: Other Post-Employment Benefits (OPEB), 2020</a> 6. <a href="https://data.ct.gov/d/kkhf-upbi">Municipal Fiscal Indicators: Type and Number of Pension Plans, 2020</a> 7. <a href="https://data.ct.gov/d/q4e6-uyfb">Municipal Fiscal Indicators: Economic and Grand List Data, 2020</a> 8. <a href="https://data.ct.gov/d/ivad-j2rk">Municipal Fiscal Indicators: Benchmark Labor Data, 2020</a> 9. <a href="https://data.ct.gov/d/8n4z-7dtx">Municipal Fiscal Indicators: Bond Ratings, 2020</a>
This dataset has the following 28 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Year | year | number | Year | 2020 view top 100 |
Entity Name | entity_name | text | Entity Name | DANBURY WESTPORT NORTH HAVEN STAMFORD ROCKY HILL view top 100 |
C-2 Plan Name | c_2_plan_name | text | C-2 Plan Name | Town of Westbrook - Police Pension Plan Town of Westport Municipal Interim Pension Fund Town of Killingworth Defined Benefit Plan- Volunteer Fire Company Town of Deep River Employee's Retirement Plan Town of Somers Firefighters' Plan view top 100 |
D-4 All Eligible Employees | d_4_all_eligible_employees | checkbox | D-4 All Eligible Employees | false true view top 100 |
D-6 General Town | d_6_general_town | checkbox | D-6 General Town | false true view top 100 |
D-8 Police | d_8_police | checkbox | D-8 Police | false true view top 100 |
D-10 Fire | d_10_fire | checkbox | D-10 Fire | false true view top 100 |
D-12 Non Certified Board of Education | d_12_non_certified_board | checkbox | D-12 Non Certified Board of Education | false true view top 100 |
D-14 Other | d_14_other | checkbox | D-14 Other | false true view top 100 |
D-16 Brief Description (if other) | d_16_brief_description_if | text | D-16 Brief Description (if other) | Ambulance Custodians, Paraeducators, Mechanics Elected Officials Eligible Ambulance FOOD SERVICE view top 100 |
F-2 Closed Plan | f_2_closed_plan | checkbox | F-2 Closed Plan | false true view top 100 |
F-4 Volunteer Plan | f_4_volunteer_plan | checkbox | F-4 Volunteer Plan | false true view top 100 |
F-6 Total Number of Members | f_6_total_number_of_members | number | F-6 Total Number of Members | 94 74 32 20 2088 view top 100 |
F-8 Number of Active Members | f_8_number_of_active_members | number | F-8 Number of Active Members | 0 50 15 28 4 view top 100 |
H-2 Discount Rate | h_2_discount_rate | number | H-2 Discount Rate | 0.07 0.0675 0.0625 0.065 0.0713 view top 100 |
H-4 Long-Term Investment Rate of Return | h_4_long_term_investment | number | H-4 Long-Term Investment Rate of Return | 0.07 0.0675 0.0625 0.065 0.0713 view top 100 |
H-6 Money Weight of Return | h_6_money_weight_of_return | number | H-6 Money Weight of Return | 0.00 0.0625 0.0111 0.036 0.0102 view top 100 |
J-2 Date of Pension Valuation | j_2_date_of_pension_valuation | calendar_date | J-2 Date of Pension Valuation | 2019-07-01T00:00:00.000 2018-07-01T00:00:00.000 2019-01-01T00:00:00.000 2020-01-01T00:00:00.000 2020-07-01T00:00:00.000 view top 100 |
J-16 Covered Payroll | j_16_covered_payroll | number | J-16 Covered Payroll | 0 21293308 3788160 137858 3484630 view top 100 |
J-4 Valuation Method | j_4_valuation_method | text | J-4 Valuation Method | ENTRY_AGE OTHER view top 100 |
J-6 Total Pension Liability of the Plan | j_6_total_pension_liability | number | J-6 Total Pension Liability of the Plan | 15650619 7130123 74594600 988356 76341071 view top 100 |
J-8 Plan Fiduciary Net Position | j_8_plan_fiduciary_net | number | J-8 Plan Fiduciary Net Position | 0 13726322 68532588 3599415 3818289 view top 100 |
J-10 Net Pension Liability | j_10_net_pension_liability | number | J-10 Net Pension Liability | 0 28613045 5020691 89179344 6464563 view top 100 |
J-12 Funded Ratio | j_12_funded_ratio | number | J-12 Funded Ratio | 0.00 0.7844 0.7975 0.341 0.7733 view top 100 |
J-14 Pay As You Go Plan | j_14_pay_as_you_go_plan | checkbox | J-14 Pay As You Go Plan | false true view top 100 |
J-18 Actuarial Determined Employer Contribution (ADEC) | j_18_actuarial_determined | number | J-18 Actuarial Determined Employer Contribution (ADEC) | 0 74000 16703922 610663 512000 view top 100 |
J-20 Employer Contribution Made | j_20_employer_contribution | number | J-20 Employer Contribution Made | 0 1572000 512000 78918 278071 view top 100 |
J-22 Contribution Shortfall (Excess) | j_22_contribution_shortfall | number | J-22 Contribution Shortfall (Excess) | 0 -11100 -34842 -96038 -82000 view top 100 |