Attachment_3_-_STD_LTD_Claims_Data_(re-sorted).xls

105 KB Posted

Attached to
Disability Insurance
Solicitation number
CC15HQR0009
Issued by

About this file

From the source

Attachment 3 (re-sorted)

View the file

Other files

File Type Posted
CC15HQR0009 _Disability_Insurance _Responses_to_questions_2.pdf PDF
CC15HQR0009 _Disability_Insurance _Responses_to_questions.pdf PDF
Attachment_8_-_Technical_Attachment_8 _STD_LTD_Rate_and_Premium_History_(OCC_and_OFR).xls XLS spreadsheet
Attachment_6_-_Technical_Attachment_6 _OFR_STD_Certificate_of_Insurance.pdf PDF
Attachment_1_-_Technical_Attachment_1_of_the_PWS _OCC_STD_LTD_Census_Data.xlsx XLSX spreadsheet
Attachment_12_-_IT_Accessibility_Questionnaire.doc DOC document
Attachment_5_-_Technical_Attachment_5 _OCC_LTD_Certificate_of_Insurance.pdf PDF
Attachment_7_-_Technical_Attachment_7 _OFR_LTD_Certificate_of_Insurance.pdf PDF
CC15HQR0009_Disability_Insurance_RFP.pdf PDF
Attachment_13_-_Questions_Form.docx DOCX document
Attachment_10_-_Conditional_Access_to_Sensitive_But_Unclassified_Information_Non-Disclosure_Agreement.doc DOC document
Attachment_14_-_Technical_Capability_Questionnaire.doc DOC document
Attachment_3_-_Technical_Attachment_3_of_the_PWS _STD_LTD_Claims_Data.xls XLS spreadsheet
Attachment_11_-_Annual_NIST_800-53_Security_Self-Assessment.pdf PDF
Attachment_2_-_Technical_Attachment_2_of_the_PWS _OFR_STD_LTD_Census_Data.xlsx XLSX spreadsheet
Attachment_4_-_Technical_Attachment_4 _OCC_STD_Certificate_of_Insurance.pdf PDF
Attachment_15_-_Past_Performance_Questionnaires.docx DOCX document
Attachment_9_-_Technical_Attachment_9 _OCC_and_OFR_Lives_Volumes.xls XLS spreadsheet
Show all 18

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

STD_1

ATTACHMENT 3 - STD CLAIMS DATA
VDT-0980035 - As of 12/31/2014
Period DescriptionFully Revealed Total
Start Date1/1/101/1/111/1/121/1/131/1/14
End Date12/31/1012/31/1112/31/1212/31/1312/26/14
# of months121212121260
Constant Premium$ 196,235$ 211,067$ 249,752$ 322,313$ 351,823$ 1,331,190
Paid Claims$ 83,351$ 111,847$ 65,715$ 55,707$ 97,083$ 413,703
IBNR$ 11,075$ 2,414$ 2,472$ 4,638$ 1,886$ 22,485
Net Incurred Claims$ 94,427$ 114,262$ 68,188$ 60,345$ 98,969$ 436,191
Loss Ratio48.3%54.2%27.3%18.8%25.8%32.8%
Total Claims14165111662

STD_2

ATTACHMENT 3 - STD CLAIMS DATA
Claims Reporting - 01/01/2010 - 12/31/2014
Offset 1 AmtOffset 1 DescOffset 2 AmtOffset 2 DescDate of DisabilityGenderClaim Status DescriptionClaim Status Effec. DateEmployerCurrent Net BenefitTotal Benefits Paid
$0$02/3/10FemaleClosed3/29/10OCC$ 556$ 6,513
$0$04/3/10FemaleClosed4/8/10OCC$ 753$ 5,163
$0$03/23/10FemaleClosed5/14/10OCC$ 1,047$ 6,132
$0$02/25/10MaleClosed5/17/10OCC$ 936$ 9,494
$0$06/1/10MaleClosed6/9/10OCC$ 680$ 2,817
$0$04/9/10FemaleClosed7/1/10OCC$ 971$ 11,513
$0$07/3/10FemaleClosed7/22/10OCC$ 1,589$ 5,675
$0$07/24/10FemaleClosed8/19/10OCC$ 883$ 5,121
$0$08/14/10FemaleClosed8/24/10OCC$ 848$ 6,178
$0$08/13/10FemaleClosed8/30/10OCC$ 1,563$ 2,903
$0$04/11/10MaleClosed8/31/10OCC$ 25$ -
$0$06/3/10FemaleClosed9/13/10OCC$ 815$ -
$0$09/24/10FemaleClosed12/1/10OCC$ 1,842$ 21,841
2010 Total$ 12,508$ 83,351
$0$012/30/10FemaleClosed1/28/11OCC$ 735$ 1,050
$0$011/20/10FemaleClosed2/2/11OCC$ 1,175$ 336
$0$011/5/10FemaleClosed2/14/11OCC$ 626$ -
$0$012/24/10FemaleClosed2/16/11OCC$ 740$ 846
$0$01/28/11FemaleClosed2/16/11OCC$ 688$ 4,423
$0$03/12/11FemaleClosed3/23/11OCC$ 692$ 5,042
$559Statutory Disability$03/21/11MaleClosed6/13/11OCC$ 914$ 17,466
$559Statutory Disability$06/22/11FemaleClosed7/15/11OCC$ 1,057$ -
$0$04/22/11FemaleClosed8/12/11OCC$ 933$ 9,863
$0$08/5/11FemaleClosed8/17/11OCC$ 726$ 3,111
$0$06/29/11FemaleClosed8/19/11OCC$ 625$ 2,679
$0$08/20/11FemaleClosed9/1/11OCC$ 628$ 1,615
$587Social Security Retirement$03/2/11FemaleClosed9/8/11OCC$ 899$ 4,624
$0$09/9/11FemaleClosed9/23/11OCC$ 723$ 4,338
$0$07/26/11FemaleClosed9/27/11OCC$ 1,022$ 13,140
$0$897Salary Continuance8/16/11FemaleClosed11/3/11OCC$ 25$ 2,704
$0$09/30/11FemaleClosed11/9/11OFR$ 1,634$ 7,003
$0$06/9/11FemaleClosed12/5/11OCC$ 1,623$ -
$0$492Social Security Retirement9/6/11MaleClosed12/21/11OCC$ 1,524$ 13,283
2011 Total$ 16,989$ 91,522
$0$06/17/11FemaleClosed1/26/12OCC$ 777$ -
$0$05/5/11FemaleClosed2/28/12OCC$ 1,899$ 18,990
$0$0Statutory Disability10/31/11FemaleClosed3/6/12OCC$ 1,622$ 8,805
$170Statutory Disability$07/8/11FemaleClosed3/9/12OCC$ 787$ 5,742
$0$03/17/12FemaleClosed3/30/12OCC$ 1,622$ 10,891
$0$05/1/12MaleClosed5/14/12OCC$ 1,962$ -
$0$05/22/12FemaleClosed6/27/12OCC$ 1,643$ 7,980
$0$06/24/12FemaleClosed7/20/12OCC$ 2,016$ -
$1,277RTW Earnings$07/20/12FemaleClosed10/1/12OCC$ 912$ 10,039
$0$09/29/12FemaleClosed10/16/12OCC$ 1,707$ 8,047
$0$0Social Security Retirement8/15/12MaleClosed11/13/12OCC$ 2,016$ 22,176
$0$010/18/12FemaleClosed12/6/12OCC$ 694$ -
2012 Total$ 17,656$ 92,669
$0$03/2/13FemaleClosed3/21/13OFR$ 1,185$ 677
$0$01/11/13FemaleClosed4/2/13OCC$ 986$ 9,437
$0$04/11/13FemaleClosed7/15/13OCC$ 1,883$ 3,844
$0$03/27/13FemaleClosed7/23/13OCC$ 637$ 7,644
$0$011/30/12MaleClosed8/22/13OCC$ 1,739$ -
$0$03/12/13MaleClosed8/28/13OCC$ 2,105$ -
$0$07/1/13FemaleClosed10/1/13OFR$ 1,500$ -
$0$07/11/13FemaleClosed10/4/13OCC$ 683$ 2,572
$0$07/9/13FemaleClosed12/3/13OFR$ 1,370$ 5,482
$0$08/31/13FemaleClosed12/3/13OFR$ 1,487$ 5,948
$0$08/7/13MaleClosed12/24/13OCC$ 1,867$ 14,136
$0$011/8/13FemaleClosed12/27/13OFR$ 1,367$ 6,054
2013 Total$ 16,809$ 55,795
$0$010/10/13FemaleClosed1/10/14OFR$ 25$ -
$0$011/2/13MaleClosed3/13/14OCC$ 1,820$ 2,694
$0$02/14/14FemaleClosed3/14/14OCC$ 822$ 2,818
$0$01/1/14FemaleClosed3/14/14OFR$ 1,584$ 5,205
$0$012/20/13FemaleClosed3/17/14OCC$ 752$ 8,487
$0$011/30/13MaleClosed3/24/14OCC$ 2,118$ -
$0$02/12/14FemaleClosed4/11/14OFR$ 1,609$ 9,194
$0$04/17/14FemaleClosed5/2/14OCC$ 25$ -
$0$02/12/14FemaleClosed5/14/14OCC$ 957$ 1,367
$0$02/12/14FemaleClosed5/14/14OCC$ 1,849$ -
$0$03/6/14FemaleClosed5/21/14OCC$ 1,305$ 4,847
$0$04/22/14FemaleClosed6/12/14OCC$ 767$ 3,178
$0$03/29/14FemaleClosed6/26/14OCC$ 713$ -
$0$07/25/14FemaleClosed9/30/14OCC$ 3,173$ -
$0$08/29/14FemaleClosed10/3/14OCC$ 685$ 2,642
$0$07/25/14FemaleClosed10/14/14OCC$ 787$ 1,462
$0$09/16/14FemaleClosed10/22/14OCC$ 1,214$ 3,642
$0$09/22/14FemaleClosed10/27/14OCC$ 1,578$ -
$0$010/3/14FemaleClosed10/28/14OCC$ 25$ -
$0$08/27/14FemaleClosed10/29/14OCC$ 3,173$ 8,612
$0$07/18/14MaleClosed11/4/14OCC$ 841$ 9,732
$0$09/26/14FemaleClosed11/14/14OCC$ 1,178$ 2,356
$0$05/17/14FemaleClosed12/3/14OCC$ 1,238$ 7,782
$0$011/8/14FemaleActive12/5/14OCC$ 865$ 9,021
$0$010/28/14FemaleClosed12/18/14OCC$ 748$ 6,625
$0$011/7/14FemaleClosed12/30/14OCC$ 681$ 3,794
2014 Total$ 30,532$ 93,457
Grand Total$ 94,495$ 416,794

&C&"Times New Roman,Regular"&12Page &P of &N

LTD_1

ATTACHMENT 3 - LTD CLAIMS DATA
LK-0980140 - As of 01/22/2015
Period Description(Not included in Fully Revealed Total)Fully Revealed Total
Start Date1/1/101/1/111/1/121/1/131/1/14
End Date12/31/1012/31/1112/31/1212/31/1312/26/14
# of months121212121260
Constant Premium$ 601,564$ 611,456$ 689,991$ 836,245$ 867,896$ 3,607,152
Paid Claims$ 429,637$ 195,090$ 152,538$ 91,282$ 35,280$ 903,827
Reserves$ 334,339$ 103,385$ 749,753$ -$ -$ 1,187,477
IBNR$ -$ -$ 1,067$ 6,592$ 158,059$ 165,718
Net Incurred Claims$ 763,976$ 298,475$ 903,358$ 97,874$ 193,339$ 2,257,022
Loss Ratio127.0%48.8%130.9%11.7%22.3%62.6%
Open/Pending Claims212005
Closed Claims4313213
Total Claims6433218

LTD_2

ATTACHMENT 3 - LTD CLAIMS DATA
Claims Reporting 01/01/10 - 12/31/14
Offset 1 AmtOffset 1 DescOffset 2 AmtOffset 2 DescOffset 3 AmtOffset 3 DescOffset 4 AmtDate of DisabilityGenderClaim Status DescriptionEmployerClaim Status Effec. DateCurrent Net BenefitTotal Benefits Paid
$1,988Social Security Disability$0Short Term Disability$909Pension$0.002/25/10MaleClosedOCC9/6/12$1,160$95,168
$1,678Social Security Disability$0Short Term Disability$0Statutory Disability$0.004/9/10FemaleClosedOCC11/29/11$1,024$87,078
$1,000Social Security Retirement$0Salary Continuance$0RTW Earnings$0.004/11/10MaleClosedOCC12/13/11$3,848$56,808
$2,037Social Security Disability$0Dependent Social Security Disability$0$0.006/26/10MaleActiveOCC5/16/12$707$44,996
$0Social Security Disability$0RTW Earnings$5,600Pension$0.009/3/10MaleActiveOCC2/27/13$2,362$114,286
$0Social Security Disability$2,774RTW Earnings$0$0.009/24/10FemaleClosedOCC6/22/11$5,209$34,370
$0Social Security Disability$0$0$0.0011/5/10FemaleClosedOCC4/20/11$2,714$0
$0Social Security Disability$0$0$0.0011/20/10FemaleClosedOCC5/2/11$5,092$0
Total 2010$22,116$432,706
$0Social Security Disability$2,431Statutory Disability$0$0.003/22/11MaleClosedOCC10/27/11$3,953$17,261
$0Social Security Disability$0Dependent Social Security Disability$4,277Statutory Disability$0.004/22/11FemaleClosedOCC7/12/11$404$0
$0Social Security Disability$0$0$0.005/5/11FemaleClosedOCC7/14/11$8,231$0
$0Social Security Disability$0Other$0$0.006/3/11FemaleClosedOCC1/4/12$7,034$10,244
$1,815Social Security Disability$0Salary Continuance$0$0.006/17/11FemaleClosedOCC7/8/13$1,553$38,970
$0Social Security Disability$0$0$0.006/29/11FemaleClosedOCC8/26/11$2,707$0
$0Social Security Disability$737Statutory Disability$0$0.007/8/11FemaleClosedOCC8/26/11$3,408$0
$911Social Security Disability$0Short Term Disability$943Pension$0.007/14/11FemaleActiveOCC8/20/12$2,573$131,188
$0Social Security Disability$0$0$0.0010/31/11FemaleClosedOCC2/8/12$7,027$0
Total 2011$36,890$197,663
$1,567Social Security Disability$0$0$0.006/6/12FemaleActiveOCC8/14/12$1,450$42,739
$0Social Security Disability$0$0$0.006/24/12FemaleClosedOCC10/24/12$8,735$0
$0RTW Earnings$0$0$0.007/20/12FemaleClosedOCC9/21/12$9,484$0
$2,690Social Security Retirement$0$0$0.008/15/12MaleClosedOCC11/8/12$6,045$0
$657RTW Earnings$0Salary Continuance$0Social Security Disability$0.009/14/12FemaleClosedOCC4/17/14$4,393$33,900
$2,491Social Security Disability$0$0$0.0011/30/12MaleActiveOCC9/26/13$4,476$80,375
Total 2012$34,583$157,014
$0Social Security Disability$4,624Statutory Disability$0$0.001/11/13FemaleClosedOCC4/1/13$427$0
$0Social Security Disability$0$0$0.003/12/13MaleClosedOCC8/18/14$9,122$0
$0Social Security Disability$0Short Term Disability$0$0.003/27/13FemaleClosedOCC7/8/13$2,760$4,784
$0Social Security Disability$0$0$0.008/7/13MaleClosedOCC3/24/14$6,474$30,212
$0Social Security Disability$0$0$0.0011/22/13MaleClosedOFR2/13/14$7,850$0
$0Social Security Disability$0Statutory Disability$0$0.0011/30/13MaleClosedOCC9/8/14$9,177$56,286
$0Social Security Disability$0$0$0.0012/20/13FemaleClosedOCC3/12/14$3,260$0
Total 2013$39,070$91,282
$0Social Security Disability$0Salary Continuance$0$0.003/29/14FemaleClosedOCC9/10/14$3,088$2,402
$0Social Security Disability$0$0$0.007/18/14MaleClosedOCC10/24/14$3,644$0
Total 2014$6,732$2,402
Grand Total$139,391$881,067

&C&"Times New Roman,Regular"&12Page &P of &N

File details come from the government source that posted it. Updated .