1.5 - Paid Claims Summary 201901-202012.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Third Party Administrator (TPA) for the Public Employees' Benefits Program (PEBP) State and local contract opportunity
Solicitation number
95PEBP-S1579
Issued by
Churchill County, Nevada

About this file

Written by GovTribe AI ·

The provided document appears to be a Paid Claims Summary for the Nevada Public Employees' Benefits Program (PEBP) covering the period from January 2019 to December 2020. The summary includes medical and dental claims data, both in-state and out-of-state, broken down by report month and the number of claims and total paid amounts. The key details indicate that PEBP is moving to Aetna for in-state claims administration effective July 1, 2021.

The related state and local contract opportunity is for a Third Party Administrator (TPA) for PEBP, which serves the jurisdiction of Carson City, Nevada. The contract details, such as response dates, award dates, and contract term, are not provided in the given information.

View the file

Other files for this state and local contract opportunity

Other files attached to Third Party Administrator (TPA) for the Public Employees' Benefits Program (PEBP), newest first.
File Type Posted
1.1 - RFP Information.docx DOCX document
1.2 - Standard Form Contract.docx DOCX document
1.4 - Sample Business Associate Agreement.docx DOCX document
1.7 - Discount Instructions.pdf PDF
95PEBP-S1579 Letter of Intent.pdf PDF
Quote Instructions.pdf PDF
1.3 - Insurance Schedule.docx DOCX document
95PEBP-S1579 Bid QA.xlsx XLSX spreadsheet
95PEBP-S1579 Presentation Notification~2.pdf PDF
2.2 - TPA RFP Revised 2021-05-07.xlsx XLSX spreadsheet
2.3 - References - CONFIDENTIAL.xlsx XLSX spreadsheet
1.6 - Enrollment Summary 202104.xlsx XLSX spreadsheet
2.1 - Intent to bid.pdf PDF
Show all 13

On GovTribe

Work with this file on GovTribe

  • 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.

Sheet1

MEDICAL CLAIMSDENTAL CLAIMS
IN STATEOUT OF STATE
REPORTMONTH# CLAIMSTOTAL PAID# CLAIMSTOTAL PAIDREPORTMONTH# CLAIMSTOTAL PAID
01-201935,093$11,437,99217,174$5,368,70601-201913,300$2,166,282
02-201940,574$12,211,01615,332$4,950,52802-201912,137$1,944,589
03-201940,648$12,239,94115,428$3,686,53403-201911,902$1,847,727
04-201941,330$11,924,92715,767$3,049,15904-201913,428$2,131,581
05-201937,977$13,212,62016,178$6,188,56705-201912,746$2,029,053
06-201943,939$13,498,40116,281$4,325,09806-201912,702$1,969,143
07-201929,456$11,233,51715,014$4,831,84307-201913,441$2,236,617
08-201949,354$11,564,88320,012$4,325,94608-201915,403$2,582,013
09-201945,025$9,958,13018,993$3,104,38309-201913,978$2,312,826
10-201944,745$13,652,26418,878$4,406,16910-201914,256$2,363,913
11-201943,805$10,391,04418,705$4,066,13111-201912,542$2,076,716
12-201938,109$12,075,81315,720$3,488,52012-201911,350$1,777,633
01-202039,362$11,748,48718,422$5,456,11001-202013,080$2,241,940
02-202041,992$13,318,85817,520$4,115,23802-202012,298$2,028,858
03-202045,097$14,609,28918,476$4,543,09603-202010,361$1,815,401
04-202030,114$13,572,92715,475$5,606,16604-20202,225$403,162
05-202028,140$8,515,02412,210$2,603,70805-20205,374$923,994
06-202040,401$13,225,45115,820$3,544,57706-202013,202$2,298,731
07-202035,950$9,363,99714,665$2,553,31307-202011,656$2,244,880
08-202038,791$11,614,40116,305$4,868,52408-202012,064$2,198,197
09-202035,296$8,130,42613,911$2,923,27109-202011,717$2,133,348
10-202043,239$11,635,43316,833$4,273,58510-202012,197$2,151,073
11-202041,312$11,256,68516,486$3,804,93211-202010,819$2,004,554
12-202039,082$11,031,71517,640$3,102,99712-202011,105$1,983,338
*In State is based on HometownHealth and Sierra Health Options; Out of State is everything else
PEBP is moving to Aetna for In-State Claims on 7/1/2021

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