Healthcare and Life Sciences data model

The Healthcare and Life Sciences Service Management Core application provides a data model that is used in the Healthcare and Life Sciences Service Management workflows.

Healthcare and Life Sciences overview

The Healthcare and Life Sciences data model is compatible with the Health Level Seven International (HL7) industry standard including the Fast Healthcare Interoperability Resources (FHIR) standard. The data model applies to all Healthcare and Life Sciences industry solutions including providers, life sciences, and payers. The model includes data tables for organizations, patients, practitioners, insurance, revenue cycle, and clinical data.

The data model uses a combination of tables to store data:

• Tables that are included with the Healthcare and Life Sciences Service Management Core application.
• Tables that are from the Customer Service Management (CSM) application.
• Tables that are from the ServiceNow AI Platform application.
• Tables that are from the Product Catalog Management Core application.

You can install the Healthcare and Life Sciences Service Management Core application to use only its data model for a basic configuration.

Healthcare and Life Sciences data model diagram

The following diagram shows the tables and their relationships that comprise the Healthcare and Life Sciences data model.

Figure 1. Healthcare and Life Sciences data model

Healthcare and Life Sciences Service Management Core tables for the Healthcare and Life Sciences data model

The Healthcare and Life Sciences data model uses the following tables included within the Healthcare and Life Sciences Service Management Core application to store data.

Table 1. Healthcare and Life Sciences Service Management Core application tables

Table	Description
Allergy intolerance [sn_hcls_allergy]	Stores the information about a clinical assessment of an allergy or intolerance; a propensity, or a potential risk to an individual, to have an adverse reaction on future exposure to the specified substance, or class of substance.
Appointment [sn_hcls_appointment]	Stores the appointment booking details for a patient in your healthcare organization.
Appointment participant [sn_hcls_appointment_participant]	Stores the participant details of an appointment.
Attribute [sn_hcls_characteristic_attribute]	Stores the characteristics options associated with a program or program service selected by a patient when submitting a healthcare request.
Book appointment [sn_hcls_book_appt_task]	Stores the task details for booking an appointment associated with a healthcare case or its extended case types.
Claim diagnosis [sn_hcls_claim_diagnosis]	Stores diagnosis information for claims.
Claim header [sn_hcls_claim_header]	Stores the details of the main claim submitted on behalf of a patient to a payer organization.
Claim line [sn_hcls_claim_line]	Stores the details of the items pertaining to a claim header.
Medical device install base item [sn_hcls_medical_device_install_base_item]	Stores the details of medical devices as install base items.
Condition [sn_hcls_condition]	Stores the information about a condition, problem, diagnosis, or other event, situation, issue, or clinical concept that has risen to a level of concern.
Dosage definition [sn_hcls_dosage_definition]	Models the Dosage specification [sn_hcls_dosage_specification] table for use as a request definition parameter.
Dosage specification [sn_hcls_dosage_specification]	Stores the information about medication product dosage associated with a program.
Dosage variable [sn_hcls_dosage_variable]	Stores the variables configured for a dosage specification displayed on the Medication Prescription form of a Healthcare and Life Sciences Service Management application.
Encounter [sn_hcls_encounter]	Stores the information about an interaction between a patient and healthcare providers for providing healthcare services or assessing the health status of a patient.
Enrolled Program [sn_hcls_enrolled_program]	Stores the programs that a patient has been enrolled into
Enrolled Program Service [sn_hcls_enrolled_program_service]	Stores the program services provided to a patient as part of a program enrollment process.
Healthcare case [sn_hcls_case]	Stores healthcare-related cases. Note: The Healthcare case [sn_hcls_case] table is an abstract table and is extendable.
Healthcare code set [sn_hcls_code_set]	Stores the details of code sets available in your ServiceNow instance.
Healthcare location [sn_hcls_location]	Stores details of the location associated with your healthcare organization.
Healthcare organization [sn_hcls_organization]	Stores the details of a healthcare organization in your ServiceNow instance.
Healthcare Task [sn_hcls_task]	Stores the details of the task associated with a healthcare case or a patient in your healthcare organization. Note: The Healthcare Task [sn_hcls_task] is an abstract table and is extendable.
Immunization [sn_hcls_immunization]	Stores the information about an event of a patient being administered a vaccine or a record of an immunization as reported by a patient, a clinician, or another party.
Medication [sn_hcls_medication]	Stores the information about a medication for the purposes of prescribing, dispensing, and administering a medication as well as for making statements about medication use.
Medication Prescription [sn_hcls_medication_prescription]	Stores the information about prescriptions ordered for a patient.
Member Plan [sn_hcls_member_plan]	Stores the details of a health insurance plan associated with a patient.
Observation [sn_hcls_observation]	Stores the information about measurements and simple assertions made about a patient.
Patient [sn_hcls_patient]	Stores the details of a patient in your healthcare organization.
Policy [sn_hcls_policy]	Stores the details of a policy shared with patients in the Healthcare and Life Sciences applications.
Policy consent [sn_hcls_policy_consent]	Stores the details of a consent accepted by a patient or a household member on behalf of the patient.
Practitioner [sn_hcls_practitioner]	Stores the details of a practitioner in your healthcare organization.
Practitioner location [sn_hcls_practitioner_facility]	Stores the details of the location at which a practitioner provides healthcare services.
Practitioner location specialty [sn_hcls_pract_location_specialty]	Stores the details about types of services that a practitioner can provide for an organization at a specific location.
Practitioner specialty [sn_hcls_practitioner_specialty]	Stores the association details of a specialty with a practitioner.
Pre-authorization diagnosis [sn_hcls_pre_auth_diagnosis]	Stores diagnosis information pertaining to a pre-authorization for healthcare services.
Pre-authorization item [sn_hcls_pre_auth_item]	Stores the details of items pertaining to a pre-authorization request for healthcare services.
Pre-authorization request [sn_hcls_pre_auth_header]	Stores the authorization request details for a healthcare service provided by a payer organization.
Procedure [sn_hcls_procedure]	Stores the information about an action that is or was performed on or for a patient. An action can be a physical intervention like an operation, or less invasive like long-term services, counseling, or hypnotherapy.
Program [sn_hcls_program]	Stores the programs offered by healthcare organizations.
Program relationship [sn_hcls_program_relationship]	Stores the association details between a program and program service.
Program service [sn_hcls_program_service]	Stores the program services associated with a program.
Source system [sn_hcls_source_system]	Stores the source and destination IDs of an external healthcare system in your ServiceNow instance.
Update insurance information [sn_hcls_insurance_info_task]	Stores the task details for updating the insurance information of a patient in your healthcare organization.

ServiceNow AI Platform, Customer Service Management (CSM), and Product Catalog Management Core tables for the Healthcare and Life Sciences data model

The Healthcare and Life Sciences data model uses the following tables included within the ServiceNow AI Platform, Customer Service Management (CSM), and Product Catalog Management Core applications to store data.

Table 2. ServiceNow AI Platform, CSM, and Product Catalog Management Core tables used in the Healthcare and Life Sciences data model

Table	Description	Application
Business location [sn_csm_business_location]	Provides the business location records.	CSM
Case [sn_customerservice_case]	Provides the cases for patients associated with customer contact records.	CSM
Characteristic [sn_prd_pm_characteristic]	Provides the attributes available for a product.	Product Catalog Management Core
Characteristic Option [sn_prd_pm_characteristic_option]	Provides the options for attributes available for a product.	Product Catalog Management Core
Consumer [csm_consumer]	Provides patient records associated with consumer records.	CSM
Consumer profile [sn_csm_consumer_profile]	Provides multiple consumer profiles.	CSM
Document template [sn_doc_template]	Provides document templates to generate standard letters or documents.	ServiceNow AI Platform
Household Member [csm_household_member]	Provides records of the patient members who have been added to a household.	CSM
Install Base Item [sn_install_base_item]	Provides the products installed or in use by an account or a customer.	CSM
Location [cmn_location]	Provides addresses associated with a patient.	ServiceNow AI Platform
Medical insurance model [sn_ent_medical_insurance_model]	Classifies medical insurance models, including health insurance plans and government insurance programs such as Medicare or Medicaid.	Expanded Model and Asset Classes Store
Product Specification [sn_prd_pm_specification]	Defines, at a functional level, a product a service provider sells to the customer.	Product Catalog Management Core
Request Definition [sn_ind_request_definition]	Associates a task type and a workflow with a request data table.	ServiceNow AI Platform
Service organization [sn_customer_service_organization]	Provides records for service organizations, including business locations and internal business locations.	CSM
Sold product [sn_install_base_sold_product]	Provides the product purchased by a patient as a customer and references the Product Model [cmdb_model] table or Service Model [cmdb_service_product_model] table for a customer (customer account or consumer).	ServiceNow AI Platform
Specification [sn_prd_pm_specification]	Provides the base table for specifications included in the industry vertical applications.	Product Catalog Management Core
Specification Characteristic [sn_prd_pm_specification_characteristic]	Provides the characteristics for product, service, and resource specifications.	Product Catalog Management Core
Specification Relationship [sn_prd_pm_specification_relationship]	Provides the association between the product, service, and resource specifications and how a product offering is decomposed, fulfilled, and delivered after a customer order is received.	Product Catalog Management Core
Task [task]	Provides a series of standard fields used on each of the tables that extend it.	ServiceNow AI Platform
Variables [var_dictionary]	Defines dynamic variables for a model used in an application form.	ServiceNow AI Platform

Note:

To learn about ServiceNow AI Platform, CSM, and Product Catalog Management Core tables, see Industry data model tables, and Tables installed with Customer Service Management.