Table Detail Report

OMF_RADTECH_ORDER_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF RADTECH ORDER ST
Definition: Summary table storing technician information for radiology mgmt.
Table Type: ACTIVITY





Column Detail - OMF_RADTECH_ORDER_ST


Column Name Type Null? Definition
OMF_RADTECH_ORDER_ST_ID DOUBLE N Unique identifier for omf_radtech_order_st
ORDER_ID DOUBLE N The identification number for the order.
PRIMARY_PRSNL_IND DOUBLE N Indicates if the personnel was the primary personnel to start/complete the exam.
ROLE_CD DOUBLE N Stores the role that the personnel performed during the exam.
TECHNOLOGIST_ID DOUBLE N The technologist responsible for the order.
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 - OMF_RADTECH_ORDER_ST


Child Column in OMF_RADTECH_ORDER_ST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
TECHNOLOGIST_ID PRSNL PERSON_ID


OMF_RADTRANS_ORDER_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF RADTRANS ORDER ST
Definition: Summary table storing transcriptionist information for radiology mgmt.
Table Type: ACTIVITY





Column Detail - OMF_RADTRANS_ORDER_ST


Column Name Type Null? Definition
NBR_CHARACTERS DOUBLE Y The number of characters associated with this transcription.
NBR_LINES DOUBLE Y The number of lines associated with this transcription.
NBR_WORDS DOUBLE Y The number of words associated with this transcription.
OMF_RADTRANS_ORDER_ST_ID DOUBLE N Unique identifier for the radiology transcription summary table.
ORDER_ID DOUBLE N The identification number associated with this order.
ORIG_TRANSCRIBE_DT_NBR DOUBLE Y Original transcribed date number used to calculate other date dimensions and filters
ORIG_TRANSCRIBE_MIN_NBR DOUBLE Y Original transcribe minute number used to create time related dimensions and filters
ORIG_TRANSCRIBE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORIG_TRANS_DT_TM DATETIME Y This column contains the date that the report was originally transcribed.
RADIOLOGIST_ID DOUBLE N This column contains the unique identifier for the Radiologist that is associated with the report.
RAD_REPORT_ID DOUBLE N The Radnet report identification number associated with this order.
RAD_REPORT_SEQ DOUBLE N Provides uniqueness to a radiology report.
TRANSCRIBE_DT_NBR DOUBLE Y Transcribe Date Number used to create date related dimensions and filters
TRANSCRIBE_DT_TM DATETIME Y The last date/time that this Radnet report was transcribed (updated).
TRANSCRIBE_MIN_NBR DOUBLE Y Transcribe minute number used to create time related dimensions and filters
TRANSCRIBE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
TRANSCRIPTIONIST_ID DOUBLE N The identification number for the transcriptionist associated with this 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 - OMF_RADTRANS_ORDER_ST


Child Column in OMF_RADTRANS_ORDER_ST(FK) Parent Table Name Parent Column Name
Parents: RADIOLOGIST_ID PRSNL PERSON_ID
TRANSCRIPTIONIST_ID PRSNL PERSON_ID
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID


OMF_RAD_DOSE_REPORT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF RadNet Dose Report Data
Definition: The OMFtable referred by a Dose discern report, that contains information about dose data added for any selected order.
Table Type: ACTIVITY





Column Detail - OMF_RAD_DOSE_REPORT_DATA


Column Name Type Null? Definition
ACQUISITION_TYPE_TXT VARCHAR(255) Y Value of the Acquisition Type dose parameter.
ANODE_TARGET_MATERIAL_TXT VARCHAR(255) Y Contains value of Anode Target Material dose parameter.
AVERAGE_GLANDULAR_DOSE_NBR DOUBLE Y Contains value of Average glandular dose parameter
BODY_PART_ID DOUBLE N The body part this report detail data pertains to.
COMPRESSION_THICKNESS_NBR DOUBLE Y Contains value of Compression Thickness dose parameter
CTDIW_PHANTOM_TYPE_TXT VARCHAR(255) Y Contains value of CTDIw Phantom Type dose parameter
CTDI_NBR DOUBLE Y Contains value of CTDI dose parameter
DAP_NBR DOUBLE Y Contains value of DAP dose parameter
DLP_NBR DOUBLE Y Contains value of DLP dose parameter
DOSE_RP_NBR DOUBLE Y Contains value of Dose RP dose parameter
EFFECTIVE_DOSE_NBR DOUBLE Y Contains value of Effective dose parameter
ENTRANCE_EXPOSURE_RP_NBR DOUBLE Y Contains value of Entrance Exposure RP dose parameter
KVP_NBR DOUBLE Y Contains value of KvP dose parameter
MAS_NBR DOUBLE Y Contains value of mAs dose parameter
MODALITY_CD DOUBLE N This field contains a code that identifies the dose template modality used for this scan.
OMF_RAD_DOSE_REPORT_DATA_ID DOUBLE N Unique generated number that identifies a single row on the omf_Rad_dose_report_data table.
ORDER_ID DOUBLE N Contains the order_ID of the order, for which dose data is being added.
PARAMETER_VALUE_SEQ DOUBLE Y Used to identify the number of dose scans that were added for the selected order. Each dose scan will have a unique whole number. Most rows will have a decimal .01. If multiple rows are required to store all the information for a scan, the decimal part is incremented.
PITCH_FACTOR_NBR DOUBLE Y Contains value of Pitch Factor dose parameter
RADIONUCLIDE_ACTIVITY_NBR DOUBLE Y Contains value of Radionuclide Activity dose parameter
RADIONUCLIDE_NBR DOUBLE Y *** Obsolete ***
RADIONUCLIDE_TXT VARCHAR(255) Y Contains value of Radionuclide dose parameter
RADIOPHARMACEUTICAL_NBR DOUBLE Y *** Obsolete ***
RADIOPHARMACEUTICAL_TXT VARCHAR(255) Y Contains value of Radio pharmaceutical dose parameter
RAD_DOSE_SCAN_ID DOUBLE N Identifies the scan that this report row pertains to.
REFERENCE_POINT_DEFINITION_TXT VARCHAR(255) Y Contains value of Reference Point Definition dose parameter
SCANNING_LENGTH_NBR DOUBLE Y Contains value of Scanning length dose parameter
SSDE_MEASUREMENT_TEXT VARCHAR(255) Y contains value of SSDE measurement dose parameter
SSDE_NBR DOUBLE Y contains value of SSDE dose parameter
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.
XRAY_FILTER_MATERIAL_TXT VARCHAR(255) Y Contains value of X-Ray Filter Material dose parameter
XRAY_FILTER_THICKNESS_MAX_NBR DOUBLE Y Contains value of X-Ray Filter Thickness Maximum dose parameter



Relationship Detail - OMF_RAD_DOSE_REPORT_DATA


Child Column in OMF_RAD_DOSE_REPORT_DATA(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
RAD_DOSE_SCAN_ID RAD_DOSE_SCAN RAD_DOSE_SCAN_ID
BODY_PART_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID


RAD_OMF_MAMMO



Column Section Relationship Section Top of Page


Table-level Detail

Description: RAD OMF MAMMO
Definition: This is the main summary table for mammo powervision
Table Type: ACTIVITY





Column Detail - RAD_OMF_MAMMO


Column Name Type Null? Definition
FOLLOW_UP_PROC_CD DOUBLE N This is the mammography follow up procedure code.
INCLUDE_BREAST_DENSITY_IND DOUBLE Y This column will contain value of include breast density statement indicator value, as saved by user in Mammo case maintenance. Possible response values are Yes / No / empty string which is also the default response selected for this question. Planning to store these values as 1 (Yes), 0 (No), NULL (empty string). If this is set to Yes, then the breast density statement set for the selected facility in breast_density_text in Rad_Config_Data table will be printed in mammo notification letters.
NO_FOL_UP_REQ_IND DOUBLE Y If this field is 1, a follow up is not required. If it is 0 or NULL then a follow up is required.
ORDER_ID DOUBLE N This is the foreign key to the order_radiology table. It uniquely identifies an order.
RECALL_INTERVAL DOUBLE N This is the mammography patient recall interval.
STAT_CAT_FLAG DOUBLE N This flag is used for calculating radiologist performance.
STUDY_DT_NBR DOUBLE Y OMF uses this number to calculate dates.
STUDY_DT_TM DATETIME Y This is the date and time that the study was conducted
STUDY_ID DOUBLE N This is the foreign key to the mammo_study table.
STUDY_MIN_NBR DOUBLE Y OMF uses number to calculate dates.
STUDY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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_OMF_MAMMO


Child Column in RAD_OMF_MAMMO(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
ORDER_ID ORDERS ORDER_ID


RAD_OMF_MAMMO_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Summary table that stores the general information related to mammo PV.
Definition: Radnet OMF Mammography Details
Table Type: ACTIVITY





Column Detail - RAD_OMF_MAMMO_DETAILS


Column Name Type Null? Definition
CERNER_MEANING_STR VARCHAR(25) Y This field corresponds to the Cerner_meaning_str on the rad_fol_up_field table. It is a unique identifier for each field.
FIELD_DESCRIPTION VARCHAR(255) Y This field corresponds to the field_description column on the rad_fol_up_field table. It contains the description of the follow up field.
FOLLOW_UP_FIELD_ID DOUBLE N This field is a foreign key to the rad_fol_up_field table.
MAMMO_DETAIL_ID DOUBLE N This field is the primary key.
NUMERIC_VALUE DOUBLE N This field holds numeric summary data.
PARENT1_MEANING_STR VARCHAR(25) Y This is the first parent meaning str of the Cerner meaning str for any given row.
PARENT2_MEANING_STR VARCHAR(25) Y This is the second parent meaning str of the Cerner meaning str for any given row. It is also the parent of the parent 1 meaning str.
PARENT3_MEANING_STR VARCHAR(25) Y This is the third parent meaning str of the Cerner meaning str for any given row. It is also the parent of the parent 2 meaning str.
PARENT4_MEANING_STR VARCHAR(25) Y This is the forth parent meaning str of the Cerner meaning str for any given row. It is also the parent of the parent 3 meaning str.
STUDY_ID DOUBLE N This is a foreign key to the mammo_study table.
TEXT_VALUE VARCHAR(255) Y This field holds summary values of string type.
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.
VALUE_DT_TM DATETIME Y This field holds date/time summary values.
VALUE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - RAD_OMF_MAMMO_DETAILS


Child Column in RAD_OMF_MAMMO_DETAILS(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
FOLLOW_UP_FIELD_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID