APPENDIX_2.pdf
PDF 92 KB Posted
- Solicitation number
- 017-202404-MC
- Issued by
- Orange County, San Francisco City, California
About this file
The document is a Life Liability Data report for the County of Orange, covering life insurance claims from January 1, 2019, through December 31, 2023. The data includes detailed information about life insurance claims across various employee units such as Administrative, Attorney, Court Management, Executive Management, and Craft and Plant units. The report provides a comprehensive breakdown of claims, including claim types (Basic Term, Supplemental, and Voluntary), gender of claimants, incurred dates, dates of birth, dates of death, and total claim amounts.
The report reveals multiple life insurance claims with varying total amounts, ranging from small paid amounts (e.g., $15.49, $64.11) to significant life insurance payouts of $250,000. The claims are categorized into two main types: "LIFE for Paids only" and "Life (no PW and/or LBO)". The data spans different plan years and covers claims for employees across multiple organizational units, with claimants of various ages and genders. The document appears to be a detailed financial and administrative record of life insurance claims processed for County of Orange employees during the specified five-year period.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| COO_LIFE_AND_ADD_FINAL.pdf | ||
| COO_LIFE_AND_ADD_FINAL.docx | DOCX document | |
| APPENDIX_3.pdf | ||
| APPENDIX_2.xlsx | XLSX spreadsheet | |
| APPENDIX_1.xlsx | XLSX spreadsheet | |
| APPENDIX_1.pdf | ||
| Attachment_J_-_County_of_Orange_Information_Technology_Security_Guidelines.docx | DOCX document | |
| Attachment_J_-_County_of_Orange_Information_Technology_Security_Guidelines.pdf | ||
| Test.docx | DOCX document |
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
Case Name Plan Year Band Claim ID Loss Unit Coverage Type Claim Type
COUNTY OF ORANGE 01/01/2023-12/31/2023 17767308 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2023-12/31/2023 17767308 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16457124 003-ADMINISTRATIVE MA SUPPLEMENTAL DEPENDLife
COUNTY OF ORANGE 01/01/2022-12/31/2022 17507576 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17507576 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 17024049 003-ADMINISTRATIVE MA BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 17024049 003-ADMINISTRATIVE MA BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 17024049 003-ADMINISTRATIVE MA SUPPLEMENTAL Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16751359 003-ADMINISTRATIVE MA BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16751359 003-ADMINISTRATIVE MA BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17504119 006-CRAFT AND PLANT U BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17504119 006-CRAFT AND PLANT U BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 16947433 002-COURT MANAGEMEN BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 16947433 002-COURT MANAGEMEN BASIC TERM Life
COUNTY OF ORANGE 01/01/2020-12/31/2020 16947433 002-COURT MANAGEMEN SUPPLEMENTAL Life
COUNTY OF ORANGE 01/01/2023-12/31/2023 17769870 003-ADMINISTRATIVE MA BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16500052 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16500052 005-ATTORNEY UNIT WO BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17583393 001-EXEC MGT-OFFICIALS BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17583393 001-EXEC MGT-OFFICIALS BASIC TERM Life
COUNTY OF ORANGE 01/01/2022-12/31/2022 17583393 001-EXEC MGT-OFFICIALS SUPPLEMENTAL Life
COUNTY OF ORANGE 01/01/2023-12/31/2023 17859519 003-ADMINISTRATIVE MA SUPPLEMENTAL DEPENDLife
Life Liability Data
COUNTY OF ORANGE
Date of Disability or Date of Death between 01/01/2019 through 12/31/2023 Plan Month Start Date: January As of Date: 01/31/2024
COUNTY OF ORANGE 01/01/2019-12/31/2019 16601694 001-EXEC MGT-OFFICIAL BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16601694 001-EXEC MGT-OFFICIAL BASIC TERM Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16601694 001-EXEC MGT-OFFICIALS SUPPLEMENTAL Life
COUNTY OF ORANGE 01/01/2019-12/31/2019 16601694 001-EXEC MGT-OFFICIALS VOLUNTARY (CHOICE) Life
Claim Type Description Gender Incurred Date Date Of Birth Date Of Death Total Amount Distinct Claim
LIFE for Paids only M 01/14/2023 07/18/1989 01/14/2023 $897.60 0
Life (no PW and/or LBO) M 01/14/2023 07/18/1989 01/14/2023 $250,000.00 1
Life (no PW and/or LBO) U 03/12/2019 08/30/1967 03/12/2019 $20,000.00 1
LIFE for Paids only M 01/02/2022 06/29/1975 01/02/2022 $650.00 0
Life (no PW and/or LBO) M 01/02/2022 06/29/1975 01/02/2022 $250,000.00 1
LIFE for Paids only F 10/11/2020 11/24/1983 10/11/2020 $208.36 0
Life (no PW and/or LBO) F 10/11/2020 11/24/1983 10/11/2020 $100,000.00 1
Life (no PW and/or LBO) F 01/00/1900 11/24/1983 10/11/2020 $200,000.00 1
LIFE for Paids only F 12/30/2019 02/27/1966 12/30/2019 $64.11 0
Life (no PW and/or LBO) F 12/30/2019 02/27/1966 12/30/2019 $100,000.00 1
LIFE for Paids only M 01/12/2022 07/11/1971 01/12/2022 $15.49 0
Life (no PW and/or LBO) M 01/12/2022 07/11/1971 01/12/2022 $10,000.00 1
LIFE for Paids only M 07/26/2020 01/30/1961 07/26/2020 $33.84 0
Life (no PW and/or LBO) M 07/26/2020 01/30/1961 07/26/2020 $100,000.00 1
Life (no PW and/or LBO) M 07/26/2020 01/30/1961 07/26/2020 $50,000.00 1
Life (no PW and/or LBO) F 03/07/2023 05/16/1983 03/07/2023 $100,000.00 1
LIFE for Paids only M 02/27/2019 05/30/1960 02/27/2019 $153.15 0
Life (no PW and/or LBO) M 02/27/2019 05/30/1960 02/27/2019 $100,000.00 1
LIFE for Paids only M 04/05/2022 03/22/1947 04/05/2022 $134.01 0
Life (no PW and/or LBO) M 04/05/2022 03/22/1947 04/05/2022 $125,000.00 1
Life (no PW and/or LBO) M 04/05/2022 03/22/1947 04/05/2022 $50,000.00 1
Life (no PW and/or LBO) U 11/20/2023 02/08/1967 11/20/2023 $20,000.00 1
LIFE for Paids only M 08/07/2019 01/26/1966 08/07/2019 $702.09 0
Life (no PW and/or LBO) M 08/07/2019 01/26/1966 08/07/2019 $125,000.00 1
Life (no PW and/or LBO) M 08/07/2019 01/26/1966 08/07/2019 $100,000.00 1
Life (no PW and/or LBO) M 08/07/2019 01/26/1966 08/07/2019 $250,000.00 0 xlsLife Liability By Incurred D
File details come from the government source that posted it. Updated .