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:
2022.09.17 02:55:37
Updated By:
system
Column Updated On:
2022.12.31 15:52:32
Column Updated By:
david.loo
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

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

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Sandiego
agent_status missing missing missing missing
average_daily_fte missing missing missing missing
city different different different different different
federated_id missing missing missing missing
geolocation_tracked missing missing missing missing
last_position_update missing missing missing missing
latitude missing missing missing missing
longitude missing missing missing missing
on_schedule missing missing missing missing
roles different
sso_source missing missing missing missing
show all 12 ...

Referenced

sys_user referenced from table:
alm_asset, alm_entitlement, alm_stockroom, alm_transfer_order_line, alm_transfer_order_line_task, alm_user_stockroom, analytics_task, antivirus_activity, appsec_domain_listing, appsec_isc_banner_configuration, appsec_isc_event_configuration, appsec_security_notification_list, asmt_assessment_instance, asmt_assessment_stat, asmt_m2m_category_user, asmt_metric_result, asmt_metric_type, asset_reclamation_request, asset_task, ast_contract, atf_breakpoint, 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, cmdb_ci_business_app, cmdb_ci_hardware, cmdb_ci_service, cmdb_ci_vpn, cmdb_class_user_preference, cmdb_data_management_policy_runtime_attributes, 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, cmn_rota, cmn_rota_esc_step_def, cmn_rota_member, cmn_rota_resp_cache, cmn_schedule_span, cmn_user_schedule, contract_rel_user, core_company, csdm_dashboard_reports_result, cxs_relevant_doc, dl_u_assignment, dsl, expert_instance, fm_expense_line, goal, gsw_change_log, help_user_interaction, help_user_interaction_step, incident, incident_fact_table, interaction, isc_event, isc_export_setting, 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, multi_factor_browser_fingerprint, ngbsm_filter, ngbsm_view, nlq_query_log, nlq_query_log0000, nlq_query_log0001, nlq_query_log0002, nlq_query_log0003, nlq_query_log0004, nlq_query_log0005, nlq_table_guesser_query_log, nlq_table_guesser_query_log0000, nlq_table_guesser_query_log0001, nlq_table_guesser_query_log0002, nlq_table_guesser_query_log0003, nlq_table_guesser_query_log0004, nlq_table_guesser_query_log0005, oauth_credential, oauth_entity, on_call_add_member, on_call_escalation_comm, on_call_escalation_response, on_call_group_preference, on_call_remove_member, on_call_swap_member, on_call_user_preference, open_nlu_predict_state_tracking, par_dashboard_permission, par_dashboard_user_metadata, par_visualization, par_visualization_permission, 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_responsibility, pa_score_notes, pa_targets, pa_text_stop_words, pa_thresholds, pa_xmr_processes, problem, problem_task, process_step_approval, provider_user_map, pwd_email_code, pwd_enrollment, pwd_enrollment_snapshot, pwd_expiration, pwd_history, pwd_reset_request, pwd_sms_code, pwd_user_lockout, quick_links, release_feature, release_product, release_project, reminder, report_executions, roster_schedule_span_proposal, sa_business_service_user_prefs, sc_cart, sc_cart_item, sc_catalog, sc_category_user_mtom, sc_category_user_no_mtom, sc_cat_dt_app_user, sc_cat_item, 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_req_item, sc_service_fulfillment_approval_step, sc_service_fulfillment_task_step, sc_ts_query, security_nonce, service_category_user_role, service_offering, service_subscribe_sys_user, sla, sla_breakdown_by_assignment, sla_repair_log, sla_request, sn_app_eng_studio_project, sn_collab_request_dev_collab_task, sn_deploy_pipeline_deployment_request, sn_devstudio_user_preferences, sn_employee_profile, sn_gf_core_goal, sn_gf_goal_target, sn_gf_strategy, sn_g_app_creator_spreadsheet_file, sn_km_mr_st_kb_knowledge, sn_publications_publication_contact_m2m, sn_publications_recipientslist_user_m2m, sn_publications_recipients_list, sn_publications_workflow_config, sn_table_bldr_wzd_attachment_helper, spm_service_portfolio, spm_taxonomy_node, sp_favorite, sp_log, strategic_objective, st_on_call_hour, svc_security_membership_ops, sysapproval_approver, sysapproval_group, sysauto, sysauto_indicator, sysauto_ms_report_builder, sysauto_query_builder, sysauto_report, sysevent_email_action, sysevent_in_email_action, sysrule_approvals, sysrule_assignment, sys_activity_supplemental, sys_amb_channel_presence, sys_api_stats_requestor, sys_api_stats_requestor_monthly, sys_appcollab_user, sys_app_template_instance, sys_app_template_sharing_m2m, sys_app_template_temp_logo, sys_atf_agent, sys_atf_schedule_run, sys_audit_role, sys_aw_list, sys_breakpoint, sys_broadcast_msg_user_m2m, sys_canvas_preferences, sys_certificate, sys_cs_auto_resolution_configuration, sys_cs_auto_resolution_context, sys_cs_consumer, sys_cs_message, sys_cs_message_notification, sys_email, sys_email_canned_message, sys_email_digest_part_user, sys_email_digest_user_pref, sys_email_draft, sys_filter, sys_flow_data, 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_js_logpoint, sys_mass_encryption_job, sys_mobile_devices, sys_nlu_model_status, sys_notification, sys_notif_subscription, sys_poll, sys_portal_page, sys_push_notif_app_install, sys_push_request, sys_rate_limit_count, sys_rate_limit_rules, sys_rate_limit_violations, sys_report, sys_report_access_request, 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_autocomplete_query_event, sys_search_event, sys_sg_favorite, sys_sg_offline_result, 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_user_unlicensed, sys_ux_route_permission, sys_wss_profile, task, task_time_worked, text_search, transaction_call_chain_register, ts_query, ts_query_kb, ua_approval_usage, ua_app_usage, ua_ct_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, v_ais_result_improvement_rule_condition_builder_values, v_alternate_rotation, v_on_call, v_rotation, v_st_kb_most_viewed, v_user_rotation, wf_context, wf_element_activity, wf_versionable, wf_workflow_version, x_665105_sample_user_type

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out