Jump to content

Archive records and Re-Activate


Recommended Posts

  • Newbies

Hello,

I am new to filemaker and using filemaker advanced pro 18.

 

Im building a database for my patients who are admitted to the hospital.

 

I would like help please with the following:

1) when I discharge the patient, the patient’s data are “archived” and not shown on the report.

 

However, when the patient gets readmitted to the hospital, I would like to:

1) add patient by the hospital chart number

2) if patient is in the archive list, then activate and use the old data but under a new encounter to the hospital.

 

whats the best way of doing this?

 

Thank you for your help,

 

Link to post
Share on other sites
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Probably not the way you are doing it.  I would think you would need a table for Admissions, which is a specific span of time for a specific admission, with Start Date and Discharge Date.

When creating a new Admission, it could be scripted to put the patients name in from existing patients or create a new patient record.  

A portal can show all the related previous records.

Keep in mind, all the patients history is important and may not come just from your hospital admissions.  Procedures and care can come from other hospitals, clinics, urgent cares and doctors offices-all which need to be in a patients history.

 

Link to post
Share on other sites
  • 2 weeks later...
  • Newbies

Thank you Steve,

Quote

Probably not the way you are doing it.  I would think you would need a table for Admissions, which is a specific span of time for a specific admission, with Start Date and Discharge Date.

I have done what you suggested with a table separate for admissions with a date of admission and date of discharge. I attach my relationships.

Quote

When creating a new Admission, it could be scripted to put the patients name in from existing patients or create a new patient record. 

Okay, instead of the patient's name, I am going to use their unique chart number or National ID number to search for the patient and then add as new admission. Exactly as you suggested, I would like everything in their past history to be duplicated but under a new admission, so when I edit the information, It will not affect the information in their old admission encounter.

Any pointers please on how to script this?

Also if you have any suggestions to my relationships, feel free to advise me.

 

Thank you

 

Relationship.PNG

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Who Viewed the Topic

    1 member has viewed this topic:
    Bob Minteer 

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.