ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
Life, Short & Long Term Disability Employee Benefits
Solicitation number
2510-006
Issued by
Travis County, Austin City, Texas

About this file

Written by GovTribe AI ·

This document is an Excel attachment titled "ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx" related to a state and local contract opportunity for the Travis County Healthcare District. The attachment provides a 5-year historical overview of the Long-Term Disability (LTD) plan, including billed premium, average lives, average volume, and accumulated benefit reserve data from August 1, 2019 to August 1, 2024. It also includes a detailed monthly LTD billed premium, lives, volume, and criteria report, as well as a list of LTD claims as of July 31, 2024.

The document appears to be a supporting financial exhibit for a contract opportunity related to the Travis County Healthcare District's LTD plan. It does not provide information on the specific scope of work, response dates, award details, or contract term. However, the comprehensive data provided suggests this is likely a renewal or continuation of an existing LTD contract for the district.

View the file

Other files

File Type Posted
ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx XLSX spreadsheet
ESBD_379720_1730752713714_Addendum 7_Q&As.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729885656635_Attachment L - UHC Life Experience 122023 - current report.pdf PDF
ESBD_379720_1729030860092_RFP 2510-006 Life, Short_Long Term Disability.pdf PDF
ESBD_379720_1729031136155_Attachment C - UHC Life Experience 032018-current.pdf PDF
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729031192350_Attachment D - UHC Life paid claim report.xlsx XLSX spreadsheet
ESBD_379720_1729031266148_Attachment E - UHC Plan Documents.pdf PDF
ESBD_379720_1730744991694_RFP 2510-006_Addendum 5_ Amendment 1 - Update to Exhibit B_Response Template.pdf PDF
ESBD_379720_1730745131589_REVISED - Exhibit B - Response Template_ RFP 2510-006.xlsx XLSX spreadsheet
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
ESBD_379720_1729031079107_Attachment B - Employee Census - RFP 2510-006 Life & Disability.xlsx XLSX spreadsheet
ESBD_379720_1730749696996_Addendum 6 - Post Additional Attachment.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1730749720275_Attachment M - Additional Disability Experience.xlsx XLSX spreadsheet
ESBD_379720_1731522844628_RFP Amendment 2 - Schedule of Events Change.pdf PDF
ESBD_379720_1729885601758_Attachment J - UHC Life Experience 032018-112022.pdf PDF
ESBD_379720_1729634933127_Addendum 3 - Pre-Proposal Conference - Attendees and Recording.pdf PDF
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729885561966_Attachment I - MetLife Invoice 11.24.xlsx XLSX spreadsheet
ESBD_379720_1729885624841_Attachment K - UHC Life Experience 122022 - 122023 report.pdf PDF
ESBD_379720_1730745094878_RFP 2510 -006 - Amendment 1 - Update to Exhibit B - Response Template.pdf PDF
ESBD_379720_1730744991694_RFP 2510-006_Addendum 5_ Amendment 1 - Update to Exhibit B_Response Template.pdf PDF
ESBD_379720_1729634933127_Addendum 3 - Pre-Proposal Conference - Attendees and Recording.pdf PDF
ESBD_379720_1729031363367_Attachment G - TRAVIS COUNTY HEALTHCARE DISTRICT ltd mpr_std mars report 08.01.2023 - 07.31.2024.xlsx XLSX spreadsheet
ESBD_379720_1729885656635_Attachment L - UHC Life Experience 122023 - current report.pdf PDF
ESBD_379720_1730749720275_Attachment M - Additional Disability Experience.xlsx XLSX spreadsheet
ESBD_379720_1729885561966_Attachment I - MetLife Invoice 11.24.xlsx XLSX spreadsheet
ESBD_379720_1729031266148_Attachment E - UHC Plan Documents.pdf PDF
ESBD_379720_1729885601758_Attachment J - UHC Life Experience 032018-112022.pdf PDF
ESBD_379720_1729885624841_Attachment K - UHC Life Experience 122022 - 122023 report.pdf PDF
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729031136155_Attachment C - UHC Life Experience 032018-current.pdf PDF
ESBD_379720_1730745131589_REVISED - Exhibit B - Response Template_ RFP 2510-006.xlsx XLSX spreadsheet
ESBD_379720_1730749696996_Addendum 6 - Post Additional Attachment.pdf PDF
ESBD_379720_1729031192350_Attachment D - UHC Life paid claim report.xlsx XLSX spreadsheet
ESBD_379720_1730745094878_RFP 2510 -006 - Amendment 1 - Update to Exhibit B - Response Template.pdf PDF
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729030860092_RFP 2510-006 Life, Short_Long Term Disability.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1729031079107_Attachment B - Employee Census - RFP 2510-006 Life & Disability.xlsx XLSX spreadsheet
ESBD_379720_1730752713714_Addendum 7_Q&As.pdf PDF
ESBD_379720_1729030935121_Exhibit B - RFP 2510-006 Life & Disability Response Template.xlsx XLSX spreadsheet
ESBD_379720_1729274028478_Addendum #2_Pre-Proposal Conference.pdf PDF
ESBD_379720_1729885511235_Addendum 4 - Post Additional Attachments.pdf PDF
ESBD_379720_1729103901241_2510-006_Addendum 1_FAQs.pdf PDF
ESBD_379720_1729031411097_Attachment H - STD LTD Claim Status 9.1.23-8.31.24_Claim Status Report.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 68 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cover_Page

TRAVIS COUNTY HEALTHCARE DISTRICT
The Marketplace Report
Date Range(s) Selected:
From:8/1/19To:8/1/20
From:8/1/20To:8/1/21
From:8/1/21To:8/1/22
From:8/1/22To:8/1/23
From:8/1/23To:8/1/24
Report Parameters:
Customer #:5924797
Experience #:All
Coverage(s):LTD
LTD Valuation Date:7/31/24
Organized By:Customer Number

Summary Info

LTD Billed Premium, Lives, Volume, and Criteria Description0
Customer: 5924797 Name: TRAVIS COUNTY HEALTHCARE DISTRICT
CUSTOMERINCURRAL PERIODINCURRAL DATESTOTAL BILLED PREMIUMAVERAGE LIVESAVERAGE VOLUMEACCUMULATED BENEFITRESERVE
5924797108/01/2019 - 08/01/2020225,70511193,526,610462,448182,152
5924797208/01/2020 - 08/01/2021305,00512653,986,18600
5924797308/01/2021 - 08/01/2022424,81113444,402,310177,52361,269
5924797408/01/2022 - 08/01/2023523,31614185,020,873145,88578,097
5924797508/01/2023 - 08/01/2024652,39817026,253,24720,726729,576

LTD Monthly

LTD Billed Premium, Lives, Volume, and Criteria Description0
Customer: 5924797 Name: TRAVIS COUNTY HEALTHCARE DISTRICT
CUSTOMERMONTHEMPLOYEE LIVESEMPLOYEE VOLUMEPREMIUM
59247977/30/2418326,821,35058,757
59247976/27/2418286,778,13158,405
59247975/30/2418196,719,89358,203
59247974/29/2417906,610,89056,549
59247973/28/2417816,576,76058,594
59247972/28/2416956,279,32555,651
59247971/30/2416566,063,61052,424
592479712/28/2316516,029,76252,206
592479711/29/2316365,953,87251,676
592479710/30/2316085,852,69550,617
59247979/28/2315945,782,87051,099
59247978/30/2315375,569,81048,218
59247977/28/2315235,495,51948,111
59247976/29/2314865,358,65447,204
59247975/30/2314595,254,95745,229
59247974/27/2314525,235,99344,753
59247973/30/2314565,241,38947,383
59247972/27/2313844,943,10943,188
59247971/30/2313814,823,23741,087
592479712/29/2213874,827,07441,708
592479711/29/2213704,784,01641,115
592479710/28/2213734,774,04840,704
59247979/29/2213794,777,90541,412
59247978/30/2213704,734,57941,423
59247977/28/2213534,617,47339,496
59247976/29/2213564,611,94439,718
59247975/27/2213484,576,08639,613
59247974/28/2213254,513,56539,473
59247973/30/2213394,403,12137,795
59247972/25/2213374,374,65033,906
59247971/28/2213334,280,43333,735
592479712/30/2113404,197,74226,041
592479711/29/2113604,364,92133,733
592479710/28/2113544,339,91233,672
59247979/29/2113514,316,10734,728
59247978/30/2113264,231,76332,901
59247977/29/2113044,184,63232,506
59247976/29/2112894,172,37432,357
59247975/28/2112874,149,65532,433
59247974/29/2113134,107,49831,667
59247973/30/2113054,095,37532,177
59247972/25/2112673,954,21421,042
59247971/28/2112483,905,65020,775
592479712/30/2012403,891,04520,437
592479711/27/2012503,898,45020,545
592479710/29/2012433,874,72620,924
59247979/29/2012203,804,51120,047
59247978/28/2012093,796,10420,095
59247977/30/2011983,768,79720,008
59247976/29/2011923,740,35419,807
59247975/28/2011723,699,59619,570
59247974/29/2011663,695,04219,509
59247973/30/2011593,686,35320,001
59247972/27/2011563,588,21818,491
59247971/30/2011793,653,76119,276
592479712/30/1911783,651,79921,305
592479711/28/1910223,246,43017,344
592479710/30/1910003,195,84216,761
59247979/27/199983,192,37416,654
59247978/29/1910023,200,75016,979

Claim List

LTD Claim Listing
as of 7/31/2024
5924797 - TRAVIS COUNTY HEALTHCARE DISTRICT
Experience NumberReport NumberSubcodePaypointSocial Security StatusAge of ClaimantGenderStatusDate of DisabilityMonthly Gross BenefitRegular Monthly BenefitTotal Benefit Paid To Date
5924797592479700030001SSP51F039/23/19$ 2,616$ - 0$ 50,742Key
5924797592479700040001SSA61F0010/17/19$ 5,941$ 3,643$ 185,599
5924797592479700030001NED60F0310/29/19$ 6,000$ - 0$ 132,432Social Security Status
5924797592479700040001SSP53F031/16/20$ 3,914$ - 0$ 93,676CodeDescription
5924797592479700040001SSP42F0112/23/20$ 1$ - 0$ - 0SSASS benefits have been approved
5924797592479700040001SSP37F016/4/21$ 2,070$ - 0$ - 0SSPSS status is pending (have not yet submitted or have submitted and not been denied twice)
5924797592479700040001SSP30F018/9/21$ 1$ - 0$ - 0NEDClaimant is not eligible for SS or has been denied at least twice
5924797592479700030001SSA63F038/13/21$ 3,396$ - 0$ 55,641
5924797592479700040001NED64F0310/1/21$ 2,008$ - 0$ 11,488Claim Status
5924797592479700040001SSP64F031/17/22$ 2,693$ - 0$ 56,993CodeDescription
5924797592479700030001SSA64F003/26/22$ 4,954$ 2,356$ 53,40200Active
5924797592479700040001SSP24F014/11/22$ 2,105$ - 0$ - 001Declined
5924797592479700040001SSP34F015/13/22$ 1$ - 0$ - 002Waiting
5924797592479700040001SSP37F0311/9/22$ 6,000$ - 0$ 68,76003Ended
5924797592479700030001SSP63F002/14/23$ 3,407$ 3,407$ 37,47804Inactive
5924797592479700040001SSP61F034/20/23$ 3,408$ - 0$ 39,64705Incomplete
5924797592479700030001SSP43F0210/14/23$ 4,400$ 4,400$ 13,200PSPending
5924797592479700030001SSP60M0011/29/23$ 3,584$ 3,584$ 7,526
5924797592479700030001SSP61F001/16/24$ 6,000$ 6,000$ - 0
5924797592479700030001SSP29F015/27/24$ 2,373$ - 0$ - 0

STD Experience

TRAVIS COUNTY HEALTHCARE DISTRICT
05924797
DatePremium ($)LivesTotal Claims ($)
08/01/2023$41,064.551,035$35,216.90
09/01/2023$41,844.311,047$31,047.17
10/01/2023$41,500.831,047$30,260.69
11/01/2023$42,164.731,058$23,867.54
12/01/2023$42,350.311,060$39,430.59
01/01/2024$42,223.591,059$27,265.36
02/01/2024$43,993.451,065$21,114.37
03/01/2024$41,318.931,098$32,245.17
04/01/2024$43,585.281,168$33,351.45
05/01/2024$42,650.301,182$48,051.87
06/01/2024$42,848.301,186$36,441.51
07/01/2024$42,018.641,175$60,457.16

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