Copy_of_I_Exhibit_6_-_Short-_and_Long-Term_Disability_Census_-_May_2024_v2.xlsx

The document is a Short- and Long-Term Disability Census for Collin County, Texas, as of May 2024, containing detailed employee demographic and coverage information. The census represents a comprehensive listing of county employees eligible for disability insurance, including individual employee data such as sex, birthdate, postal code, annual rate, and coverage begin date. Collin County is seeking a vendor to provide group benefits administration and insurance for its Short- and Long-Term Disability Programs, with the census serving as a foundational document for potential insurance providers to assess the county's workforce composition and risk profile.

The census includes 1,007 employee records with varying coverage details, indicating a diverse workforce across multiple zip codes primarily in the 750xx range. The data reveals employees ranging in age from the late 1940s to early 2000s, with annual rates spanning from approximately $35,000 to over $434,000. Coverage begin dates extend back to October 2006, suggesting a long-standing benefits program with multiple entry points. The detailed nature of the census, including precise individual information, suggests Collin County is preparing a comprehensive and transparent solicitation for disability insurance services, enabling potential vendors to accurately price and structure their benefit proposals based on the county's specific workforce characteristics.