Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PROGRAM_ATTENDANCE_HISTORY_ID | int | 4 | null |
|
|
The program attendance history ID |
||||||||
| REGISTRATION_ID | int | 4 | √ | null |
|
|
The program registration ID |
|||||||
| IS_CHECK_IN | varchar | 5 | √ | null |
|
|
Whether the history record is for a check-in (Yes/No) |
|||||||
| CHECK_IN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The check-in date and time |
|||||||
| 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) |
|||||||
| IS_CHECK_OUT | varchar | 5 | √ | null |
|
|
Whether the history record is for a check-out (Yes/No) |
|||||||
| CHECK_OUT_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The check-out date and time |
|||||||
| PICK_UP_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who picked up the registrant |
|||||||
| IS_STAFF_PICK_UP | varchar | 5 | √ | null |
|
|
Whether a staff member picked up the registrant (Yes/No) |
|||||||
| BULK_SIGNATURE_NAME | varchar | 100 | √ | null |
|
|
The bulk signature name if a signature was captured |
|||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the check-in or check-out |
|||||||
| SOURCE_TYPE | varchar | 15 | √ | null |
|
|
The source type of the check-in or check-out (Staff Admin / Online) |
|||||||
| ATTENDANCE_NOTES | varchar | 8000 | √ | null |
|
|
Attendance notes entered |
|||||||
| UNDO_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed an undo of the check-in or check-out |
|||||||
| UNDO_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that an undo of the check-in or check-out was performed |
|||||||
| IS_DELETED | varchar | 5 | √ | null |
|
|
Whether the history record is considered to be deleted (Yes/No) |
|||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|||||||
| 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 |
|||||||
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PROGRAM_ATTENDANCE_HISTORY_PROGRAM_ATTENDANCE_HISTORY_ID_ORG_ID_PK | Primary key | Asc/Asc | PROGRAM_ATTENDANCE_HISTORY_ID + ORG_ID |
| PROGRAM_ATTENDANCE_HISTORY_DROP_OFF_CUSTOMER_ID_IX | Performance | Asc | DROP_OFF_CUSTOMER_ID |
| PROGRAM_ATTENDANCE_HISTORY_PARENT_LOCATION_ID_IX | Performance | Asc | PARENT_LOCATION_ID |
| PROGRAM_ATTENDANCE_HISTORY_PICK_UP_CUSTOMER_ID_IX | Performance | Asc | PICK_UP_CUSTOMER_ID |
| PROGRAM_ATTENDANCE_HISTORY_REGISTRATION_ID_IX | Performance | Asc | REGISTRATION_ID |
| PROGRAM_ATTENDANCE_HISTORY_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| PROGRAM_ATTENDANCE_HISTORY_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| PROGRAM_ATTENDANCE_HISTORY_UNDO_SYSTEMUSER_ID_IX | Performance | Asc | UNDO_SYSTEMUSER_ID |