Table Definitions: Business Administrators

column	type	null	unique	references	referenced_by	since_version	description
username	username	false	true	usernames.username	disable_log.disabled_by monthly_charges.created_by packages.created_by transactions.username business_administrator_permissions.username master_processes.authenticated_user master_processes.effective_user master_users.username credit_cards.created_by credit_card_transactions.authorization_username credit_card_transactions.capture_username credit_card_transactions.credit_card_created_by credit_card_transactions.void_username signup_requests.completed_by ticket_actions.administrator ticket_actions.old_assigned_to ticket_actions.new_assigned_to ticket_assignments.administrator tickets.created_by	1.0a100	the unique identifier for this admin
password	hashed_password	true	false			1.69	the encrypted password for this admin
name	string	false	false			1.0a100	the name of this admin
title	string	true	false			1.0a100	the admins title within their organization
birthday	date	true	false			1.69	the admins birthday
is_preferred	boolean	false	false			1.0a100	if true, customers is preferred
private	boolean	false	false			1.0a100	indicates if the admin should not be listed in publicly available lists
created	time	false	false			1.0a100	the time the admin entry was created
work_phone	phone	false	false			1.0a100	the work phone number (if different than business)
home_phone	phone	true	false			1.0a100	the home phone number
cell_phone	phone	true	false			1.0a100	the cellular phone number
fax	phone	true	false			1.0a100	the fax number (if different than business)
email	email	false	false			1.0a100	the email address
address1	string	true	false			1.0a100	the street address (if different than business)
address2	string	true	false			1.0a100	the street address (if different than business)
city	string	true	false			1.69	the city (if different than business)
state	string	true	false			1.69	the state (if different than business)
country	string	true	false	country_codes.code		1.69	the country (if different than business)
zip	string	true	false			1.69	the zip code (if different than business)
disable_log	fkey	true	false	disable_log.pkey		1.0a100	indicates that this account is disabled
can_switch_users	boolean	false	false			1.0a118	allows this person to switch users to any subaccounts
support_code	string	true	true			1.44	used to authenticate for email-based supprt

TABLE NAME

DESCRIPTION

COLUMNS