Users

Columns

Name	Type	Description
Id [KEY]	String	A unique numeric identifier for the user.
FirstName	String	The first name of the user.
LastName	String	The last name of the user.
FullName	String	The full name of the user.
Email	String	The email of the user.
RoleName	String	The name of the role the user has.
RoleId	String	The Id of the role the user has.
ProfileName	String	The name of the profile the user has.
ProfileId	String	The Id of the profile the user has.
Country	String	The country where the user is situated.
City	String	The city where the user is situated.
Street	String	The street where the user is situated.
State	String	The state where the user is situated.
Zip	String	The zip where the user is situated.
Alias	String	The alias of the user.
Signature	String	The signature of the user.
NameFormat	String	The format of the name of the user.
PersonalAccount	Boolean	Whether this user has a personal account or not.
DefaultTabGroup	String	The default tab group for this user.
CountryLocale	String	The default country locale of the user.
Fax	String	The fax of the user.
Website	String	The website of the user.
Mobile	String	The mobile phone number of the user.
Phone	String	The phone number of the user.
Dob	String	The date of birth of the user.
Status	String	The status of the user.
Confirm	Boolean	Whether this user has confirmed his email or not.
Language	String	The Language of the user.
Locale	String	The locale of the user.
TimeFormat	String	The default time format of the user.
DateFormat	String	The default date format of the user.
DecimalSeparator	String	The locale of the default decimal separator of the user.
TimeZone	String	The time zone of the user.
Zuid	String	The default ZUID of the user.
Territories	String	A comma separeted string of the user's territories.
CreatedByName	String	The name of the user who created this user.
CreatedById	String	The id of the user who created this user.
CreatedTime	Datetime	The time this user was created.
ModifiedByName	String	The name of the user who modified this user.
ModifiedById	String	The id of the user who modified this user.
ModifiedTime	Datetime	The time this user was last modified.

Pseudo-Columns

Name	Type	Description
Type	String	Limit the users returned to the ones of this type The allowed values are AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser.