table - change_request «Change Request»

Derivation Hierarchy

task «Task» Global
\| +—	change_request «Change Request» Global

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

Table Details

Name:: change_request
Label:: Change Request (en)

Created On:: 2022.09.17 02:03:22
Created By:: system

Updated On:: 2022.09.17 02:32:50
Updated By:: system

Column Updated On:: 2022.09.17 02:31:41
Column Updated By:: system

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
	backout_plan	Backout plan	string	4000	Global		change_request
	business_duration	Business duration	glide_duration	40	Global		task
	business_service	Service	reference	32	Global	cmdb_ci_service	task
P	cab_date	CAB date	glide_date	40	Global		change_request
	cab_date_time	CAB date/time	glide_date_time	40	Global		change_request
	cab_delegate	CAB delegate	reference	32	Global	sys_user	change_request
	cab_recommendation	CAB recommendation	string	4000	Global		change_request
	cab_required	CAB required	boolean	40	Global		change_request
	calendar_duration	Duration	glide_duration	40	Global		task
	category	Category	string[choice]	40	Global		change_request
	change_plan	Change plan	string	4000	Global		change_request
	chg_model	Model	reference	32	Global	chg_model	change_request
	closed_at	Closed	glide_date_time	40	Global		task
	closed_by	Closed by	reference	32	Global	sys_user	task
	close_code	Close code	string[choice]	40	Global		change_request
	close_notes	Close notes	string	4000	Global		task
	cmdb_ci	Configuration item	reference	32	Global	cmdb_ci	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
	conflict_last_run	Conflict last run	glide_date_time	40	Global		change_request
	conflict_status	Conflict status	string[choice]	40	Global		change_request
	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
	end_date	Planned end date	glide_date_time	40	Global		change_request
	escalation	Escalation	integer[choice]	40	Global		task
	expected_start	Expected start	glide_date_time	40	Global		task
	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
	implementation_plan	Implementation plan	string	4000	Global		change_request
	justification	Justification	string	4000	Global		change_request
	knowledge	Knowledge	boolean	40	Global		task
	location	Location	reference	32	Global	cmn_location	task
	made_sla	Made SLA	boolean	40	Global		task
D	number	Number	string	40	Global		task
	on_hold	On hold	boolean	40	Global		change_request
	on_hold_reason	On hold reason	string	4000	Global		change_request
	on_hold_task	On Hold Change Tasks	glide_list	4000	Global	change_task	change_request
	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
	outside_maintenance_schedule	Outside maintenance schedule	boolean	40	Global		change_request
	parent	Parent	reference	32	Global	task	task
	phase	Phase	string[choice]	40	Global		change_request
	phase_state	Phase state	string[choice]	40	Global		change_request
	priority	Priority	integer[choice]	40	Global		task
	production_system	Production system	boolean	40	Global		change_request
	reason	Reason	string[choice]	40	Global		change_request
	reassignment_count	Reassignment count	integer	40	Global		task
P	rejection_goto	Rejection goto	reference	32	Global	task	task
	requested_by	Requested by	reference	32	Global	sys_user	change_request
	requested_by_date	Requested by date	glide_date_time	40	Global		change_request
	review_comments	Review comments	string	4000	Global		change_request
	review_date	Review date	glide_date	40	Global		change_request
	review_status	Review status	integer[choice]	40	Global		change_request
	risk	Risk	integer[choice]	40	Global		change_request
	risk_impact_analysis	Risk and impact analysis	string	4000	Global		change_request
	route_reason	Transfer reason	integer[choice]	40	Global		task
	scope	Scope	integer[choice]	40	Global		change_request
	service_offering	Service offering	reference	32	Global	service_offering	task
	short_description	Short description	string[choice]	160	Global		task
	sla_due	SLA due	due_date	40	Global		task
	start_date	Planned start date	glide_date_time	40	Global		change_request
	state	State	integer[choice]	40	Global		task
	std_change_producer_version	Standard Change Template version	reference	32	Global	std_change_producer_version	change_request
	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		change_request
	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
	test_plan	Test plan	string	4000	Global		change_request
	time_worked	Time worked	timer	40	Global		task
	type	Type	string[choice]	40	Global		change_request
	unauthorized	Unauthorized	boolean	40	Global		change_request
	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
	work_end	Actual end date	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 date	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)	Sandiego
agile_story	missing	missing	missing	missing
cab_date				different
cab_date_time				missing
cmdb_ci_business_app	missing	missing	missing
probability	missing	missing	missing	missing
risk_value	missing	missing	missing	missing
skills	missing	missing	missing	missing

Referenced

change_request referenced from table:: change_phase, change_risk_details, change_task, chg_policy_applied, config_automation_object, conflict, incident, problem, release_feature, release_rfcs, std_change_proposal
task referenced from table:: asmt_assessment_instance, catalog_channel_analytics, cmdb_ci_outage, cmdb_health_result, 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, sys_cs_auto_resolution_context, task, 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 change_request «Change Request» / Global (global)

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