260125_10312025_COT_FI_Enrollment_by_tier_DHMO_DPPO_2022_to_2025.xls

XLS spreadsheet 53 KB Posted

Attached to
Medical/Telehealth/Pharmacy, Wellness, Health Savings Account (HSA) and Health Reimbursement Arrangement (HRA) Administration, Dental, and Employee Assistance Program (EAP) Coverage
Solicitation number
260125
Issued by
Pima County, Tucson City, Arizona

About this file

The file is a monthly enrollment spreadsheet for dental insurance plans for the City of Tucson, covering the period from October 2022 to September 2025. The document details enrollment across multiple dental plan types, including Cigna Dental Choice Texas, Dental HMO (DHMO), Dental PPO for Arizona (DPPO), Dental PPO for All Other States, and a new Dental PPO for Montana added in July 2024. The spreadsheet tracks monthly enrollment by coverage tier (Employee Only, Two Party, and Employee + Family) for each dental plan option, showing consistent fluctuations in enrollment numbers across different months and years.

The enrollment data reveals that the Dental PPO for Arizona consistently has the highest enrollment, ranging from approximately 4,270 to 4,386 total members throughout the contract period. The Dental HMO plan shows gradual growth from around 1,622 members in October 2022 to a peak of 1,869 members in November 2023, before stabilizing around 1,800 members. The total enrollment across all dental plans remains relatively stable, hovering between 6,158 and 6,420 members throughout the documented period. This enrollment spreadsheet appears to be supporting documentation for the City of Tucson's ongoing dental insurance contract, providing detailed membership tracking for potential future procurement decisions.

View the file

Other files

File Type Posted
Medical_Telehealth_Pharmacy,_Wellness,_Health_Savings_Account_(HSA)_and_Health_Reimbursement_Arrangement_(HRA)_Administration,_Dental,_and_Employee_Assistance_Program_(EAP)_Coverage_(Addendum_#4_R.pdf PDF
260125_Dental_Addendum_11042025.docx DOCX document
260125_Chapter_1E_-_Amendment_Attachment_-_DHMO_Questionnaires_(MOA)_&_Disruption-11.04.2025_RETURN_WITH_BID.xlsx XLSX spreadsheet
REVISED_260125_Chapter_1E_-_Dental_Cost_Proposal-RETURN_WITH_BID-11.04.2025.xlsx XLSX spreadsheet
260125_10312025_City_of_Tucson_DHMO_Report_23-24.ppt PPT presentation
260125_10312025_City_of_Tucson_DHMO_Report_Jan23-June23.ppt PPT presentation
260125_10312025_2025-09_City_of_Tucson_Rolling_36_Claims_and_Enrollment.pdf PDF
260125_10312025_COT_DPPO_Enrollment_by_Tier_7.1.2025_to_10.1.2025.xls XLS spreadsheet
260125_10312025_COT_FI_Enrollment_by_tier_DHMO_DPPO_2022_to_2025.xls XLS spreadsheet
260125_10312025_COT_Monthly_Experience_2022-2025.xls XLS spreadsheet
Medical_Telehealth_Pharmacy,_Wellness,_Health_Savings_Account_(HSA)_and_Health_Reimbursement_Arrangement_(HRA)_Administration,_Dental,_and_Employee_Assistance_Program_(EAP)_Coverage_(Addendum_#2_R.pdf PDF
260125_Chapter_1B_-_PBM_Cost_Proposal-REVISED-RETURN_WITH_BID.xlsx XLSX spreadsheet
Medical_Telehealth_Pharmacy,_Wellness,_Health_Savings_Account_(HSA)_and_Health_Reimbursement_Arrangement_(HRA)_Administration,_Dental,_and_Employee_Assistance_Program_(EAP)_Coverage.pdf PDF
260125_Business_Associate_Agreement_Template.docx DOCX document
REQUEST_FOR_CONFIDENTIAL_DOCUMENTS_FORM_260125.pdf PDF
260125_Chapter_1A_-_Medical_HRA_Plan_Booklet_FY25_(SPD)_-_Retiree.pdf PDF
260125_Chapter_1B_-_PBM_Standard-4-Tier_PDL_(2025).pdf PDF
260125_Chapter_1E_-_CIGNA_OHIP_Flyer_COT.pdf PDF
260125_Chapter_1E_-_Dental_3342685_City_of_Tucson_07.01.2025_AZ_and_CA_members.pdf PDF
260125_Chapter_1E_-_Dental_Technical_Workbook-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1E_-_Dental_COT_PPO_Summary_-_AZ.pdf PDF
260125_Chapter_1D_-_EAP_Utilization.pdf PDF
260125_Chapter_1A_-_Medical_HSA_Plan_Booklet_FY25_(SPD)_-_Employees.pdf PDF
260125_Chapter_1E_-_Dental_COT_HMO_Patient_Change_Schedule_W1SV9_AZ.pdf PDF
260125_Chapter_1B_-_PBM_Standard-4-Tier_PDL_(Jan_2026).pdf PDF
260125_Chapter_1E_-_Dental_Cost_Proposal-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1B_-_PBM_Cost_Proposal-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1D_-_EAP_Cost_Proposal-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1A_-_Medical_Your_Call_Firefighter_Program_Flyer.pdf PDF
260125_Chapter_1E_-_Dental_COT_PPO_Summary_-_All_Other_States_FY26.pdf PDF
260125_Chapter_1A_-_Medical_Plan_changes_eff_7-1-25.pptx PPTX presentation
260125_Chapter_1A_-_Medical_HRA_Plan_Booklet_FY25_(SPD)_-_Employees.pdf PDF
260125_Chapter_1B_-_PBM_Benefit_Design.docx DOCX document
260125_Chapter_1C_-_Wellness_COT_Incentives_Redeemed.xls XLS spreadsheet
260125_Chapter_1C_-_Welllness_COT_Incentives_Earned.xlsx XLSX spreadsheet
260125_Chapter_1E_-_Dental_Scope_of_Work.docx DOCX document
260125_Chapter_1D_-_EAP_Scope_of_Work.docx DOCX document
260125_Chapter_1A_-_Medical_Network_Plan_Booklet_FY25_(SPD)_-_Employee.pdf PDF
260125_Chapter_1A_-_Medical_Network_Plan_Booklet_FY25_(SPD)_-_Retiree.pdf PDF
260125_Chapter_1B_-_PBM_Scope_of_Work.docx DOCX document
260125_Chapter_1D_-_Attachment_EAP_Questionnaires_(MOA_and_QE)-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1A_-_Medical_HSA_Plan_Booklet_FY25_(SPD)_-_Retiree.pdf PDF
260125_Chapter_1E_-_Attachment_-_Dental_Questionnaires_(MOA_and_QE)-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1C_-_Attachment_Wellness_Questionnaires_(MOA_and_QE)-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1A_-_Medical_Pricebook-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1C_-_Wellness_Cost_Proposal-RETURN_WITH_BID.xlsx XLSX spreadsheet
260125_Chapter_1C_-_Wellness_Scope_of_Work.docx DOCX document
260125_Chapter_1B_-_Attachment_PBM_Questionnaires_(MOA_and_QE)-RETURN_WITH_BID.xlsx XLSX spreadsheet
IMPORTANT_NOTE-Attachment_A_Request_for_Confidential_Documents_Form.pdf PDF
260125_Chapter_1A_-_Medical_Scope_of_Work.docx DOCX document
Show 40 more

Latest 50 of 59 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Report-1

CITY OF TUCSON
TRADITIONAL ENROLLMENT BY RATE TIER
October 2022 thru September 2025
Funding Type : MINIMUM PREMIUM, N/A, TRADITIONAL
Rating Type : N/A, PROSPECTIVE GUARANTEED COST, RETROSPECTIVE EXPERIENCE RATED
YTD/MONTHBENEFIT OPTIONEMPLOYEE ONLYTWO PARTYEMPLOYEE + FAMILYEMPLOYEE TOTAL
Oct-22DENT-CIGNA DENTAL CHOICE TEXAS65011
DHMO-DENTAL HMO8104763361,622
DPPO-DENTAL PPO FOR AZ1,6531,3201,3864,359
DPPO5-DENTAL PPO ALL OTHER STATES866317166
Oct-2022 Total2,5551,8641,7396,158
Nov-22DENT-CIGNA DENTAL CHOICE TEXAS65011
DHMO-DENTAL HMO8214763371,634
DPPO-DENTAL PPO FOR AZ1,6681,3221,3824,372
DPPO5-DENTAL PPO ALL OTHER STATES876317167
Nov-2022 Total2,5821,8661,7366,184
Dec-22DENT-CIGNA DENTAL CHOICE TEXAS65011
DHMO-DENTAL HMO8324733441,649
DPPO-DENTAL PPO FOR AZ1,6681,3241,3834,375
DPPO5-DENTAL PPO ALL OTHER STATES866416166
Dec-2022 Total2,5921,8661,7436,201
Jan-23DENT-CIGNA DENTAL CHOICE TEXAS65011
DHMO-DENTAL HMO8294743471,650
DPPO-DENTAL PPO FOR AZ1,6651,3131,3814,359
DPPO5-DENTAL PPO ALL OTHER STATES866216164
Jan-2023 Total2,5861,8541,7446,184
Feb-23DHMO-DENTAL HMO8374693461,652
DPPO-DENTAL PPO FOR AZ1,6611,3101,3704,341
DPPO5-DENTAL PPO ALL OTHER STATES927015177
Feb-2023 Total2,5901,8491,7316,170
Mar-23DHMO-DENTAL HMO8534693471,669
DPPO-DENTAL PPO FOR AZ1,6711,3101,3744,355
DPPO5-DENTAL PPO ALL OTHER STATES936916178
Mar-2023 Total2,6171,8481,7376,202
Apr-23DHMO-DENTAL HMO8684693481,685
DPPO-DENTAL PPO FOR AZ1,6801,3121,3724,364
DPPO5-DENTAL PPO ALL OTHER STATES956916180
Apr-2023 Total2,6431,8501,7366,229
May-23DHMO-DENTAL HMO8754683541,697
DPPO-DENTAL PPO FOR AZ1,6831,3001,3604,343
DPPO5-DENTAL PPO ALL OTHER STATES967016182
May-2023 Total2,6541,8381,7306,222
Jun-23DHMO-DENTAL HMO8844723641,720
DPPO-DENTAL PPO FOR AZ1,6971,3101,3644,371
DPPO5-DENTAL PPO ALL OTHER STATES966916181
Jun-2023 Total2,6771,8511,7446,272
Jul-23DHMO-DENTAL HMO9125064131,831
DPPO-DENTAL PPO FOR AZ1,6721,2831,3304,285
DPPO5-DENTAL PPO ALL OTHER STATES946916179
Jul-2023 Total2,6781,8581,7596,295
Aug-23DHMO-DENTAL HMO9095094141,832
DPPO-DENTAL PPO FOR AZ1,6691,2811,3224,272
DPPO5-DENTAL PPO ALL OTHER STATES946916179
Aug-2023 Total2,6721,8591,7526,283
Sep-23DHMO-DENTAL HMO9165084201,844
DPPO-DENTAL PPO FOR AZ1,6751,2791,3174,271
DPPO5-DENTAL PPO ALL OTHER STATES937016179
Sep-2023 Total2,6841,8571,7536,294
Oct-23DHMO-DENTAL HMO9235184141,855
DPPO-DENTAL PPO FOR AZ1,6781,2761,3224,276
DPPO5-DENTAL PPO ALL OTHER STATES936915177
Oct-2023 Total2,6941,8631,7516,308
Nov-23DHMO-DENTAL HMO9365154181,869
DPPO-DENTAL PPO FOR AZ1,6751,2721,3264,273
DPPO5-DENTAL PPO ALL OTHER STATES926916177
Nov-2023 Total2,7031,8561,7606,319
Dec-23DHMO-DENTAL HMO9335164131,862
DPPO-DENTAL PPO FOR AZ1,6761,2711,3254,272
DPPO5-DENTAL PPO ALL OTHER STATES916917177
Dec-2023 Total2,7001,8561,7556,311
Jan-24DHMO-DENTAL HMO9505024111,863
DPPO-DENTAL PPO FOR AZ1,6951,2671,3124,274
DPPO5-DENTAL PPO ALL OTHER STATES917018179
Jan-2024 Total2,7361,8391,7416,316
Feb-24DHMO-DENTAL HMO9575034121,872
DPPO-DENTAL PPO FOR AZ1,7031,2681,3174,288
DPPO5-DENTAL PPO ALL OTHER STATES907218180
Feb-2024 Total2,7501,8431,7476,340
Mar-24DHMO-DENTAL HMO9825014141,897
DPPO-DENTAL PPO FOR AZ1,7231,2671,3124,302
DPPO5-DENTAL PPO ALL OTHER STATES907318181
Mar-2024 Total2,7951,8411,7446,380
Apr-24DHMO-DENTAL HMO9855004151,900
DPPO-DENTAL PPO FOR AZ1,7191,2651,3064,290
DPPO5-DENTAL PPO ALL OTHER STATES937218183
Apr-2024 Total2,7971,8371,7396,373
May-24DHMO-DENTAL HMO9985014201,919
DPPO-DENTAL PPO FOR AZ1,7151,2651,3024,282
DPPO5-DENTAL PPO ALL OTHER STATES957118184
May-2024 Total2,8081,8371,7406,385
Jun-24DHMO-DENTAL HMO9935014221,916
DPPO-DENTAL PPO FOR AZ1,7061,2641,3004,270
DPPO5-DENTAL PPO ALL OTHER STATES967119186
Jun-2024 Total2,7951,8361,7416,372
Jul-24DHMO-DENTAL HMO9404804071,827
DPPO-DENTAL PPO FOR AZ1,7331,3111,3424,386
DPPO5-DENTAL PPO ALL OTHER STATES947017181
DPPO6-DENTAL PPO FOR MT1023
Jul-2024 Total2,7681,8611,7686,397
Aug-24DHMO-DENTAL HMO9324814091,822
DPPO-DENTAL PPO FOR AZ1,7331,3051,3364,374
DPPO5-DENTAL PPO ALL OTHER STATES947016180
DPPO6-DENTAL PPO FOR MT1023
Aug-2024 Total2,7601,8561,7636,379
Sep-24DHMO-DENTAL HMO9374784091,824
DPPO-DENTAL PPO FOR AZ1,7381,3021,3294,369
DPPO5-DENTAL PPO ALL OTHER STATES937116180
DPPO6-DENTAL PPO FOR MT1023
Sep-2024 Total2,7691,8511,7566,376
Oct-24DHMO-DENTAL HMO9374774021,816
DPPO-DENTAL PPO FOR AZ1,7361,3001,3274,363
DPPO5-DENTAL PPO ALL OTHER STATES937216181
DPPO6-DENTAL PPO FOR MT1023
Oct-2024 Total2,7671,8491,7476,363
Nov-24DHMO-DENTAL HMO9424764021,820
DPPO-DENTAL PPO FOR AZ1,7221,3071,3314,360
DPPO5-DENTAL PPO ALL OTHER STATES927216180
DPPO6-DENTAL PPO FOR MT2024
Nov-2024 Total2,7581,8551,7516,364
Dec-24DHMO-DENTAL HMO9314774041,812
DPPO-DENTAL PPO FOR AZ1,7241,3021,3274,353
DPPO5-DENTAL PPO ALL OTHER STATES937415182
DPPO6-DENTAL PPO FOR MT3025
Dec-2024 Total2,7511,8531,7486,352
Jan-25DHMO-DENTAL HMO9384794011,818
DPPO-DENTAL PPO FOR AZ1,7221,3031,3274,352
DPPO5-DENTAL PPO ALL OTHER STATES957315183
DPPO6-DENTAL PPO FOR MT1124
Jan-2025 Total2,7561,8561,7456,357
Feb-25DHMO-DENTAL HMO9404733941,807
DPPO-DENTAL PPO FOR AZ1,7221,3091,3154,346
DPPO5-DENTAL PPO ALL OTHER STATES967315184
DPPO6-DENTAL PPO FOR MT1124
Feb-2025 Total2,7591,8561,7266,341
Mar-25DHMO-DENTAL HMO9454734021,820
DPPO-DENTAL PPO FOR AZ1,7281,3001,3104,338
DPPO5-DENTAL PPO ALL OTHER STATES967315184
DPPO6-DENTAL PPO FOR MT1023
Mar-2025 Total2,7701,8461,7296,345
Apr-25DHMO-DENTAL HMO9624754041,841
DPPO-CANCEL - DENTAL PPO FOR AZ2406
DPPO-DENTAL PPO FOR AZ1,7441,3031,3064,353
DPPO5-DENTAL PPO ALL OTHER STATES997316188
DPPO6-DENTAL PPO FOR MT1023
Apr-2025 Total2,8081,8551,7286,391
May-25DHMO-DENTAL HMO9734804031,856
DPPO-CANCEL - DENTAL PPO FOR AZ(1)4(1)2
DPPO-DENTAL PPO FOR AZ1,7571,3101,3044,371
DPPO5-DENTAL PPO ALL OTHER STATES977316186
DPPO6-DENTAL PPO FOR MT2024
May-2025 Total2,8281,8671,7246,419
Jun-25DHMO-DENTAL HMO9794804031,862
DPPO-CANCEL - DENTAL PPO FOR AZ(7)3(4)(8)
DPPO-DENTAL PPO FOR AZ1,7671,3111,2984,376
DPPO5-CANCEL - DENTAL PPO ALL OTHER STATES1(1)00
DPPO5-DENTAL PPO ALL OTHER STATES977316186
DPPO6-DENTAL PPO FOR MT2024
Jun-2025 Total2,8391,8661,7156,420
Jul-25DHMO-DENTAL HMO8934824201,795
Jul-2025 Total8934824201,795
Aug-25DHMO-DENTAL HMO8904804181,788
Aug-2025 Total8904804181,788
Sep-25DHMO-DENTAL HMO8964784141,788
Sep-2025 Total8964784141,788
BENEFIT OPTION TotalsDENT-CIGNA DENTAL CHOICE TEXAS2420044
DHMO-DENTAL HMO33,03817,49514,20164,734
DPPO5-CANCEL - DENTAL PPO ALL OTHER STATES1(1)00
DPPO5-DENTAL PPO ALL OTHER STATES3,0682,3105395,917
DPPO6-DENTAL PPO FOR MT1722443
DPPO-CANCEL - DENTAL PPO FOR AZ(6)11(5)0
DPPO-DENTAL PPO FOR AZ56,17842,74244,015142,935
Grand Total92,32062,57958,774213,673

&R &8Page &P of &N Date: 10/24/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.

File details come from the government source that posted it. Updated .