Guest RADAR Report Details

The Guest RADAR Report is designed to provide the statistical data that is requested by the annual RADAR report from RMCC. The source of data and method of calculation for each row in the report are described below. There are two sections: Ronald McDonald House and Ronald McDonald Family Room.

The report can be printed, and then you can transfer the numbers into the RADAR reporting site. Alternatively, you can create an export file in CSV format that can be emailed directly to ?

Each Ronald McDonald Chapter is assigned an ID number that is added to the CSV file. You enter this number into Client Defaults, in the Guest Stay section, under Chapter iMIS ID. In addition, each House or Family Room location has an iMIS ID which needs to be added to the Stay Location codes in the Codes tab of the Admin tab.

Ronald McDonald House

The user selects, by room number or room location, the rooms to be included in this section of the report. This selection applies to all rows in this section except for the Hotel stay data. The user also specifies the period to be covered. See the Report Setup Options description at the end of this document for more detail.

Ethnicity

For each Ethnicity code, the number of patients with that ethnicity who stayed during the period divided by the total number of patients who stayed during the period. If the same patient stayed more than once during the period, he is counted once for the period.

Payor Profile Information

Total amount of monies received from guest families for overnight stays — the total amount paid during the period from any payor for any overnight stay in the House. To be counted, the amount must be paid, not just invoiced, and the Stay Type must be "Stay." The stay must include at least one night during the period, and the payment date must be during the period. If a stay extends beyond the end of the period or begins before the start of the period, the payment amount is not prorated for the portion of the stay during the period.

The total amount received is spread by percentage among various sources of payment, or Paid By Groups, determined by the Paid By code attached to each payment and the Paid By Group that code belongs to. The report lists each Paid By Group, with the percentage coming from that group.

Program Beneficiary Information

Total number of guest family registrations for overnight stay only — a count of the guest stays that have at least one night during the period in one of the selected rooms and are of stay type "Stay."
Total number of guest registrations for hospitalized patients —a count of stays during which the patient is in-patient. If at least half of the nights during a stay are outpatient nights, the patient is considered an outpatient, and the registration is counted in the outpatient line. Otherwise the registration is counted as a hospitalized patient. Note: these numbers include guest family registrations for day use.
Total number of guest registrations for outpatients — see above.
Total number of guest family registrations for day use — a count of guest stays where the arrival and departure date are the same, the date is in the period, the room is included in the selected rooms, and the stay type is "Stay."
Total number of family nights — a count of nights during the period that a guest stay of type "Stay" covers. If a stay extends beyond the end of the period or begins before the start of the period, only the nights during the period are counted.
Total number of family members accommodated for overnight stays — the count of all occupants in the room, determined by the check boxes on the Daily Occupancy tab of the Occupant Manager tab. An occupant is counted if he is checked as ‘In room” for any night during the stay. This is not an unduplicated count. If the same family member comes for two separate stays, he or she is counted twice, once for each stay. Patients who are checked as "In Room" are also counted.
Total number of families not accommodated due to lack of space — a count of the number of guest stays with stay type of "No Room" and arrival date in the period. The Location code must be filled for the stay and match the Location for at least one of the rooms included in this report.
Total number of nights that families were provided hotel lodging, paid for by the Chapter — the total number of nights for stays in the period with a stay type of "Stay" and a Location that matches one of the Locations selected under "Hotel Locations" on the report set up. In addition, there must be a payment for the stay with a Paid By code that matches one of the Paid By codes selected under "Paid by Chapter" on the report set up.

Monthly Occupancy Rate

The monthly occupancy rate is calculated by dividing the number of family nights during the month by the number of available room nights. Available room nights are calculated by multiplying the number of rooms selected for the report by the number of nights in the month. Subtracted from this is the number of unavailable room nights for the period.

Monthly Average Length of Stay

The average length of stay is calculated for each month and includes only the nights spent in the house during that month, even if a stay extends beyond the end of the month.

The maximum length of stay is the longest continuous stay during the year and includes only nights spent in the house during the year, even if the stay spanned more than one year.

Top 5 Diagnoses

The top 5 diagnoses are calculated by counting patient stays by diagnosis and selecting the top five. This is not an unduplicated count. For example, if the same patient comes for two separate stays, that patient's diagnosis is counted twice.

Ronald McDonald Family Room

The user selects, by room number or room location, the rooms to be included in this section of the report.

Because ExceedFurther’s Guest Module is primarily for tracking detailed information about overnight guests, the data in this section may reflect only a small percentage of the families who have used the Family Room during the course of the year.