# ServiceNow schema ERD

Table and field reference for the Fivetran ServiceNow connector.

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

## Relationships

- change_request(cab_delegate) → sys_user(sys_id)
- change_request(on_hold_task) → change_task(sys_id)
- change_request(requested_by) → sys_user(sys_id)
- sc_req_item(cat_item) → sc_cat_item(sys_id)
- sc_req_item(configuration_item) → cmdb_ci(sys_id)
- sc_req_item(request) → sc_request(sys_id)
- sc_req_item(requested_for) → sys_user(sys_id)
- sc_task(cat_item) → sc_cat_item(sys_id)
- sc_task(request_item) → sc_req_item(sys_id)
- sc_task(request) → sc_request(sys_id)
- cmn_location(company) → core_company(sys_id)
- cmn_location(contact) → sys_user(sys_id)
- cmn_location(managed_by_group) → sys_user_group(sys_id)
- cmn_location(parent) → cmn_location(sys_id)
- cmn_location(primary_location) → cmn_location(sys_id)
- core_company(contact) → sys_user(sys_id)
- core_company(parent) → core_company(sys_id)
- core_company(vendor_manager) → sys_user(sys_id)
- sys_user_grmember(group) → sys_user_group(sys_id)
- sys_user_grmember(user) → sys_user(sys_id)
- task_sla(sla) → contract_sla(sys_id)
- task_sla(task) → task(sys_id)
- cmn_department(company) → core_company(sys_id)
- cmn_department(dept_head) → sys_user(sys_id)
- cmn_department(parent) → cmn_department(sys_id)
- cmn_department(primary_contact) → sys_user(sys_id)
- cmdb_ci_service(assigned_to) → sys_user(sys_id)
- cmdb_ci_service(assignment_group) → sys_user_group(sys_id)
- cmdb_ci_service(attested_by) → sys_user(sys_id)
- cmdb_ci_service(business_contact) → sys_user(sys_id)
- cmdb_ci_service(business_relation_manager) → sys_user(sys_id)
- cmdb_ci_service(change_control) → sys_user_group(sys_id)
- cmdb_ci_service(company) → core_company(sys_id)
- cmdb_ci_service(delivery_manager) → sys_user(sys_id)
- cmdb_ci_service(department) → cmn_department(sys_id)
- cmdb_ci_service(duplicate_of) → cmdb_ci(sys_id)
- cmdb_ci_service(location) → cmn_location(sys_id)
- cmdb_ci_service(managed_by_group) → sys_user_group(sys_id)
- cmdb_ci_service(managed_by) → sys_user(sys_id)
- cmdb_ci_service(manufacturer) → core_company(sys_id)
- cmdb_ci_service(owned_by) → sys_user(sys_id)
- cmdb_ci_service(parent) → cmdb_ci_service(sys_id)
- cmdb_ci_service(published_ref) → cmdb_ci_service(sys_id)
- cmdb_ci_service(service_classification) → sys_choice(sys_id)
- cmdb_ci_service(service_owner_delegate) → sys_user(sys_id)
- cmdb_ci_service(stakeholders) → sys_user(sys_id)
- cmdb_ci_service(support_group) → sys_user_group(sys_id)
- cmdb_ci_service(supported_by) → sys_user(sys_id)
- cmdb_ci_service(user_group) → sys_user_group(sys_id)
- cmdb_ci_service(vendor) → core_company(sys_id)
- problem(related_incidents) → incident(sys_id)
- problem(rfc) → change_request(sys_id)
- incident(caller_id) → sys_user(sys_id)
- incident(caused_by) → change_request(sys_id)
- incident(parent_incident) → incident(sys_id)
- incident(problem_id) → problem(sys_id)
- incident(reopened_by) → sys_user(sys_id)
- incident(resolved_by) → sys_user(sys_id)
- incident(rfc) → change_request(sys_id)
- cmdb_ci(assigned_to) → sys_user(sys_id)
- cmdb_ci(assignment_group) → sys_user_group(sys_id)
- cmdb_ci(attested_by) → sys_user(sys_id)
- cmdb_ci(change_control) → sys_user_group(sys_id)
- cmdb_ci(company) → core_company(sys_id)
- cmdb_ci(department) → cmn_department(sys_id)
- cmdb_ci(duplicate_of) → cmdb_ci(sys_id)
- cmdb_ci(location) → cmn_location(sys_id)
- cmdb_ci(managed_by_group) → sys_user_group(sys_id)
- cmdb_ci(managed_by) → sys_user(sys_id)
- cmdb_ci(manufacturer) → core_company(sys_id)
- cmdb_ci(owned_by) → sys_user(sys_id)
- cmdb_ci(support_group) → sys_user_group(sys_id)
- cmdb_ci(supported_by) → sys_user(sys_id)
- cmdb_ci(vendor) → core_company(sys_id)
- sc_cat_item(group) → sys_user_group(sys_id)
- sc_cat_item(location) → cmn_location(sys_id)
- sc_cat_item(owner) → sys_user(sys_id)
- sc_cat_item(published_ref) → sc_cat_item(sys_id)
- sc_cat_item(vendor) → core_company(sys_id)
- sys_user(company) → core_company(sys_id)
- sys_user(department) → cmn_department(sys_id)
- sys_user(location) → cmn_location(sys_id)
- sys_user(manager) → sys_user(sys_id)
- sys_user(sys_domain) → sys_user_group(sys_id)
- contract_sla(sys_overrides) → contract_sla(sys_id)
- contract_sla(vendor) → core_company(sys_id)
- change_task(change_request) → change_request(sys_id)
- sc_request(requested_for) → sys_user(sys_id)
- task(additional_assignee_list) → sys_user(sys_id)
- task(assigned_to) → sys_user(sys_id)
- task(assignment_group) → sys_user_group(sys_id)
- task(business_service) → cmdb_ci_service(sys_id)
- task(closed_by) → sys_user(sys_id)
- task(cmdb_ci) → cmdb_ci(sys_id)
- task(company) → core_company(sys_id)
- task(group_list) → sys_user_group(sys_id)
- task(location) → cmn_location(sys_id)
- task(opened_by) → sys_user(sys_id)
- task(parent) → task(sys_id)
- task(rejection_goto) → task(sys_id)
- task(universal_request) → task(sys_id)
- task(watch_list) → sys_user(sys_id)
- task(work_notes_list) → sys_user(sys_id)
- sys_user_group(default_assignee) → sys_user(sys_id)
- sys_user_group(manager) → sys_user(sys_id)
- sys_user_group(parent) → sys_user_group(sys_id)