Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
ID of the activity. |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
Name of the activity. |
||||
| ACTIVITYNUMBER | varchar | 20 | √ | null |
|
|
The activity number of this activity |
||||
| ACTIVITY_NUMBER_OPEN_SPOTS | int | 4 | √ | null |
|
|
The current number of openings for this activity |
||||
| ACTIVITY_NUMBER_WAITLISTED | int | 4 | √ | null |
|
|
The current number of people waitlisted for this activity |
||||
| ENROLLMENT_STATUS | varchar | 255 | √ | null |
|
|
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 |
||||
| REFUND_STATUS | varchar | 20 | √ | null |
|
|
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) |
||||
| FIRST_NAME | varchar | 255 | √ | null |
|
|
First name of the customer |
||||
| LAST_NAME | varchar | 255 | √ | null |
|
|
Last name of the customer |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the Customer |
||||
| CUSTOMER_DATE_MODIFIED | datetime | 16,3 | √ | null |
|
|
The most recent date and time when the customer’s information was modified |
||||
| CUSTOMER_EMAIL | varchar | 255 | √ | null |
|
|
Email address of the customer |
||||
| RECEIPT_NUMBER | varchar | 255 | √ | null |
|
|
Receipt number of the last transaction |
||||
| HAS_ACTIVE_MEMBERSHIP | bit | 1 | null |
|
|
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 |
|||||
| TRIAL_CLASS_DATE | datetime | 16,3 | √ | null |
|
|
The meeting date of the trial class enrollment |
||||
| LAST_TRANSACTION_DATE | datetime | 16,3 | √ | null |
|
|
Date of the customers last transaction |
||||
| WITHDRAW_DATE | datetime | 16,3 | √ | null |
|
|
The date and time when the customer withdrew from the activity |
||||
| TOTAL_FEE | decimal | 11,2 | √ | null |
|
|
The total fee amount for the activity and customer |
||||
| TOTAL_PAID | decimal | 11,2 | √ | null |
|
|
The total amount paid by the customer for the activity |
||||
| TOTAL_DUE | decimal | 11,2 | √ | null |
|
|
The total due amount for the activity and customer |
||||
| DATE_REGISTERED | datetime | 16,3 | √ | null |
|
|
The date and time the customer enrolled in the activity |
||||
| REQUESTED_SEATS | int | 4 | √ | null |
|
|
The number of seats requested for registration |
||||
| CUSTOMER_MODIFIED_DATE_ONLY | date | 20 | √ | null |
|
|
The most recent date that the customer’s information was modified |
||||
| REGISTERED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the customer enrolled in the activity |
||||
| LAST_TRANSACTION_DATE_ONLY | date | 20 | √ | null |
|
|
Date of the customers last transaction |
||||
| TRIAL_CLASS_DATE_ONLY | date | 20 | √ | null |
|
|
The meeting date of the trial class enrollment |
||||
| WITHDRAW_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the customer withdrew from the activity |
||||
| HAS_ACTIVE_MEMBERSHIP_YES_NO | varchar | 5 | √ | null |
|
|
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 |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The most recent transaction ID related to the enrollment. |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The receipt header ID of the latest transaction for the enrollment |
||||
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
Root transaction ID of the enrollment. |
||||
| ORIGINAL_RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The receipt header ID of the original transaction |
||||
| IS_ONLINE_RECEIPT | varchar | 5 | √ | null |
|
|
Whether the original registration was done online (Yes / No) |
||||
| MAX_PRIVATE_LESSON_BOOKINGS | int | 4 | √ | null |
|
|
The number of private lesson sessions purchased with this enrollment. |
||||
| BOOKED_PRIVATE_LESSON_BOOKINGS | int | 4 | √ | null |
|
|
The number of private lesson sessions that have been booked. |
||||
| UNBOOKED_PRIVATE_LESSON_BOOKINGS | int | 4 | √ | null |
|
|
The number of private lesson sessions that remain to be booked. |
||||
| TEAM_ID | int | 4 | √ | null |
|
|
The ID of the team that the enrollment is for |
||||
| IS_TEAM_PLACEHOLDER | varchar | 5 | √ | null |
|
|
Whether this is a team placeholder enrollment to reserve multiple seats for team members |
||||
| ORIGINAL_PLACEHOLDER_SEATS | int | 4 | √ | null |
|
|
The original number of seats that the team placeholder enrollment had reserved |
||||
| WAITLISTED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time when the customer was waitlisted for the activity |
||||
| WAITLISTED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the customer was waitlisted for the activity |
||||
| WAITLIST_POSITION | int | 4 | √ | null |
|
|
The current waitlist position |
||||
| WAITLIST_RESERVED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that an available spot was reserved for this waitlist request |
||||
| WAITLIST_RESERVED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that an available spot was reserved for this waitlist request (date only) |
||||
| WAITLIST_REMOVED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time when the customer was removed from the waitlist for the activity |
||||
| WAITLIST_REMOVED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the customer was removed from the waitlist for the activity |
||||
| REGISTRATION_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID of the enrollment |
||||
| HAS_MEMBER_FEE | varchar | 5 | √ | null |
|
|
Whether a member-only fee was charged for this activity enrollment (Yes/No) |
||||
| HAS_MEMBER_DISCOUNT | varchar | 5 | √ | null |
|
|
Whether a member-only discount was applied to this activity enrollment (Yes/No) |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
System Generated key value. No significance to Enrollment data |
|||||
| INITIATED_ONLINE | varchar | 5 | √ | null |
|
|
Whether the root registration was done online (Yes / No). |
||||
| IS_DROP_IN | varchar | 5 | √ | null |
|
|
Whether the customer is a drop-in customer (Yes/No). |
||||
| DROP_IN_EMAIL | varchar | 100 | √ | null |
|
|
The email address of the drop-in customer if entered. |
||||
| HAS_PRIOR_ENROLLMENT | varchar | 3 | null |
|
|
Indicates whether the participant has had a prior program enrollment for the same org, either in Activities or Flex Reg. |