Juniper Fitness and Clinic Administration: Remittance adjustment lines
Remittance adjustment lines for Juniper Fitness and Clinic Administration. 35 rows, one per adjustment rather than one per service line, because a paid service line carries two adjustments and a denied one carries a single CO 97. Grouping by adjustment group gives 304.00 USD of CO write-offs and 175.20 USD of PR patient responsibility. Summing the charged column instead double counts, because charged repeats on both adjustment rows of a paid line.
csv
text/csv
- Document Set
- healthcare
- Industry
- fitness-clinic-administration
- Source Kit
- appointment-capacity
- Entity
- Juniper Fitness and Clinic Administration
- Synthetic
- true
- As Of
- 2026-09-08
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- healthcare
- Industry
- fitness-clinic-administration
- Source Kit
- appointment-capacity
- Entity
- Juniper Fitness and Clinic Administration
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 35
- Service Lines
- 18
- Contractual Total
- 304.00
- Patient Responsibility Total
- 175.20
- Double Count Trap
- true
Testing contract
Expected to pass- Scenario
- Group by adjustment_group and total adjustment_usd, then try to total charged_usd and see what happens.
- Expected result
- The CO group totals 304.00 and the PR group 175.20, which together are 479.20 and leave 700.80 paid out of 1180.00 charged. Summing charged_usd across all 35 rows gives 2275.00, not 1180.00, because the paid lines appear twice.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Juniper Fitness and Clinic Administration: Remittance adjustment lines” is a deterministic Novus Examples fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 35 rows. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("eob-lines.csv")
print(df.head())
print(df.dtypes)Related files
- csvJuniper Fitness and Clinic Administration: Claim adjustment reason codesClaim adjustment reason codes for Juniper Fitness and Clinic Administration. The 5 adjustment codes the remittance uses, each with its group code and whether it is contractual, patient responsibility or another adjustment. The distinction matters: a CO adjustment can never be billed to the patient and a PR adjustment is exactly what is billed, so a reader that ignores the group code bills the wrong party.
- csvJuniper Fitness and Clinic Administration: Claim status registerClaim status register for Juniper Fitness and Clinic Administration. All 16 claims with the status code the 835 CLP02 carries, the payer control number and the 17 days between submission and payment. 1 claim is status 4, denied, and the rest are status 1, processed as primary. Every payer control number is unique and appears once in remittance-835.edi.
- csvJuniper Fitness and Clinic Administration: Denial registerDenial register for Juniper Fitness and Clinic Administration. The single denied claim, CLM-0011, denied in full for 85.00 USD under CO 97 with a 90 day appeal deadline of 2026-12-24. The group code is CO, so the amount is a contractual write-off and must not be billed to the patient even though nothing was paid, which is exactly the case a reader gets wrong by assuming an unpaid claim becomes a patient balance.
- csvJuniper Fitness and Clinic Administration: Diagnosis code tableDiagnosis code table for Juniper Fitness and Clinic Administration. The 3 diagnosis codes referenced by the claims, all of them administrative rather than clinical: a routine assessment, a follow-up and an equipment familiarisation visit. Every code is a synthetic placeholder and the table says so in its own column.
- csvJuniper Fitness and Clinic Administration: Encounter registerEncounter register for Juniper Fitness and Clinic Administration. 16 encounters, one for each confirmed booking in the appointment model. The two cancelled bookings are absent, so the register has 16 rows where the booking table has 18. Charges sum to 1,180.00 USD across 18 service lines, allowed to 876.00, and the payers paid 700.80 leaving 175.20 with patients.
- csvJuniper Fitness and Clinic Administration: Patient rosterPatient roster for Juniper Fitness and Clinic Administration. The 16 patients, which are the fictional visitor names the appointment model already carries, joined to their booking, encounter, claim and payer. Every row carries the same synthetic date of birth of 1900-01-01 and a column that says so, because the X12 claim needs a demographic segment and this set will not hold a plausible personal record to fill it.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.