Defines the user in the system, inherited from inetOrgPerson, a standard ldap user class. This is the physical user who will get authenticated and can login in into the system.
User belongs to a tenant( domain), and will login into the specific domain he is part of to access the system
User also is tied to a role which determines what level of access he has
icgroupname is replaced by icroleid icuserquery is replaced with user_query_history icpwdhistrory is replaced with user_pwd_history
| Column Name | Column Datatype | Column Null Option | Column Comment |
| user_id | varchar(128) | not null | The unique userid, user id is of the form username@domain |
| status | integer | with null | Status, 0- deleted user 1 - active user |
| common_name | varchar(128) | with null | |
| first_name | varchar(64) | with null | |
| last_name | varchar(64) | with null | |
| initials | varchar(32) | with null | |
| address | varchar(128) | with null | Address where usm_user resides. |
| city | varchar(64) | with null | |
| external_ou | varchar(20) | with null | The path for the external LDAP user organization unit |
| external_dn | varchar(256) | with null | The external LDAP distinguished name if the user lies in an external LDAP |
| domain | varchar(50) | with null | Handle to tenant object, specifying which organization this user belongs to |
| time_zone_code | varchar(64) | with null | Handle to a timezone object |
| locale_code | varchar(4) | with null | Handle to the locale object |
| state | varchar(64) | with null | |
| country | varchar(64) | with null | |
| postal_code | varchar(16) | with null | |
| varchar(128) | with null | ||
| telephone | varchar(20) | with null | |
| fax | varchar(20) | with null | |
| mobile | varchar(20) | with null | |
| pager | varchar(20) | with null | |
| home_phone | varchar(20) | with null | |
| password | varchar(64) | with null | |
| title | varchar(64) | with null | |
| description | varchar(128) | with null | |
| manager | varchar(64) | with null | |
| employee_type | varchar(32) | with null | |
| employee_number | varchar(16) | with null | |
| department_number | varchar(8) | with null | |
| secretary | varchar(64) | with null | |
| organization | varchar(64) | with null | |
| organization_unit | varchar(64) | with null | |
| uid | varchar(64) | with null | |
| car_licence | varchar(16) | with null | |
| url | varchar(128) | with null | |
| user_account_control | integer | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| user_id | usm_dash | user_id |
| user_id | usm_dash | user_id |
| user_id | usm_appuser | user_id |
| user_id | usm_link_account_user | user_id |
| user_id | usm_user_query_history | user_id |
| user_id | usm_role_user | user_id |