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 |