Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| INSTRUCTOR_ROLE_ID | int | 4 | null |
|
|
The instructor role ID |
|||||
| INSTRUCTOR_ROLE_NAME | varchar | 40 | √ | null |
|
|
The instructor role name |
||||
| INSTRUCTOR_ROLE_PAYRATE_CODE | varchar | 20 | √ | null |
|
|
The instructor role pay rate code if applicable |
||||
| INSTRUCTOR_FIXED_FEE | money | 21,4 | √ | null |
|
|
The fixed fee rate for instructors of this role type |
||||
| INSTRUCTOR_PER_HOUR_FEE | money | 21,4 | √ | null |
|
|
The per hour fee rate for instructors of this role type |
||||
| INSTRUCTOR_PER_SESSION_FEE | money | 21,4 | √ | null |
|
|
The per session fee rate for instructors of this role type |
||||
| INSTRUCTOR_PER_STUDENT_FEE | money | 21,4 | √ | null |
|
|
The per student fee rate for instructors of this role type |
||||
| INSTRUCTOR_PER_STUDENT_PER_HOUR_FEE | money | 21,4 | √ | null |
|
|
The per student per hour fee rate for instructors of this role type |
||||
| INSTRUCTOR_PER_STUDENT_PER_SESSION_FEE | money | 21,4 | √ | null |
|
|
The per student per session fee rate for instructors of this role type |
||||
| INSTRUCTOR_PERCENT_ALL_FEES | money | 21,4 | √ | null |
|
|
The fee rate comprised of a percentage of all fees for instructors of this role type |
||||
| INSTRUCTOR_PERCENT_PRIMARY_FEES | money | 21,4 | √ | null |
|
|
The fee rate comprised of a percentage of primary fees for instructors of this role type |
||||
| UPFRONT_INSTRUCTOR_FIXED_FEE | money | 21,4 | √ | null |
|
|
The up-front preparation fixed fee rate for instructors of this role type |
||||
| UPFRONT_INSTRUCTOR_PER_HOUR_FEE | money | 21,4 | √ | null |
|
|
The up-front preparation per hour fee rate for instructors of this role type |
||||
| UPFRONT_INSTRUCTOR_PER_STUDENT_FEE | money | 21,4 | √ | null |
|
|
The up-front preparation per student fee rate for instructors of this role type |
||||
| UPFRONT_INSTRUCTOR_PERCENT_ALL_FEES | money | 21,4 | √ | null |
|
|
The up-front preparation fee rate comprised of a percentage of all fees for instructors of this role type |
||||
| UPFRONT_INSTRUCTOR_PERCENT_KEY_FEES | money | 21,4 | √ | null |
|
|
The up-front preparation fee rate comprised of a percentage of primary fees for instructors of this role type |
||||
| ONGOING_INSTRUCTOR_FIXED_FEE | money | 21,4 | √ | null |
|
|
The ongoing preparation fixed fee rate for instructors of this role type |
||||
| ONGOING_INSTRUCTOR_PER_HOUR_FEE | money | 21,4 | √ | null |
|
|
The ongoing preparation per hour fee rate for instructors of this role type |
||||
| ONGOING_INSTRUCTOR_PER_STUDENT_FEE | money | 21,4 | √ | null |
|
|
The ongoing preparation per student fee rate for instructors of this role type |
||||
| ONGOING_INSTRUCTOR_PERCENT_ALL_FEES | money | 21,4 | √ | null |
|
|
The ongoing preparation fee rate comprised of a percentage of all fees for instructors of this role type |
||||
| ONGOING_INSTRUCTOR_PERCENT_KEY_FEES | money | 21,4 | √ | null |
|
|
The ongoing preparation fee rate comprised of a percentage of primary fees for instructors of this role type |
||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this instructor role has been retired from further use (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) |
|---|---|---|---|
| INSTRUCTOR_ROLES_INSTRUCTOR_ROLE_ID_ORG_ID_PK | Primary key | Asc/Asc | INSTRUCTOR_ROLE_ID + ORG_ID |
| INSTRUCTOR_ROLES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |