Derivation Hierarchy

Subclasses:
No Subclasses
Siblings:
No Siblings

Table Details

Name:
sys_user
Label:
User (en)
Created On:
2006.01.16 19:50:22
Created By:
glide.maint
Updated On:
2018.12.05 01:08:27
Updated By:
system
Column Updated On:
2020.03.21 19:45:48
Column Updated By:
system
Listing:
open
Dictionary:
open

Attributes

+ Status Name Label Datatype Length Reference Included By
  accumulated_roles Accumulated roles string 4000 sys_user
  active Active boolean 40 sys_user
  avatar Avatar user_image 40 sys_user
  building Building reference 32 cmn_building sys_user
  calendar_integration Calendar integration integer [choice] 40 sys_user
  city City string 40 sys_user
  company Company reference 32 core_company sys_user
  cost_center Cost center reference 32 cmn_cost_center sys_user
  country Country code string [choice] 3 sys_user
  date_format Date format string [choice] 40 sys_user
  default_perspective Default perspective reference 32 sys_perspective sys_user
  department Department reference 32 cmn_department sys_user
 
P
edu_status EDU Status string [choice] 40 sys_user
  email Email email 100 sys_user
  employee_number Employee number string 40 sys_user
  enable_multifactor_authn Enable Multifactor Authentication boolean 40 sys_user
  failed_attempts Failed login attempts integer 40 sys_user
  first_name First name string 50 sys_user
  gender Gender string [choice] 40 sys_user
  home_phone Home phone ph_number 40 sys_user
  internal_integration_user Internal Integration User boolean 1 sys_user
  introduction Prefix string [choice] 40 sys_user
  last_login Last login glide_date 40 sys_user
 
P
last_login_device Last login device string 40 sys_user
  last_login_time Last login time glide_date_time 40 sys_user
  last_name Last name string 50 sys_user
 
P
last_password Last password string 40 sys_user
  ldap_server LDAP server reference 32 ldap_server_config sys_user
  location Location reference 32 cmn_location sys_user
  locked_out Locked out boolean 40 sys_user
  manager Manager reference 32 sys_user sys_user
  middle_name Middle name string 50 sys_user
  mobile_phone Mobile phone ph_number 40 sys_user
 
D
name Name string 151 sys_user
  notification Notification integer [choice] 40 sys_user
  password_needs_reset Password needs reset boolean 40 sys_user
  phone Business phone ph_number 40 sys_user
  photo Photo user_image 40 sys_user
  preferred_language Language string [choice] 3 sys_user
  roles Roles user_roles 255 sys_user
  schedule Schedule reference 32 cmn_schedule sys_user
  source Source string 255 sys_user
  state State / Province string 40 sys_user
  street Street multi_two_lines 255 sys_user
  sys_class_name Class sys_class_name [choice] 80 sys_user
  sys_created_by Created by string 40 sys_user
  sys_created_on Created glide_date_time 40 sys_user
  sys_domain Domain domain_id 32 sys_user_group sys_user
  sys_domain_path Domain Path domain_path 255 sys_user
 
K
sys_id Sys ID GUID 32 sys_user
  sys_mod_count Updates integer 40 sys_user
  sys_updated_by Updated by string 40 sys_user
  sys_updated_on Updated glide_date_time 40 sys_user
  time_format Time format string [choice] 40 sys_user
  time_zone Time zone string [choice] 40 sys_user
  title Title string [choice] 60 sys_user
 
U
user_name User ID string 40 sys_user
  user_password Password password 100 sys_user
  vip VIP boolean 40 sys_user
  web_service_access_only Web service access only boolean 40 sys_user
  zip Zip / Postal code string 40 sys_user
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Prod Dev Test

Deviating Attributes

Column Prod
roles different

Referenced

Included By:
alm_asset, alm_entitlement, alm_stockroom, alm_transfer_order_line, alm_transfer_order_line_task, alm_user_stockroom, antivirus_activity, appsec_domain_listing, appsec_isc_banner_configuration, appsec_isc_event_configuration, appsec_security_dashboard_event_logs, asmt_assessment_instance, asmt_assessment_stat, asmt_m2m_category_user, asmt_metric_result, asmt_metric_type, ast_contract, bsm_chart, bsm_map_filter, business_unit, cab_definition, cab_meeting, catalog_category_request, catalog_category_request_user, cert_audit, change_request, change_request_imac, checklist, checklist_item, checklist_template, chg_approval_def, chg_soc_definition, clm_m2m_contract_user, clone, cmdb, cmdb_ci_business_app, cmdb_ci_service, cmdb_ci_vpn, cmdb_class_user_preference, cmdb_duplicate_ci_remediation, cmdb_model, cmdb_rel_person, cmdb_subscriber, cmn_building, cmn_cost_center, cmn_department, cmn_location, cmn_notif_device, cmn_notif_grmember, cmn_notif_message, core_company, cxs_relevant_doc, dl_u_assignment, draft_document, dsl, expert_instance, fm_expense_line, goal, gsw_change_log, incident, incident_fact_table, interaction, itil_agreement_owners, itil_agreement_support, itil_appointment, kb_feedback, kb_knowledge, kb_knowledge_base, kb_submission, kb_use, label, label_history, label_user_m2m, live_notification, m2m_dismissed_announcement, m2m_kb_feedback_likes, m2m_sp_status_subscription, mtg_agenda_item, mtg_attendee, mtg_definition, mtg_meeting, mtg_runtime_state, ngbsm_filter, ngbsm_view, notification_trigger, oauth_credential, oauth_entity, pa_breakdowns, pa_dashboards, pa_dashboards_group, pa_dashboards_permissions, pa_ds_preference, pa_favorites, pa_indicators, pa_m2m_indicator_notification_users, pa_m2m_targets_users, pa_m2m_thresholds_users, pa_score_notes, pa_targets, pa_text_stop_words, pa_thresholds, pdf_draft, process_step_approval, pwd_enrollment, pwd_enrollment_snapshot, pwd_history, pwd_reset_request, pwd_user_lockout, release_feature, release_product, release_project, reminder, report_executions, sa_business_service_user_prefs, sc_cart, sc_catalog, sc_category_user_mtom, sc_category_user_no_mtom, sc_cat_dt_app_user, sc_cat_item_app_user, sc_cat_item_delivery_task, sc_cat_item_guide_items, sc_cat_item_producer_service, sc_cat_item_user_mtom, sc_cat_item_user_no_mtom, sc_ic_aprvl_defn, sc_ic_aprvl_defn_staging, sc_ic_aprvl_type_defn, sc_ic_aprvl_type_defn_staging, sc_ic_category_request, sc_ic_item_staging, sc_ic_req_item_aprvl_defn, sc_ic_req_item_task_defn, sc_ic_task_assign_defn, sc_ic_task_assign_defn_staging, sc_ic_task_defn, sc_ic_task_defn_staging, sc_request, sc_ts_query, security_nonce, service_category_user_role, service_offering, signature_image, sla, sla_breakdown_by_assignment, sla_repair_log, sla_request, sn_devstudio_user_preferences, sn_publications_publication_contact_m2m, sn_publications_recipientslist_user_m2m, sn_publications_recipients_list, sn_publications_workflow_config, sp_log, strategic_objective, svc_security_membership_ops, sysapproval_approver, sysapproval_group, sysauto, sysauto_indicator, sysauto_query_builder, sysauto_report, sysevent_email_action, sysevent_in_email_action, sysrule_approvals, sysrule_assignment, sys_amb_channel_presence, sys_api_stats_requestor, sys_api_stats_requestor_monthly, sys_atf_agent, sys_atf_schedule_run, sys_audit_role, sys_breakpoint, sys_broadcast_msg_user_m2m, sys_canvas_preferences, sys_certificate, sys_email, sys_email_canned_message, sys_email_digest_part_user, sys_email_digest_user_pref, sys_filter, sys_flow_record_trigger, sys_guided_tour_analytics, sys_guided_tour_user_overrides, sys_history_line, sys_history_line0000, sys_history_line0001, sys_history_line0002, sys_history_line0003, sys_ia_preferences, sys_js_breakpoint, sys_mobile_devices, sys_notif_subscription, sys_portal_page, sys_push_notif_app_install, sys_rate_limit_count, sys_rate_limit_rules, sys_rate_limit_violations, sys_report, sys_report_import_table, sys_report_import_table_users_groups_roles, sys_report_users_groups, sys_rollback_context, sys_rw_action, sys_script_execution_history, sys_search_event, sys_sync_change, sys_template, sys_text_snippet, sys_ui_bookmark, sys_ui_bookmark_group, sys_ui_element, sys_ui_form, sys_ui_home_favorite, sys_ui_home_section, sys_ui_list, sys_ui_mobile_offline_result, sys_ui_mobile_visualization, sys_ui_navigator_history, sys_ui_recent_selection, sys_ui_related_list, sys_ui_section, sys_ui_view, sys_update_set, sys_user, sys_user_delegate, sys_user_geo_location, sys_user_grmember, sys_user_group, sys_user_has_license, sys_user_has_role, sys_user_license_audit_log, sys_user_license_exclude, sys_user_license_source, sys_user_pending_license, sys_user_preference, sys_user_presence, sys_wss_profile, task, task_time_worked, text_search, ts_query, ts_query_kb, ua_app_usage, ua_enforce_log, ua_sp_usage, ua_user_ct_count, ua_user_role_ct, ui_notification_inbox, user_criteria, user_multifactor_auth, vtb_board, vtb_board_member, vtb_card_history, vtb_task, wf_context, wf_element_activity, wf_versionable, wf_workflow_version

Applications

Included By:
Organization [B], Password Reset [B], Password Reset [B], Self-Service [B], Service Desk [B], System Security [B], User Administration [B]

Diagram

Download