RAD_OPS_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Operations Exception
Definition: This table contains entries for reports that have not been successfully updated upon signout.
Table Type: ACTIVITY





Column Detail - RAD_OPS_EXCEPTION


Column Name Type Null? Definition
EVENT_ID DOUBLE N This table contains the key to the clinical event table. It identifies the report.
FINAL_DT_TM DATETIME Y This column contains the date and time that the report was signed out.
RAD_REPORT_ID DOUBLE N This column contains the foreign key to the rad_report table. It uniquely defines the report that did not process successfully.
SEVERITY_CD_OCF DOUBLE Y This column contains the severity code returned from the event server if an error occurred.
STATUS_CD_OCF DOUBLE Y This column contains the Status_cd returned by the clinical event server if an error has occurred.
STATUS_TEXT VARCHAR(255) Y This column contains the status message returned from the clinical event server if an error has occurred.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - RAD_OPS_EXCEPTION


Child Column in RAD_OPS_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID


RAD_PEER_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Peer Review
Definition: Stores Radiology peer reviews done on radiology reports.
Table Type: ACTIVITY





Column Detail - RAD_PEER_REVIEW


Column Name Type Null? Definition
ARBITER_COMMENT_TXT VARCHAR(1000) Y Comments entered at the time of the discrepancy review.
ARBITER_DT_NBR DOUBLE N Arbitrated date number used for calculation of other time related dimensions and filters.
ARBITER_DT_TM DATETIME Y Last date and time the discrepancy review was updated.
ARBITER_ID DOUBLE N The last individual that reviewed this peer review in the discrepancy queue.
ARBITER_MIN_NBR DOUBLE N Arbitrated minute number used for calculation of other time related dimensions and filters.
ARBITER_TZ DOUBLE N Time zone associated with ARBITER_DT_TM.
RAD_PEER_REVIEW_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_PEER_REVIEW table.
RAD_REPORT_ID DOUBLE N The report that is being reviewed.
RESOLVED_IND DOUBLE N Indicates if this peer review has been resolved. If so, no further evaluation or arbitration is necessary.
REVIEWER_ID DOUBLE N The individual who performed the peer review.
REVIEW_CLASS_CD DOUBLE N Summarizes the review. A value assigned to a review to describe an overall opinion as to whether the review is positive, neutral, or negative.
REVIEW_COMMENT_TXT VARCHAR(1000) Y Comments entered for the peer review.
REVIEW_DT_NBR DOUBLE N Reviewed date number used for calculation of other time related dimensions and filters.
REVIEW_DT_TM DATETIME N Date and time at which the peer review was last updated.
REVIEW_MIN_NBR DOUBLE N Reviewed minute number used for calculation of other time related dimensions and filters.
REVIEW_PRSNL_TYPE_FLAG DOUBLE N The type of personnel that was selected for the review.
REVIEW_TZ DOUBLE N Time zone associated with REVIEW_DT_TM.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - RAD_PEER_REVIEW


Child Column in RAD_PEER_REVIEW(FK) Parent Table Name Parent Column Name
Parents: ARBITER_ID PRSNL PERSON_ID
REVIEWER_ID PRSNL PERSON_ID
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID


RAD_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Report
Definition: The Rad_Report table contains general information about a radiology report.
Table Type: ACTIVITY





Column Detail - RAD_REPORT


Column Name Type Null? Definition
ADDENDUM_IND DOUBLE Y The Addendum_Ind field indicates if this row represents an addendum to a report.
BATCH_SIGN_IND DOUBLE Y This indicator will be set to 1 if the report was signed out in batch by the radiologist.
CHARGES_SENT_IND DOUBLE N This column indicates if professional charges have been sent for a given radiology report.
CLASSIFICATION_CD DOUBLE N the Classification_Cd is used for procedure classification.
DICTATED_BY_ID DOUBLE N The Dictated_By_Id indicates the radiologist/resident that dictated the report.
DICTATED_DT_TM DATETIME Y The Dictated_Dt_tm captures the date and time that the report was dictated.
DICTATED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DICTATION_SECONDS DOUBLE N This field contains the length in seconds of the voice dictation associated with the Radiology report.
FINAL_DT_TM DATETIME Y The final_dt_tm contains the date and time that the report was finalized or signed out.
FINAL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
MODIFIED_IND DOUBLE Y The Modified_Ind indicates whether or not the canned normal report has been modified or not.
NO_PROXY_IND DOUBLE Y The No_Proxy_Ind indicates if the radiologist/resident will allow this specific case to be proxied or not.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. It identifies the master order for the report.
ORIGINAL_TRANS_DT_TM DATETIME Y The Original_Trans_Dt_Tm captures the date and time that the report was first transcribed.
ORIGINAL_TRANS_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PERF_LOC_CD DOUBLE N The location where the report was created.
POSTED_FINAL_DT_TM DATETIME Y This column contains the date/time that the report was updated to authenticated on the clinical_event table.
POSTED_FINAL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PREV_OWNER_ID DOUBLE N The Prev_Owner_Id identifies who the report was queued to last.
RAD_REPORT_ID DOUBLE N The Rad_Report_Id uniquely identifies a row in the Rad_Report table. It serves no other purpose other than to uniquely identify the row.
RAD_RPT_REFERENCE_NBR VARCHAR(40) Y The Rad_Rpt_Reference_Nbr serves as a tie to the clinical event row that represents the report.
REDICTATE_IND DOUBLE Y The Re-dictate_Ind indicates if the report has been re-dictated or not.
REPORTING_PRIORITY_CD DOUBLE N No longer used. Moved to Order_radiology table.
REPORT_CREATION_MTHD_CD DOUBLE N Describes the method in which the report was originally created.
REPORT_EVENT_ID DOUBLE N The Report_Event_Id is a foreign key to the Clinical_Event table. It identifies the report that isstored in the repository.
RES_MARKUP_QUEUE_READ_IND DOUBLE N The res_markup _queue_read_ind indicates if the report is currently in the resident's final markup queue. A value of zero indicates that the report is currently in the resident's final markup queue and a value of 1 means that the report is marked as read.
RES_QUEUE_IND DOUBLE Y the Res_Queue_Ind indicates if the report is currently queued to a resident.
RES_SIGN_REJECT_MARK_FLAG DOUBLE Y The Res_Sign_Reject_Mark_Flag indicates whether or not the resident has marked the report for rejection or signout.
RET_TO_RES_DT_TM DATETIME Y This column contains the date/time that the report was returned to a resident.
SCD_STORY_ID DOUBLE N When a report is a structured report, this is the activity data that will be contained in the report.
SEQUENCE DOUBLE Y The Sequence identifies the order that the addendums, if any, are in.
SIGN_REJECT_MARK_FLAG DOUBLE Y The Sign_Reject_Mark_Flag indicates whether or not the radiologist/cosigner has marked the report for rejection or signout.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VOICE_DEL_ATMT_DT_TM DATETIME Y The field stores the first time that an attempt was made to delete the voice file. Field is null if the report is not a DD or VR report.
VOICE_DEL_SUCC_DT_TM DATETIME Y The field stores the date and time when the voice file was successfully deleted from the server. Field is null if the report is not a DD or VR report.



Relationship Detail - RAD_REPORT


Child Column in RAD_REPORT(FK) Parent Table Name Parent Column Name
Parents: PERF_LOC_CD LOCATION LOCATION_CD
ORDER_ID ORDER_RADIOLOGY ORDER_ID
DICTATED_BY_ID PRSNL PERSON_ID
PREV_OWNER_ID PRSNL PERSON_ID
SCD_STORY_ID SCD_STORY SCD_STORY_ID




Parent Column in RAD_REPORT (PK) Child Table Name Child Column Name
Children: RAD_REPORT_ID OMF_RADREPORT_ST RAD_REPORT_ID
OMF_RADTRANS_ORDER_ST RAD_REPORT_ID
RAD_OPS_EXCEPTION RAD_REPORT_ID
RAD_PEER_REVIEW RAD_REPORT_ID
RAD_REPORT_DETAIL RAD_REPORT_ID
RAD_REPORT_PRSNL RAD_REPORT_ID
RAD_RPT_PRSNL_HIST RAD_REPORT_ID
RAD_TRANS_STATS RAD_REPORT_ID


RAD_REPORT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Report Detail
Definition: The Rad_Report_Detail table contains information about each of the report sections that make up a radiology report.
Table Type: ACTIVITY





Column Detail - RAD_REPORT_DETAIL


Column Name Type Null? Definition
ACR_CODE_IND DOUBLE Y The ACR_Code_Ind indicates if an ACR code has been assigned.
DETAIL_EVENT_ID DOUBLE N The Detail_Event_Id is a foreign key to the Clinical_Event table. It identifies the report section that is stored in the repository.
DETAIL_REFERENCE_NBR VARCHAR(40) Y The Detail_Reference_Nbr serves as a tie to the Clinical_Event row that represents one of the report sections.
RAD_REPORT_ID DOUBLE N The Rad_Report_Id is a foreign key to the Rad_Report table. It identifies the report that the report detail belongs to.
REQUIRED_IND DOUBLE Y The Required_Ind indicates whether or not the report section is required.
SECTION_SEQUENCE DOUBLE N The Section_Sequence indicates in what order the report sections should appear.
TASK_ASSAY_CD DOUBLE N The Task_Assay_Cd is a foreign key to the Discrete_Task_Assay table. It identifies the report detail.
TEMPLATE_ID DOUBLE N The Template_Id is a foreign key to the WP_Template table. It identifies the template that was used for this report section. If one was used at all.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - RAD_REPORT_DETAIL


Child Column in RAD_REPORT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID


RAD_REPORT_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Report Prsnl
Definition: The Rad_Report_Prsnl table keeps track of all of the people that have interacted, or will interact, with a radiology report.
Table Type: ACTIVITY





Column Detail - RAD_REPORT_PRSNL


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The Action_Dt_Tm captures the date and time that the person finished their involvement with the report.
ACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PROVISIONAL_QUEUE_IND DOUBLE N The Provisional_Queue_Ind indicates if the report is currently queued to this person in the provisional queue.
PROXIED_FOR_ID DOUBLE N The Proxied_For_Id contains the Id of the person that was proxied for by this individual.
PRSNL_RELATION_FLAG DOUBLE N The Prsnl_Relation_Flag indicates the relationship that the person had with the report. (ex. transcriptionist, radiologist, resident)
QUEUE_IND DOUBLE Y The Queue_Ind indicates if the report is currently queued to this person.
RAD_REPORT_ID DOUBLE N The Rad_Report_Id is a foreign key to the Rad_Report table. It identifies the report that the person is related to.
REPORT_PRSNL_ID DOUBLE N The Report_Prsnl_Id is a foreign key to the Prsnl table. It identifies the person that is related to the report.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - RAD_REPORT_PRSNL


Child Column in RAD_REPORT_PRSNL(FK) Parent Table Name Parent Column Name
Parents: PROXIED_FOR_ID PRSNL PERSON_ID
REPORT_PRSNL_ID PRSNL PERSON_ID
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID