<< Click to Display Table of Contents >> Navigation:  Charity Care and Collections > S-10 Reporting > Total Hospital Bad Debt S10 > Description and Usage

The Total Hospital Bad Debt S10 report is one of three reports used for gathering information for the S-10 worksheet to comply with CMS reporting mandates. This report will display patients who have been written off to bad debt within the reporting period.

 

NOTE: If there are multiple bad debt write off charges on the account, the report will pull the first bad debt item number charged within the date range with a "WO" summary code.

 

This report will only display in a CSV format.

 

Listed below is an explanation of each column:

 

•Insurance Status (insurance_status): One of the following statuses will display:

▪Uninsured: This will pull for each line of a patient's account if the original financial class starts with a "P".

▪Insured: This will pull all other original financial classes.

 

•Primary Payor Plan (primary_payor): The name of the patient's primary insurance.

 

•Secondary Payor Plan (secondary_payor): The name of the patient's secondary insurance.

 

•Patient Identification Number (patient_identification_number): The patient's account number.

 

•Patient Name (patient_name): The patient's full name.

 

•Patient Birth Date (patient_birth_date): The patient's date of birth.

 

•Social Security Number (social_security_number): The patient's Social Security Number.

 

•Patient Gender (gender_desc): The patient's birth sex.

 

•Admit Date (admit_date): The patient's admit date.

 

•Discharge Date (discharge_date): The patient's discharge date.

 

•Service Indicator (service_indicator): Will display either "inpatient" or "Outpatient" depending on the stay type of the patient.

 

NOTE: Patient accounts will be considered inpatient if a "Y" is in the Census Reports column on page 4 of AHIS next to the stay type. Patients will be considered outpatient if an "N" is in the Census Reports column on page 4 of AHIS next to the stay type.

 

•Revenue Code (revenue_code): The revenue code associated with the charge on the patient's account. If there are multiple charges on the patients account with the same revenue code, these charges will all be combined into one line.

 

NOTE: Charges with a summary code beginning with a "W" or have "Adjustment Charge" set to Y in the Charge Summary Code table will not pull on this report.

 

•Revenue Code Total Charges for the Claim (charge_total): The total dollar amount per revenue code on the patient's account.

 

•Date of Write Off to Bad Debt (first_write_off_date): The date of when the account was first written off to bad debt.

 

NOTE: This field will look to the first bad debt item numbers charged to patient accounts with a summary code of "WO".

 

•Total Patient Payments for Services Provided (patient_payments): The total of all payments made by the patient on the account.

 

NOTE: A patient payment will be determined if the receipt code used to post the payment is designated as a Patient Payment in the Receipt Table.

 

•Total Third Party Payment for Services Provided (third_party_payments): The total of all payments made by a third party.

 

NOTE: A third party payment will be determined if the receipt code used to post the payment is designated as an Insurance Receipt Code in the Receipt Table.

 

•Patient Charity Contractual Amount (patient_charity_care_contractual_amount): Pulls the amount in the Charity Care Amount field in the Charity Care and Collections screen.

 

•Other Contractual Amount (other_contractual_amount): The total amount of all insurance contractuals from insurance receipts plus any amount in the Other Approved Discount Amount field in the Charity Care and Collections screen.

 

•Patient Bad Debt Write-Off Amount (patient_bad_debt_write_off_amount): The amount of the bad debt write off.