Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
User ID |
|||||
| PROFILE_ID | int | 4 | √ | null |
|
|
User profile ID |
||||
| USER_DEFAULT_PROFILE | varchar | 50 | √ | null |
|
|
User default profile name |
||||
| USER_FIRST_NAME | varchar | 255 | √ | null |
|
|
User first name |
||||
| USER_LAST_NAME | varchar | 255 | √ | null |
|
|
User last name |
||||
| EMPLOYEE_ID | varchar | 255 | √ | null |
|
|
User employee number |
||||
| LOGIN_NAME | varchar | 255 | √ | null |
|
|
User login name |
||||
| varchar | 255 | √ | null |
|
|
User email address |
|||||
| IS_EMAIL_VALID | varchar | 3 | null |
|
|
Whether the user’s email address has been provided and is a validly formatted email address (Yes/No) |
|||||
| MOBILE_PHONE_COUNTRY_CODE | varchar | 50 | √ | null |
|
|
The country code for the user’s mobile phone number |
||||
| MOBILE_PHONE_NUMBER | varchar | 50 | √ | null |
|
|
The user’s mobile phone number |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
User customer ID |
||||
| SYSTEM_ADMIN | varchar | 5 | √ | null |
|
|
Whether the user is a system administrator (Yes or No) |
||||
| PERMIT_ADMINISTRATOR | varchar | 5 | √ | null |
|
|
Whether the user is a permit adminstrator (Yes or No) |
||||
| RECEIVE_EMAIL_FOR_NEW_ACCOUNTS | varchar | 5 | √ | null |
|
|
Whether this user should receive an email for each newly created customer account (Yes / No) |
||||
| CUSTOMER_VIEW_TYPE | varchar | 40 | √ | null |
|
|
The type of customer view that this user should maintain customer records with (Use Standard HTML Customer View / Use Enhanced Customer View / Use System Default Type) |
||||
| AUTO_PRINT_RECEIPTS | varchar | 20 | √ | null |
|
|
Whether receipts should auto print for this user (Yes / No / Use System Default) |
||||
| AUTO_PRINT_PERMITS | varchar | 20 | √ | null |
|
|
Whether permits should auto print for this user (Yes / No / Use System Default) |
||||
| SITE_ACCESS | varchar | 255 | √ | null |
|
|
User site access description |
||||
| ALL_DEPARTMENTS_ACCESS | varchar | 5 | √ | null |
|
|
Whether this user has access to all departments (Yes or No) |
||||
| NEVER_EXPIRE | varchar | 5 | √ | null |
|
|
Whether the user password never expires (Yes or No) |
||||
| RETIRED | varchar | 5 | √ | null |
|
|
Whether the user record has been retired (Yes or No) |
||||
| PASSWORD_LAST_CHANGED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the user’s password was last changed |
||||
| PASSWORD_LAST_CHANGED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the user’s password was last changed (date only) |
||||
| 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 |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| LAST_LOGIN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the user last logged in |
||||
| LAST_LOGIN_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the user last logged in (date only) |