Sample Data.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Historical Medical Claims Data Analysis
- Solicitation number
- 15BCMS26Q70000005
About this file
This file is a sample dataset in spreadsheet format containing historical medical claims data. The dataset includes two claim records from WVU Hospitals for a patient treated on January 10, 2020, under payor plan VB230081 with FCI McDowell in Welch, West Virginia. The records contain comprehensive claim information including patient demographics (with redacted personally identifiable information), clinical details with multiple diagnostic codes (D57.1, H36, H43.11, H53.002, Z87.891), procedure codes (G0463 for hospital outpatient clinic visit assessment and 92250 for fundus photography), and billing information with facility NPI 1841271459 and TIN 550643304. The claim line items reference revenue codes 510 and 920, place of service code 73 and 532 respectively, with service units and charge amounts documented.
The dataset structure includes standard healthcare claims data fields such as claim type, claim ID, patient identifiers, insurance authorization information, admit and discharge details, provider NPIs and TINs, and procedural descriptions with HCPCS modifiers. This sample data appears designed to demonstrate the format and content requirements for the Department of Justice Bureau of Prisons solicitation 15BCMS26Q70000005 for Historical Medical Claims Data Analysis, serving as a template or example of the claims data that contractors would be expected to process or analyze under that federal contract opportunity.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 15BCMS26Q70000005 Mod 0003.pdf | ||
| BOP_QA_List_.pdf | ||
| 15BCMS26Q70000005 Mod 001.pdf | ||
| 15BCMS26Q70000005 Historical Medical Claims Data Analysis.pdf |
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
Sheet1
| partner_name | claim_type | claim_id | claim_line_number | patient_id | patient_first_name | patient_last_name | patient_date_of_birth | patient_gender | Insured_id | authorization_number | payor_plan_name | payor_address_city | payor_address_state | payor_address_zip | diagnostic_code_1 | diagnostic_code_2 | diagnostic_code_3 | diagnostic_code_4 | diagnostic_code_5 | diagnostic_code_6 | diagnostic_code_7 | diagnostic_code_8 | diagnostic_code_9 | diagnostic_code_10 | diagnostic_code_11 | diagnostic_code_12 | diagnostic_code_13 | diagnostic_code_14 | diagnostic_code_15 | diagnostic_code_16 | diagnostic_code_17 | diagnostic_code_18 | diagnostic_code_19 | diagnostic_code_20 | admit_diagnostic_code_1 | type_of_bill_code | admit_type_code | admit_source_code | admit_date | statement_cover_period_from | statement_cover_period_through | service_start_date | service_end_date | discharge_status_code | revenue_code | procedure_code | procedure_description | hcpcs_modifier_1 | hcpcs_modifier_2 |
| REDACTED | I | 14507861 | 1 | REDACTED | REDACTED | REDACTED | REDACTED | REDACTED | REDACTED | VB230081 | FCI McDowell | Welch | West Virginia | 24801 | D57.1 | H36 | H43.11 | H53.002 | Z87.891 | 131 | 3 | 2 | 1/10/20 | 1/10/20 | 1/10/20 | 1/10/20 | 1 | 510 | G0463 | Hospital outpatient clinic visit for assessment and management of a patient | |||||||||||||||||||
| REDACTED | I | 14507861 | 2 | REDACTED | REDACTED | REDACTED | REDACTED | REDACTED | REDACTED | VB230081 | FCI McDowell | Welch | West Virginia | 24801 | D57.1 | H36 | H43.11 | H53.002 | Z87.891 | 131 | 3 | 2 | 1/10/20 | 1/10/20 | 1/10/20 | 1/10/20 | 1 | 920 | 92250 | Fundus photography with interpretation and report |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .