sys_user
The table below describes the sys_user table.
This table contains the following foldable columns:
- sys_id_value
- building_value
- company_value
- cost_center_value
- department_value
- ldap_server_value
- location_value
- manager_value
- schedule_value
- active_display_value
- active_value
- building_display_value
- calendar_integration_display_value
- calendar_integration_value
- city_display_value
- city_value
- company_display_value
- cost_center_display_value
- country_display_value
- country_value
- date_format_display_value
- date_format_value
- default_perspective_display_value
- default_perspective_value
- department_display_value
- email_display_value
- email_value
- employee_number_display_value
- employee_number_value
- failed_attempts_display_value
- failed_attempts_value
- first_name_display_value
- first_name_value
- gender_display_value
- gender_value
- home_phone_display_value
- home_phone_value
- internal_integration_user_display_value
- internal_integration_user_value
- introduction_display_value
- introduction_value
- last_login_display_value
- last_login_time_display_value
- last_login_time_value
- last_login_value
- last_name_display_value
- last_name_value
- ldap_server_display_value
- location_display_value
- locked_out_display_value
- locked_out_value
- manager_display_value
- middle_name_display_value
- middle_name_value
- mobile_phone_display_value
- mobile_phone_value
- name_display_value
- name_value
- notification_display_value
- notification_value
- password_needs_reset_display_value
- password_needs_reset_value
- phone_display_value
- phone_value
- photo_display_value
- photo_value
- preferred_language_display_value
- preferred_language_value
- roles_display_value
- roles_value
- schedule_display_value
- source_display_value
- source_value
- sso_source_display_value
- sso_source_value
- state_display_value
- state_value
- street_display_value
- street_value
- sys_class_name_display_value
- sys_class_name_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_domain_display_value
- sys_domain_path_display_value
- sys_domain_path_value
- sys_domain_value
- sys_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_tags_display_value
- sys_tags_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
- time_format_display_value
- time_format_value
- time_zone_display_value
- time_zone_value
- title_display_value
- title_value
- user_name_display_value
- user_name_value
- user_password_display_value
- user_password_value
- vip_display_value
- vip_value
- web_service_access_only_display_value
- web_service_access_only_value
- zip_display_value
- zip_value
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
building_value Foreign Key linked to column sys_id_value in cmn_building table |
SQL_VARCHAR(64) | True | True |
|
company_value Foreign Key linked to column sys_id_value in core_company table |
SQL_VARCHAR(64) | True | True |
|
cost_center_value Foreign Key linked to column sys_id_value in cmn_cost_center table |
SQL_VARCHAR(64) | True | True |
|
department_value Foreign Key linked to column sys_id_value in cmn_department table |
SQL_VARCHAR(64) | True | True |
|
ldap_server_value Foreign Key linked to column sys_id_value in ldap_server_config table |
SQL_VARCHAR(64) | True | True |
|
location_value Foreign Key linked to column sys_id_value in cmn_location table |
SQL_VARCHAR(64) | True | True |
|
manager_value Foreign Key linked to column sys_id_value in sys_user table |
SQL_VARCHAR(64) | True | True |
|
schedule_value Foreign Key linked to column sys_id_value in cmn_schedule table |
SQL_VARCHAR(64) | True | True |
|
active_display_value |
SQL_VARCHAR(500) | True | True |
|
active_value |
SQL_BIT | True | True |
|
building_display_value |
SQL_VARCHAR(500) | True | True |
|
calendar_integration_display_value |
SQL_VARCHAR(500) | True | True |
|
calendar_integration_value |
SQL_INTEGER(signed) | True | True |
|
city_display_value |
SQL_VARCHAR(500) | True | True |
|
city_value |
SQL_VARCHAR(80) | True | True |
|
company_display_value |
SQL_VARCHAR(500) | True | True |
|
cost_center_display_value |
SQL_VARCHAR(500) | True | True |
|
country_display_value |
SQL_VARCHAR(500) | True | True |
|
country_value |
SQL_VARCHAR(6) | True | True |
|
date_format_display_value |
SQL_VARCHAR(500) | True | True |
|
date_format_value |
SQL_VARCHAR(80) | True | True |
|
default_perspective_display_value |
SQL_VARCHAR(500) | True | True |
|
default_perspective_value |
SQL_VARCHAR(64) | True | True |
|
department_display_value |
SQL_VARCHAR(500) | True | True |
|
email_display_value |
SQL_VARCHAR(500) | True | True |
|
email_value |
SQL_VARCHAR(256) | True | True |
|
employee_number_display_value |
SQL_VARCHAR(500) | True | True |
|
employee_number_value |
SQL_VARCHAR(80) | True | True |
|
failed_attempts_display_value |
SQL_VARCHAR(500) | True | True |
|
failed_attempts_value |
SQL_INTEGER(signed) | True | True |
|
first_name_display_value |
SQL_VARCHAR(500) | True | True |
|
first_name_value |
SQL_VARCHAR(100) | True | True |
|
gender_display_value |
SQL_VARCHAR(500) | True | True |
|
gender_value |
SQL_VARCHAR(80) | True | True |
|
home_phone_display_value |
SQL_VARCHAR(500) | True | True |
|
home_phone_value |
SQL_VARCHAR(256) | True | True |
|
internal_integration_user_display_value |
SQL_VARCHAR(500) | True | True |
|
internal_integration_user_value |
SQL_BIT | True | True |
|
introduction_display_value |
SQL_VARCHAR(500) | True | True |
|
introduction_value |
SQL_VARCHAR(80) | True | True |
|
last_login_display_value |
SQL_VARCHAR(500) | True | True |
|
last_login_time_display_value |
SQL_VARCHAR(500) | True | True |
|
last_login_time_value |
SQL_TIMESTAMP | True | True |
|
last_login_value |
SQL_DATE | True | True |
|
last_name_display_value |
SQL_VARCHAR(500) | True | True |
|
last_name_value |
SQL_VARCHAR(100) | True | True |
|
ldap_server_display_value |
SQL_VARCHAR(500) | True | True |
|
location_display_value |
SQL_VARCHAR(500) | True | True |
|
locked_out_display_value |
SQL_VARCHAR(500) | True | True |
|
locked_out_value |
SQL_BIT | True | True |
|
manager_display_value |
SQL_VARCHAR(500) | True | True |
|
middle_name_display_value |
SQL_VARCHAR(500) | True | True |
|
middle_name_value |
SQL_VARCHAR(100) | True | True |
|
mobile_phone_display_value |
SQL_VARCHAR(500) | True | True |
|
mobile_phone_value |
SQL_VARCHAR(256) | True | True |
|
name_display_value |
SQL_VARCHAR(500) | True | True |
|
name_value |
SQL_VARCHAR(302) | True | True |
|
notification_display_value |
SQL_VARCHAR(500) | True | True |
|
notification_value |
SQL_INTEGER(signed) | True | True |
|
password_needs_reset_display_value |
SQL_VARCHAR(500) | True | True |
|
password_needs_reset_value |
SQL_BIT | True | True |
|
phone_display_value |
SQL_VARCHAR(500) | True | True |
|
phone_value |
SQL_VARCHAR(256) | True | True |
|
photo_display_value |
SQL_VARCHAR(500) | True | True |
|
photo_value |
SQL_VARCHAR(80) | True | True |
|
preferred_language_display_value |
SQL_VARCHAR(500) | True | True |
|
preferred_language_value |
SQL_VARCHAR(6) | True | True |
|
roles_display_value |
SQL_VARCHAR(500) | True | True |
|
roles_value |
SQL_VARCHAR(256) | True | True |
|
schedule_display_value |
SQL_VARCHAR(500) | True | True |
|
source_display_value |
SQL_VARCHAR(500) | True | True |
|
source_value |
SQL_VARCHAR(510) | True | True |
|
sso_source_display_value |
SQL_VARCHAR(500) | True | True |
|
sso_source_value |
SQL_VARCHAR(256) | True | True |
|
state_display_value |
SQL_VARCHAR(500) | True | True |
|
state_value |
SQL_VARCHAR(80) | True | True |
|
street_display_value |
SQL_VARCHAR(500) | True | True |
|
street_value |
SQL_VARCHAR(256) | True | True |
|
sys_class_name_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_class_name_value |
SQL_VARCHAR(160) | False | True |
|
sys_created_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_created_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_on_value |
SQL_TIMESTAMP | False | True |
|
sys_domain_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_domain_path_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_domain_path_value |
SQL_VARCHAR(510) | False | True |
|
sys_domain_value |
SQL_VARCHAR(64) | False | True |
|
sys_id_display_value |
SQL_VARCHAR(500) | False | False |
|
sys_mod_count_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_mod_count_value |
SQL_INTEGER(signed) | False | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_updated_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_updated_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_on_value |
SQL_TIMESTAMP | False | True |
|
time_format_display_value |
SQL_VARCHAR(500) | True | True |
|
time_format_value |
SQL_VARCHAR(80) | True | True |
|
time_zone_display_value |
SQL_VARCHAR(500) | True | True |
|
time_zone_value |
SQL_VARCHAR(80) | True | True |
|
title_display_value |
SQL_VARCHAR(500) | True | True |
|
title_value |
SQL_VARCHAR(120) | True | True |
|
user_name_display_value |
SQL_VARCHAR(500) | True | True |
|
user_name_value |
SQL_VARCHAR(200) | True | True |
|
user_password_display_value |
SQL_VARCHAR(500) | True | True |
|
user_password_value |
SQL_VARCHAR(256) | True | True |
|
vip_display_value |
SQL_VARCHAR(500) | True | True |
|
vip_value |
SQL_BIT | True | True |
|
web_service_access_only_display_value |
SQL_VARCHAR(500) | True | True |
|
web_service_access_only_value |
SQL_BIT | True | True |
|
zip_display_value |
SQL_VARCHAR(500) | True | True |
|
zip_value |
SQL_VARCHAR(80) | True | True |