Wait List Report Columns

The following columns are available on the Wait List report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's wait list item
Pat Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Status	Patient Status	Patient Information > Status
Addr 1	Address Line 1	Patient Information
Addr 2	Address Line 2	Patient Information
City, State, Zip	City, State, Zip	Patient Information
County	County	Patient Information
Hm Phone	Home Phone	Patient Information
Day Phone	Day Phone	Patient Information
Cont Pref	Contact Preference	Patient Information
Cont Pref Val	Contact Preference Indicator	Patient Information
Event	Event	Patient Waitlist Item
Loc Name	Service Location Name	Patient Waitlist Item
Res Name	Resource Name	Patient Waitlist Item
Begin Dt	Beginning Date	Patient Waitlist Item
End Dt	Ending Date	Patient Waitlist Item
Beg Tm	Beginning Time	Patient Waitlist Item
End Tm	Ending Time	Patient Waitlist Item
Dur	Duration	Patient Waitlist Item
Mon	Monday	Patient Waitlist Item
Tu	Tuesday	Patient Waitlist Item
Wed	Wednesday	Patient Waitlist Item
Thr	Thursday	Patient Waitlist Item
Fri	Friday	Patient Waitlist Item
Sat	Saturday	Patient Waitlist Item
Sun	Sunday	Patient Waitlist Item
Interim Appt Date	Interim Appointment Date	Appointment
Interim Appt Time	Interim Appointment Time	Appointment
Interim Appt Event	Interim Appointment Event	Appointment
Interim Appt Resource	Interim Appointment Resource	Appointment
Interim Appt Location	Interim Appointment Location	Appointment
Final Appt Date	Final Appointment Date	Appointment
Final Appt Time	Final Appointment Date	Appointment
Final Appt Event	Final Appointment Event	Appointment
Final Appt Resource	Final Appointment Resource	Appointment
Final Appt Location	Final Appointment Location	Appointment
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Hid	Hidden Indicator	Appointment
Created By	Created By	Patient Waitlist Item
Crt Dt	Create Date	Patient Waitlist Item
Modified By	Modified By	Patient Waitlist Item
Mod Dt	Modified Date	Patient Waitlist Item
Lst Enc Date	Last Encounter Date	Patient Chart > Encounters Tab
Lst Enc Loc Name	Last Encounter Location Name	Patient Chart > Encounters Tab
Notification Preferences	Patient selected Notification Preferences	Patient Information > Demographics > Notifications field Note: If the Make Notifications in Person Demographics Practice specific option is enabled in Practice Preferences > Patient Notifications, then data pulls from the " patient_notifications " table in the database. If the option is not enabled, then data pulls from the " person " table.
Pref Language	Preferred Language	Patient Information

Filter 1

Begin Date: Include wait list items with a beginning date within a date range.
End Date: Include wait list items with an end date within a date range.
Deleted: Include/exclude deleted wait list items. Select either Only, Exclude (default), or Include All.
Interim Appt: Include/exclude interim appointments for wait list items. Select either Only, Exclude, or Include All (default).
Final Appt: Include/exclude final appointments for wait list items. Select either Only, Exclude, or Include All (default).
Waitlist Statuses: Include wait list items by status. Select Pending Booking, Pending Open Appt Slot, Successful and/or Unsuccessful.

Filter 2

Use columns to filter data on the report. Column filter options include the following:

Between
Equals
Not Equals
Greater Than
Less Than
Like

Additional Filters

Use additional filters to filter data on the report. Additional filters include the following:

Events
Resources

Sorting

Use columns to sort and group data on the report. Column sorting options include the following:

Ascending
Descending
Group By
Page Break

Note: Columns that are not available for Group By or Page Break are indicated by 'n/a'.

Totals

Use columns to sub-total and total data on the report. Column total options include the following:

Sum
Average
Count
Totals

Note: Columns that are not available for totals are indicated by 'n/a'.

Wait List Report Columns

The following columns are available on the Wait List report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's wait list item
Pat Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Status	Patient Status	Patient Information > Status
Addr 1	Address Line 1	Patient Information
Addr 2	Address Line 2	Patient Information
City, State, Zip	City, State, Zip	Patient Information
County	County	Patient Information
Hm Phone	Home Phone	Patient Information
Day Phone	Day Phone	Patient Information
Cont Pref	Contact Preference	Patient Information
Cont Pref Val	Contact Preference Indicator	Patient Information
Event	Event	Patient Waitlist Item
Loc Name	Service Location Name	Patient Waitlist Item
Res Name	Resource Name	Patient Waitlist Item
Begin Dt	Beginning Date	Patient Waitlist Item
End Dt	Ending Date	Patient Waitlist Item
Beg Tm	Beginning Time	Patient Waitlist Item
End Tm	Ending Time	Patient Waitlist Item
Dur	Duration	Patient Waitlist Item
Mon	Monday	Patient Waitlist Item
Tu	Tuesday	Patient Waitlist Item
Wed	Wednesday	Patient Waitlist Item
Thr	Thursday	Patient Waitlist Item
Fri	Friday	Patient Waitlist Item
Sat	Saturday	Patient Waitlist Item
Sun	Sunday	Patient Waitlist Item
Interim Appt Date	Interim Appointment Date	Appointment
Interim Appt Time	Interim Appointment Time	Appointment
Interim Appt Event	Interim Appointment Event	Appointment
Interim Appt Resource	Interim Appointment Resource	Appointment
Interim Appt Location	Interim Appointment Location	Appointment
Final Appt Date	Final Appointment Date	Appointment
Final Appt Time	Final Appointment Date	Appointment
Final Appt Event	Final Appointment Event	Appointment
Final Appt Resource	Final Appointment Resource	Appointment
Final Appt Location	Final Appointment Location	Appointment
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Hid	Hidden Indicator	Appointment
Created By	Created By	Patient Waitlist Item
Crt Dt	Create Date	Patient Waitlist Item
Modified By	Modified By	Patient Waitlist Item
Mod Dt	Modified Date	Patient Waitlist Item
Lst Enc Date	Last Encounter Date	Patient Chart > Encounters Tab
Lst Enc Loc Name	Last Encounter Location Name	Patient Chart > Encounters Tab
Notification Preferences	Patient selected Notification Preferences	Patient Information > Demographics > Notifications field Note: If the Make Notifications in Person Demographics Practice specific option is enabled in Practice Preferences > Patient Notifications, then data pulls from the " patient_notifications " table in the database. If the option is not enabled, then data pulls from the " person " table.
Pref Language	Preferred Language	Patient Information

Filter 1

Begin Date: Include wait list items with a beginning date within a date range.
End Date: Include wait list items with an end date within a date range.
Deleted: Include/exclude deleted wait list items. Select either Only, Exclude (default), or Include All.
Interim Appt: Include/exclude interim appointments for wait list items. Select either Only, Exclude, or Include All (default).
Final Appt: Include/exclude final appointments for wait list items. Select either Only, Exclude, or Include All (default).
Waitlist Statuses: Include wait list items by status. Select Pending Booking, Pending Open Appt Slot, Successful and/or Unsuccessful.

Filter 2

Use columns to filter data on the report. Column filter options include the following:

Between
Equals
Not Equals
Greater Than
Less Than
Like

Additional Filters

Use additional filters to filter data on the report. Additional filters include the following:

Events
Resources

Sorting

Use columns to sort and group data on the report. Column sorting options include the following:

Ascending
Descending
Group By
Page Break

Note: Columns that are not available for Group By or Page Break are indicated by 'n/a'.

Totals

Use columns to sub-total and total data on the report. Column total options include the following:

Sum
Average
Count
Totals

Note: Columns that are not available for totals are indicated by 'n/a'.

Wait List Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Patient Recall Report Columns

Kept Appointment with No Charges Report Columns

Appointment Listing Report Columns

Payments by Line Item Report Columns

Statistical Analysis of Appointments Report Columns

Downtime Patient Listing by Provider Report Columns

Wait List Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Patient Recall Report Columns

Kept Appointment with No Charges Report Columns

Appointment Listing Report Columns

Payments by Line Item Report Columns

Statistical Analysis of Appointments Report Columns

Downtime Patient Listing by Provider Report Columns