Missed Appointments Follow-up Report CLN029 (Output)

The Missed Appointments Follow-up Report CLN029 (Output) allows the user to print all applicants who missed their scheduled appointment during the given date range. If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="Y" the report also includes unattended nutrition education classes. The report is generated when the OK button is clicked on the Generate Missed Appointment Follow-up Report screen.

Report Title

Origin of Data Element

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="N" the value will be "Missed Appointments Follow-up".

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="Y" the value will be "Missed Appointments and Unattended Classes Follow-up".

Format

The value will print as its literal value.

Report Subtitle

Origin of Data Element

The value will be the date range selected for the repot.

Format

The value will print in the following format:

{from date} - {to date}

Household ID

Origin of Data Element

The value will be taken from the Household.HouseholdID.

Format

The value will print as its literal value.

State WIC ID

Origin of Data Element

This value comes from the Member.StateWICID.

Format

The value will print as its literal value.

Client Name

Origin of Data Element

The value will be taken from the Member.FirstName Member.MiddleInitial and Member.LastName.

Format

The value will print in {first name} {middle initial}. {last name} format.

Client Address

Origin of Data Element

The value will be taken from the Household.Address, Household.City, Household.State, and Household.ZIP.

Format

The value will print in the following format:

{address} {city}, {state} {ZIP code}

The ZIP code will print in #####-#### format.

Client Telephone Number

Origin of Data Element

The value will be taken from the Household.Telephone1.

Format

The value will print in ###-###-#### format.

WIC Category

Origin of Data Element

The value will be taken from the Member.WICStatus.

Format

The value will print as its literal value.

Appointment Date/Appointment or Class Date

Origin of Data Element

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="N" the value will be taken from the Appointment.AppointmentDate.

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="Y" the value will be from the Appointment.AppointmentDate if the item is an appointment or from the ClassSchedule.ClassDate if the item is a class.

Format

This is an eight-digit value formatted MM/DD/CCYY.

Appointment Type/Appointment or Class Type

Origin of Data Element

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="N" the value will be taken from the AppointmentType descriptions.

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="Y" the value will be from the AppointmentType descriptions if the item is an appointment or from the ClassSchedule.ClassTypeID if the item is a class.

Format

The value will print as its literal value.

Filter Criteria

Base of Data

All applicants who missed their scheduled appointment and fit the criteria selected on the Missed Appointments screen will be included on the report.

Sort Order

Household ID

The report will be sorted first by Household ID.

Appointment Date/Appointment or Class Date

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="N" the report will be sorted in chronological order by Appointment Date within Household ID

If the state business rule DSP_CLASSES_IN_MISSED_APT_FOLLWUP ="Y" the report will be sorted in chronological order by Appointment and Class Date within Household ID