| identity_type_id |
INT |
Person’s document type, reference to AFW_CATALOG_CODE.id |
| update_date |
DATETIME |
Date of last modification of the record |
| user_active* |
BIT |
Identify whether a user is active=true or inactive=false |
| user_address1 |
NVARCHAR (510) |
Address of the person |
| user_address2 |
NVARCHAR (510) |
Second address of the person |
| user_address3 |
NVARCHAR (510) |
Third Person Direction |
| user_authentication_id |
INT |
Authentication provider ID, reference to REFERENCES AFW_LDAP.id |
| user_birthdate |
DATETIME |
Person’s date of birth |
| user_building_id |
INT |
Identifier of the building where the person is located, reference to AFW_CATALOG_CODE.id |
| user_builtin* |
BIT |
Preset User Indicator |
| user_chief |
INT |
Person’s immediate boss, reference to AFW_USERS.user_id |
| user_city_id |
INT |
Identifier of the city where the person lives, reference to AFW_CATALOG_CODE.id |
| user_comments |
NVARCHAR (510) |
User Reviews |
| user_company_id |
INT |
Identifier of the company for which the person works, reference to AFW_CATALOG_CODE.id |
| user_country_id |
INT |
Country identifier, reference to AFW_CATALOG_CODE.id |
| user_department_code |
INT |
Department ID, reference to AFW_CATALOG_CODE.id |
| user_email |
NVARCHAR (510) |
User Email |
| user_ext |
NVARCHAR (40) |
Extension of the person’s telephone line |
| user_fax |
NVARCHAR (40) |
Person’s fax number |
| user_floor_id |
INT |
Identifier of the apartment where the person works, reference to AFW_CATALOG_CODE.id |
| user_guid_ldap |
NVARCHAR (100) |
Unique Active Directory Identifier |
| user_id* |
INT |
User ID |
| user_identity_number |
NVARCHAR (28) |
Person’s Identification Number |
| user_identity_type |
NVARCHAR (40) |
Person Document Type, (Obsolete): Use identity_type_id Property |
| user_language |
NVARCHAR (10) |
The user’s language |
| user_mobile |
NVARCHAR (510) |
Person’s cell phone number |
| user_name* |
NVARCHAR (510) |
Username |
| user_nick_name |
NVARCHAR (510) |
Username used to log in |
| user_numberdepid |
INT |
Identifier of the area where the person works, reference to AFW_CATALOG_CODE.id |
| user_phone1 |
NVARCHAR (510) |
The person’s first phone number |
| user_phone2 |
NVARCHAR (510) |
Person’s second phone number |
| user_phone3 |
NVARCHAR (510) |
Person’s third phone number |
| user_picture |
NVARCHAR (510) |
User Image Path |
| user_site_id |
INT |
Identifier of the location where the person is located, reference to AFW_CATALOG_CODE.id |
| user_title_id |
INT |
Person’s job title ID, reference to AFW_CATALOG_CODE.id |
| user_zone |
NVARCHAR (512) |
User’s geographic area |
