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
Attachment P is a detailed claims document for the State of Nebraska, covering disability insurance claims data from July 1, 2019, through October 31, 2024. The document provides a comprehensive breakdown of approved and pending claims, including policy holder demographics, gross and net benefits, and 100% GAAP reserves. It tracks claims across multiple years, showing 32 total claims with a total sum of $2,275,286.65 in reserves, broken down by year from 2019 to 2024. The data includes individual claim details such as policy holder sex, date of birth, date of death, approved status, gross benefit, net benefit for reserves, and 100% GAAP reserve amount.
The claims data reveals additional insights into the state's disability insurance program, including the number of employees and open/pending claims for each period. The document shows a total of 5,768 employees in the most recent period, with claim volumes ranging from 1 to 10 claims per period and total closed claims volumes between $12,104,762 and $30,725,262. The paid claims triangle illustrates the financial progression of claims across different fiscal years, with total paid claims from July 1, 2019, to October 31, 2024, reaching $980,214.04 and a disabled life reserve of $2,100,344.68. The data suggests a dynamic and evolving disability insurance claims landscape for the State of Nebraska, with varying claim volumes and financial implications across different reporting periods.
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 .