Hi.
I just love this site...!
What I don't love is our IT department who decided that the databases I use to extract some statistics no longer need to have the same data form in the only two fields (one from each DB) I use to define my reports.
I work as a system admin on a hospital and the two DBs are one for image data and one for data concerning the booking for these image data.
The workflow is started with someone creating a request that results in a booking in the first DB (RIS database). When the patients get their examinations done images are sent to the second DB (PACS database).
Each exam is identified by a unique(!) accession number. Except that recently this number gets a prefix ('DKRIG') in the second DB.
When we work with CR I know that it's possible to define that we only ned e.g. the last 8 characters from a certain field but do we have the same option when linking the databases?
I just love this site...!
What I don't love is our IT department who decided that the databases I use to extract some statistics no longer need to have the same data form in the only two fields (one from each DB) I use to define my reports.
I work as a system admin on a hospital and the two DBs are one for image data and one for data concerning the booking for these image data.
The workflow is started with someone creating a request that results in a booking in the first DB (RIS database). When the patients get their examinations done images are sent to the second DB (PACS database).
Each exam is identified by a unique(!) accession number. Except that recently this number gets a prefix ('DKRIG') in the second DB.
When we work with CR I know that it's possible to define that we only ned e.g. the last 8 characters from a certain field but do we have the same option when linking the databases?
