ESBD_398114_1740251881456_F022710 STD Claims Status Report 10.1.2021-12.30.2024.xlsx

XLSX spreadsheet 107 KB Posted

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

About this file

This is a Short Term Disability (STD) claims status report for the City of Waco covering the period from October 1, 2021, to December 30, 2024. The report details 44 STD claims processed through Dearborn Life Insurance Company (operating as Blue Cross and Blue Shield of Texas), tracking various claim statuses including approved, denied, closed, and pending cases. The claims are categorized under different employee eligibility classes including "All Full-time EEs" and "AAFT ELECTING" with benefit levels of $500 and $750.

The report shows various claim outcomes with total payments ranging from $0 to $13,000 per claim. Common denial reasons included pre-existing conditions, failure to provide required information, and work-related conditions. Successful claims were typically closed due to return to work, maximum duration of benefits reached, or advance pay and close. The average benefit amounts varied significantly, with weekly benefits typically ranging from $445 to $750. The data includes detailed tracking of claim receipt dates, benefit begin dates, approval dates, and claim completion dates for each case.

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/2021
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 WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-181590ClosedAdvance Pay & Close05/10/202304/08/202305/19/2023$500.00$3,000.0005/18/20233203/24/202303/25/202310/06/202305/10/202305/10/202305/10/202305/10/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-268626ClosedAdvance Pay & Close06/25/202406/07/202407/05/2024$545.72$2,260.8407/17/20243305/23/202405/24/202412/05/202406/25/202406/25/202406/25/202406/25/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-221820DeniedPre-existing Condition12/26/202301/06/2024$705.60$0.005812/10/202312/11/202307/05/202412/26/202301/11/202412/26/202301/11/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability3AAFT ELECTING $500GDC-270377DeniedPre-existing Condition07/16/202407/06/2024$500.00$0.005805/17/202405/18/202401/03/202509/26/202407/16/202407/16/202409/03/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-264129DeniedPre-existing Condition05/03/202405/23/2024$467.32$0.006605/05/202405/09/202411/20/202405/03/202405/03/202405/03/202405/21/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability2AAFT ELECTING $750GDC-273449DeniedPre-existing Condition08/19/202408/15/2024$711.20$0.004807/19/202407/22/202402/12/202508/19/202409/10/202408/23/202409/10/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-206958ClosedReturn to Work10/31/202311/16/202302/04/2024$645.40$7,468.2002/05/20243611/02/202311/02/202305/15/202410/31/202310/31/202310/31/202311/02/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-202447ClosedReturn to Work09/12/202308/22/202310/16/2023$677.87$5,422.9611/13/20235208/07/202308/08/202302/19/202409/12/202309/18/202309/12/202309/18/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-90486ClosedAdvance Pay & Close09/16/202109/06/202109/19/2021$500.00$1,000.0010/08/20213608/22/202108/23/202103/06/202209/16/202109/16/202109/16/202109/16/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-96040ClosedReturn to Work11/16/202111/24/202101/09/2022$500.00$3,357.1401/10/20225111/10/202111/10/202105/24/202212/03/202111/16/202111/18/202112/03/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-109891ClosedReturn to Work04/29/202205/06/202206/05/2022$500.00$2,214.2906/06/20225604/21/202204/22/202211/03/202204/29/202204/29/202204/29/202204/29/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-198192ClosedReturn to Work07/27/202307/04/202307/23/2023$750.00$0.005306/19/202306/20/202301/01/202409/11/202309/11/202307/27/202309/11/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-220289ClosedReturn to Work12/05/202310/10/202311/06/2023$750.00$3,000.0012/14/20235309/25/202309/26/202304/08/202412/05/202312/05/202312/05/202312/05/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-90215ClosedReturn to Work09/13/202109/15/202101/31/2022$500.00$9,928.5702/16/20225908/10/202108/11/202103/15/202209/13/202109/16/202109/13/202109/16/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-109117ClosedMaximum Duration of Benefits04/19/202205/05/202211/02/2022$500.00$13,000.0011/02/20225104/20/202204/21/202211/02/202204/19/202204/19/202204/19/202204/21/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability3AAFT ELECTING $500GDC-269459ClosedMaximum Duration of Benefits07/03/202404/12/202410/10/2024$500.00$13,000.0010/17/20246903/12/202403/13/202410/10/202407/17/202407/03/202407/03/202407/17/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-87312ClosedReturn to Work08/12/202109/07/202110/05/2021$500.00$2,071.4310/05/20216408/23/202108/24/202103/07/202208/12/202108/12/202108/30/202108/30/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-274520ClosedAdvance Pay & Close08/29/202408/19/202409/16/2024$588.00$2,436.0010/25/20243308/02/202408/05/202402/16/202508/29/202408/29/202408/29/202408/28/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-129379ClosedReturn to Work12/19/202212/10/202206/04/2023$484.12$12,241.3208/25/20234911/23/202211/26/202206/09/202312/19/202212/19/202212/19/202212/19/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-224888ClosedReturn to Work01/30/202402/02/202402/04/2024$508.40$217.8902/05/20245012/08/202312/11/202308/01/202401/31/202401/31/202401/31/202401/31/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-129002ClosedReturn to Work12/14/202212/29/202201/17/2023$500.00$1,428.5701/20/20232912/13/202212/15/202206/28/202312/14/202212/14/202212/14/202212/14/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-224894ClosedReturn to Work01/30/202401/30/202403/10/2024$747.32$4,377.1603/12/20245001/12/202401/14/202407/29/202401/30/202401/30/202401/30/202401/30/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-101893ClosedReturn to Work01/25/202211/23/202112/19/2021$500.00$1,928.5702/25/20225410/29/202111/09/202105/23/202201/25/202201/25/202201/25/202201/25/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-201826DeniedNot Disabled Own Occupation09/05/202308/01/2023$461.14$0.002907/17/202307/18/202301/29/202409/05/202309/12/202309/05/202309/12/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability3AAFT ELECTING $500GDC-276392ClosedReturn to Work09/18/202407/22/202409/29/2024$500.00$5,000.0009/30/20243707/05/202407/08/202401/19/202509/18/202409/18/202409/23/202409/23/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability2AAFT ELECTING $750GDC-292244ClosedAdvance Pay & Close11/18/202410/26/202412/30/2024$725.20$6,837.6012/30/20245409/20/202409/30/202404/25/202511/18/202411/18/202411/18/202411/18/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-196561ClosedReturn to Work07/10/202307/13/202307/25/2023$500.00$928.5708/07/20233306/27/202306/28/202301/10/202407/10/202307/10/202307/10/202307/10/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-108256DeniedWork Related Condition04/08/202212/16/2021$500.00$0.004511/19/202112/02/202106/15/202204/08/202204/08/202204/08/202204/08/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-220512ClosedDeath12/11/202312/15/202301/11/2024$750.00$5,250.0001/26/20244211/13/202311/29/202306/13/202412/11/202312/11/202312/11/202312/11/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-289463Pending10/18/202410/09/2024$577.92$0.004208/23/202408/27/202404/08/202510/18/202410/18/202410/18/202410/18/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-224968ClosedAdvance Pay & Close01/30/202401/25/202402/11/2024$693.08$1,782.2102/05/20244412/27/202312/28/202307/24/202401/30/202401/30/202401/30/202401/30/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-206959ClosedReturn to Work10/31/202310/14/202312/08/2023$732.26$7,636.4312/26/20236309/25/202309/26/202304/12/202410/31/202310/31/202310/31/202310/31/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-108777ClosedAdvance Pay & Close04/14/202204/23/202205/26/2022$500.00$2,428.5704/28/20223103/25/202204/01/202210/21/202204/14/202204/14/202204/14/202204/14/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-288407ClosedIncomplete claim10/08/202410/16/2024$750.00$0.004210/02/202410/02/202404/15/202510/08/202410/08/202412/20/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-219968ClosedAdvance Pay & Close12/05/202312/02/202312/18/2023$745.92$1,811.5201/19/20244311/03/202311/06/202305/31/202412/05/202312/05/202312/05/202312/05/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-128497ClosedReturn to Work12/08/202212/21/202203/05/2023$500.00$5,357.1404/13/20234512/06/202212/07/202206/20/202312/08/202212/08/202212/08/202212/08/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-119387DeniedElimination Period Not Satisfied08/22/202209/22/2022$470.02$0.006607/18/202207/19/202203/22/202308/23/202208/22/202208/23/202208/23/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-93645ClosedReturn to Work10/20/202110/01/202102/19/2022$500.00$10,142.8603/18/20225609/16/202109/17/202103/31/202210/20/202110/20/202110/22/202110/22/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-103541ClosedReturn to Work02/10/202201/25/202201/30/2022$482.17$413.2903/21/20223701/11/202201/11/202207/25/202202/10/202202/10/202202/10/202202/10/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-198060DeniedPre-existing Condition07/26/202307/31/2023$445.20$0.004807/14/202307/17/202301/28/202407/26/202308/04/202308/18/202308/18/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-109065ClosedAdvance Pay & Close04/19/202204/04/202205/15/2022$481.76$3,578.7904/22/20223103/18/202203/21/202210/02/202204/19/202204/19/202204/19/202204/19/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-197193ClosedReturn to Work07/17/202306/27/202307/09/2023$500.00$928.5707/25/20235006/12/202306/13/202312/25/202307/17/202307/21/202307/21/202307/21/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-89473ClosedAdvance Pay & Close09/03/202108/24/202109/29/2021$481.76$1,458.7610/14/20214808/09/202108/10/202102/21/202209/16/202109/03/202109/03/202109/16/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-165837ClosedReturn to Work03/07/202303/09/202303/12/2023$500.00$285.7103/24/20236302/20/202302/23/202309/06/202303/07/202303/07/202303/07/202303/07/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-118127DeniedPre-existing Condition08/08/202208/13/2022$461.16$0.005207/28/202207/30/202202/10/202308/08/202208/08/202208/08/202208/08/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability2AAFT ELECTING $750GDC-263012DeniedFailure to Provide Required Information04/22/202405/01/2024$750.00$0.002604/12/202404/17/202410/29/202404/22/202404/22/202404/22/202404/22/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-94500ClosedReturn to Work10/28/202109/19/202101/10/2022$500.00$8,142.8601/11/20226109/02/202109/05/202103/19/202211/11/202110/28/202111/11/202111/11/2021
1CITY OF WACOSTDSTDVoluntary Short Term Disability2AAFT ELECTING $750GDC-264796ClosedReturn to Work05/10/202405/13/202408/25/2024$711.76$10,676.4008/26/20246504/26/202404/29/202411/10/202405/10/202405/10/202405/28/202405/28/2024
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-219972ClosedReturn to Work12/05/202312/11/202301/14/2024$750.00$3,237.5201/16/20245011/22/202311/27/202306/09/202412/05/202312/05/202312/05/202312/05/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-181902DeniedPre-existing Condition05/14/202305/30/2023$500.00$0.003905/12/202305/16/202311/27/202305/14/202308/04/202305/15/202307/06/2023
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-114271ClosedReturn to Work06/23/202206/07/202207/05/2022$463.40$1,986.0009/09/20225604/12/202204/13/202212/05/202206/23/202206/23/202206/23/202206/23/2022
1CITY OF WACOSTDSTDVoluntary Short Term Disability1All Full-time EEsGDC-95336DeniedFailure to Provide Required Information11/08/202111/09/202101/28/2022$485.38$5,616.5401/28/20225010/26/202110/26/202105/09/202211/09/202111/08/202111/11/202111/11/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 .