Check In Member Detail Subcategory

This report subcategory provides details about members who have checked in.

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
Address	The member's address as it is entered on the member page.
Age	The member's age.
Agreement #	The member's agreement number.
Agreement Club	Displays "Yes" if the club at which the member signed an agreement is the same club where he checked in.
Agreement Club Name	The name of the club at which the agreement was created.
Agreement Club Nbr	The number of the club at which the agreement was created.
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.
Alert	The name of the alert, as listed on the Check Ins tab on the Attended Check In 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.
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.
Birth Date	The member’s birth date.
CC Exp Date	The expiration date of the credit card associated with the agreement.
CC on File	Displays "Yes" if the member's credit card information is saved for billing purposes, or "No" if it is not.
Campaign	The campaign by which the member was acquired, as listed in the Miscellaneous section of the Agreement tab on the member page.
Cell Phone	The member's mobile phone number, as listed in the Demographics section of the Personal tab on the member page.
Check In Count	The total number of check ins for the member, as listed on the Check In History tab of the member page.
Check In Date	The date of the check in.
Check In Date/Time	The date and time of the check in.
Check In Status	Indicates the status of the listed check in: Entry Allowed, Entry Denied, Entry Not Set, or Normal Entry.
Check In Time	The time of the check in.
Check In by Date	The date on which the check in occurred.
Check In by Hour	The hour in which the check in occurred.
City	The member’s city as it appears on the member page.
Club Account Days Past Due	The number of days from the last due date for unpaid club account invoices until the day the report was run.
Club Account Oldest Due	The date of the oldest club account invoice due date.
Club Account Past Due	The full invoice amount for the member's club account that is past due.
Club Name	The name of the club at which the check in occurred.
Club Nbr	The number of the club at which the check in occurred.
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 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 to 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 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 Personal section on the Personal tab of the member page.
Entry Allowed	Displays "Yes" if the member was permitted to enter at the time of check in, or "No" if the member was denied entry.
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.
Gender	The member's gender.
Group	The membership group listed in the Personal section of the Personal tab on the member page.
Join Status	Indicates whether the listed transaction belongs to a Member or a Prospect.
Last Renewal Date	The date the agreement was last renewed, as listed in the Status section on the Agreement tab on 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 date and time of the member's most recent check in.
Last Visit Time	The time of the member's most recent check in.
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.
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. There are up to four Member Name columns: Last name, first name; first name, last name; first name only; last name only.
Member Since Date	The date that the member 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 Due Amount	The next due amount.
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.
Past Due	The member's total past due invoice amount.
Pre-Pay Bal.	The member’s club account pre-pay balance.
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.
Referred by Agreement #	The agreement number of the member who referred the listed number.
Referred by Name	The name of the member who referred the listed member.
Referred by Type	Indicates whether the person who referred this member is a member or a prospect.
Remote Club Number	The number of the club at which a remote check in occurred. If the check in was not a remote check in, this field will be blank.
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 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 sales person associated with the transaction.
State	The state in which the member resides, as listed in the Demographics section on the Personal tab of the member page.
Station	The name of the station at which the check in occurred.
Station Group	The workstation group to which the workstation that performed the transaction belongs.
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.
Sync	Displays "Yes" if the member is synced, or "No" if he is not.
Term	The agreement term (Cash, Cash Open, Open, Installment).
Work Phone	The member's work phone number, as listed in the Demographics section on the Personal tab of the member page.
Zip	The member’s zip code, as listed in the Demographics section of the Personal tab of the member page.