AttachmentHClaimsEnrollment.pdf
PDF 60 KB Posted
- Attached to
- RFQ/P Dental Insurance Services
- Solicitation number
- S162324-vCurrent
- Issued by
- Middlesex County, Norfolk County, Suffolk County, Quincy City, Boston City, Massachusetts
About this file
This document appears to be an Attachment Claims and Enrollment Data Plan for a government health insurance program. It contains product reporting period data on individual, two-party, SPMD (?) and family subscriber and member counts, as well as paid capitation premium amounts for the program from June 2010 to March 2013. The data is broken down by month and product type, with summary totals provided for each annual reporting period. The document indicates this is for a Dental Blue PPO and Dental Blue Standard insurance plan, with the totals for each plan provided separately.
The document provides detailed enrollment and claims data for this government health insurance program, including subscriber and member counts as well as the paid capitation premiums. It appears to cover multiple years of historical data for these dental insurance products. No other information is provided about the specific contract or procurement details.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| AddenumAttachmentNo1.pdf | ||
| AddenumAttachmentNo3.pdf | ||
| AttachmentD.pdf | ||
| RFQP.pdf | ||
| S162324-vCurrent_OD.xlsx | XLSX spreadsheet | |
| AddenumAttachmentNo2.pdf | ||
| AddenumAttachmentNo4.pdf | ||
| AttachmentE.pdf | ||
| AttachmentF.pdf | ||
| AddendumNo1.pdf | ||
| AddendumNo2.pdf | ||
| AttachmentA.pdf | ||
| AttachmentCCompensation.pdf | ||
| AttachmentG.pdf |
Show all 14
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
Attachment Claims and Enrollment Data
Plan Product Reporting Period
Month Individual 2 Party SPMD Family Total Subscribers
Total Members
Paid Capitation Premium
201006 1 1 2 4 $0 $0 $148
201007 1 1 2 4 $0 $0 $148
201008 1 1 2 4 $122 $0 $148
201009 1 1 2 4 $0 $0 $148
201010 1 1 2 4 $0 $0 $148
201011 1 1 2 4 $0 $0 $148
201012 1 1 2 4 $0 $0 $148
201101 1 1 2 4 $0 $0 $148
201102 1 1 2 4 $0 $0 $148
201103 1 1 2 4 $568 $0 $148
201104 1 1 2 4 $267 $0 $148
201105 1 1 2 4 $152 $0 $148
Summary 12 12 24 48 $1,108 $0 $1,774
201106 1 1 2 4 $400 $0 $148
201107 1 1 2 4 $0 $0 $148
201108 1 1 2 4 $0 $0 $148
201109 1 1 2 4 $0 $0 $148
201110 1 1 2 4 $0 $0 $148
201111 1 1 2 4 $536 $0 $148
201112 1 1 2 4 $143 $0 $148
201201 1 1 2 4 $0 $0 $148
201202 1 1 2 4 $0 $0 $148
201203 1 1 2 4 $476 $0 $148
201204 1 1 2 4 $352 $0 $148
201205 1 1 2 4 $0 $0 $148
Summary 12 12 24 48 $1,907 $0 $1,774
201206 1 1 2 4 $187 $0 $148
201207 1 1 2 4 $98 $0 $148
201208 1 1 2 4 $203 $0 $148
201209 1 1 2 4 $462 $0 $148
201210 1 1 2 4 $0 $0 $148
201211 1 1 2 4 $0 $0 $148
201212 1 1 2 4 $0 $0 $148
201301 1 0 1 1 $0 $0 $43
201302 1 0 1 1 $149 $0 $43
201303 1 0 1 1 $187 $0 $43
201304 1 0 1 1 $0 $0 $43
201305 1 0 1 1 $0 $0 $43
Summary 12 7 19 33 $1,285 $0 $1,249
201306 1 0 1 1 $0 $0 $43
201307 1 0 1 1 $0 $0 $43
Summary 2 0 2 2 $0 $0 $86
DENTAL
BLUE PPO
Jun '10-May '11
Jun '11-May '12
Jun '12-May '13
Other
Summary 38 31 69 131 $4,299 $0 $4,883
201006 80 229 309 839 $28,583 $0 $32,323
201007 79 230 309 838 $20,712 $0 $32,382
201008 79 229 308 837 $32,716 $0 $32,273
201009 79 228 307 834 $22,334 $0 $32,150
201010 79 228 307 832 $20,331 $0 $32,150
201011 79 228 307 831 $24,110 $0 $32,145
201012 79 227 306 827 $24,514 $0 $32,026
201101 76 231 307 830 $33,598 $0 $32,369
201102 76 230 306 827 $27,566 $0 $32,233
201103 76 229 305 825 $29,056 $0 $32,122
201104 77 229 306 825 $26,378 $0 $32,149
201105 76 230 306 825 $25,379 $0 $32,245
Summary 935 2,748 3,683 9,970 $315,277 $0 $386,567
201106 76 230 306 825 $24,170 $0 $32,245
201107 76 230 306 824 $23,731 $0 $32,245
201108 76 229 305 821 $25,866 $0 $32,122
201109 75 228 303 818 $25,897 $0 $31,948
201110 74 229 303 818 $23,127 $0 $32,021
201111 74 228 302 813 $21,786 $0 $31,897
201112 74 228 302 810 $24,919 $0 $31,897
201201 72 228 300 809 $36,551 $0 $31,797
201202 72 228 300 807 $28,305 $0 $31,788
201203 72 227 299 802 $32,300 $0 $31,673
201204 72 226 298 799 $28,852 $0 $31,550
201205 73 225 298 795 $23,962 $0 $31,476
Summary 886 2,736 3,622 9,741 $319,466 $0 $382,660
201206 73 224 297 790 $27,246 $0 $31,351
201207 72 225 297 790 $21,136 $0 $31,426
201208 72 224 296 784 $25,297 $0 $31,302
201209 71 226 297 787 $24,896 $0 $31,476
201210 70 224 294 778 $23,040 $0 $31,202
201211 70 223 293 775 $22,401 $0 $31,074
201212 72 222 294 773 $29,494 $0 $31,055
201301 69 221 290 765 $41,451 $0 $30,787
201302 69 219 288 759 $27,547 $0 $30,534
201303 68 219 287 756 $26,149 $0 $30,471
201304 68 217 285 750 $28,941 $0 $30,228
201305 68 215 283 745 $26,453 $0 $29,989
Summary 842 2,659 3,501 9,252 $324,051 $0 $370,896
201001 0 0 0 $201 $0 $0
201003 0 0 0 $330 $0 $0
201004 0 0 0 $156 $0 $0
201005 0 0 0 $1,448 $0 $0
201306 68 213 281 740 $21,611 $0 $29,843
201307 68 213 281 739 $14,207 $0 $29,865
Summary 136 426 562 1,479 $37,954 $0 $59,708
DENTAL
BLUE
STANDARD
Jun '10-May '11
Jun '11-May '12
Jun '12-May '13
Other
Summary 2,799 8,569 11,368 30,442 $996,748 $0 $1,199,831
Summary 2,837 8,600 11,437 30,573 $1,001,047 $0 $1,204,714
Sheet1
File details come from the government source that posted it. Updated .