Member and Check In Subcategory

Members > Member and Check In

This subcategory contains member demographic and check in 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
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 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.
Alert	The name of the alert, as listed on the Check Ins tab on the Attended Check In 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.
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 associated with the alert.
Check In Date/Time	The date and time of the check in associated with the alert.
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 at which the check in occurred.
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 Days Past Due	The number of days from the last due date for unpaid club account invoices until the date the report was run.
Club Account Oldest Due	The date of the oldest club account invoice due date.
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.
Country	The abbreviated name of the member's country (ex. "US").
Country Name	The full name of the member's country (ex. "United States").
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.
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.
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.
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 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 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 GUID	The member GUID (Globally Unique Identifier) is assigned to a member, and uniquely identifies the member for web services function.
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 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.
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.
Primary Phone	The member's primary phone number, as listed in the Demographics section on the Personal tab of the member page.
State	The state in which the member resides, as listed in the Demographics section on the Personal tab of the member 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.
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.