Table Details

Name:
problem
Label:
Problem (en)
Created On:
2005.08.10 18:46:13
Created By:
glide.maint
Updated On:
2022.03.18 03:33:32
Updated By:
system
Column Updated On:
2022.12.30 11:42:04
Column Updated By:
admin
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  active
Active boolean 40 Global task
  activity_due
Activity due due_date 40 Global task
  additional_assignee_list
Additional assignee list glide_list 4000 Global sys_user task
  approval
Approval string[choice] 40 Global task
  approval_history
Approval history journal 4000 Global task
  approval_set
Approval set glide_date_time 40 Global task
  assigned_to
Assigned to reference 32 Global sys_user task
  assignment_group
Assignment group reference 32 Global sys_user_group task
  business_duration
Business duration glide_duration 40 Global task
  business_service
Service reference 32 Global cmdb_ci_service task
  calendar_duration
Duration glide_duration 40 Global task
  category
Category choice[choice] 40 Global problem
  cause_notes
Cause notes html 65536 Global problem
  closed_at
Closed glide_date_time 40 Global task
  closed_by
Closed by reference 32 Global sys_user task
  close_notes
Close notes string 4000 Global task
  cmdb_ci
Configuration item reference 32 Global cmdb_ci task
  cmdb_ci_business_app
Business Application reference 32 Application Portfolio Management cmdb_ci_business_app task
  comments
Additional comments journal_input 4000 Global task
  comments_and_work_notes
Comments and Work notes journal_list 4000 Global task
  company
Company reference 32 Global core_company task
  confirmed_at
Confirmed glide_date_time 40 Global problem
  confirmed_by
Confirmed by reference 32 Global sys_user problem
  contact_type
Contact type string[choice] 40 Global task
  contract
Contract reference 32 Global ast_contract task
  correlation_display
Correlation display string 100 Global task
  correlation_id
Correlation ID string 100 Global task
  delivery_plan
Delivery plan reference 32 Global sc_cat_item_delivery_plan task
  delivery_task
Delivery task reference 32 Global sc_cat_item_delivery_task task
  description
Description string 4000 Global task
  due_date
Due date glide_date_time 40 Global task
  duplicate_of
Duplicate of reference 32 Global problem problem
  escalation
Escalation integer[choice] 40 Global task
  expected_start
Expected start glide_date_time 40 Global task
  first_reported_by_task
First reported by reference 32 Global task problem
  fix_at
Fix glide_date_time 40 Global problem
  fix_by
Fix by reference 32 Global sys_user problem
  fix_communicated_at
Fix communicated glide_date_time 40 Global problem
  fix_communicated_by
Fix communicated by reference 32 Global sys_user problem
  fix_notes
Fix notes html 65536 Global problem
  follow_up
Follow up glide_date_time 40 Global task
  group_list
Group list glide_list 4000 Global sys_user_group task
  impact
Impact integer[choice] 40 Global task
  knowledge
Knowledge boolean 40 Global task
  known_error
Known error boolean 40 Global problem
  location
Location reference 32 Global cmn_location task
  made_sla
Made SLA boolean 40 Global task
  major_problem
Major problem boolean 40 Global problem
 
D
number
Number string 40 Global task
  opened_at
Opened glide_date_time 40 Global task
  opened_by
Opened by reference 32 Global sys_user task
  order
Order integer 40 Global task
  parent
Parent reference 32 Global task task
  priority
Priority integer[choice] 40 Global task
  problem_state
Problem state integer[choice] 40 Global problem
  reassignment_count
Reassignment count integer 40 Global task
 
P
rejection_goto
Rejection goto reference 32 Global task task
  Related Incidents integer 40 Global problem
  reopened_at
Last reopened at glide_date_time 40 Global problem
  reopened_by
Last reopened by reference 32 Global sys_user problem
  reopen_count
Reopen count integer 40 Global problem
  resolution_code
Resolution code choice[choice] 40 Global problem
  resolved_at
Resolved glide_date_time 40 Global problem
  resolved_by
Resolved by reference 32 Global sys_user problem
  review_outcome
Major problem review notes string 4000 Global problem
  rfc
Change request reference 32 Global change_request problem
  route_reason
Transfer reason integer[choice] 40 Global task
  service_offering
Service offering reference 32 Global service_offering task
  short_description
Problem statement string[choice] 160 Global task
  sla_due
SLA due due_date 40 Global task
  state
State integer[choice] 40 Global task
  subcategory
Subcategory choice[choice] 40 Global problem
  sys_class_name
Task type sys_class_name[choice] 80 Global task
  sys_created_by
Created by string 40 Global task
  sys_created_on
Created glide_date_time 40 Global task
  sys_domain
Domain domain_id 32 Global task
  sys_domain_path
Domain Path domain_path 255 Global task
 
K
sys_id
Sys ID GUID 32 Global problem
  sys_mod_count
Updates integer 40 Global task
  sys_updated_by
Updated by string 40 Global task
  sys_updated_on
Updated glide_date_time 40 Global task
  task_effective_number
Effective number string 40 Global task
  time_worked
Time worked timer 40 Global task
  universal_request
Universal Request reference 32 Global task task
  upon_approval
Upon approval string[choice] 40 Global task
  upon_reject
Upon reject string[choice] 40 Global task
  urgency
Urgency integer[choice] 40 Global task
  user_input
User input user_input 4000 Global task
 
P
variables
Variables variables 40 Global task
  watch_list
Watch list glide_list 4000 Global sys_user task
 
P
wf_activity
Workflow activity reference 32 Global wf_activity task
  workaround
Workaround html 65536 Global problem
  workaround_applied
Workaround applied boolean 40 Global problem
  workaround_communicated_at
Workaround communicated glide_date_time 40 Global problem
  workaround_communicated_by
Workaround communicated by reference 32 Global sys_user problem
  work_end
Actual end glide_date_time 40 Global task
  work_notes
Work notes journal_input 4000 Global task
  work_notes_list
Work notes list glide_list 4000 Global sys_user task
  work_start
Actual start glide_date_time 40 Global task
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) Tokyo
agile_story missing missing missing missing
cmdb_ci_business_app missing missing missing
skills missing missing missing missing

Referenced

problem referenced from table:
incident, problem, problem_task
task referenced from table:
asmt_assessment_instance, catalog_channel_analytics, cmdb_ci_outage, cmdb_health_result, dmn_demand, ecc_event, ecc_event0000, ecc_event0001, ecc_event0002, ecc_event0003, ecc_event0004, ecc_event0005, ecc_event0006, execution_plan_local, fm_expense_line, goal, interaction_related_record, itil_appointment, kb_knowledge, m2m_kb_task, ml_predictor_results_task, mtg_agenda_item, mtg_attendee, problem, reminder, sc_item_produced_record, sc_item_variables_task, sc_service_fulfillment_stage_data, sc_service_fulfillment_step_data, sla_breakdown_core, sla_repair_log_entry, sla_repair_log_entry0000, sla_repair_log_entry0001, sla_repair_log_entry0002, sla_repair_log_entry0003, sla_repair_log_entry0004, sla_repair_log_entry0005, sla_repair_log_entry0006, sla_repair_log_entry0007, sn_m2m_note_template_for_table, sysapproval_approver, task, task_activity, task_ci, task_cmdb_ci_business_app, task_cmdb_ci_service, task_cost_center, task_group, task_location, task_outage, task_service_offering, task_sla, task_time_worked, vtb_card

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