Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVITYATTENDANCE_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| ACTIVITY_DATE_ID | int | 4 | √ | null |
|
|
Activity date ID |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Transaction ID |
|
| ACTIVITY_INSTRUCTOR_ID | int | 4 | √ | null |
|
|
Activity Instructor ID |
|
| SUB_INSTRUCTOR_ID | int | 4 | √ | null |
|
|
Activity Sub Instructor ID |
|
| FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
Facility schedule ID (if the facility is reserved) |
|
| NUMBER_OF_MINUTES | int | 4 | √ | null |
|
|
Activtiy duration in minutes |
|
| START_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Activity start date time |
|
| SITE_ID | int | 4 | √ | null |
|
|
Site ID |
|
| ATTENDANCE_CODE_ID | int | 4 | √ | null |
|
|
Attendance code ID |
|
| ABSENT | smallint | 2 | √ | null |
|
|
Absent status |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| CHECKINSYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who checked in customer |
|
| CHECKINDATETIME | datetime | 16,3 | √ | null |
|
|
Check in datetime |
|
| CHECK_IN_SOURCE_TYPE | smallint | 2 | √ | null |
|
|
Check in source type(MOBILE-0, AUI-1) |
|
| CHECKOUTSYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who checked out customer |
|
| CHECKOUTDATETIME | datetime | 16,3 | √ | null |
|
|
Check out datetime |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ACTIVITYATTENDANCE_ACTIVITYATTENDANCE_ID_ORG_ID_PK | Primary key | Asc/Asc | ACTIVITYATTENDANCE_ID + ORG_ID |
| ACTIVITYATTENDANCE_ORG_ID_IX | Performance | Asc | ORG_ID |