“IN Line” Teaching File Database
Ashley Davidoff July 18 2020
Creation of a
Teaching File Database While Dictating
Dictating the word “keywords” placed at the end of a report will act as a searchable phrase to identify cases for the Teaching File Database
What to add after “keywords”
“keywords” is a succinct crystallised version of the aspects of the case that are of interest
“keywords” will follow a format that will include;
structural reference/findings/diagnosis
eg appendix, enlarged, acute appendicitis
-
After the Case is Signed off
-
Performance Bridge
-
identifies the word
“keywords” in the report
-
-
Automatically and in Real Time
-
Extracts and
-
Uploads this case to the
-
-
Teaching File Database in the
-
Secure BMC Server
-
Extracted Data Would Include the Following Fields from Performance Bridge
The Imported Data Would not be Editable
The Radiologist from here has 2 choices
- There may be no need to add anything else to the database since the keywords may serve the purpose
- The Radiologists/Residents want to add some specific issues eg added clinical info, quality control, research possibilities
For ” 2″
The User would be Provided with Editable Fields such as
Diagnosis
Comment
Specialty area
Needs F/U
Path Proven
The Radiologist/Resident would have to go to a secure link to open the Database and would be presented with a form to edit the data
Appearance of the Form to Edit Data
When the student, resident staff , want to search the TF Database they click “Search” and they can search any of the fields
Appearance of the Form to Search Data
We understand that a link from Performance Bridge to PACS is a plan for the future. This will enable us to go from the database back to the study
Search and Link Function
In Summary
-
What We Need
-
Extract in Real Time All Reports that Have the Word
-
“keyword”/”keywords”/”key word”/”key words”
-
-
Export in Real Time after the Report is Signed off
-
to the Secure BMC Performance Bridge Database
-
-
Ability to Edit and Search the Secure TF Database
-
Link from the Secure TF Database Back to PACS
-
Philips response
Mohannad Hussain
Liked the idea – Could only start work in Jan would take about 3 months
The only aspect that would need to be addressed as “new” and not in progress is the
-
Extract in Real Time All Reports that Have the Word
-
“keyword”/”keywords”/”key word”/”key words”
-
Suggested we use “Case Index” Gemma is working to have a button on our PACS work station that would allow us to tag cases
- If we can create new tags eg if Dr Jones wants to be able to retrieve all her cases from the TF could she tag a case with her name and later search for her cases
- Yes ? should be able to do that since you can manually type in tags!
- Can you try and understand why the reports cannot be searched? Do not quite understand that May just be that they do not have that search function available yet
- What do you mean why the reports cannot be searched? Do you mean within Case Indexer?
- When may the link from Case Index to the PACS become available
- Unsure! I don?t anticipate SOON but I will find out.
- Will the link to the Case Index always be available when we are signed into PACS and where will it be located
- Not sure? need to find out when we can integrate first then can dig into these questions.
- I think Dr LeBedis may have used this in the past and lost all her data on one upgrade Do we have a system for backing up this database
- Oh no!! That?s terrible!! If they live in Philips I am sure they have to have a backup but I am not sure. I will ask!!
- Dr Bedi suggested we create a macro for keywords on all our reports Is there any reason we should not start that now? so that by the time we develop the link to the database (which could be the same case index database) we could integrate all the databases into Case File Database
- Are you able to extract the Case File Database into Excel so that we can add Dr Lebedi’s database and then export the integrated db back
- How do we get to a DB development resource in the BU BMC environment
email with Barry Baylosis 7/22
AD
In essence we can start to develop a working slick system right now (Phase 1) by adding a macro to all our reports keywords/structure/findings/diagnosis that is used only in select cases With that intact we can manually search the Philips database (performance bridge) and get all the cases of interest. I suspect that with this simple maneuver we have a start of what we want ie if you want to find the great case of appendicitis to present at 10am that you reported – you search the PB database /keywords/your name/date/appendicitis etc and easy to find and always there for you to search and have even in 5 years time We just cannot add additional info like “great case,” “research” since it appears on the patient report This could be the QI project key would be to have easy access to PB, do some piloting and if it works ,then circulate among all members of the department Perhaps we start with the chest and abdominal imaging group and then to the rest of the department
Phase 2 – real time extraction into an isolated db that resides in Performance Bridge that allows us to add and edit data If we wait for Philips (Jan 2021) If we find a DB developer in house we can start now
Phase 3
Exclude the keywords from the report Perhaps a Nuance request
Then keywords could be more robust eg “research” “consult Dr Jones”