Radiant/Cupid Flashcards
Can an order be scheduled to an appointment as well as a case?
No. It will be scheduled to one or the other.
What contact is created when an order is scheduled using the non-invasive procedure scheduling method?
Appointment contact
Scheduling an invasive procedure creates…?
A Case
T/F: More information relevant to the imaging applications comes from the appt contact than the ordering contact.
False
Why might an order, procedure log, or external procedure have multiple lines in PAT_LIFEDOSE_HX?
A user modified a previously documented radiation exposure.
PAT_ENC and PAT_ENC_APPT both have fields that hold provider and department. What is the difference between them?
PAT_ENC_APPT holds ALL the providers involved in an encounter. PAT_ENC only the first.
What table joins orders to the appointment?
ORD_APPT_SRL_NUM
Appointments are scheduled at the department level. What level are Cases scheduled at?
Location (CLARITY_LOC)
In the non-invasive data model, the order (procedure) is typically more granular than the appointment (visit type). T/F: In the invasive data model, the order (procedure) is typically less granular than the case’s procedure (surgical procedure).
True
T/F: Cases are the request for an invasive procedure to be performed and are always created prior to the log.
True
T/F: Logs are more closely aligned with what was actually performed because it is created and filled out during or shortly after the procedure.
True
T/F: There is a one to one relationship between cases and logs. There will always be a log with a case.
False. There is a one to one relationship however, a case can be scheduled and not have a log yet or canceled.
T/F: Intra-procedure documentation lives on the case.
False. Intra-procedure documentation lives on the log. The case is comprised mostly of what is scheduled to take place.
Case records correspond with two distinct patient encounter records. What are they?
Surgery encounter and Hospital encounter (admission)
7 - Reading and Resulting
T/F: The newest contact is always the record with the highest *DATE_REAL value per record ID.
True
ORDER_STATUS holds all order contacts including any addenda.
False. See ORDER_RAD_ADDEND for those note IDs.
To see the narratives and impressions combined you will make two joins. ORDER_STATUS . PROCEDURE_NOTE_ID to HNO_NOTE_TEXT. NOTE ID and ORDER_STATUS.PROC_NOTE_DATE_REAL to…
HNO_NOTE_TEXT . CONTACT_DATE_REAL
Interface-created results might not set note id and date real on the ORDER_STATUS table, in that case what two tables will you need to use?
ORDER_NARRATIVE and ORDER_IMPRESSION
If text from the previous contact is important which combination of tables would you use ORDER_STATUS/HNO_NOTE_TEXT or ORDER_NARRATIVE/ORDER_IMPRESSION ?
ORDER_STATUS and HNO_NOTE_TEXT
NARRATIVE and IMPRESSION only have the last contact text.
If any component of a result is abnormal ORDER_PROC . ABNORMAL_YN will have a Y.
True
A study can cover multiple orders (MOPS).
True
‘Biopsy’ in Radiant refers to the image guided extraction of a tissue sample from the breast.
true
Mammography involves three types of procedures in the workflow. What are they?
A screening, a diagnostic, and a biopsy
End users do not directly set the mammography outcome.
true
Name a type of question that does not produce a question answer record.
Order specific questions
If an end exam questionnaire contains a networked type question that collects a user record, how would you go about joining from CL_QANSWER_QA record to CLARITY_EMP?
Determine if CLARITY_EMP . USER_ID was varchar or numeric (it is varchar). Then connect CL_QANSWER_QA . VARCHAR_ANSWER to CLARITY_EMP . USER_ID
What determines whether a begin exam questionnaire files its answers to RIS_BGN_PROC_ANS vs. RIS_BPROC_V_QNRS?
Procedure or procedure category level questionnaires file to RIS_BGN_PROC_ANS where visit type questionnaire responses file to RIS_BPROC_V_QNRS.
Name two different ways to differentiate between the recommendations and pathology results held in ORDER_RES.
Connect ORDER_PROC . ORDER_PROC_ID to ORDER_RAD_REC_ID or ORDER_RAD_PATH_RES respectively then to ORDER_RES (results).
Filter on ORDER_RES . RESULT_TYPE_C (52011 = RIS Recommendations and 52012 = Pathology results)
Do extra steps need to be taken by a report writer to have the count of assessments or outcomes be one per order as opposed to one per MOPS (Multiple Orders per Study) group?
No, assessments and outcomes are automatically propagated to each order record by the application. (ORDER_PROC_3 . MAMMO_OUTCOME_C and LAST_OVERALL_ASMT_C)
Explain the complication with coming up with a cancer detection rate figure on a report.
It requires looking at multiple orders per patient. 1st check whether any other order for that same patient has a malignant pathology attached to it AND whether the pathology was resulted within 365 days of the original order. F_RIS_MAMMO . IS_CANCER_PAT_YN or V_RIS_PATHOLOGY linked to ORDER_PROC and ORDER_RES through PAT_ID (if they want details of those orders/procedures)
Wat are the two unique configurations to the cardiovascular palette?
Echo and Cath. Where the cardiologist would document many measurements and findings collected during the procedure which has already been completed.
Each time a provider opens the echo or cath palettes, they are working with a single order record.
True
What are two main types of information collected using the Cath and Echo Palettes?
measurements and findings
What context are palette SmartData elements stored in?
Only records of type ‘RESULT’ are relevant.