Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| INSTRUCTOR_FACILITY_ID | int | 4 | √ | null |
|
|
Instructor facility ID. |
|
| INSTRUCTOR_FACILITY_NAME | varchar | 255 | √ | null |
|
|
Instructor facility name. |
|
| ADDRESS1 | varchar | 35 | √ | null |
|
|
The first address line of the instructor facility |
|
| ADDRESS2 | varchar | 35 | √ | null |
|
|
The second address line of the instructor facility |
|
| CITY | varchar | 30 | √ | null |
|
|
The city of the instructor facility address |
|
| STATE | varchar | 15 | √ | null |
|
|
The state of the instructor facility address |
|
| ZIPCODE | varchar | 10 | √ | null |
|
|
The postal code of the instructor facility address |
|
| COUNTRY | varchar | 2 | √ | null |
|
|
The country code of the instructor facility address |
|
| INSTRUCTOR_FACILITY_NOTES | varchar | 8000 | √ | null |
|
|
Notes related to the instructor facility |
|
| OPEN_24_HOURS | varchar | 5 | √ | null |
|
|
Whether the instructor facility is open 24 hours per day (Yes/No) |
|
| MONDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Mondays (Yes/No) |
|
| TUESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Tuesdays (Yes/No) |
|
| WEDNESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Wednesdays (Yes/No) |
|
| THURSDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Thursdays (Yes/No) |
|
| FRIDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Fridays (Yes/No) |
|
| SATURDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Saturdays (Yes/No) |
|
| SUNDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the instructor facility is closed on Sundays (Yes/No) |
|
| HIDE_ON_INTERNET | varchar | 5 | √ | null |
|
|
Whether the instructor facility should be hidden from display online (Yes/No) |
|
| MODIFIED_DATE | datetime | 16,3 | √ | null |
|
|
The date and time of the last modification to the instructor facility information |
|
| MODIFIED_DATE_ONLY | date | 20 | √ | null |
|
|
The date of the last modification to the instructor facility information (date only) |
|
| RETIRED | varchar | 5 | √ | null |
|
|
Whether the instructor facility record has been retired (Yes or No) |
|
| ITEM_TYPE_ID | int | 4 | √ | null |
|
|
The type of resource that this facility is (0=facility, 1=equipment, 2=human resource) |
|
| RESOURCE_TYPE | varchar | 10 | √ | null |
|
|
Facility resource type (Facility, Equipment or Instructor). |
|
| ACTIVE_HUB_KEY | int identity | 4 | null |
|
|
The Hub record ID |
||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
|
| 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 |