ServiceNow

Explore the interactive ERD

Table & Field Reference

change_request

Column	Type	Keys
`sys_id`	String	PK
`cab_delegate`	String	FK
`on_hold_task`	String	FK
`requested_by`	String	FK
`backout_plan`	String
`cab_date`	LocalDate
`cab_date_time`	Instant
`cab_recommendation`	String
`cab_required`	Boolean
`category`	String
`change_plan`	String
`chg_model`	String
`close_code`	String
`conflict_last_run`	Instant
`conflict_status`	String
`end_date`	String
`implementation_plan`	String
`justification`	String
`on_hold`	String
`on_hold_reason`	String
`outside_maintenance_schedule`	Boolean
`phase`	String
`phase_state`	String
`production_system`	Boolean
`reason`	String
`requested_by_date`	Instant
`review_comments`	String
`review_date`	LocalDate
`review_status`	Long
`risk`	Long
`risk_impact_analysis`	String
`scope`	Long
`start_date`	Instant
`std_change_producer_version`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant
`test_plan`	String
`type`	String
`unauthorized`	Boolean

sc_req_item

Column	Type	Keys
`sys_id`	String	PK
`cat_item`	String	FK
`configuration_item`	String	FK
`request`	String	FK
`requested_for`	String	FK
`backordered`	Boolean
`billable`	String
`context`	String
`estimated_delivery`	Instant
`flow_context`	String
`order_guide`	String
`price`	String
`quantity`	Long
`recurring_frequency`	String
`recurring_price`	Double
`sc_catalog`	String
`stage`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

sc_task

Column	Type	Keys
`sys_id`	String	PK
`cat_item`	String	FK
`request`	String	FK
`request_item`	String	FK
`calendar_stc`	Long
`sc_catalog`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

cmn_location

Column	Type	Keys
`sys_id`	String	PK
`company`	String	FK
`contact`	String	FK
`managed_by_group`	String	FK
`parent`	String	FK
`primary_location`	String	FK
`city`	String
`cmn_location_source`	String
`cmn_location_type`	String
`coordinates_retrieved_on`	Instant
`country`	String
`duplicate`	Boolean
`fax_phone`	String
`full_name`	String
`lat_long_error`	String
`latitude`	String
`life_cycle_stage`	String
`life_cycle_stage_status`	String
`longitude`	String
`name`	String
`phone`	String
`phone_territory`	String
`state`	String
`stock_room`	Boolean
`street`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	String
`sys_updated_by`	String
`sys_updated_on`	Instant
`time_zone`	String
`zip`	String

core_company

Column	Type	Keys
`sys_id`	String	PK
`contact`	String	FK
`parent`	String	FK
`vendor_manager`	String	FK
`banner_text`	String
`city`	String
`coordinates_retrieved_on`	Instant
`country`	String
`customer`	Boolean
`discount`	String
`fax_phone`	String
`fiscal_year`	LocalDate
`lat_long_error`	String
`latitude`	String
`longitude`	String
`manufacturer`	Boolean
`market_cap`	Long
`name`	String
`notes`	String
`num_employees`	Long
`phone`	String
`primary`	Boolean
`profits`	String
`publicly_traded`	Boolean
`rank_tier`	String
`revenue_per_year`	Long
`sso_source`	String
`state`	String
`stock_price`	String
`stock_symbol`	String
`street`	String
`sys_class_name`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	Instant
`theme`	String
`vendor`	Boolean
`vendor_type`	String
`website`	String
`zip`	String

sys_user_grmember

Column	Type	Keys
`sys_id`	String	PK
`group`	String	FK
`user`	String	FK
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	String
`sys_updated_by`	String
`sys_updated_on`	Instant

sys_choice

Column	Type	Keys
`sys_id`	String	PK
`dependent`	String
`element`	String
`hint`	String
`inactive`	Boolean
`label`	String
`language`	String
`name`	String
`sequence`	Long
`synonyms`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_domain`	String
`sys_domain_path`	String
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	String
`value`	String

task_sla

Column	Type	Keys
`sys_id`	String	PK
`sla`	String	FK
`task`	String	FK
`active`	Boolean
`business_duration`	Instant
`business_pause_duration`	Instant
`business_percentage`	String
`business_time_left`	Instant
`duration`	Instant
`end_time`	String
`has_breached`	Boolean
`original_breach_time`	Instant
`pause_duration`	Instant
`pause_time`	Instant
`percentage`	String
`planned_end_time`	Instant
`schedule`	String
`stage`	String
`start_time`	Instant
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	Instant
`time_left`	Instant
`timezone`	String

cmn_department

Column	Type	Keys
`sys_id`	String	PK
`company`	String	FK
`dept_head`	String	FK
`parent`	String	FK
`primary_contact`	String	FK
`business_unit`	String
`cost_center`	String
`description`	String
`head_count`	Long
`id`	String
`name`	String
`sys_created_by`	String
`sys_created_on`	String
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	Instant

cmdb_ci_service

Column	Type	Keys
`sys_id`	String	PK
`assigned_to`	String	FK
`assignment_group`	String	FK
`attested_by`	String	FK
`business_contact`	String	FK
`business_relation_manager`	String	FK
`change_control`	String	FK
`company`	String	FK
`delivery_manager`	String	FK
`department`	String	FK
`duplicate_of`	String	FK
`location`	String	FK
`managed_by`	String	FK
`managed_by_group`	String	FK
`manufacturer`	String	FK
`owned_by`	String	FK
`parent`	String	FK
`published_ref`	String	FK
`service_classification`	String	FK
`service_owner_delegate`	String	FK
`stakeholders`	String	FK
`support_group`	String	FK
`supported_by`	String	FK
`user_group`	String	FK
`vendor`	String	FK
`asset`	String
`business_unit`	String
`checkout`	String
`consumer_type`	String
`cost_center`	String
`life_cycle_stage`	String
`life_cycle_stage_status`	String
`maintenance_schedule`	String
`model_id`	String
`name`	String
`operational_status`	Double
`schedule`	String
`sla`	String
`spm_service_portfolio`	String
`spm_taxonomy_node`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

problem

Column	Type	Keys
`sys_id`	String	PK
`related_incidents`	Double	FK
`rfc`	String	FK
`known_error`	String
`problem_state`	Long
`sys_created_on`	Instant
`sys_updated_on`	Instant

incident

Column	Type	Keys
`sys_id`	String	PK
`caller_id`	String	FK
`caused_by`	String	FK
`parent_incident`	String	FK
`problem_id`	String	FK
`reopened_by`	String	FK
`resolved_by`	String	FK
`rfc`	String	FK
`business_impact`	String
`business_stc`	Long
`calendar_stc`	Long
`category`	String
`cause`	String
`child_incidents`	Long
`close_code`	String
`hold_reason`	Long
`incident_state`	Long
`notify`	Long
`origin_id`	String
`origin_table`	String
`reopen_count`	Long
`reopened_time`	Instant
`resolved_at`	Instant
`severity`	Long
`subcategory`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

cmdb_ci

Column	Type	Keys
`sys_id`	String	PK
`assigned_to`	String	FK
`assignment_group`	String	FK
`attested_by`	String	FK
`change_control`	String	FK
`company`	String	FK
`department`	String	FK
`duplicate_of`	String	FK
`location`	String	FK
`managed_by`	String	FK
`managed_by_group`	String	FK
`manufacturer`	String	FK
`owned_by`	String	FK
`support_group`	String	FK
`supported_by`	String	FK
`vendor`	String	FK
`asset`	String
`asset_tag`	String
`assigned`	Instant
`business_unit`	String
`category`	String
`comments`	String
`cost`	String
`cost_cc`	String
`cost_center`	String
`delivery_date`	Instant
`discovery_source`	String
`dns_domain`	String
`first_discovered`	Instant
`gl_account`	String
`install_date`	Instant
`install_status`	Long
`last_discovered`	Instant
`life_cycle_stage`	String
`life_cycle_stage_status`	String
`mac_address`	String
`maintenance_schedule`	String
`model_id`	String
`name`	String
`schedule`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

sc_cat_item

Column	Type	Keys
`sys_id`	String	PK
`group`	String	FK
`location`	String	FK
`owner`	String	FK
`published_ref`	String	FK
`vendor`	String	FK
`access_type`	String
`active`	Boolean
`availability`	String
`billable`	Boolean
`category`	String
`checked_out`	String
`cost`	String
`custom_cart`	String
`delivery_plan`	String
`delivery_time`	Instant
`description`	String
`display_price_property`	String
`flow_designer_flow`	String
`hide_sp`	Boolean
`ignore_price`	Boolean
`list_price`	Double
`mandatory_attachment`	Boolean
`meta`	String
`mobile_hide_price`	Boolean
`mobile_picture_type`	String
`model`	String
`name`	String
`no_cart`	Boolean
`no_order`	Boolean
`ordered_item_link`	String
`sc_catalogs`	String
`sc_ic_item_staging`	String
`sc_template`	String
`short_description`	String
`state`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant
`taxonomy_topic`	String
`template`	String
`type`	String
`workflow`	String

sys_user

Column	Type	Keys
`sys_id`	String	PK
`company`	String	FK
`department`	String	FK
`location`	String	FK
`manager`	String	FK
`sys_domain`	String	FK
`active`	Boolean
`building`	String
`calendar_integration`	Long
`city`	String
`cost_center`	String
`country`	String
`date_format`	String
`default_perspective`	String
`email`	String
`employee_number`	String
`enable_multifactor_authn`	Boolean
`failed_attempts`	Long
`first_name`	String
`internal_integration_user`	Boolean
`last_login_time`	Instant
`last_name`	String
`ldap_server`	String
`locked_out`	Boolean
`middle_name`	String
`name`	String
`notification`	Long
`schedule`	String
`source`	String
`state`	String
`sys_class_name`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	Instant
`time_format`	String
`time_zone`	String
`title`	String
`user_name`	String
`vip`	Boolean
`web_service_access_only`	Boolean

contract_sla

Column	Type	Keys
`sys_id`	String	PK
`sys_overrides`	String	FK
`vendor`	String	FK
`active`	Boolean
`adv_condition_type`	String
`cancel_condition`	String
`collection`	String
`condition_class`	String
`duration`	Instant
`duration_type`	String
`enable_logging`	Boolean
`flow`	String
`name`	String
`pause_condition`	String
`relative_duration_works_on`	String
`reset_action`	String
`reset_condition`	String
`resume_condition`	String
`retroactive`	Boolean
`retroactive_pause`	Boolean
`schedule`	String
`schedule_source`	String
`schedule_source_field`	String
`set_start_to`	String
`start_condition`	String
`stop_condition`	String
`sys_created_on`	Instant
`sys_domain`	String
`sys_domain_path`	String
`sys_updated_on`	Instant
`target`	String
`timezone`	String
`timezone_source`	String
`type`	String
`when_to_cancel`	String
`when_to_resume`	String
`workflow`	String

change_task

Column	Type	Keys
`sys_id`	String	PK
`change_request`	String	FK
`change_task_type`	String
`close_code`	String
`created_from`	String
`on_hold`	Boolean
`on_hold_reason`	String
`planned_end_date`	Instant
`planned_start_date`	Instant
`sys_created_on`	Instant
`sys_updated_on`	Instant

sc_request

Column	Type	Keys
`sys_id`	String	PK
`requested_for`	String	FK
`calendar_stc`	Long
`delivery_address`	String
`parent_interaction`	String
`price`	String
`request_state`	String
`requested_date`	String
`special_instructions`	String
`stage`	String
`sys_created_on`	Instant
`sys_updated_on`	Instant

task

Column	Type	Keys
`sys_id`	String	PK
`additional_assignee_list`	String	FK
`assigned_to`	String	FK
`assignment_group`	String	FK
`business_service`	String	FK
`closed_by`	String	FK
`cmdb_ci`	String	FK
`company`	String	FK
`group_list`	String	FK
`location`	String	FK
`opened_by`	String	FK
`parent`	String	FK
`rejection_goto`	String	FK
`universal_request`	String	FK
`watch_list`	String	FK
`work_notes_list`	String	FK
`active`	Boolean
`approval`	String
`closed_at`	Instant
`contact_type`	String
`contract`	String
`correlation_display`	String
`correlation_id`	String
`delivery_plan`	String
`delivery_task`	String
`description`	String
`follow_up`	Instant
`impact`	Long
`number`	String
`opened_at`	Instant
`priority`	Long
`reassignment_count`	Long
`service_offering`	String
`short_description`	String
`skills`	String
`state`	String
`sys_class_name`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_updated_by`	String
`sys_updated_on`	Instant
`wf_activity`	String

sys_user_group

Column	Type	Keys
`sys_id`	String	PK
`default_assignee`	String	FK
`manager`	String	FK
`parent`	String	FK
`active`	String
`cost_center`	String
`description`	String
`email`	String
`exclude_manager`	Boolean
`include_members`	Boolean
`name`	String
`source`	String
`sys_created_by`	String
`sys_created_on`	Instant
`sys_mod_count`	Long
`sys_updated_by`	String
`sys_updated_on`	Instant
`type`	String