Attachment G- STD Group Paid by month.pdf
PDF 278 KB Posted
- Solicitation number
- 120084 O5
- Issued by
- Lancaster County, Nebraska
About this file
This document is an Experience Summary by Group by Paid report from UnitedHealthcare for the State of Nebraska's Short Term Disability (STD) insurance program, covering the period from July 1, 2019, to October 25, 2024. The report provides a detailed monthly breakdown of premium/fees, paid claims, covered lives, and volume of coverage for the STD insurance group with customer number 306147. The data spans from July 2019 to October 2024, showing a consistent increase in covered lives from 1,839 in July 2019 to 3,145 in the later months of 2024, with total premiums reaching $8,181,741.13 and total paid claims of $2,167,109.38 across 993 claims.
The report reveals a steady growth in the STD insurance program, with annual premium/fees increasing from $544,708.29 in 2019 to $1,836,267.04 in 2023, and a corresponding rise in the number of claims from 27 in 2019 to 248 in 2023. The data suggests UnitedHealthcare has been the incumbent provider since July 1, 2019, with a voluntary program where employees pay full premiums through post-tax deductions. The business segment is categorized as STD, and the source systems include ACIS, FACETS, Onbase, PRIME, UHOPS, and USP, indicating a comprehensive data collection and management approach for the state's disability insurance program.
View the file
Other files
Show 40 more
Latest 50 of 146 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
Text version
Number of Claims
Experience Summary by Group by Paid Selection Parameters
Group/Customer: 306147
Subgroup/Policy: ALL
Paid Date Range: 07/01/2019 to 10/25/2024
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
All Subgroups and Products by Paid Month Paid Month/Year Premium/Fees Paid Claims Covered Lives Volume of
Coverage
Business Segment: STD
Source System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
$923,281 08/2019 $174,673.63 $0.00 1,860 $946,186 07/2019 $0.00 $0.00 1,839
$961,080 10/2019 $92,936.01 $11,275.03 1,916 $973,111 09/2019 $89,532.35 $6,107.24 1,892
$988,332 12/2019 $94,281.11 $17,433.49 2,001 $1,014,016 11/2019 $93,285.19 $10,204.05 1,957
$1,020,345 02/2020 $98,499.97 $19,734.04 2,044 $1,060,469 01/2020 $97,044.42 $13,788.05 2,032
$1,062,604 04/2020 $99,855.36 $10,819.48 2,114 $1,070,456 03/2020 $100,351.53 $17,658.66 2,072
$1,112,018 06/2020 $104,448.21 $30,527.92 2,181 $1,104,158 05/2020 $104,306.51 $7,907.77 2,174
$1,075,341 08/2020 $102,141.03 $19,901.93 2,089 $1,088,846 07/2020 $108,108.03 $20,968.58 2,108
$1,101,471 10/2020 $104,293.42 $28,527.10 2,148 $1,125,370 09/2020 $102,441.69 $28,683.85 2,103
$1,125,805 12/2020 $105,118.25 $37,055.06 2,158 $1,120,663 11/2020 $107,487.73 $46,735.39 2,158
Run Date: 10/25/2024 4:04:37 PM OFCR-04C; v2.5 Page 1 of 8
Attachment G
Experience Summary by Group by Paid Selection Parameters
Group/Customer: 306147
Subgroup/Policy: ALL
Paid Date Range: 07/01/2019 to 10/25/2024
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
Business Segment: STD
Source System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
$1,137,117 02/2021 $106,610.74 $29,969.91 2,181 $1,139,865 01/2021 $108,955.37 $34,026.50 2,172
$1,146,700 04/2021 $108,050.40 $15,093.68 2,192 $1,145,895 03/2021 $108,852.76 $51,972.47 2,193
$1,144,063 06/2021 $107,772.14 $34,883.91 2,168 $1,137,905 05/2021 $108,580.46 $37,385.47 2,187
$1,381,561 08/2021 $110,518.72 $60,205.75 2,585 $1,373,214 07/2021 $90,725.53 $25,235.48 2,609
$1,370,843 10/2021 $125,974.20 $24,720.98 2,558 $1,366,530 09/2021 $113,767.09 $23,454.43 2,568
$1,367,357 12/2021 $109,430.97 $39,362.03 2,599 $1,450,268 11/2021 $109,515.33 $18,834.15 2,562
$1,527,959 02/2022 $129,230.23 $21,268.41 2,640 $1,552,560 01/2022 $116,638.37 $25,833.49 2,603
$1,583,825 04/2022 $128,689.18 $45,267.62 2,774 $1,635,118 03/2022 $130,343.98 $36,101.02 2,691
$1,661,933 06/2022 $136,367.68 $17,363.78 2,863 $1,694,187 05/2022 $132,886.24 $25,802.37 2,820
$1,653,166 08/2022 $135,332.94 $40,425.94 2,785 $1,687,638 07/2022 $136,908.04 $42,737.40 2,736
$1,704,63809/2022 $133,383.27 $49,580.03 2,814
Run Date: 10/25/2024 4:04:37 PM
OFCR-04C; v2.5 Page 1 of 8
Group/Customer: 306147
Subgroup/Policy: ALL
Paid Date Range: 07/01/2019 to 10/25/2024
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
Business Segment: STD
Source System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
10/2022 $136,895.07 $46,569.40 2,834 $1,716,951 $1,732,117
12/2022 $139,997.31 $46,521.07 2,902 $1,758,833 11/2022 $141,964.19 $44,179.74 2,850
$1,768,508 02/2023 $143,804.43 $8,600.12 2,920 $1,782,991 01/2023 $142,074.53 $41,704.24 2,903
$1,810,731 04/2023 $145,935.06 $60,397.54 2,993 $1,817,487 03/2023 $143,511.03 $51,377.56 2,971
$1,847,559 06/2023 $148,158.30 $75,844.99 3,067 $1,858,616 05/2023 $147,473.56 $93,344.67 3,038
$1,949,552 08/2023 $158,231.45 $39,980.71 3,008 $1,979,929 07/2023 $150,745.00 $78,766.47 2,976
$1,977,838 10/2023 $159,382.19 $28,859.63 3,034 $2,002,740 09/2023 $168,298.55 $52,148.82 2,999
$2,033,161 12/2023 $165,308.25 $42,703.42 3,097 $2,038,953 11/2023 $163,344.69 $24,772.54 3,092
$2,031,004 02/2024 $163,253.38 $42,291.86 3,107 $2,037,711 01/2024 $165,804.97 $54,801.64 3,087
$2,036,198 04/2024 $163,502.06 $62,702.48 3,127 $2,061,561 03/2024 $162,749.52 $37,045.64 3,107
$2,058,521 06/2024 $165,740.97 $48,950.09 3,145 $2,055,575 05/2024 $164,895.61 $54,043.91 3,145
Group/Customer: 306147
Subgroup/Policy: ALL
Paid Date Range: 07/01/2019 to 10/25/2024
Group Effective Date: 07/01/2019
STATE OF NEBRASKA
Business Segment: STD
Source System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
$2,052,747 08/2024 $166,025.73 $33,784.33 3,110 $2,128,751 07/2024 $163,497.52 $29,427.26 3,065
All subgroups and
$8,181,741.13 $2,167,109.38
$2,055,575 10/2024 $171,904.86 $0.00 0 $0 09/2024 $171,904.82 $41,438.79 3,145
Business Segment: STD STD
FACETSSource System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
Experience Summary by Group by Paid M h Selection Parameters Values on Report
Group/Customer: 306147 00306147 - STATE OF NEBRASKA
Subgroup/Policy: ALL 1002
Paid Date Range: 07/01/2019 to 10/25/2024 07/01/2019 to 10/01/2024
STATE OF NEBRASKA
All Subgroups by Year and Product Summary Year 2019
Number of Claims Short Term Disability $544,708.29 $45,019.81 27 Products Premium/Fees Paid Claims
Year 2020
Products Premium/Fees Paid Claims Number of Claims
Year 2019 Total $544,708.29 $45,019.81
Year 2020 Total $1,234,096.15 $282,307.83 138
Short Term Disability $1,234,096.15 $282,307.83
Year 2021 Products Premium/Fees Paid Claims Number of Claims
Year 2021 Total $1,308,753.71 $395,144.76 208
Short Term Disability $1,308,753.71 $395,144.76
Year 2022 Products Premium/Fees Paid Claims Number of Claims
Year 2022 Total $1,598,636.50 $441,650.27 216
Short Term Disability $1,598,636.50 $441,650.27
Year 2023 Products Premium/Fees Paid Claims Number of Claims
Year 2023 Total $1,836,267.04 $598,500.71 248
Short Term Disability $1,836,267.04 $598,500.71
Year 2024 Products Premium/Fees Paid Claims Number of Claims
156Short Term Disability $1,659,279.44 $404,486.00
OFCR-04C; v2.5 Page 8 of 8
Business Segment: STD STD
FACETSSource System: ACIS,FACETS,Onbase,PRIME,UHOPS,USP
Experience Summary by Group by Paid M h Selection Parameters Values on Report
Group/Customer: 306147 00306147 - STATE OF NEBRASKA
Subgroup/Policy: ALL 1002
Paid Date Range: 07/01/2019 to 10/25/2024 07/01/2019 to 10/01/2024
STATE OF NEBRASKA
L
All Subgroups by Year and Product Total $8,181,741.13 $2,167,109.38 993 Year 2024 Total $1,659,279.44 $404,486.00 156
All Subgroups by Product
993All Subgroups Product Total $8,181,741.13 $2,167,109.38
Number of Claims
Short Term Disability $8,181,741.13 $2,167,109.38 993
Products Premium/Fees Paid Claims
OFCR-04C; v2.5 Page 8 of 8
| Sheet1 |
| Sheet8 |
File details come from the government source that posted it. Updated .