Skip to main content

Notifications

Customer Service forum

Data model

Posted on by 353

Hi all,

Here is the question,

One dental organization have 20+ clinic located different city. They want to implement Dynamics 365 service engagement to manage patients, appointment, insurance and clinics.

Please kindly tell me how to setup data model?

  • Verified answer
    apa Profile Picture
    apa 8,282 on at
    RE: Data model

    Depending on the goals, I would keep Business Units to a minimum as they are are related to controlling access to data. The more BUs you have, the slower your system will be. The goal should always be to use only 1 BU unless you require very segregated access to data.

    As one option and again depending on you goals, you could compartmentalize people by adding them as Resources and then utilizing Universal Resource Scheduling as a means to move your users/resources, rooms and equipment around. In other words URS also gives you the possibility to resource people on a more granular level after resource scheduling has been done - most likely in a system of its own.

    Hope these ideas help. Remember that there are many ways to approach these things.

  • Verified answer
    Emre GULCAN Profile Picture
    Emre GULCAN 2,379 on at
    RE: Data model

    Hi,

    You can plan your structure like below, and of course you should consider about Security Roles and permissions. Maybe all systemusers can see all patients (contact) data but only edit with Business Unit (department) level.

    CRM Entity Domain Object (client data) Purpose
    Business Unit (Department) Clinics Security
    System User Doctors (dentists) and other stuff like secretary Security
    Contact Patients (clients)
    Account Suppliers and other companies like insurance agency etc.
    Appointment Manage appointments
    Phonecall Manage incoming / outgoing phonecall activity
    Custom entities Manage treatments and other stuff like drug etc.

  • Verified answer
    Mihir@CRM Profile Picture
    Mihir@CRM 4,036 on at
    RE: Data model

    Hi,

    I would create the following entities -

    1. Clinic - custom

    2. Patient - Contact

    3. Dentist - Contact

    4.  Professional employees - Hygienist, Dental assistant... - Contact

    5. Appointments activity (OOTB)

    7. Insurance - custom

    8. Company - Account

    Than start building the relationship and map the business processes.

    You can use the service scheduling feature too.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans