Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 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 |
||||
| SESSION_ID | int | 4 | √ | null |
|
|
Session ID |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Program ID |
||||
| 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 |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The most recent transaction ID for this registration |
||||
| RECEIPTNUMBER | varchar | 255 | √ | null |
|
|
Receipt number |
||||
| TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Transaction date |
||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID 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. |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| 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) |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID for this program registration |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The most recent receipt header ID for this program registration |
||||
| ORIGINAL_RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The original receipt header ID for this program registration |
||||
| TRIAL_CLASS_ENROLLMENTS | int | 4 | √ | null |
|
|
Number of trial class enrollments |
||||
| CONTRACT_HOURS | money | 21,4 | √ | null |
|
|
Number of contracted hours |
||||
| 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_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| PARENT_LOCATION_ID | int | 4 | √ | null |
|
|
The ID 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 bulk 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_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| CHECK_OUT_SIGNATURE | varchar | 100 | √ | null |
|
|
The bulk 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_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who marked the registrant as absent |
||||
| ATTENDANCE_NOTES | varchar | 8000 | √ | null |
|
|
Attendance notes entered |
||||
| NET_REVENUE | money | 21,4 | √ | null |
|
|
The revenue amount for the registration excluding tax |
||||
| TOTAL_TAX | money | 21,4 | √ | null |
|
|
The tax amount for the registration |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PROGRAM_REGISTRATIONS_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| PROGRAM_REGISTRATIONS_ABSENT_SYSTEMUSER_ID_IX | Performance | Asc | ABSENT_SYSTEMUSER_ID |
| PROGRAM_REGISTRATIONS_BEGIN_DATE_ONLY_REGISTRATION_STATUS_IX | Performance | Asc/Asc | BEGIN_DATE_ONLY + REGISTRATION_STATUS |
| PROGRAM_REGISTRATIONS_BEGIN_DATE_TIME_REGISTRATION_STATUS_IX | Performance | Asc/Asc | BEGIN_DATE_TIME + REGISTRATION_STATUS |
| PROGRAM_REGISTRATIONS_CHECK_IN_HISTORY_ID_IX | Performance | Asc | CHECK_IN_HISTORY_ID |
| PROGRAM_REGISTRATIONS_CHECK_IN_SYSTEMUSER_ID_IX | Performance | Asc | CHECK_IN_SYSTEMUSER_ID |
| PROGRAM_REGISTRATIONS_CHECK_OUT_HISTORY_ID_IX | Performance | Asc | CHECK_OUT_HISTORY_ID |
| PROGRAM_REGISTRATIONS_CHECK_OUT_SYSTEMUSER_ID_IX | Performance | Asc | CHECK_OUT_SYSTEMUSER_ID |
| PROGRAM_REGISTRATIONS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| PROGRAM_REGISTRATIONS_DROP_OFF_CUSTOMER_ID_IX | Performance | Asc | DROP_OFF_CUSTOMER_ID |
| PROGRAM_REGISTRATIONS_ENROLLMENTS_IX | Performance | Asc | ENROLLMENTS |
| PROGRAM_REGISTRATIONS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | BEGIN_DATE_TIME + CUSTOMER_ID + END_DATE_TIME + ENROLLMENTS + ORIGINAL_RECEIPT_HEADER_ID + ORIGINAL_TRANSACTION_ID + PROGRAM_ID + RECEIPT_HEADER_ID + REGISTRATION_ID + SESSION_ID + TRANSACTION_ID + WORKSTATION_ID |
| PROGRAM_REGISTRATIONS_ORIGINAL_RECEIPT_HEADER_ID_IX | Performance | Asc | ORIGINAL_RECEIPT_HEADER_ID |
| PROGRAM_REGISTRATIONS_ORIGINAL_TRANSACTION_ID_IX | Performance | Asc | ORIGINAL_TRANSACTION_ID |
| PROGRAM_REGISTRATIONS_PARENT_LOCATION_ID_IX | Performance | Asc | PARENT_LOCATION_ID |
| PROGRAM_REGISTRATIONS_PICK_UP_CUSTOMER_ID_IX | Performance | Asc | PICK_UP_CUSTOMER_ID |
| PROGRAM_REGISTRATIONS_PROGRAM_ID_IX | Performance | Asc | PROGRAM_ID |
| PROGRAM_REGISTRATIONS_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| PROGRAM_REGISTRATIONS_REGISTRATION_ID_ORG_ID_UQ | Must be unique | Asc/Asc | REGISTRATION_ID + ORG_ID |
| PROGRAM_REGISTRATIONS_REGISTRATION_SESSION_ID_IX | Performance | Asc | REGISTRATION_SESSION_ID |
| PROGRAM_REGISTRATIONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| PROGRAM_REGISTRATIONS_SESSION_ID_IX | Performance | Asc | SESSION_ID |
| PROGRAM_REGISTRATIONS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |