table - problem «Problem»

Derivation Hierarchy

task «Task» Global
\| +—	problem «Problem» Global

Subclasses:: No Subclasses
Siblings:: dmn_demand, roster_schedule_span_proposal, sys_report_access_request, release_phase, kb_feedback_task, statemgmt_renew_lease_task, std_change_proposal, help_guidance_task, asset_task, kb_submission, scan_task, cmdb_data_management_task, gsw_task, chat_queue_entry, change_task, alm_transfer_order_line_subtask, reconcile_duplicate_task, problem_task, recommended_field_remediation, sc_request, required_field_remediation, cmdb_multisource_recomp_task, change_phase, upgrade_history_task, change_request, vtb_task, alm_transfer_order_line_task, incident, sn_collab_request_dev_collab_task, ticket, asset_reclamation_request, incident_task, sysapproval_group, sc_req_item, business_app_request, release_task, stale_ci_remediation, service_task, sc_task, orphan_ci_remediation, cert_follow_on_task, sn_deploy_pipeline_deployment_request, reclassification_task

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	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

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	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

Diagram problem «Problem» / Global (global)

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