Attachment P Claim details for SAE from 07.01.2019.pdf
PDF 625 KB Posted
- Solicitation number
- 120084 O5
- Issued by
- Lancaster County, Nebraska
About this file
This is a claims data report attachment for the State of Nebraska covering claims activity from July 1, 2019 through October 31, 2024. The document shows detailed claims data for 32 total claims (30 approved and 2 pending) with a total GAAP Reserve of $2,275,286.65. The claims are broken down by year, with 4 claims in 2019, 7 in 2020, 3 in 2021, 10 in 2022, 6 in 2023, and 2 pending claims in 2024.
The financial data shows total billed premiums of $4,394,198.23 over the period, with paid claims totaling $980,214.04 from July 2019 through October 2024. The document includes a disabled life reserve of $2,100,344.68 and details the number of employees covered, ranging from 2,823 to 5,768 across different periods. The claims volume by period ranges from $12.1M to $30.7M, with individual gross benefits typically between $1,500-$5,400 per claim. The data includes detailed breakdowns of paid claims triangles across multiple time periods and tracks both approved and pending claim statuses.
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
10/31/2024
STATE OF NEBRASKA 2019 4 101,399.79$ 4 101,399.79$
2020 7 289,736.14$ 7 289,736.14$ 2021 3 222,424.58$ 3 222,424.58$ 2022 10 688,627.03$ 10 688,627.03$ 2023 6 864,801.89$ 6 864,801.89$ 2024 2 108,297.22$ 2 108,297.22$
STATE OF NEBRASKA Total 30 2,166,989.43$ 2 108,297.22$ 32 2,275,286.65$
Approved_Pending Data Approved Pending
Total Count of Approved_Pending
Total Sum of 100% GAAP Reserve
ATTACHMENT P
POLICY_HOLDER SEX DOB DOD Approved_Pending GROSS_BENEFIT Net Ben for Reserves 100% GAAP Reserve
STATE OF NEBRASKA F 1/22/1972 11/16/2019 Approved 2,178.63$ 447.63$ 49,351.53$ STATE OF NEBRASKA M 12/31/1958 7/12/2019 Approved 2,227.92$ 505.92$ 5,189.43$ STATE OF NEBRASKA F 4/26/1967 12/8/2019 Approved 1,568.20$ 100.00$ 8,660.61$ STATE OF NEBRASKA M 2/21/1961 3/13/2020 Approved 4,059.92$ 1,999.92$ 62,832.43$ STATE OF NEBRASKA M 12/21/1969 3/3/2020 Approved 2,574.66$ 100.00$ 11,236.09$ STATE OF NEBRASKA F 1/9/1964 9/14/2020 Approved 1,772.99$ 576.99$ 34,915.89$ STATE OF NEBRASKA M 12/18/1981 9/18/2020 Approved 2,469.80$ 104.80$ 72,616.36$ STATE OF NEBRASKA F 9/24/1969 8/18/2020 Approved 1,835.80$ 348.80$ 34,390.63$ STATE OF NEBRASKA M 3/20/1958 12/17/2020 Approved 2,420.05$ 525.05$ 810.55$ STATE OF NEBRASKA M 1/7/1969 11/16/2020 Approved 2,684.14$ 838.14$ 72,934.19$ STATE OF NEBRASKA F 3/21/1968 2/1/2021 Approved 1,558.54$ 100.00$ 8,010.96$ STATE OF NEBRASKA M 4/28/1976 11/18/2021 Approved 2,128.10$ 456.10$ 48,681.15$ STATE OF NEBRASKA F 7/27/1960 2/23/2022 Approved 2,478.61$ 699.61$ 21,008.82$ STATE OF NEBRASKA M 5/3/1965 1/7/2022 Approved 2,838.23$ 873.23$ 57,966.54$ STATE OF NEBRASKA F 9/7/1972 5/18/2022 Approved 2,069.50$ 1,863.28$ 183,285.42$ STATE OF NEBRASKA M 2/19/1980 10/25/2022 Approved 2,015.52$ 100.00$ 11,830.32$ STATE OF NEBRASKA F 2/22/1983 6/3/2022 Approved 1,901.12$ 1,714.96$ 188,183.99$ STATE OF NEBRASKA F 9/16/1982 8/11/2022 Approved 2,915.85$ 779.85$ 43,456.12$ STATE OF NEBRASKA F 7/30/1970 7/26/2022 Approved 2,912.00$ 100.00$ 8,694.84$ STATE OF NEBRASKA M 10/22/1967 8/12/2022 Approved 2,626.78$ 2,349.48$ 108,636.27$ STATE OF NEBRASKA F 12/11/1979 11/29/2022 Approved 2,916.16$ 1,686.16$ 10,833.50$ STATE OF NEBRASKA M 5/31/1959 4/16/2023 Approved 2,488.51$ 769.51$ 15,801.26$ STATE OF NEBRASKA F 4/28/1970 2/27/2023 Approved 5,383.04$ 4,826.85$ 416,161.79$ STATE OF NEBRASKA M 12/30/1964 10/24/2022 Approved 2,808.00$ 100.00$ 54,731.21$ STATE OF NEBRASKA M 1/17/1961 6/9/2023 Approved 2,800.82$ 879.82$ 23,396.11$ STATE OF NEBRASKA F 9/29/1978 9/12/2023 Approved 3,427.84$ 2,943.89$ 123,204.27$ STATE OF NEBRASKA M 4/22/1971 9/28/2023 Approved 2,180.88$ 1,663.78$ 138,462.34$ STATE OF NEBRASKA M 11/16/1967 10/9/2021 Approved 2,043.46$ 2,043.46$ 165,732.47$ STATE OF NEBRASKA F 12/13/1967 9/10/2019 Approved 2,448.46$ 456.46$ 38,198.22$ STATE OF NEBRASKA F 1/4/1977 5/20/2023 Approved 1,955.20$ 1,545.08$ 147,776.12$ STATE OF NEBRASKA F 5/12/1968 4/17/2024 Pending 1,659.63$ 761.67$ 40,839.59$ STATE OF NEBRASKA M 7/1/1962 3/13/2024 Pending 2,408.98$ 1,957.51$ 67,457.63$
State of Nebraska Period
Number # of months Incurral
Period|From Incurral
Period|Through Billed Premium
Paid Claims Triangle|7/1/2023 -
10/31/2024
Paid Claims Triangle|7/1/2022 -
6/30/2023 1 16 7/1/2023 10/31/2024 1,350,438.67$ 38,443.54$ 2 12 7/1/2022 6/30/2023 923,012.73$ 305,376.35$ 21,873.20$ 3 12 7/1/2021 6/30/2022 865,059.11$ 97,921.28$ 129,172.63$ 4 12 7/1/2020 6/30/2021 841,359.09$ 27,611.63$ (55,610.54)$ 5 12 7/1/2019 6/30/2020 414,328.63$ 35,942.05$ 27,599.04$
4,394,198.23$ 505,294.85$ 123,034.33$
Paid Claims Triangle|7/1/2021 -
6/30/2022
Paid Claims Triangle|7/1/2020 -
6/30/2021
Paid Claims Triangle|7/1/2019 -
6/30/2020 Total Paid claims 7/1/19 - 10/31/24 Disabled Life Reserve
Number of Employees
Number of Open/Pending
Claims 38,443.54$ 265,662.31$ 5768 2
327,249.55$ 852,061.58$ 5670 10 11,113.30$ 238,207.21$ 672,890.92$ 5462 6
204,245.30$ 46,329.07$ 222,575.46$ 226,410.26$ 5639 8 34,486.55$ 55,610.64$ 100.00$ 153,738.28$ 83,319.61$ 2823 3
249,845.15$ 101,939.71$ 100.00$ 980,214.04$ 2,100,344.68$
Number of Closed Claims Volume
1 30,725,262$ 4 27,661,310$ 4 25,295,416$
10 24,543,891$ 5 12,104,762$
File details come from the government source that posted it. Updated .