Field/Column name

Type

Acceptable values

Required

Description

Notes

booAcknowledgeDisclaimer

Boolean

0 or 1

No

A boolean value that controls the display of the terms and conditions modal pop up.

If set to 0 it informs the system that the user has not accepted the system disclaimer message. This will cause the message to be displayed to the user upon first login. If set to 1, the message will not be displayed.

booActive

Small Integer

-32,768 to 32,767

No

A boolean value that represents if the account is active.

If set to 0, the account is inactive and the user will not be able to login to the system. If set to 1, the account is active and the user may be able to login.

booCanCreateChildren

Small Integer

-32,768 to 32,767

If set to 0, the user will not have permission to create children or new user accounts. If set to 1, the user will have permission to create new user accounts.

0 represents the boolean value of false. 1 represents the boolean value of true.

booCanCreateOrders

Small Integer

-32,768 to 32,767

No

Signifies if the user is able to create new orders.

If set to 0, the user will not be able to create new orders. If set to 1, the user will be able to create new orders.

booCanCreateProjects

Small Integer

-32,768 to 32,767

No

A boolean value that control whether or not the user may create new projects.

If the value is set to 0, the user will not have permissions to create new projects. If set to 1, the user will have the permission to create new projects.

booCanSeeSiblingUsers

Small Integer

-32,768 to 32,767

No

Specifies if the user will be able to view sibling (or users at the same permission level as they) users.

If the value is set to 0, the user will not have permissions to view sibling users. If set to 1, the user will be able to view sibling users.

booCanSubmitOrders

Small Integer

-32,768 to 32,767

No

Controls if the user is able to submit orders to the factory.

If the value is set to 0, the user will not have permissions to submit orders to the factory. If set to 1, the user will be able to submit new orders.

booResetPassword

Boolean

0 or 1

No

Controls how the system responds to a login request.

If the value is set to 0, the system will not prompt the user to reset their password. If the value is set to 1, the system will prompt the user to reset their password.

booShowLoginMessage

Boolean

0 or 1

No

CompanyLineItemGroupIDs

Character

Max 255 characters

No

Controls the types of devices the user may select.

May be set to 4 or 5 or a combination of both. 4 = Water to Water. 5 = Water to Air

datCreated

Datetime

January 1, 1753 - December 21, 9999

No

Represents the date and time that the user account was created.

Should not be modified.

datLogin

Datetime

January 1, 1753 - December 21, 9999

No

A date that represents the date and time the user logged into the system.

Provided for informational purposes only. Should not be modified in most cases.

defaultACCMultiplier

Float

0 - 1

No

Represents the user's default accessory multiplier

Must be between 0 and 1

defaultAOPMultiplier

Float

0 - 1

No

Represents the user's default multiplier for products that are not TC units and are not accessories

Must be between 0 and 1

defaultTCMultiplier

Float

0 - 1

No

Represents the user's default multiplier for all TC products

Must be between 0 and 1

lngPermissionLevel

Integer

-2,147,483,648 to 2,147,483,647

No

A number that represents the user's permission level. The value specified is related to the user's role as defined in the user administration pages. View the help topic Permission Levels elsewhere in this document for acceptable values.

While technically not required by the database, users without a permission level will not be able to access any pages after logging in to the system.

lngTimeoutMinutes

Small Integer

-32,768 to 32,767

No

Represents the number of minutes that a user may be logged in with no activity before the user account is logged out.

Normally set to a value between 30 and 480 minutes

RegionalSalesManager

Boolean

0 or 1

No

Informs the system if the user is a Regional Sales Manager.

If set to 0, the user is not a regional sales manager. If set to 1, the user is a regional sales manager and will be sent multiplier requests from their users.

strAddress1

Character

Max 80 characters

No

Represents the user's physical or mailing address.

May include any combination of alphanumeric characters.

strAddress2

Character

Max 80 characters

No

Represents the second portion of the user's physical or mailing address.

strCell

Character

Max 20 characters

No

Represents the user's cellular or mobile phone number.

strCity

Character

Max 50 characters

No

Represents the user's physical address.

strCompanyID

Character

Max 6 characters

No

A numerical representation of the company id to which the user belongs.

Must match a company id in the tblCompanies table.

strCompanyName

Character

Max 50 characters

No

The name of the company to which the user belongs.

Should match the company name associated with the company id in the tblCompanies table.

strCountry

Character

Max 50 characters

No

The country in which the user resides.

strEmail

Character

Max 100 characters

No

Used to store the user's e-mail address.

While not required by the database this field should represent a valid e-mail address for the user. It is used when sending password requests, multiplier requests and approval messages.

strFax

Character

Max 20 characters

No

If the user has a fax number, this number may be stored in this field

strFirstName

Character

Max 40 characters

No

The user's first name.

Even though it isn't required by the database it should be provided for accessibility purposes and to make it easier to relate projects, quotes and orders to a physical person.

strJobTitle

Character

Max 50 characters

No

The job title of the user.

strLastName

Character

Max 40 characters

No

The user's last name or surname.

Even though it isn't required by the database it should be provided for accessibility purposes and to make it easier to relate projects, quotes and orders to a physical person.

strPager

Character

Max 20 characters

No

Represents the user's page number

strPhone1

Character

Max 20 characters

No

Usually is used to represent the user's primary phone number

strPhone1ext

Character

Max 10 characters

No

Represents the user's phone extension

strPhone2

Character

Max 20 characters

No

If the user has an additional phone number, this may be stored here

strPhone2ext

Character

Max 10 characters

No

Represents the user's secondary phone extension

strState

Character

Max 15 characters

No

The state or province where the user resides

strUserName

Character

Max 40 characters

Yes

The name that the user uses to login to the system.

Although it may be changed by the administrator, it may impact other user when attempting to search for objects created or owned by the user.

strUser1

Decimal (whole number)

0 - 99,999,999,999

No

The regional sales manager's id for the user account.

Must match a user account varID contained in the tblUsers table.

strZip

Character

Max 10 characters

No

The zip or postal code where the user resides.

varID

Decimal (whole number)

0 - 99,999,999,999

Yes

A unique number that identifies the user account to the system. This number is tied to all of the other tables in the database and is used to represent the user account.

Should not be changed by the administrator. Changing this value will render all user associated items, such as projects, quotes and orders inaccessible to the user.

varParentID

Decimal (whole number)

0 - 99,999,999,999

No

The user account (varID) of the user currently listed as the parent of this user.

User should always have parent ids for ease of management purposes. Parents are required if making changes to a user account using the User administration pages.