topic Building process flow based on database in FlexSim Forum

Building process flow based on database

leah_r — Fri, 28 Jun 2024 14:19:46 GMT

[ FlexSim 23.2.1 ]

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

Re: Building process flow based on database

Jeanette_Fullmer — Fri, 28 Jun 2024 16:09:38 GMT

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.

Re: Building process flow based on database

allister_wilson — Wed, 03 Jul 2024 08:39:43 GMT

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.

Re: Building process flow based on database

clair_augsburgerZGWRZ — Wed, 03 Jul 2024 16:57:55 GMT

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

Re: Building process flow based on database

Jeanette_Fullmer — Fri, 12 Jul 2024 03:01:12 GMT

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.

Re: Building process flow based on database

joerg_vogel_HsH — Fri, 12 Jul 2024 07:20:31 GMT

@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.