SYSTEM_USERS

0 rows


Description

Organization’s system users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 √ null

The Hub record ID
SYSTEMUSER_ID int 4 √ null
ACCOUNT_CREDIT_HISTORY.SYSTEMUSER_ID Defined in XML R
AR_SCHEDULED_HEADERS.SYSTEMUSER_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.CHECK_IN_SYSTEMUSER_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.CHECK_OUT_SYSTEMUSER_ID Defined in XML R
CREDIT_CARD_PROCESSING_LOG.SYSTEMUSER_ID Defined in XML R
CUSTOMER_MERGE_LOG.SYSTEMUSER_ID Defined in XML R
CUSTOMER_NOTES.SYSTEMUSER_ID Defined in XML R
CUSTOMER_SIGNED_WAIVERS.SYSTEMUSER_ID Defined in XML R
FACILITY_RESERVATION.SYSTEMUSER_ID Defined in XML R
FACILITY_USERS.SYSTEMUSER_ID Defined in XML R
GIFT_CARDS.ISSUED_BY_SYSTEMUSER_ID Defined in XML R
LOCKER_SCHEDULES.SYSTEMUSER_ID Defined in XML R
MEMBERSHIP_AUDIT_LOG.SYSTEMUSER_ID Defined in XML R
PERMITS.PERMIT_ADMINISTRATOR_ID Defined in XML R
PERMITS.SYSTEMUSER_ID Defined in XML R
PROGRAM_ATTENDANCE_HISTORY.SYSTEMUSER_ID Defined in XML R
PROGRAM_ATTENDANCE_HISTORY.UNDO_SYSTEMUSER_ID Defined in XML R
PROGRAM_REGISTRATIONS.ABSENT_SYSTEMUSER_ID Defined in XML R
PROGRAM_REGISTRATIONS.CHECK_IN_SYSTEMUSER_ID Defined in XML R
PROGRAM_REGISTRATIONS.CHECK_OUT_SYSTEMUSER_ID Defined in XML R
RECEIPT_DETAILS.SYSTEMUSER_ID Defined in XML R
RECEIPT_GL_POSTINGS.SYSTEMUSER_ID Defined in XML R
RECEIPT_HEADERS.SYSTEMUSER_ID Defined in XML R
RECEIPT_PAYMENTS.SYSTEMUSER_ID Defined in XML R
SAVED_CREDIT_CARD_HISTORY.LAST_UPDATED_SYSTEMUSER_ID Defined in XML R
SAVED_CREDIT_CARD_HISTORY.UPDATED_SYSTEMUSER_ID Defined in XML R
SAVED_CREDIT_CARDS.SYSTEMUSER_ID Defined in XML R
STAGES.APPROVAL_SYSTEMUSER_ID Defined in XML R
SYSTEM_USAGE_LOG.SYSTEMUSER_ID Defined in XML R
SYSTEM_USER_PROFILES.SYSTEMUSER_ID Defined in XML R
TRANSACTION_STAGES.APPROVAL_SYSTEMUSER_ID Defined in XML R
TRANSACTION_STAGES.SYSTEMUSER_ID Defined in XML R
TRANSACTIONS.SYSTEMUSER_ID Defined in XML R
UPLOADED_FILES.UPLOADED_BY_SYSTEMUSER_ID Defined in XML R

User ID
PROFILE_ID int 4 √ null
PROFILES.PROFILE_ID Defined in XML R

User profile ID
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
EMAIL varchar 255 √ null

User email address
CUSTOMER_ID int 4 √ null
CUSTOMERS.CUSTOMER_ID Defined in XML R

User customer ID
SYSTEM_ADMIN varchar 5 √ null

Whether the user is a system administrator (Yes or No)
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)
PERMIT_ADMINISTRATOR varchar 5 √ null

Whether the user is a permit adminstrator (Yes or No)
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
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)
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
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
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)
PASSWORD_LAST_CHANGED datetime 16,3 √ null

The date and time that the user’s password was last changed

Indexes

Constraint Name Type Sort Column(s)
SYSTEM_USERS_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
SYSTEM_USERS_CUSTOMER_ID_IX Performance Asc CUSTOMER_ID
SYSTEM_USERS_PROFILE_ID_IX Performance Asc PROFILE_ID
SYSTEM_USERS_ROW_VERSION_IX Performance Asc ROW_VERSION
SYSTEM_USERS_SYSTEMUSER_ID_ORG_ID_UQ Must be unique Asc/Asc SYSTEMUSER_ID + ORG_ID

Relationships

Close relationships within degrees of separation