No Show Report CLN021 (Output)

Contents Show

The No Show Report CLN021 (Output) allows the user to print the no show rate for the selected Clinics. The report contains the Clinic information for each day for the month for the number of months desired starting with the selected month. The report is generated when the OK button is clicked on the Generate No Show Report screen.

Data Elements

This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.

Report Title

The title of the report is the text "No Show Rate" and the starting and ending date of the report. The starting and ending dates of the report will be entered on the Generate No Show Report screen by the user.

Origin of Data Element

The value is a literal value.

Format

The value prints as its literal value.

Local Agency

Origin of Data Element

The values will be taken from the Agency.AgencyID - Agency.Name.

Format

The values will print as their literal value.

Clinic Number

Origin of Data Element

The value will be taken from the Appointment.ServiceSiteID.

Format

The value will print as its literal value.

Clinic Name

Origin of Data Element

The value will be taken from the ServiceSite.ServiceSiteName.

Format

The value will print as its literal value.

Date

Origin of Data Element

The value is the date of the appointment and will be taken from the AppointmentDate column of the Appointment table.

Format

The value is a date value and will print in the MM/DD/CCYY format.

Hour

Origin of Data Element

This value is taken from the ShortTime column of the TimeSlice table. An hour will print for each hour of the day.

Format

This is a five-character value and will print as its literal value. If the value ends with a colon, the colon is removed.  For example, if the value “08:00:” it will print as “08:00”.

Appointments

Origin of Data Element

The value is the count of appointments within the hour. For example, if there are two appointments (one at 8:15 AM and another at 8:50 AM), the value will be 2.

Format

The value will print as a three-digit value.

Kept

Origin of Data Element

This value is the count of appointments for the hour where the AppointmentKept column of the Appointment table equals “Y”.

Format

TThe value will print as a three-digit value.

Missed

Origin of Data Element

This value is the count of appointments for the hour where the AppointmentKept column of the Appointment table does not equal “Y”.

Format

The value will print as a three-digit value.

Missed %

Origin of Data Element

The value is calculated by dividing the Missed count by the Appointments count for the hour. The result is multiplied by 100 and rounded to the nearest whole number. If the Appointments count for the hour equals zero, this value is also zero.

Format

The value will print as a three-digit value.

Filter Criteria

Appointments for Specified Clinics

All appointments for user-specified Clinics will be included in the report.

Appointments within Specified Date Range

All appointments with an appointment date occurring between the user-specified begin and end date will be included in the report.

Sort Order

Clinic ID

The document will be sorted first by the Clinic ID.

Appointment Date

Within Clinic ID, the report will be sorted by the appointment date.

Hour

Within the Appointment Date, the report will be sorted by the hour.

Control Breaks

Days of the Month

At a change in the day of the month, the following subtotals will print and a page break will occur:

Clinic Number

At a change Clinic ID, the following subtotals will print and a page break will occur:

Grand Total

At the end of the report, report totals by hour will print for the selected agencies. The following report totals will also print:

|

Clinic