ESBD_398114_1740251854848_F022710 LTD Claims Status Report 10.1.2019-12.30.2024.xlsx

XLSX spreadsheet 102 KB Posted

Attached to
Life and Disability Plans
Solicitation number
RFP2025-015
Issued by
Henderson County, Texas

About this file

This is a Long-Term Disability (LTD) claims status report for the City of Waco, covering the period from October 1, 2019, to December 30, 2024. The report details 12 LTD claims filed by full-time City of Waco employees, tracking their status, benefit amounts, and claim durations. Of these claims, four are closed, three were denied, two are pending, two are approved, and one resulted in death. The claims are administered by Dearborn Life Insurance Company, operating as Blue Cross and Blue Shield of Texas.

The total benefits paid across all claims amount to $287,472.46, with individual claim payments ranging from $0 to $117,517.07. The highest monthly benefit amount was $4,044.56, while the ages of claimants ranged from 30 to 69 years old. Denials were due to various reasons including pre-existing conditions, failure to provide required information, and eligibility issues. Currently active claims include two approved cases with benefit periods extending to March 2025 and November 2034, respectively.

View the file

Other files

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

Claim Status Report_Excel

Claim Status Report for CITY OF WACO

Group Number:F022710
Line of Coverage:ALL
From Date:10/01/2019
To Date:12/30/2024
Data as of Date:12/28/2024
EmployeeEligibilityClaimBenefitClaimLatestAgeLast DateMaxClaimantEmployerPhysicianRequired
AccountAccount NameLocationProduct TypeCoverageProductEmployeeEligibilityClassClaimStatusStatus ReasonReceivedBeginApprovedBenefitTotal PaidPaymentatofEvent DateDurationStatementStatementStatementInformation
NumberDescriptionTypeIDClassDescriptionNumberDateDateThroughAmountDateEventWorkDateRec'dRec'dRec'dCompleted
NumberDateDate
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-49772ClosedOther05/13/202011/01/202010/31/2022$2,625.76$61,862.6809/09/20224005/04/202005/05/202005/17/204605/13/202005/13/202005/14/202005/14/2020
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-71552DeniedPre-existing Condition02/03/202107/06/2021$1,716.78$0.004001/03/202101/07/202107/16/204702/03/202102/03/202102/03/202102/03/2021
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-70336ClosedReturn to Work02/04/202106/04/202110/13/2021$1,712.88$6,368.1510/22/20213212/06/202012/06/202004/06/205501/20/202101/20/202101/20/202101/20/2021
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-109117ClosedAdvance Pay & Close04/19/202210/18/202211/10/2022$2,221.31$592.3512/14/20225104/20/202204/21/202211/14/203704/19/202204/19/202204/19/202204/21/2022
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-269459Pending07/03/202409/09/2024$4,044.56$0.006903/12/202403/13/202409/08/202507/17/202407/03/202407/03/202407/17/2024
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-129379DeniedFailure to Provide Required12/19/202205/25/2023$1,798.16$0.004911/23/202211/26/202206/21/204012/19/202212/19/202212/19/202212/19/2022
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-109956ClosedDeath04/29/202208/25/202203/11/2024$3,890.00$21,239.8004/24/20245502/25/202202/26/202209/15/203304/29/202204/29/202204/29/202204/29/2022
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-39012DeniedEligibility For Coverage Not Satisfied12/04/2019$0.00$0.005806/24/201906/25/201910/20/202712/04/201912/10/201912/19/201912/19/2019
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-64255ClosedOther11/04/202004/27/202104/26/2023$1,352.00$31,606.7603/13/20233210/28/202010/29/202002/24/205511/09/202011/06/202011/04/202011/09/2020
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-294109Pending12/10/202402/04/2024$0.00$0.003008/08/202308/08/202304/26/206012/10/202412/10/202412/10/202412/10/2024
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-70456Approved01/21/202110/19/202011/04/2034$3,615.97$117,517.0712/18/20245204/19/202004/22/202011/04/203401/21/202101/21/202101/21/202101/21/2021
1CITY OF WACOLTDLTDLong Term Disability1All Full-time EEsGDC-72192Approved02/10/202108/02/202103/01/2025$2,004.52$48,285.6512/02/20245302/02/202102/03/202101/05/203502/10/202102/10/202102/10/202102/10/2021

Insurance products issued by Dearborn Life Insurance Company, 701 E. 22nd St. Suite 300, Lombard, IL 60148. Blue Cross and Blue Shield of Texas is the trade name of Dearborn Life Insurance Company, an independent licensee of the Blue Cross and Blue Shield Association. BLUE CROSS®, BLUE SHIELD® and the Cross and Shield Symbols are registered service marks of the Blue Cross and Blue Shield Association, an association of independent Blue Cross and Blue Shield Plans.

image1.jpeg

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