table - change_request «Change Request»

Derivation Hierarchy

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

Subclasses:: change_request_imac
Siblings:: dmn_demand, problem, 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, 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:: change_request
Label:: Change Request (en)

Created On:: 2022.03.18 03:11:31
Created By:: system

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
	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
	cab_date	CAB date	glide_date	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
	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
	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	Vancouver	Uta	Tokyo (Vanilla)	Tokyo
agile_story	missing	missing			missing	missing
cab_date		different	different	different	different	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, 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 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