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 |
|||||||
| REGISTRANT_CUSTOMER_ID | int | 4 | √ | null |
|
|
The customer ID of the registrant |
|||||||
| REGISTRANT_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the registrant |
|||||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
The ID of the program |
|||||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The name of the program |
|||||||
| SESSION_ID | int | 4 | √ | null |
|
|
The ID of the session |
|||||||
| SESSION_NAME | varchar | 255 | √ | null |
|
|
The name of the session |
|||||||
| SESSION_BEGIN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The start date and time of the session |
|||||||
| SESSION_END_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The end date and time of the session |
|||||||
| 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 |
|||||||
| CHECK_IN_DATE_ONLY | date | 20 | √ | null |
|
|
The check-in date (date only) |
|||||||
| 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) |
|||||||
| 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 |
|||||||
| CHECK_OUT_DATE_ONLY | date | 20 | √ | null |
|
|
The check-out date (date only) |
|||||||
| 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 |
|||||||
| 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 |
|||||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name 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_SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name 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 |
|||||||
| UNDO_DATE_ONLY | date | 20 | √ | null |
|
|
The date that an undo of the check-in or check-out was performed (date only) |
|||||||
| IS_DELETED | varchar | 5 | √ | null |
|
|
Whether the history record is considered to be deleted (Yes/No) |
|||||||
| 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 |
|||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |