Exercise - Explore the healthcare data model
In this exercise, you'll learn about the core Care Management data tables. To explore the tables in more detail, see Overview of Microsoft Cloud for Healthcare entities.
The healthcare data model uses some out-of-the-box tables from Microsoft Dynamics 365 applications. The following healthcare solutions use the built-in Dynamics 365 tables.
| Healthcare solution | Dynamics 365 tables |
|---|---|
| Care Management | Account, Activities, Contact, Tasks |
| Home Health | Bookings, Incident, Products, Work Order |
| Patient Outreach | Lead/Lead Score, Marketing Emails, Contact, Tasks |
| Patient Service Center | Agent Script, Knowledge Article, Queues, Survey Response |
For more information, see Healthcare data model overview.
Task: Navigate patient detail tables and relationships
In this task, you'll explore the main tables that are related to patient data.
Patient details table definitions
Select each table name to go to the article that provides details about each table.
Patient (Contact) - Person with whom a business unit has a relationship, such as customer, supplier, and colleague.
AllergyIntolerance - Risk of a harmful or an undesirable physiological response that's unique to an individual and associated with exposure to a substance.
Condition - A clinical condition, problem, diagnosis, or other event, situation, issue, or clinical concept that has risen to a level of concern.
MedicationRequest - An order or request for supply of the medication and the instructions for administration of the medication to a patient.
RelatedPerson - Information about a person who is involved in the care of a patient but isn't the target of healthcare or has a formal responsibility in the care process.
Task: Navigate clinical data tables and relationships
In this task, you'll explore the main tables that are related to clinical data.
Clinical data table definitions
Select each table name to go to the article that provides details about each table.
Patient or Practitioner (Contact) - Person with whom a business unit has a relationship, such as customer, supplier, and colleague.
Organization - Top level of the Microsoft Dynamics 365 business hierarchy. The organization can be a specific business, holding company, or corporation.
Location - Details and position information for a physical place where services are provided and resources and participants might be stored, found, contained, or accommodated.
AppointmentEMR - A booking of a healthcare event among patient(s), practitioner(s), related person(s), and/or device(s) for a specific date/time. This event might result in one or more encounter(s).
Procedure - An action that is or was performed on a patient. This action can be a physical intervention (such as an operation) or less invasive (such as counseling).
Encounter - An interaction between a patient and healthcare provider(s) for providing healthcare service(s) or assessing the health status of a patient.
EpisodeOfCare - An association between a patient and an organization/healthcare provider(s) during which time encounters might occur.
Observation - Measurements and simple assertions that are made about a patient, device, or other subject.
CodeableConcept - Represents a value that's supplied by providing a reference to one or more terminologies, but it might also be defined by the provision of text.
Task: Navigate care plan management tables and relationships
In this task, you'll explore the main tables that are related to care plan management.
Care plan management table definitions
Select each table name to go to the article that provides details about each table.
Patient (Contact) - Person with whom a business unit has a relationship, such as customer, supplier, and colleague.
CarePlan - Describes how one or more practitioners intend to deliver care for a particular patient, group, or community for a certain length of time, possibly limited to care for a specific condition.
CarePlanActivity - Identifies a planned action to occur as part of the plan, such as a medication to be used, lab tests to perform, self-monitoring, education, and so on.
CarePlanActivityGoal - Internal reference that identifies the goals that this activity is intended to contribute toward meeting.
Goal - Target objective for a user or a team for a specified time period.
CarePlanGoal - Describes the intended objective(s) of carrying out the care plan.
Encounter - An interaction between a patient and healthcare provider(s) for providing healthcare service(s) or assessing the health status of a patient.
Episode of Care - An association between a patient and an organization/healthcare provider(s) during which time encounters might occur.
