Building process flow based on database

Question

question

Leah R asked Jun 28, '24 Joerg Vogel commented Jul 12, '24

Building process flow based on database

Hello !

I was wondering if it was possible to automatically build a process flow based on a database using flexsim healthcare.

Let's assume my database looks like this :

Table #1 describes the pathway timestamps. It has 3 columns : patient ID, timestamp type (example : TA = patient enters the service), and time.

Table #2 describes the pathway activities. It has 4 columns : patient ID, activity type (example : AB = prepare patient for surgery), duration, resource (example : HR_AB = OR nurse).

Can I create a patient process in flexsim that allows me to simulate what is described in this table ? This would allow me to have great flexibility in my model as patient process can evolve over time.

This is kind of similar to process mining which allows you to automatically draw processes based on a timestamp database.

Thanks in advance,

Leah

Software Version:

FlexSim 23.2.1

patient flow

1719584007778.png (27.1 KiB)

· 4

Jeanette F ♦♦ commented · Jun 28 at 04:09 PM

Hi @Leah R,

Thank you for contributing to our community! We couldn't identify a maintained license or subscription linked to your account.

You may need to update your profile information to identify yourself as a license owner or their associate. Check out our article for how to ensure you receive timely support. If you update your profile comment back to let us know - we'll adjust the priority of your post accordingly.

If your current license is expired, please contact your local distributor to renew.

0 ·

Clair A Jeanette F ♦♦ commented · Jul 03 at 04:57 PM

Hi @Jeanette F , Leah is using a maintained license from IMT Mines Albi.

0 ·

Jeanette F ♦♦ commented · Jul 12 at 03:01 AM

Hi @Leah R, was Allister Wilson's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 ·

Joerg Vogel commented · Jul 12 at 07:20 AM

@Leah R, so far as I know, there aren’t any ways to add dynamically activities into a process flow. Your logic must be setup to achieve what you want from model start on. But you can dynamically change evaluated data while a model runs, as long as any change is reasonable and events happens in the future of model runtime.

0 ·

Answer 1 · 2024-07-03T08:39:43Z

Allister Wilson answered Jul 3, '24

Hello Leah,

If you can precisely define what a "process step" implies, then you could build a patient flow which :

iterates over the first table, one step at a time
waits until the correct time
reads the second table to determine what must be done
acquires any necessary resources for the step, then releases any resources still held from the previous step if needed
performs the process

I suggest you take a look at the Table class (user manual) if you're unsure how to read information from a table inside a process flow.

question