Exhibit_7_-_Short_Term_Disability_Count_by_Month.pdf

263 KB Posted

Attached to
Short- and Long-Term Disability
Solicitation number
2024-335
Issued by
Collin County, Texas

About this file

Written by GovTribe AI ·

Exhibit 7 is a detailed monthly report of Short-Term Disability claims for Collin County, Texas, tracking disability notifications from January 2020 through June 2024. The document, prepared by Blue Cross Blue Shield (BCBS), provides a comprehensive breakdown of disability claims categorized by Closed, Denied, and Open statuses for each month. The total number of short-term disability claims over the reported period is 261, with quarterly variations ranging from 11 to 20 claims.

The report reveals consistent monthly tracking of disability claims, with most months showing between 3-9 closed claims and minimal denied claims. Notable observations include occasional months with 1-2 denied claims and a total of 9 denied claims across the entire reporting period. BCBS has explicitly noted that this report is specifically for short-term disability tracking, suggesting it is part of a broader benefits administration process for Collin County. The data could be useful for understanding disability claim trends, workforce health patterns, and potential risk management strategies for the county's employee benefits program.

View the file

Other files

File Type Posted
Short-_and_Long-Term_Disability_(Addendum_#3_Revision).pdf PDF
Copy_of_I_Exhibit_6_-_Short-_and_Long-Term_Disability_Census_-_May_2024_v2.xlsx XLSX spreadsheet
Exhibit_6_-_Short-_and_Long-Term_Disability_Census_-_May_2024.pdf PDF
Exceptions.docx DOCX document
LEGAL_NOTICE_TEMPLATE-RFP-2024-335_.pdf PDF
W-9_rev_2018-3-22-24.pdf PDF
CIQ_-3-22-24.pdf PDF
Attachment_C_Disability_Pricing_Information_Updated_v2.pdf PDF
Exhibit_4_-_Short-_and_Long-Term_Disability_Rates_(1).xlsx XLSX spreadsheet
Exhibit_3_-_Long-Term_Disability_Plan_Document_Class_2_(1).pdf PDF
Attachment_A_Disability_RFP_Questionnairev3.xlsx XLSX spreadsheet
Attachment_B_-_Disability_Questionnaire.pdf PDF
Exhibit_2_-_Long-Term_Disability_Plan_Document_Class_1_(1).pdf PDF
Exhibit_5_-_Short-_and_Long-Term_Disability_Experience_Report_(2020-May_2024)_(1).pdf PDF
Exhibit_1_-_Short-Term_Disability_Plan_Document_(1)_(1).pdf PDF
Show all 15

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.

Notification Month Closed Denied Open Total Total by Quarter

Jan-20 6 0 0 6 16

Feb-20 5 0 0 5

Mar-20 5 0 0 5

Apr-20 4 0 0 4 13

May-20 4 0 0 4

Jun-20 4 1 0 5

Jul-20 2 0 0 2 13

Aug-20 5 0 0 5

Sep-20 6 0 0 6

Oct-20 6 1 0 7 20

Nov-20 4 0 0 4

Dec-20 9 0 0 9

Jan-21 7 1 0 8 13

Feb-21 1 0 0 1

Mar-21 4 0 0 4

Apr-21 7 0 0 7 20

May-21 5 0 0 5

Jun-21 8 0 0 8

Jul-21 3 1 0 4 12

Aug-21 1 0 0 1

Sep-21 7 0 0 7

Oct-21 6 0 0 6 12

Nov-21 3 0 0 3

Dec-21 1 2 0 3

Jan-22 5 0 0 5 11

Feb-22 2 0 0 2

Mar-22 4 0 0 4

Apr-22 5 1 0 6 15

May-22 6 0 0 6

Jun-22 2 1 0 3

Jul-22 9 0 0 9 17

Aug-22 4 1 0 5

Sep-22 3 0 0 3

Oct-22 4 0 0 4 16

Nov-22 5 0 0 5

Dec-22 7 0 0 7

Jan-23 3 0 0 3 11

Feb-23 3 0 0 3

Mar-23 5 0 0 5

Apr-23 3 0 0 3 13

May-23 3 0 0 3

Jun-23 7 0 0 7

Jul-23 5 0 0 5 12

Aug-23 7 0 0 7

Exhibit 7 - Short Term Disability Count by Month

Sep-23 0 0 0 0

Oct-23 5 0 0 5 15

Nov-23 6 0 0 6

Dec-23 4 0 0 4

Jan-24 1 0 0 1 18

Feb-24 9 0 0 9

Mar-24 7 0 1 8

Apr-24 3 0 2 5 14

May-24 3 0 2 5

Jun-24 3 0 1 4

246 9 6 261 261

BCBS has indicated this report can only be provided for short term disability

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