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 |