Table Details

Name:
service_offering
Label:
Offering (en)
Created On:
2022.09.17 02:00:42
Created By:
system
Updated On:
2022.09.17 02:00:42
Updated By:
system
Column Updated On:
2022.12.31 15:53:25
Column Updated By:
david.loo
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  aliases
Aliases string 40 Global cmdb_ci_service
  asset
Asset reference 32 Global alm_asset cmdb
+
asset_tag
Asset tag string 80 Global cmdb
  assigned
Assigned glide_date_time 40 Global cmdb
  assigned_to
Assigned to reference 32 Global sys_user cmdb
  assignment_group
Change Group reference 32 Global sys_user_group cmdb
  attestation_score
Attestation Score integer 40 Global cmdb_ci
  attestation_status
Attestation Status string[choice] 40 Global cmdb_ci
  attested
Attested boolean 40 Global cmdb_ci
  attested_by
Attested By reference 32 Global sys_user cmdb_ci
  attested_date
Attested Date glide_date_time 40 Global cmdb_ci
  attributes
Attributes string 65000 Global cmdb_ci
  billing
Billing string[choice] 40 Global service_offering
  business_contact
Business contact reference 32 Global sys_user cmdb_ci_service
  business_need
Business need string 40 Global cmdb_ci_service
  business_relation_manager
Business relation manager reference 32 Global sys_user cmdb_ci_service
  business_unit
Business Unit reference 32 Global business_unit cmdb_ci
  busines_criticality
Business criticality string[choice] 40 Global cmdb_ci_service
  can_print
Can Print boolean 40 Global cmdb_ci
  category
Category string 40 Global cmdb_ci
  change_control
Approval group reference 32 Global sys_user_group cmdb_ci
  checked_in
Checked in glide_date_time 40 Global cmdb
  checked_out
Checked out glide_date_time 40 Global cmdb
  checkout
Checkout string[choice] 40 Global cmdb_ci_service
  comments
Comments string 4000 Global cmdb_ci
  company
Company reference 32 Global core_company cmdb
  compatibility_dependencies
Compatibility dependencies string 40 Global cmdb_ci_service
  consumer_type
Consumer type string[choice] 40 Global cmdb_ci_service
  contract
Contract reference 32 Global ast_contract service_offering
  correlation_id
Correlation ID string 512 Global cmdb_ci
  cost
Cost float 40 Global cmdb
  cost_cc
Cost currency string[choice] 3 Global cmdb
  cost_center
Cost center reference 32 Global cmn_cost_center cmdb
  delivery_date
Order received glide_date_time 40 Global cmdb
  delivery_manager
Delivery manager reference 32 Global sys_user cmdb_ci_service
  department
Department reference 32 Global cmn_department cmdb
  description
Description string 4000 Global service_offering
  discovery_source
Discovery source string[choice] 40 Global cmdb_ci
  dns_domain
DNS Domain string 255 Global cmdb_ci
  due
Due glide_date_time 40 Global cmdb
  due_in
Due in string[choice] 40 Global cmdb
  duplicate_of
Duplicate Of reference 32 Global cmdb_ci cmdb_ci
  end_date
End date glide_date_time 40 Global cmdb_ci_service
  environment
Environment string[choice] 40 Global cmdb_ci
  fault_count
Fault count integer 40 Global cmdb_ci
  first_discovered
First discovered glide_date_time 40 Global cmdb_ci
  fqdn
Fully qualified domain name string 255 Global cmdb_ci
  gl_account
GL account string 40 Global cmdb
  install_date
Installed glide_date_time 40 Global cmdb
  install_status
Install Status integer[choice] 40 Global cmdb
  invoice_number
Invoice number string 40 Global cmdb
  ip_address
IP Address ip_addr 255 Global cmdb_ci
  justification
Justification string[choice] 80 Global cmdb
  last_discovered
Most recent discovery glide_date_time 40 Global cmdb_ci
  last_review_date
Last review date glide_date_time 40 Global cmdb_ci_service
  lease_id
Lease contract string 40 Global cmdb
  life_cycle_stage
Life Cycle Stage reference 40 Global life_cycle_stage cmdb_ci
  life_cycle_stage_status
Life Cycle Stage Status reference 40 Global life_cycle_stage_status cmdb_ci
  location
Location reference 32 Global cmn_location cmdb
  mac_address
MAC Address string 24 Global cmdb_ci
  maintenance_schedule
Maintenance schedule reference 32 Global cmn_schedule cmdb_ci
  managed_by
Managed by reference 32 Global sys_user cmdb
  managed_by_group
Managed By Group reference 32 Global sys_user_group cmdb_ci
  manufacturer
Manufacturer reference 32 Global core_company cmdb
  model_id
Model ID reference 32 Global cmdb_model cmdb
  model_number
Model number string 255 Global cmdb_ci
  monitor
Monitor boolean 40 Global cmdb_ci
  monitoring_requirements
Monitoring requirements string 40 Global cmdb_ci_service
 
D
name
Name string 255 Global cmdb
  number
Number string 40 Global cmdb_ci_service
  operational_status
Operational status integer[choice] 40 Global cmdb_ci
  order
Order string 40 Global service_offering
  order_date
Ordered glide_date_time 40 Global cmdb
  owned_by
Owned by reference 32 Global sys_user cmdb
  parent
Parent reference 32 Global cmdb_ci_service cmdb_ci_service
  portfolio_status
Phase string[choice] 40 Global cmdb_ci_service
  po_number
PO number string 40 Global cmdb
  prerequisites
Prerequisites translated_html 65536 Global cmdb_ci_service
  price
Price price 20 Global service_offering
  price_model
Price model string[choice] 40 Global cmdb_ci_service
  price_unit
Price unit string 40 Global cmdb_ci_service
  published_ref
Published Item reference 32 Global cmdb_ci_service cmdb_ci_service
  purchase_date
Purchased glide_date 40 Global cmdb
  schedule
Schedule reference 32 Global cmn_schedule cmdb_ci
  serial_number
Serial number string 255 Global cmdb
  service_classification
Service classification string[choice] 40 Global cmdb_ci_service
  service_level_requirement
Service level requirement translated_html 8000 Global cmdb_ci_service
  service_owner_delegate
Delegate reference 32 Global sys_user cmdb_ci_service
  service_status
Status string[choice] 40 Global cmdb_ci_service
  short_description
Short Description string 1000 Global cmdb_ci
  skip_sync
Skip sync boolean 40 Global cmdb
  sla
SLA reference 32 Global sla cmdb_ci_service
  spm_service_portfolio
Service portfolio reference 32 Global spm_service_portfolio cmdb_ci_service
  spm_taxonomy_node
Taxonomy node reference 32 Global spm_taxonomy_node cmdb_ci_service
  stakeholders
Stakeholders glide_list 1024 Global sys_user cmdb_ci_service
  start_date
Start date glide_date_time 40 Global cmdb_ci
  state
State string[choice] 40 Global cmdb_ci_service
  subcategory
Subcategory string 40 Global cmdb_ci
  supported_by
Supported by reference 32 Global sys_user cmdb
  support_group
Support group reference 32 Global sys_user_group cmdb
  sys_class_name
Class sys_class_name[choice] 80 Global cmdb
  sys_class_path
Sys class path sys_class_path 255 Global cmdb
  sys_created_by
Created by string 40 Global cmdb
  sys_created_on
Created glide_date_time 40 Global cmdb
  sys_domain
Domain domain_id 32 Global cmdb
  sys_domain_path
Domain Path domain_path 255 Global cmdb
 
K
sys_id
Sys ID GUID 32 Global service_offering
  sys_mod_count
Updates integer 40 Global cmdb
  sys_updated_by
Updated by string 40 Global cmdb
  sys_updated_on
Updated glide_date_time 40 Global cmdb
  technical_contact
Technical contact reference 32 Global sys_user service_offering
  unit_description
Unit description html 4000 Global cmdb_ci_service
  unverified
Requires verification boolean 40 Global cmdb
  used_for
Used for string[choice] 40 Global cmdb_ci_service
  user_group
Users supported reference 32 Global sys_user_group cmdb_ci_service
  vendor
Vendor reference 32 Global core_company cmdb
  version
Version string 40 Global cmdb_ci_service
  warranty_expiration
Warranty expiration glide_date 40 Global cmdb
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Sandiego
asset_tag different different different different different
cmdb_ot_entity missing missing missing missing missing
csat_score missing missing missing missing
csat_survey_frequency missing missing missing missing
csat_survey_last_sent missing missing missing missing
ip_address different
perf_score missing missing missing missing
product_instance_id missing missing missing missing missing
total_subscribers missing missing missing missing
total_vulnerable_items missing missing missing missing missing
vulnerability_risk_score missing missing missing missing missing
show all 11 ...

Referenced

cmdb_ci referenced from table:
alm_asset, alm_entitlement, ast_contract_instance, bsm_chart, bsm_graph, cert_audit_result, change_request_imac, cmdb_alias, cmdb_ci, cmdb_ci_config_file_tracked, cmdb_ci_endpoint_manual, cmdb_ci_end_of_life_ledger, cmdb_ci_fc_port, cmdb_ci_ip_network, cmdb_ci_ip_service, cmdb_ci_lb_interface, cmdb_ci_lb_pool, cmdb_ci_lb_pool_member, cmdb_ci_lb_service, cmdb_ci_lb_vlan, cmdb_ci_memory_module, cmdb_ci_network_adapter, cmdb_ci_os_packages, cmdb_ci_outage, cmdb_ci_patches, cmdb_ci_state_management_task_to_ci, cmdb_ci_storage_device, cmdb_ci_storage_export, cmdb_ci_storage_pool, cmdb_ci_storage_pool_member, cmdb_ci_storage_volume, cmdb_ci_ucs_blade, cmdb_ci_ucs_chassis, cmdb_ci_ucs_rack_unit, cmdb_ci_vpn, cmdb_datasource_last_update, cmdb_data_management_task_to_ci, cmdb_dependent_ci_ledger, cmdb_discovery, cmdb_dynamic_ire_match, cmdb_environment_to_ci, cmdb_group_contains_ci, cmdb_health_result, cmdb_instance_run_history, cmdb_ip_service_ci, cmdb_ire_output_comparison_item, cmdb_key_value, cmdb_m2m_business_process_ci, cmdb_multisource_data, cmdb_outage_ci_mtom, cmdb_peer, cmdb_pid, cmdb_policy_ci_exclusion_list, cmdb_printer_instance, cmdb_print_queue_instance, cmdb_properties, cmdb_related, cmdb_rel_ci, cmdb_rel_group, cmdb_rel_person, cmdb_rel_team, cmdb_resource_location, cmdb_serial_number, cmdb_software_instance, cmdb_subscriber, cmdb_switch_port, cmn_notif_message, conflict, contract_rel_ci, csdm_dashboard_action_report_result, csdm_dashboard_reports_result, csdm_dashboard_type_report_result, diagnostic_event, discovery_active_error, discovery_device_duplicate_ips, discovery_device_history, discovery_log, discovery_log0000, discovery_log0001, discovery_log0002, discovery_log0003, discovery_log0004, discovery_log0005, discovery_log0006, discovery_log0007, dl_u_assignment, dscy_router_interface, dscy_route_interface, dscy_route_next_hop, dscy_switchport, dscy_swtch_fwd_rule, dscy_swtch_partition, dsl, duplicate_audit_result, ecc_event, ecc_event0000, ecc_event0001, ecc_event0002, ecc_event0003, ecc_event0004, ecc_event0005, ecc_event0006, fm_expense_line, itam_ci_usage, itil_agreement_ci, itil_agreement_target_ci, kb_knowledge, m2m_kb_ci, map_cell, ngbsm_view, release_cis, sa_notification, sa_notification0000, sa_notification0001, sa_notification0002, sa_notification0003, sa_notification0004, sa_notification0005, sa_notification0006, sc_req_item, service_availability, service_offering_commitment, sm_ci_field_data, sm_flapper_strategy_data, sn_cmdb_ws_attestation_task_to_ci, statemgmt_cmdb_actions, statemgmt_ops_state, svc_changes, svc_ci_assoc, svc_model_assoc_ci, task, task_ci, task_cmdb_ci_service, unauth_chg_notifications
cmdb_ci_service referenced from table:
cmdb_ci_service, cmdb_convert_bulk_services_entry, cmdb_health_result_service_map, cmdb_health_scorecard_service, conflict, m2m_sp_status_subscription, release_product, sa_hash, sa_m2m_service_entry_point, sc_cat_item_service, service_in_scope, service_out_scope, svc_ci_assoc, svc_rel_assoc, sys_customer_trend, task
service_offering referenced from table:
sc_cat_item_subscribe_mtom, sc_cat_item_subscribe_no_mtom, service_availability, service_offering_commitment, service_subscribe_company, service_subscribe_department, service_subscribe_location, service_subscribe_sys_user, service_subscribe_sys_user_grp, task, task_service_offering

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