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 |
|
| ACTIVITY_INSTRUCTOR_ID | int | 4 | √ | null |
|
|
Activity Instructor ID |
|
| INSTRUCTOR_ID | int | 4 | √ | null |
|
|
The unique IT of the Instructor |
|
| INSTRUCTOR_CUSTOMER_ID | int | 4 | √ | null |
|
|
The Customer ID of the Instructor join from INSTRUCTORS |
|
| INSTRUCTOR_FIRST_NAME | varchar | 255 | √ | null |
|
|
Customer First Name from Customers |
|
| INSTRUCTOR_LAST_NAME | varchar | 255 | √ | null |
|
|
Customer Last Name from Customers |
|
| INSTRUCTOR_ROLE_ID | int | 4 | √ | null |
|
|
The unique ID of the Instructor Role |
|
| INSTRUCTOR_ROLE_NAME | varchar | 40 | √ | null |
|
|
The name of the Instructor Role from INSTRUCTOR_ROLES |
|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID - join from ACTIVITY_INSTRUCTORS |
|
| ACTIVITYNUMBER | varchar | 20 | √ | null |
|
|
Activity Number - join from ACTIVITIES |
|
| ACTIVITYNAME | nvarchar | 240 | √ | null |
|
|
Activity Name - join from ACTIVITIES |
|
| 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_YES_NO | varchar | 3 | null |
|
|
Yes/No of whether the person was absent |
||
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time dbo record was last modified |
||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The dbo sync process ID |