About this file

The document is a monthly healthcare detail experience report for the City of Tucson, covering fiscal years 2022-2025, detailing healthcare claims, premiums, and membership data for a Dental PPO and Dental Choice plan. The report provides a comprehensive breakdown of in-network and out-of-network claims, total claims, billed premiums, loss ratios, and subscriber/member counts across multiple fiscal years, with the most recent data extending through July-September 2025. The report indicates a consistent enrollment of approximately 4,500-4,600 subscribers and 9,900-10,300 total members, with monthly claims ranging between $230,000 and $365,000 and billed premiums consistently around $300,000-$325,000.

The healthcare experience report supports the City of Tucson's concurrent Request for Proposal (RFP #260125) for comprehensive healthcare and benefits administration services, which seeks vendors to provide medical, telehealth, pharmacy, wellness, HSA/HRA administration, dental, and Employee Assistance Program (EAP) coverage. The RFP targets services for approximately 4,498 employees and 2,306 retirees, with a July 1, 2026 effective date, and allows vendors to bid on one or more service lines. Minimum bidder requirements include five years of business experience, 10,000 full-service covered members, and three clients with at least 2,000 total members. The current incumbent is Cigna, and the City pays 100% of employee and dependent costs, with an annual wellness incentive of $100 per subscriber. The contract will have an initial one-year term with options to renew for six additional one-year periods.

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
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
260125_Chapter_1A_-_Attachment_Medical_Questionnaires_(MOA_and_QE)-RETURN_WITH_BID.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 58 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

2022-2023

CITY OF TUCSON
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
July 2022 thru June 2023
Funding Type : TRADITIONAL
Rating Type : PROSPECTIVE GUARANTEED COST
Reported Premium: Billed Premium without fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHACCOUNTPRODUCT TYPEIN NETWORKOUT OF NETWORKTOTAL CLAIMSTOTAL HSATotal HSA & CLAIMSBILLED PREMIUMTOTAL LOSS RATIOTOTAL SUBSTOTAL MBRS
Jul-223342685-CITY OF TUCSONDPPO$191,413$57,986$249,399$0$249,399$315,65379.0%4,53410,304
ACCOUNT Total$191,413$57,986$249,399$0$249,399$315,65379.0%4,53410,304
Aug-223342685-CITY OF TUCSONDPPO$258,466$85,210$343,677$0$343,677$314,512109.3%4,52510,281
ACCOUNT Total$258,466$85,210$343,677$0$343,677$314,512109.3%4,52510,281
Sep-223342685-CITY OF TUCSONDPPO$238,158$79,326$317,483$0$317,483$314,546100.9%4,53110,277
ACCOUNT Total$238,158$79,326$317,483$0$317,483$314,546100.9%4,53110,277
Oct-223342685-CITY OF TUCSONDPPO$219,553$64,543$284,096$0$284,096$313,93590.5%4,52810,257
ACCOUNT Total$219,553$64,543$284,096$0$284,096$313,93590.5%4,52810,257
Nov-223342685-CITY OF TUCSONDPPO$201,281$61,140$262,420$0$262,420$311,55684.2%4,53910,261
ACCOUNT Total$201,281$61,140$262,420$0$262,420$311,55684.2%4,53910,261
Dec-223342685-CITY OF TUCSONDPPO$231,592$76,817$308,409$0$308,409$314,19798.2%4,54410,270
ACCOUNT Total$231,592$76,817$308,409$0$308,409$314,19798.2%4,54410,270
Jan-233342685-CITY OF TUCSONDPPO$212,927$53,999$266,926$0$266,926$313,08085.3%4,54410,254
ACCOUNT Total$212,927$53,999$266,926$0$266,926$313,08085.3%4,54410,254
Feb-233342685-CITY OF TUCSONDPPO$191,922$50,859$242,781$0$242,781$311,11878.0%4,52710,197
ACCOUNT Total$191,922$50,859$242,781$0$242,781$311,11878.0%4,52710,197
Mar-233342685-CITY OF TUCSONDPPO$191,357$53,845$245,202$0$245,202$343,45971.4%4,54310,217
ACCOUNT Total$191,357$53,845$245,202$0$245,202$343,45971.4%4,54310,217
Apr-233342685-CITY OF TUCSONDPPO$233,730$53,037$286,767$0$286,767$314,26491.3%4,55310,216
ACCOUNT Total$233,730$53,037$286,767$0$286,767$314,26491.3%4,55310,216
May-233342685-CITY OF TUCSONDPPO$190,233$48,669$238,902$0$238,902$314,37876.0%4,55810,223
ACCOUNT Total$190,233$48,669$238,902$0$238,902$314,37876.0%4,55810,223
Jun-233342685-CITY OF TUCSONDPPO$203,774$52,203$255,978$0$255,978$314,06881.5%4,56310,201
ACCOUNT Total$203,774$52,203$255,978$0$255,978$314,06881.5%4,56310,201
Grand Total$2,564,406$737,633$3,302,039$0$3,302,039$3,794,76687.0%54,489122,958

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

2023-2024

CITY OF TUCSON
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
July 2023 thru June 2024
Funding Type : TRADITIONAL
Rating Type : PROSPECTIVE GUARANTEED COST
Reported Premium: Billed Premium without fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHACCOUNTPRODUCT TYPEIN NETWORKOUT OF NETWORKTOTAL CLAIMSTOTAL HSATotal HSA & CLAIMSBILLED PREMIUMTOTAL LOSS RATIOTOTAL SUBSTOTAL MBRS
Jul-233342685-CITY OF TUCSONDPPO$222,553$60,328$282,882$0$282,882$312,26590.6%4,4639,972
ACCOUNT Total$222,553$60,328$282,882$0$282,882$312,26590.6%4,4639,972
Aug-233342685-CITY OF TUCSONDPPO$283,795$81,344$365,138$0$365,138$307,488118.7%4,4619,948
ACCOUNT Total$283,795$81,344$365,138$0$365,138$307,488118.7%4,4619,948
Sep-233342685-CITY OF TUCSONDPPO$199,448$46,138$245,586$0$245,586$307,24979.9%4,4599,930
ACCOUNT Total$199,448$46,138$245,586$0$245,586$307,24979.9%4,4599,930
Oct-233342685-CITY OF TUCSONDPPO$225,365$61,952$287,316$0$287,316$306,78493.7%4,4629,931
ACCOUNT Total$225,365$61,952$287,316$0$287,316$306,78493.7%4,4629,931
Nov-233342685-CITY OF TUCSONDPPO$217,687$50,306$267,993$0$267,993$305,67787.7%4,4599,931
ACCOUNT Total$217,687$50,306$267,993$0$267,993$305,67787.7%4,4599,931
Dec-233342685-CITY OF TUCSONDPPO$212,022$53,877$265,898$0$265,898$306,76586.7%4,4589,922
ACCOUNT Total$212,022$53,877$265,898$0$265,898$306,76586.7%4,4589,922
Jan-243342685-CITY OF TUCSONDPPO$227,632$47,259$274,892$0$274,892$305,29590.0%4,4619,873
ACCOUNT Total$227,632$47,259$274,892$0$274,892$305,29590.0%4,4619,873
Feb-243342685-CITY OF TUCSONDPPO$209,352$50,077$259,429$0$259,429$306,30684.7%4,4789,911
ACCOUNT Total$209,352$50,077$259,429$0$259,429$306,30684.7%4,4789,911
Mar-243342685-CITY OF TUCSONDPPO$229,802$49,054$278,856$0$278,856$306,50491.0%4,4929,906
ACCOUNT Total$229,802$49,054$278,856$0$278,856$306,50491.0%4,4929,906
Apr-243342685-CITY OF TUCSONDPPO$215,278$37,638$252,916$0$252,916$305,67982.7%4,4839,873
ACCOUNT Total$215,278$37,638$252,916$0$252,916$305,67982.7%4,4839,873
May-243342685-CITY OF TUCSONDPPO$228,852$42,842$271,694$0$271,694$305,14089.0%4,4769,850
ACCOUNT Total$228,852$42,842$271,694$0$271,694$305,14089.0%4,4769,850
Jun-243342685-CITY OF TUCSONDPPO$217,154$40,874$258,028$0$258,028$304,59584.7%4,4669,831
ACCOUNT Total$217,154$40,874$258,028$0$258,028$304,59584.7%4,4669,831
Grand Total$2,688,939$621,688$3,310,627$0$3,310,627$3,679,74890.0%53,618118,878

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

2024-2025

CITY OF TUCSON
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
July 2024 thru June 2025
Funding Type : TRADITIONAL
Rating Type : PROSPECTIVE GUARANTEED COST
Reported Premium: Billed Premium without fees
Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM
Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHACCOUNTPRODUCT TYPEIN NETWORKOUT OF NETWORKTOTAL CLAIMSTOTAL HSATotal HSA & CLAIMSBILLED PREMIUMTOTAL LOSS RATIOTOTAL SUBSTOTAL MBRS
Jul-243342685-CITY OF TUCSONDPPO$243,479$41,610$285,089$0$285,089$325,81987.5%4,57510,099
ACCOUNT Total$243,479$41,610$285,089$0$285,089$325,81987.5%4,57510,099
Aug-243342685-CITY OF TUCSONDPPO$231,194$62,816$294,010$0$294,010$324,58590.6%4,56310,051
ACCOUNT Total$231,194$62,816$294,010$0$294,010$324,58590.6%4,56310,051
Sep-243342685-CITY OF TUCSONDPPO$242,767$48,872$291,640$0$291,640$323,80790.1%4,55710,020
ACCOUNT Total$242,767$48,872$291,640$0$291,640$323,80790.1%4,55710,020
Oct-243342685-CITY OF TUCSONDPPO$276,023$66,092$342,115$0$342,115$323,432105.8%4,5529,999
ACCOUNT Total$276,023$66,092$342,115$0$342,115$323,432105.8%4,5529,999
Nov-243342685-CITY OF TUCSONDPPO$252,198$73,454$325,652$0$325,652$323,871100.5%4,54910,014
ACCOUNT Total$252,198$73,454$325,652$0$325,652$323,871100.5%4,54910,014
Dec-243342685-CITY OF TUCSONDPPO$185,465$39,248$224,712$0$224,712$323,24069.5%4,5439,983
ACCOUNT Total$185,465$39,248$224,712$0$224,712$323,24069.5%4,5439,983
Jan-253342685-CITY OF TUCSONDPPO$216,407$44,215$260,622$0$260,622$323,23980.6%4,5449,993
ACCOUNT Total$216,407$44,215$260,622$0$260,622$323,23980.6%4,5449,993
Feb-253342685-CITY OF TUCSONDPPO$205,200$51,188$256,389$0$256,389$322,39279.5%4,5399,960
ACCOUNT Total$205,200$51,188$256,389$0$256,389$322,39279.5%4,5399,960
Mar-253342685-CITY OF TUCSONDPPO$209,384$56,077$265,461$0$265,461$321,30982.6%4,5319,929
ACCOUNT Total$209,384$56,077$265,461$0$265,461$321,30982.6%4,5319,929
Apr-253342685-CITY OF TUCSONDPPO$189,291$60,952$250,243$0$250,243$322,30577.6%4,5509,943
ACCOUNT Total$189,291$60,952$250,243$0$250,243$322,30577.6%4,5509,943
May-253342685-CITY OF TUCSONDPPO$233,348$40,791$274,139$0$274,139$322,84384.9%4,5639,954
ACCOUNT Total$233,348$40,791$274,139$0$274,139$322,84384.9%4,5639,954
Jun-253342685-CITY OF TUCSONDPPO$182,104$49,468$231,573$0$231,573$321,80472.0%4,5569,913
ACCOUNT Total$182,104$49,468$231,573$0$231,573$321,80472.0%4,5569,913
Grand Total$2,666,861$634,783$3,301,644$0$3,301,644$3,878,64685.1%54,622119,858

&R &8Page &P of &N Date: 7/5/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.

Jul-Sept 2025

CITY OF TUCSON
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
July 2025 thru September 2025
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Account : 3342685-CITY OF TUCSON
Reported Premium: Billed Pooled Premium, ASO Fees
Reported Claims: All Claims, All HRA, Debit, Clms Fwrd, Check, ATM
Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHBENEFIT OPTIONFIXED CHARGESIN NETWORKOUT OF NETWORKCOST CONTAINCLASURCHARGEDRUGGROSS CLAIMSSTOP LOSSPPACA FEESSTATE ASSESSMENTSINCENTIVESNET CLAIMSHRA FUNDTOTAL HRA & CLAIMSHSA FUNDTOTAL HSA & CLAIMSPOOLED PREMIUMTOTAL ASO FEESTOTAL SUBSTOTAL MBRS
Jul-25DENT1-CIGNA DENTAL CHOICE TEXAS$0$750$1,582$21$0$0$0$2,353$0$0$0$0$2,353$0$2,353$0$2,353$0$000
DPP1-DENTAL PPO FOR AZ$0$164,998$40,483$4,090$0$0$0$209,571$0$0$0$0$209,571$0$209,571$0$209,571$0$12,2244,4469,730
DPP5-DENTAL PPO ALL OTHER STATES$0$3,762$3,099$215$0$0$0$7,076$0$0$0$0$7,076$0$7,076$0$7,076$0$534194326
$0$169,510$45,164$4,326$0$0$0$219,001$0$0$0$0$219,001$0$219,001$0$219,001$0$12,757464010056
Aug-25DENT1-CIGNA DENTAL CHOICE TEXAS$0$292$0$36$0$0$0$328$0$0$0$0$328$0$328$0$328$0$000
DPP1-DENTAL PPO FOR AZ$0$265,190$54,847$7,849$0$0$0$327,886$0$0$0$0$327,886$0$327,886$0$327,886$0$12,1944,4359,684
DPP5-DENTAL PPO ALL OTHER STATES$0$3,554$6,607$256$0$0$0$10,417$0$0$0$0$10,417$0$10,417$0$10,417$0$550200337
$0$269,037$61,454$8,141$0$0$0$338,631$0$0$0$0$338,631$0$338,631$0$338,631$0$12,7444,63510,021
Sep-25DPP1-DENTAL PPO FOR AZ$0$208,167$48,522$8,821$0$0$0$265,510$0$0$0$0$265,510$0$265,510$0$265,510$0$12,1994,4379,676
DPP5-DENTAL PPO ALL OTHER STATES$0$4,534$4,424$181$0$0$0$9,139$0$0$0$0$9,139$0$9,139$0$9,139$0$553201336
$0$212,701$52,946$9,001$0$0$0$274,649$0$0$0$0$274,649$0$274,649$0$274,649$0$12,7524,63810,012
BENEFIT OPTION TotalsDENT1-CIGNA DENTAL CHOICE TEXAS$0$1,042$1,582$57$0$0$0$2,681$0$0$0$0$2,681$0$2,681$0$2,681$0$000
DPP1-DENTAL PPO FOR AZ$0$638,356$143,852$20,760$0$0$0$802,967$0$0$0$0$802,967$0$802,967$0$802,967$0$36,6161331829090
DPP5-DENTAL PPO ALL OTHER STATES$0$11,850$14,130$651$0$0$0$26,632$0$0$0$0$26,632$0$26,632$0$26,632$0$1,636595999
Grand Total$0$651,248$159,564$21,468$0$0$0$832,281$0$0$0$0$832,281$0$832,281$0$832,281$0$38,2531391330089

&R &8Page &P of &N Date: 10/5/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 .