Members Subcategory

Members > Members

This subcategory lists information about member demographic and billing information.

Some report columns are derived from UDFs (user-defined fields) in DataTrak. Because UDFs are defined at the club level, those columns are omitted from this documentation.

Column Name	Column Description
0 - 30 Days	The fee amount that has been overdue 30 days or less.
31 - 60 Days	The fee amount that has been overdue between 31 and 60 days.
61 - 90 Days	The fee amount that has been overdue between 61 and 90 days.
ABC Will Draft Club Account	Indicates whether the member's club account will be drafted by ABC (Yes|No).
Activity Count	The number of activities listed under the Activities tab on the member page.
Address	The member's address as it is entered on the member page.
Age	The age of the member.
Agr Bank Account Num Last Four	The last four digits of the bank account number associated with the agreement.
Agr Bank Account Type	The type of bank account associated with the agreement: Checking or Savings
Agr Bank Routing Number	The routing number of the bank account associated with the agreement.
Agr CC Exp Date	The expiration date of the credit card associated with the agreement.
Agr CC Number Last Four	The last four digits of the credit card associated with the agreement.
Agr CC Type	The type of credit card associated with the agreement: Visa, Master Card, etc.
Agr CC on File	Indicates whether credit card information is saved for the listed agreement.
Agr Card Holder	The name that appears on the credit card associated with the agreement.
Agr EFT on File	Indicates whether bank account information for electronic file transfer is saved for the listed agreement.
Agreement #	The member's agreement number.
Agreement Entry Source	Where the member's agreement entry was completed (ex. EAE).
Agreement Misc	The Agreement Misc fields contain the text entered in the fields of the same name in the Miscellaneous section of the Agreement tab on the member page.
Agreement Payment Method	The payment method for the member's agreement, as listed on the Billing tab of the member page.
Agreement Payment Plan	The name of the payment plan associated with the agreement.
Agreement Type	The type of agreement (New Agreement, Rewrite, or Renew).
Agt Down Payment	The agreement down payment amount, as displayed in the Down Payment section of the Agreement tab on the member page.
Allow Charges	Displays "Yes" if the member is set to allow club charge privilege, as set in the Club Account section on the Billing tab of the member page.
Alt CC Exp Date	The expiration date of the member's alternate payment method.
Alt CC Number Last Four	The last four digits of the member's alternate payment method.
Alt CC on File	Whether the member has alternate payment method information saved.
Alt CC Type	The type of the member's alternate payment method.
Alt Card Holder	The alternate payment method cardholder's name.
Alternate Payment Offered	Whether the alternate payment option has been offered to the member.
Auto Renew Dues	The dues amount at the time of auto-renewal.
Availability	Member availability, as entered in the Demographics section on the Personal tab of the member page.
Bank Account Number Last Four	The last four digits of the member's bank account number.
Bank Account Type	The member's bank account type: Checking or Savings.
Bank Routing Number	The routing number of the bank account associated with the agreement.
Barcode	The member’s barcode.
Begin Date	The agreement begin date, as listed in the Dates section on the Agreement tab of the member page.
Bill Member	Indicates whether or not the member’s provided Alternate ABC Billing payment method will be used for alternate payments.
Billed by ABC	Indicates whether the member is billed by ABC.
Birth Date	The member’s date of birth.
Birth Date Month	The month in which the member was born.
CA Bank Account Type	The type of bank account being used by this member for club account transactions: Checking or Savings.
CA Bank Routing Number	The routing number of the bank account that is being used for the member's club account.
CA CC Exp Date	The expiration date of the credit card that is being used for the member's club account.
CA CC Number Last Four	The last four digits of the credit card that is being used for the member's club account.
CA CC Type	The type of credit card that is being used for the member's club account (Visa, Master Card, etc.).
CA CC on File	Displays "Yes" if the member has credit card information saved in DataTrak for club account usage.
CA Card Holder	The name that appears on the credit card that is being used for the member's club account.
CA EFT Last Four	The last four digits of bank account that is being used for the member's club account.
CA EFT on File	Displays "Yes" if the member has EFT information saved in DataTrak for club account usage.
CC Exp Date	The expiration date of the credit card that is being used as the member's primary payment method.
CC Number Last Four	The last four digits of the credit card number associated with the agreement.
CC Type	Credit card type (Visa, Master Card, etc.).
CC on File	Displays "Yes" if the member's credit card information is saved for billing purposes.
Campaign	The campaign by which the member was acquired, as listed in the Miscellaneous section of the Agreement tab on the member page.
Card Holder	The name that appears on the credit card used for the agreement.
Cell Phone	The member's mobile phone number, as listed in the Demographics section of the Personal tab on the member page.
Cell Phone Textable	Indicates whether the listed cell phone number can receive text messages.
Check In Count	The total number of check ins for the member, as listed on the Check In History tab of the member page.
City	The member’s city as it appears on the member page.
CityStateZip	The member’s city, state, and zip code, as listed in the Demographics section of the Personal tab on the member page.
Club Account Oldest Due	The date of the oldest club account invoice due date.
Club Account Payment Method	The payment method that is being used for the member's club account.
Club Extension	The phone number extension for the club, as listed on the General tab of the Edit Club page.
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.
Club Nbr	The number of the club associated with the transaction.
Club Phone	The club's phone number, listed as the work number on the General tab of the Edit Club page.
Combined Past Due	The sum of the Total Past Due and the member's club account past due amount.
Converted Date	The date the member was converted from a prospect, listed as the Conversion Date in the Status section of the Agreement tab on the member page.
Country	The abbreviated name of the member’s country (ex. “US”).
Country Name	The full name of the member's country (ex. "United States").
Created Date	The date the agreement was created, as listed on the Agreement tab of the member page.
Created Date/Time	The date and time the agreement was created, as listed on the Agreement tab of the member page.
Created Time	The time the agreement was created, as listed on the Agreement tab of the member page.
Credit Limit	The member's club account credit limit amount, as listed in the Club Account section on the Billing tab of the member page.
Date Converted to Member	The date the agreement was signed by the member, as listed on the Agreement tab of the member page.
Date Signed	The date the agreement was signed by the member, as listed on the Agreement tab of the member page.
Days Past Due	The number of days from the last due date for unpaid invoices until the day the report was run.
Department	The department(s) to which the associated service employee(s) belongs.
EFT on File	Displays "Yes" if the member's billing information is saved for electronic file transfer.
Email	The member’s email address as it appears in the Demographics section of the Personal tab on the member page.
Emergency Availability	The availability of the child's emergency contact, as entered in the Emergency Contact section of the Edit Child page.
Emergency Name	The name of the member's emergency contact.
Emergency Phone	The emergency phone number listed in the Demographics section of the Personal tab on the member page.
Employer	The member's employer, as listed in the Persona l section on the Personal tab of the member page.
Entry Date	The date the agreement was entered, as listed on the Agreement tab of the member page.
Expiration Date	The agreement expiration date, as listed on the Agreement tab of the member page.
Fax	The fax number listed in the Demographics section of the Personal tab on the member page.
First Payment Date	The first due date for agreement invoices, as listed in the ABC Membership section on the Billing tab of the member page.
First Visit Date	The date of the member's first check in.
Future Invoices	The total amount for all invoices that are due today and later.
Gender	The member's gender.
Group	The membership group listed in the Personal section of the Personal tab on the member page.
Has Fingerprint	Indicates whether the member's fingerprint data has been saved in DataTrak.
Has Photo	Indicates whether the member has a photo saved in DataTrak.
Issue Date	The date the member was created, as listed in the Status section on the Agreement tab of the member page.
Join Status	Indicates whether the listed transaction belongs to a Member or a Prospect.
Last Billing Date	The date the member was last billed, as listed in the ABC Member section on the Billing tab of the member page.
Last Renewal Date	The date the agreement was last renewed, as listed in the Status section of the Agreement tab on the member page.
Last Rewrite Date	The date the agreement was last rewritten, as listed in the Status section of the Agreement tab on the member page.
Last Sync Date	The date that the agreement information was last synced with ABC, as listed in the Status section on the Agreement tab of the member page.
Last Visit Date	The member's most recent check in date, as listed on the Check In History tab of the member page.
Last Visit Date/Time	The member's most recent check in date and time.
Last Visit Time	The member's most recent check in time.
Late Fee	The total amount of late fees for the listed agreement.
Latest Agreement Type	The member's most current agreement type (ex. Rewrite or New Agreement).
Lead Priority	The lead priority level of a prospect: Lost, Cold, Medium, or Hot.
License	The member's driver's license number, as entered on the Personal tab of the member page.
Management	Indicates whether the agreement is ABC Managed or Club Managed.
Master Agreement #	The agreement number for the master agreement associated with the listed agreement.
Master Member Name	The name of the member associated with the master agreement.
Master Member Status	The current status of the member who has the master agreement.
Master Next Due Amount	The next due amount for the associated master agreement.
Member GUID	The member GUID (Globally unique identifier) is assigned to a member and uniquely identifies the member for web services functions.
Member Misc	The Member Misc fields contain the text entered in the fields of the same name in the Personal section on the Personal tab of the member page.
Member Name	The member's name.
Member Since Date	The date that the master agreement was created.
Member Status	The member’s current status, as listed in the Status section of the Agreement tab on the member page.
Member Status Reason	The reason for the member's current status.
Membership State	Indicates whether a member is active or inactive.
Membership Type	The membership type associated with this agreement, as it appears in the Personal section of the Personal tab on the member page.
Next Billing Date	The next date the member will be billed.
Next Due Amount	The next due amount.
Non Member	Indicates whether the member has been inactivated from the agreement.
Occupation	The member's occupation, as listed in the Personal section of the Personal tab on the member page.
Oldest Due Date	The first due date for the agreement, as listed on the Agreements tab of the member page.
Ordinal	The ordinal indicates whether the member is the primary member on an agreement or a secondary member. Primary members are indicated with an Ordinal of 0. Secondary members are organized by their Ordinal. For example, a member with an Ordinal of 3 is a secondary member, and the fourth member listed on the agreement.
Ordinal Identifier	The ordinal identifier is the agreement number with an additional number called an ordinal. The primary member on an agreement has an Ordinal of 0, which will not be displayed in the ordinal identifier. For all secondary members on an agreement, the ordinal identifier will be the agreement number plus an additional digit indicating that this is a secondary member. For example, for agreement number 900312345, the primary member's ordinal identifier will be 900312345, while the first secondary member's ordinal identifier will be 90031234501.
Over 90 Days	The fee amount that is over 90 days past due.
Past Due	The member's total past due invoice amount.
Payment Frequency	The frequency that the member is billed, as listed in the ABC Membership section on the Billing tab of the member page.
Pre-Pay Bal.	The member’s club account pre-pay balance.
Previous Agreement Number	The agreement number previously held by the member, if any.
Primary Member	Displays "Yes" if the listed member is the primary member on the agreement, or "No" if the member is a secondary member.
Primary Phone	The member's primary phone number, as listed in the Demographics section on the Personal tab of the member page.
Primary Phone Textable	Indicates whether the listed primary phone number can receive a text message.
Queue	The name of the queue in which the agreement has been placed.
Queue Agreement Type	The Agreement Type of the agreement in queue.
Queue Date	The date the agreement was moved to its current queue.
Queue Date/Time	The date and time the agreement was moved to its current queue.
Queue Time	The time the agreement was moved to its current queue.
Receive Email	Whether the member's account is configured to receive email.
Referred by Address	The home address of the referring member, if any.
Referred by Agreement #	The agreement number of the member who referred the listed number.
Referred by City	The city in which the referring member resides.
Referred by Email	The email address of the referring member.
Referred by Name	The name of the member who referred the listed member.
Referred by Ordinal	The ordinal of the person who referred this member. An ordinal is a number that indicates whether a member is primary or secondary, and places them in order within an agreement.
Referred by State	The state in which the referring member resides.
Referred by Type	Indicates whether the person who referred this member is a member or a prospect.
Referred by Zip	The referring member's zip code.
Refused Email	Indicates whether the "None" box next to the email address field was checked at the time the member was created. Members designated as "Refused Email" may still have an email address that was entered after the member was created.
Renewal Cash	The agreement renewal price paid in cash, as listed in the Renewal section on the Agreement tab of the member page.
Renewal Date	The date the agreement was renewed, as listed in the Renewal section on the Agreement tab of the member page.
Renewal EFT	The agreement renewal draft price, as listed in the Renewal section on the Agreement tab of the member page.
Renewal Frequency	The frequency the agreement is renewed, as listed in the Renewal section on the Agreement tab of the member page: Weekly, Monthly, etc.
Renewal Statement	The agreement renewal statement price, as listed in the Renewal section on the Agreement tab of the member page.
Renewal Type	The type of agreement renewal , as listed in the Renewal section on the Agreement tab of the member page.
Sale Price	The agreement sale price, as listed on the Billing tab of the member page.
Sales Person	The name of the salesperson associated with the agreement.
Sales Person Barcode	The barcode of the salesperson associated with the agreement.
Service Fee	The service fee amount for the member, as listed in the Member Details section on the Member Summary page.
State	The state in which the member resides, as listed in the Demographics section on the Personal tab of the member page.
Station Location	The name of the workstation location where the document was created, as listed on the Manage Station Locations page.
Status Date	The date the member's status was last changed, as listed in the Status section on the Agreement tab of the member page.
Status Description	The status description for the transaction, as listed in the Description column on the Invoices tab of the member page. The default description “Club Account Purchase” is excluded from this report.
Sync	Indicates whether a member's account is synced with ABC.
Term	The agreement term (Cash, Cash Open, Open, Installment).
Total Due	The total account balance due for this member. This value does not include late fees.
Total Past Due	The member's total past due balance, including late fees.
Value of Accounts	The total value amount of the agreement, listed in the Member Details section on the Member Summary. This value includes future invoices.
Value to Date	The value amount of the agreement to date. This value does not include future invoices.
Visits Allowed	The total number of visits permitted to a club prospect, as entered in the Sales section in Fast Add.
Visits Remaining	The number of visits allowed to a prospect minus the number of visits used.
Visits Used	The number of visits a club prospect has made to the club.
Web Service Plan	Indicates whether the member's payment plan is a web plan. Web plans can be listed on the Manage Payment Plans page by setting Web Plan to Yes.
Work Phone	The member's work phone number, as listed in the Demographics section on the Personal tab of the member page.
Work Phone Textable	Indicates whether the listed work phone number can receive a text message.
Zip	The member’s zip code, as listed in the Demographics section of the Personal tab of the member page.