Table Detail Report

RAD_DOSE_SCAN_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose Scan Order Relation
Definition: Stores the relationship between a scan and an order.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_SCAN_ORDER_R


Column Name Type Null? Definition
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. It identifies the order this scan is for.
RAD_DOSE_SCAN_ID DOUBLE N Identifies a scan that is related to this order.
RAD_DOSE_SCAN_ORDER_R_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_SCAN_ORDER_R table.
SCAN_SEQ DOUBLE N Indicates the order the scans occurred for an 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 - RAD_DOSE_SCAN_ORDER_R


Child Column in RAD_DOSE_SCAN_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
RAD_DOSE_SCAN_ID RAD_DOSE_SCAN RAD_DOSE_SCAN_ID


RAD_DOSE_SNOMED_RT_GLOSSARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose SNOMED Radiation Therapy Terminology Glossary
Definition: The glossary for the facet and units required to display by dose facets.
Table Type: REFERENCE





Column Detail - RAD_DOSE_SNOMED_RT_GLOSSARY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DICOM_CODE_MEANING_TXT VARCHAR(256) Y The meaning of the facet/unit as described in the DIACOM doc.
DICOM_CODE_SCHEME_DESGNTR_TXT VARCHAR(256) N An identifier of the coding organization as per the DIACOM doc.
DICOM_CODE_SCHEME_VERSION_TXT VARCHAR(256) Y Used when the coding scheme designator does not imply a version. From the DIACOM doc.
DICOM_CODE_VALUE_TXT VARCHAR(256) N A computer-readable and searchable identifier for a facet/unit as per the DICOM doc.
DISPLAY_TXT VARCHAR(256) Y The text that will be displayed in the front-end.
RAD_DOSE_SNOMED_RT_GLOSSARY_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_DOSE_SNOMED_RT_GLOSSARY table.
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_DOSE_SNOMED_RT_GLOSSARY




Parent Column in RAD_DOSE_SNOMED_RT_GLOSSARY (PK) Child Table Name Child Column Name
Children: RAD_DOSE_SNOMED_RT_GLOSSARY_ID OMF_RAD_DOSE_REPORT_DATA BODY_PART_ID
RAD_DOSE_CONVERSION_FACTOR BODY_PART_ID
RAD_DOSE_FACET_R_SET UOM_ID
RAD_DOSE_FACET_R_SET_HIST UOM_ID
RAD_DOSE_SCAN BODY_PART_ID
RAD_DOSE_SCAN_FACET_R UOM_ID
RAD_DOSE_SCAN_FACET_R_HIST UOM_ID
RAD_DOSE_SCAN_HIST BODY_PART_ID


RAD_ENCNTR_PATH_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Encounter Path Relation
Definition: Defines a template for radiology orders at a particular facility.
Table Type: REFERENCE





Column Detail - RAD_ENCNTR_PATH_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Catalog Code for the radiology procedure.
CKI_IDENTIFIER VARCHAR(50) N Indicates the CKI Identifier of the pattern selected to be associated with the given procedure and facility. This identifier originates in the SCR Pattern table.
CKI_SOURCE CHAR(12) N This column indicates the CKI Source of the pattern selected to be associated with the given procedure and facility. This identifier originates in the SCR Pattern table.
DEFAULT_IND DOUBLE N Marks the row as the default pathway for the facility.
FACILITY_CD DOUBLE N Code for the facility in the catalog code pathway relationship. If the facility code is -1, then this pathway is for all facilities.
RAD_ENCNTR_PATH_R_ID DOUBLE N Unique, generated key for RAD_ENCNTR_PATH_R.
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_ENCNTR_PATH_R


Child Column in RAD_ENCNTR_PATH_R(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


RAD_FILM_ADJUST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Film Adjustments
Definition: The Rad_Film_Adjust table contains repeat and waste information about a particular order.
Table Type: ACTIVITY





Column Detail - RAD_FILM_ADJUST


Column Name Type Null? Definition
COMPLETE_DT_TM DATETIME Y The Complete_Dt_Tm captures the date and time that the exam was performed.
COMPLETE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
FILM_SIZE_CD DOUBLE N The Film_Size_Cd identifies a specific size of film that was used while performing the exam.
FILM_TYPE_CD DOUBLE N The Film_Type_Cd identifies a specific type of film that was used while performing the exam.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. It identifies the order which the film adjustments are being recorded for.
REPEAT_WASTE_CD DOUBLE N The Repeat_Waste_Cd identifies if the if the film was repeated or wasted.
RESPONSIBLE_ID DOUBLE N The Responsible_Id identifies the person responsible for the use of additional film.
SEQUENCE DOUBLE N The Sequence is used along with the Order_Id to uniquely identify a row in the Rad_Film_Adjust table. It serves no other purpose other than to uniquely identify the row.
STD_QUANTITY DOUBLE Y The Std_Quantity stores the number of films that should be used while performing the exam.
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.
WASTE_QUANTITY DOUBLE Y The Waste_Quantity stores the number of films that were wasted while performing the exam.



Relationship Detail - RAD_FILM_ADJUST


Child Column in RAD_FILM_ADJUST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
RESPONSIBLE_ID PRSNL PERSON_ID


RAD_INIT_READ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Initial Reading
Definition: The contents of RAD_INIT_READ allows for the system tracking of information, that formerly existed as yellow sticky notes on the Film or in the Film folder, created by an ED Physician to be associated with an acquired study from a modality. The table also tracks the later entry by a Radiologist that may indicate a different finding or agree/disagree with the ED Physician's initial read.
Table Type: ACTIVITY





Column Detail - RAD_INIT_READ


Column Name Type Null? Definition
ACTIVITY_CD DOUBLE N This column contains the type of user-performed activity.
CONSULTATION_CD DOUBLE N This column identifies the consultation required.
ORDER_ID DOUBLE N Order ID for which the wet read is being stored.
PARENT_ENTITY_ID DOUBLE N This column contains the unique ID of a foreign table such as Acquired Study ID, Accession_ID
PARENT_ENTITY_NAME VARCHAR(30) N This column contains the name of the table where the Parent_Entity_ID comes from. EX: IM_Acquired_Study or ORDER_RADIOLOGY table
RAD_INIT_READ_ID DOUBLE N This column contains a unique number that serves the purpose of uniquely identifying a wet read.
READ_BY_DT_NBR DOUBLE N Date Number used for calculation of other date related dimensions and filters for an initial read.
READ_BY_DT_TM DATETIME Y Date and time the row was added.
READ_BY_ID DOUBLE N Person ID of the person adding the wet read row.
READ_BY_MIN_NBR DOUBLE N Minute value used for calculation of other time related dimensions and filters indicating when the initial read was created.
READ_BY_TZ DOUBLE Y Time zone associated with the column READ_BY_DT_TM.
READ_TEXT VARCHAR(255) Y This column contains the text string for initial reading. It identifies the text entered during wet read.
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_INIT_READ


Child Column in RAD_INIT_READ(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
READ_BY_ID PRSNL PERSON_ID