Use Case:
Participants and the pathology reports are stored in an external database. When user will be adding specimens into OpenSpecimen, the participants/visits will be searched within the OpenSpecimen database and if no match is found then in the external database.
If the match is found in the external database, the participant is registered in OpenSpecimen and the user then adds the samples collected.
For searching the participants, MRN/EMPI can be used and for visits 'Visit name' or 'Accession Number'The below-mentioned code block is to setup the visit lookup step. For the visits 'Visit name' or 'Accession Number' can be used.
| Info |
|---|
Below is the section from the code block which is configurable.
Example: In the below code 'Visit Name' renamed to 'Bank Number' (Refer to the first screenshot)
Example: In the below code block, the Visit Name, Visit Date, and Surgical Pathology Number are added. (Refer to the second screenshot)
|
| Note |
|---|
Configure the below code block in JSON workflow in the new section "visitsLookup". |
Example: In the below code block, the search visit table is sorted in descending order of the visit date.
| Code Block | ||
|---|---|---|
| ||
{
"name": "visitsLookup",
"data": {
"enable": true,
/* matchTableOpts is used to sort the matching visit based on Visit date*/
"matchTableOpts": {
"sortAttr": "visit.visitDate",
"sortDirection": "desc"
},
"matchTable": [
{
"name": "visit.name",
"baseField": "visit.name",
"caption": "Bank Number"
},
{
"name": "visit.visitDate",
"baseField": "visit.visitDate"
},
{
"name": "visit.surgicalPathologyNumber",
"baseField": "visit.surgicalPathologyNumber",
"caption": "Accession Number"
}
],
"searchAttrs": [
{
"attr": "EMPI_MRN",
"caption": "MRN"
},
{
"attr": "VISIT_NAME",
"caption": "Bank Number"
},
{
"attr": "SPR_NO",
"caption": "Accession Number"
}
]
}
} |
On setting up the above JSON for the CP, a new button on the participant list page will appear 'Search Visits'
On clicking 'Search Visits', user will be navigated to a page where participants/visits can be searched across OpenSpecimen and external database(configured)
On searching for a participant that has 2 visits addedThe configured fields will be displayed on the search visits page
On searching by MRN, OpenSpecimen will fetch both the visits in the results table. User You can then select from these visits and add specimens to them. The fields added in the 'matchTable' section will be displayed as the columns in the results table.
