Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| SITE_URL | varchar | 30 | null |
|
|
Your organization’s website name. This is also database name in the Active Net system |
||
| ORG_NAME | varchar | 80 | √ | null |
|
|
Your organization’s full name |
|
| ORG_ADDR1 | varchar | 50 | √ | null |
|
|
Your organization’s street address 1 |
|
| ORG_ADDR2 | varchar | 50 | √ | null |
|
|
Your organization’s street address 2 |
|
| ORG_CITY | varchar | 50 | √ | null |
|
|
Your organization’s city |
|
| ORG_STATE | varchar | 3 | √ | null |
|
|
Your organization’s state |
|
| ORG_ZIP | varchar | 20 | √ | null |
|
|
Your organization’s zip |
|
| RETIRED | smallint | 2 | √ | null |
|
|
Your organization’s marked as retired |
|
| TIME_ZONE_OFFSET_HR | int | 4 | √ | null |
|
|
Your organization’s offset time in number of hours |
|
| RETIREASOFDATE | date | 20 | √ | null |
|
|
Your organization’s unique will be retired as of this date |
|
| 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 |