Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| REGISTRATION_ID | int | 4 | √ | null |
|
|
ID of the registration record |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The customer ID of the registrant |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the registrant |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Program ID |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The name of the program |
||||
| SESSION_ID | int | 4 | √ | null |
|
|
Session ID |
||||
| SESSION_NAME | varchar | 255 | √ | null |
|
|
The name of the session |
||||
| SESSION_DATE_ID | int | 4 | √ | null |
|
|
Session Date ID |
||||
| BEGIN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Session start date and time |
||||
| END_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Session end date and time |
||||
| ENROLLMENTS | int | 4 | √ | null |
|
|
Number of enrollments |
||||
| TRIAL_CLASS_ENROLLMENTS | int | 4 | √ | null |
|
|
Number of trial class enrollments |
||||
| CONTRACT_HOURS | money | 21,4 | √ | null |
|
|
Number of contracted hours |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The most recent transaction ID for this program registration |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The most recent receipt header ID for this program registration |
||||
| RECEIPTNUMBER | varchar | 255 | √ | null |
|
|
Receipt number |
||||
| TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Transaction date |
||||
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID for this program registration |
||||
| ORIGINAL_RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The original receipt header ID for this program registration |
||||
| IS_ONLINE_RECEIPT | varchar | 5 | √ | null |
|
|
Whether the original registration was done online (Yes/No) |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the registration occurred |
||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation where the registration occurred |
||||
| BEGIN_DATE_ONLY | date | 20 | √ | null |
|
|
Session start date (date only) |
||||
| END_DATE_ONLY | date | 20 | √ | null |
|
|
Session end date (date only) |
||||
| TRANSACTION_DATE_ONLY | date | 20 | √ | null |
|
|
Transaction date (date only) |
||||
| WAITLISTED | varchar | 5 | √ | null |
|
|
Whether this registration is to waitlist the customer for the session. |
||||
| REGISTRATION_STATUS | varchar | 15 | √ | null |
|
|
The current status of this registration (Waitlisted, Unwaitlisted, Registered, Withdrawn, Inactive). |
||||
| WAITLISTED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The most recent waitlisted date and time for this registration |
||||
| WAITLISTED_DATE_ONLY | date | 20 | √ | null |
|
|
The most recent waitlisted date for this registration (date only) |
||||
| UNWAITLISTED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The most recent waitlist deletion date and time for this registration |
||||
| UNWAITLISTED_DATE_ONLY | date | 20 | √ | null |
|
|
The most recent waitlist deletion date for this registration (date only) |
||||
| REGISTERED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The most recent registration date and time for this registration |
||||
| REGISTERED_DATE_ONLY | date | 20 | √ | null |
|
|
The most recent registration date for this registration (date only) |
||||
| WITHDRAWN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The most recent withdrawal date and time for this registration |
||||
| WITHDRAWN_DATE_ONLY | date | 20 | √ | null |
|
|
The most recent withdrawal date for this registration (date only) |
||||
| REGISTRATION_SESSION_ID | bigint | 8 | √ | null |
|
|
Unique identifier used to link the program registration to the specific program session. |
||||
| HAS_MEMBER_FEE | varchar | 5 | √ | null |
|
|
Whether a member-only fee was charged for this program registration (Yes/No) |
||||
| HAS_MEMBER_DISCOUNT | varchar | 5 | √ | null |
|
|
Whether a member-only discount was applied to this program registration (Yes/No) |
||||
| EXTERNAL_REGISTRATION | varchar | 5 | √ | null |
|
|
Whether the enrollment was performed externally (Yes/No) |
||||
| CHECK_IN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The check-in date and time |
||||
| CHECK_IN_DATE_ONLY | date | 20 | √ | null |
|
|
The check-in date (date only) |
||||
| CHECK_IN_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the check-in |
||||
| CHECK_IN_SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who performed the check-in |
|||||
| DROP_OFF_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who dropped off the registrant |
||||
| DROP_OFF_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer who dropped off the registrant |
||||
| PARENT_LOCATION_ID | int | 4 | √ | null |
|
|
The ID of the parent’s location during the session |
||||
| PARENT_LOCATION_NAME | varchar | 50 | √ | null |
|
|
The name of the parent’s location during the session |
||||
| CHOOSE_CUBBY | varchar | 5 | √ | null |
|
|
Whether a cubby was chosen during check-in (Yes/No) |
||||
| CHECK_IN_SIGNATURE | varchar | 100 | √ | null |
|
|
The signature name if a signature was captured during check-in |
||||
| CHECK_IN_SOURCE_TYPE | varchar | 15 | √ | null |
|
|
The source type of the check-in (Staff Admin / Online) |
||||
| CHECK_IN_HISTORY_ID | int | 4 | √ | null |
|
|
The program attendance history ID for the check-in |
||||
| CHECK_OUT_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The check-out date and time |
||||
| CHECK_OUT_DATE_ONLY | date | 20 | √ | null |
|
|
The check-out date (date only) |
||||
| CHECK_OUT_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the check-out |
||||
| CHECK_OUT_SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who performed the check-out |
|||||
| PICK_UP_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who picked up the registrant |
||||
| PICK_UP_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer who picked up the registrant |
||||
| CHECK_OUT_SIGNATURE | varchar | 100 | √ | null |
|
|
The signature name if a signature was captured during check-out |
||||
| CHECK_OUT_SOURCE_TYPE | varchar | 15 | √ | null |
|
|
The source type of the check-out (Staff Admin / Online) |
||||
| CHECK_OUT_HISTORY_ID | int | 4 | √ | null |
|
|
The program attendance history ID for the check-out |
||||
| ABSENT_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the registrant was marked as absent |
||||
| ABSENT_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the registrant was marked as absent (date only) |
||||
| ABSENT_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who marked the registrant as absent |
||||
| ABSENT_SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who marked the registrant as absent |
|||||
| ATTENDANCE_NOTES | varchar | 8000 | √ | null |
|
|
Attendance notes entered |
||||
| 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 |
||||
| source_id | int | 4 | √ | null |
|
|
The ID value from the Active Net system |
||||
| INITIATED_ONLINE | varchar | 5 | √ | null |
|
|
Whether the root registration was done online (Yes / No). |