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

The Total Charity Care 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 any patient who received a Charity Care Write off during the reporting period. This is based on if there is a Charity Care amount in the Charity Care and Collections screen.

 

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.

 

•Payment Transaction Code (last_transaction_code): The receipt code used when payment was posted to the patient's account.

 

NOTE: If a refund is posted to the patient's account, the Transaction Code will display "RF", and the refund amount will display as a negative amount in the Total Patient Payments for Services Provided column.

 

•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 Charity Care (cacc_write_off_date): Pulls the date in the Determination/Charity Care Write Off field in the Charity Care and Collections screen.

 

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

 

•Non-Covered Charges for Days Exceeding LOS Limit or Patient Covered by Medicaid or Other Indigent Care (noncov_los_limit_mcaid_indigen_care): This field will currently pull blank.