Municipal Fiscal Indicators: Other Post-Employment Benefits (OPEB), 2019
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). The data contained in Indicators provides key financial and demographic information on municipalities in Connecticut. Municipal Fiscal Indicators contains the most current financial data available for each of Connecticut's 169 municipalities. 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. This database of information includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition. The most recent edition is for the Fiscal Years Ended 2015-2019 published in April 2021. Other Post-Employment Benefits (OPEB) for 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. Data on the Municipal Fiscal Indicators is included in the following datasets: Municipal Fiscal Indicators, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-2019/sb4i-6vik Municipal Fiscal Indicators: Grand List Components, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Grand-List-Components-/ifrb-kp2b Municipal Fiscal Indicators: Pension Funding Information For Defined Benefit Pension Plans, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Pension-Funding-Inform/civu-w22d Municipal Fiscal Indicators: Type and Number of Pension Plans, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Type-and-Number-of-Pen/9f65-c4yr Municipal Fiscal Indicators: Other Post-Employment Benefits (OPEB), 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Other-Post-Employment-/sa26-46h8 Municipal Fiscal Indicators: Economic and Grand List Data, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Economic-and-Grand-Lis/wpbp-b657 Municipal Fiscal Indicators: Benchmark Labor Data, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Benchmark-Labor-Data-2/db37-h23r Municipal Fiscal Indicators: Unemployment, 2019 https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Unemployment-2019/cugp-2za3
This dataset has the following 35 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Year | year | text | Year | 2019 view top 100 |
Town | town | text | Town | FAIRFIELD EAST HAVEN WEST HAVEN ROCKY HILL THOMASTON view top 100 |
Plan Name | plan_name | text | Plan Name | Bethany Public Schools OPEB Plan Hartford OPEB Plan - City Employees Town of Trumbull OPEB Plan City of New London OPEB Plan Town of Ledyard OPEB Plan view top 100 |
Date of Actuarial Valuation | date_of_actuarial_valuation | calendar_date | Date of Actuarial Valuation | 2018-07-01T00:00:00.000 2017-07-01T00:00:00.000 2018-06-30T00:00:00.000 2019-06-30T00:00:00.000 2017-06-30T00:00:00.000 view top 100 |
Total OPEB Liability | total_opeb_liability | number | Total OPEB Liability | 972380.00 19777856.00 46250480.00 138039.00 2778991.00 view top 100 |
Plan Fiduciary Net Positon | plan_fiduciary_net_positon | number | Plan Fiduciary Net Positon | 0.00 35912836.00 50971.00 15809000.00 7129000.00 view top 100 |
ADEC | adec | number | ADEC | 0.00 4965000.00 458274.00 5485000.00 30154000.00 view top 100 |
Employer Contribution | employer_contribution | number | Employer Contribution | 0.00 3404996.00 12297000.00 4367945.00 9017976.00 view top 100 |
Number of Members | no_of_members | number | Number of Members | 31.00 54.00 327.00 363.00 42.00 view top 100 |
Volunteer | volunteer | checkbox | Volunteer | false true view top 100 |
All Groups | all_groups | checkbox | All Groups | true false view top 100 |
Genl Town Group | genl_town_group | checkbox | Genl Town Group | false true view top 100 |
Police Group | police_group | checkbox | Police Group | false true view top 100 |
Fire Group | fire_group | checkbox | Fire Group | false true view top 100 |
Teachers | teachers | checkbox | Teachers | false true view top 100 |
Non Certified Ed Group | non_certified_ed_group | checkbox | Non Certified Ed Group | false true view top 100 |
Other Description | other_description | text | Other Description | administrators Department of Public Works view top 100 |
Other Group | other_group | checkbox | Other Group | false true view top 100 |
Pay As You Go | pay_as_you_go | checkbox | Pay As You Go | true false view top 100 |
Investment Rate of Return | investment_rate_of_return | number | Investment Rate of Return | 0.00 3.51 6.50 6.75 7.00 view top 100 |
Discount Rate | discount_rate | number | Discount Rate | 3.51 3.50 6.50 3.87 7.00 view top 100 |
Money Weight of Return | money_weight_of_return | number | Money Weight of Return | 0.00 6.11 5.31 3.52 6.81 view top 100 |
Entry Age Method | entry_age_method | checkbox | Entry Age Method | true false view top 100 |
Covered Payroll | covered_payroll | number | Covered Payroll | 0.00 3285752.00 46133025.00 1096915.00 198787331.00 view top 100 |
Footnotes | footnotes | text | Footnotes | view top 100 |
Trust or Equivalent | trust_or_equivalent | checkbox | Trust or Equivalent | false true view top 100 |
Healthcare | healthcare | checkbox | Healthcare | true false view top 100 |
Insurance | insurance | checkbox | Insurance | false true view top 100 |
Other OPEB | other_opeb | checkbox | Other OPEB | false true view top 100 |
Description Other OPEB | description_other_opeb | text | Description Other OPEB | Real Estate/Motor Vehicle Prop view top 100 |
Comments | comments | text | Comments | 1/6/20--JG does not see where L/T Investment ROR is listed. 1/6/20--JG does not see where L/T Investment ROR is listed. NOTE: Used covered payroll figure fro BOE Plan--Covered payroll is from p. 78. Entry Age--RSI--Note 5, page 101. Healthcare Cost Trend Rate--Left blank because percent varies by category. view top 100 |
Closed | closed | checkbox | Closed | false true view top 100 |
Alternative Method | alternative_method | checkbox | Alternative Method | false true view top 100 |
Current Year Healthcare Trend Rate | current_year_healthcare_trend | number | Current Year Healthcare Trend Rate | 7.00 0.00 7.50 8.00 6.50 view top 100 |
Projected Healthcare Trend Rate | projected_healthcare_trend | number | Projected Healthcare Trend Rate | 4.60 4.50 0.00 4.75 4.40 view top 100 |