RFP_21-057-DP_1_Attachment-7.xlsx

This file is a Long-Term Disability (LTD) claims status report for the Palm Beach County Board of County Commissioners and Palm Transit, Inc., documenting individual employee disability claims under policy FLK0960504. The spreadsheet contains detailed claim information for numerous employees across multiple occupational categories, including office and clerical workers, operators, service workers, technicians, professionals, laborers, craftsmen, and officials and managers. The report tracks claims from initiation through closure or active status, with claim received dates ranging from 2018 through 2021 and various claim statuses including approved claims returning to work, denied claims, and claims closed due to death or plan maximums.

The file presents comprehensive claim data including benefit payment frequencies (primarily monthly), current benefit percentages ranging from 50% to 60%, current gross and net benefits, dates of disability, dates of hire, approved benefit days, and total benefits paid. Many claims show denial reasons including failure to meet disability definitions under own occupation or any occupation provisions, as well as denials due to other contract limits. Claim outcomes include returns to work, deaths, plan maximum benefit exhaustion, and ongoing active claims with benefit end dates extending through 2023 and beyond. The report provides no information regarding pricing, set-asides, funding sources, or contract terms, as it serves as an administrative claims management document rather than a solicitation or procurement instrument.