ACTIVITY_ENROLLMENTS

System Generated key value. No significance to Enrollment data

ID of the activity.

The enrollment status of the customer at the time of enrollment (Enrolled / Withdrawn / Waitlisted / Waitlist Removed / Trial / Refunded). If the current membership status is needed, please join to either CUSTOMERS or MEMBERSHIPS on the customer ID in question

ID of the Customer

Receipt number of the last transaction

The membership status at the time of enrollment, Note that If the current membership status is needed you may join to either CUSTOMERS or MEMBERSHIPS for the CUSTOMER_ID in question

The meeting date of the trial class enrollment

Date of the customers last transaction

The date and time when the customer withdrew from the activity

The total fee amount for the activity and customer

The total amount paid by the customer for the activity

The total due amount for the activity and customer

The date and time the customer enrolled in the activity

Date and time Hub record was last modified

The Hub sync process ID

The date that the customer enrolled in the activity

Date of the customers last transaction

The meeting date of the trial class enrollment

The date that the customer withdrew from the activity

The membership status at the time of enrollment, Note that If the current membership status is needed you may join to either CUSTOMERS or MEMBERSHIPS for the CUSTOMER_ID in question

The most recent transaction ID related to the enrollment.

Root transaction ID of the enrollment.

Your organization’s unique identifier in the Active Net system

The number of private lesson sessions purchased with this enrollment.

The number of private lesson sessions that have been booked.

The number of private lesson sessions that remain to be booked.

The date and time when the customer was waitlisted for the activity

The date that the customer was waitlisted for the activity

The date and time when the customer was removed from the waitlist for the activity

The date that the customer was removed from the waitlist for the activity

The original transaction ID of the enrollment

Whether a member-only fee was charged for this activity enrollment (Yes/No)

Whether a member-only discount was applied to this activity enrollment (Yes/No)

The receipt header ID of the original transaction

The number of seats requested for registration

The current waitlist position

The date and time that an available spot was reserved for this waitlist request

System timestamp (for internal use)

The receipt header ID of the latest transaction for the enrollment

The ID of the team that the enrollment is for

Whether this is a team placeholder enrollment to reserve multiple seats for team members

The original number of seats that the team placeholder enrollment had reserved

Indicates whether an enrolled enrollment has had a refund applied against it as its latest transaction without being withdrawn from the activity (None, Partially Refunded, Fully Refunded)