Expired Contracts by Date Range Report

Members > Members > Expired Contracts

This system default report contains the following columns in this order:

Column Name	Column Description
Club Name	The name of the associated club as it is listed in the Club Name field on the General tab of the Edit Club page.
Membership Type	The membership type associated with this agreement, as it appears in the Personal section of the Personal tab on the member page.
Agreement #	The member's agreement number.
Member Name (last, first)	The member's name with last name first.
Member Status	The member’s current status, as listed in the Status section of the Agreement tab on the member page.
Sales Person (last, first)	The name of the sales person associated with the transaction with last name first.
Primary Phone	The member's primary phone number, as listed in the Demographics section on the Personal tab of the member page.
Expiration Date	The agreement expiration date, as listed on the Agreement tab of the member page.
Last Visit Date/Time	The date and time of the member's most recent check in.
Renewal EFT	The agreement renewal draft price, as listed in the Renewal section on the Agreement tab of the member page.
Renewal Statement	The agreement renewal statement price, as listed in the Renewal section on the Agreement tab of the member page.
Renewal Cash	The agreement renewal price paid in cash, as listed in the Renewal section on the Agreement tab of the member page.
Member Status Reason	The reason for the member’s current status.

 

Report Type	Sorted by	Set Filters	Runtime Filters
Detail	Club Name Membership Type Member Name	Join Status = Member	Club Nbr = in list Expiration Date = in range