Table Detail Report

RAD_DOSE_FACET_R_SET_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose Facet Relation Set History
Definition: This will contain the history of Dose facet series details, if the facet has multiple value.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_FACET_R_SET_HIST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACET_VALUE_SEQ DOUBLE N The sequence of the values for a facet.
LAST_UPDT_DT_TM DATETIME N The date and time this row was last updated by personnel.
LAST_UPDT_PRSNL_ID DOUBLE N the person that last updated this row.
RAD_DOSE_FACET_R_SET_HIST_ID DOUBLE N Unique generated number that identifies a single row on the rad_dose_facet_r_series_hist table.
RAD_DOSE_FACET_R_SET_ID DOUBLE N The table that originally stored this data. This is the foreign Key from the table rad_dose_scan_facet_r_set table.
UOM_CD DOUBLE N *** OBSOLETE ****
UOM_ID DOUBLE N The unit of measure the value represents.
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_NBR DOUBLE N The numeric value for the facet. This can also store code values.
VALUE_TXT VARCHAR(255) Y Stores the string information related to this facet.



Relationship Detail - RAD_DOSE_FACET_R_SET_HIST


Child Column in RAD_DOSE_FACET_R_SET_HIST(FK) Parent Table Name Parent Column Name
Parents: LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
RAD_DOSE_FACET_R_SET_ID RAD_DOSE_FACET_R_SET RAD_DOSE_FACET_R_SET_ID
UOM_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID


RAD_DOSE_SCAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose Scan
Definition: Represents a single radiation scan.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_SCAN


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N This field contains a code that identifies the dose template modality used for this scan.
BODY_PART_CD DOUBLE N *** OBSOLETE ***
BODY_PART_ID DOUBLE N The body part the conversion factor applies to.
CREATED_DT_TM DATETIME N Date/time the row was created.
EFFECTIVE_DOSE_AMT DOUBLE N The calculated effective dose for the scan.
IRRADIATION_EVENT_UID VARCHAR(255) N Stores the irradiation event uid received from DICOM.
LAST_UPDT_DT_TM DATETIME N Date/time the row was last updated.
LAST_UPDT_PRSNL_ID DOUBLE N The person that last updated this row.
RAD_DOSE_SCAN_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_SCAN 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_SCAN


Child Column in RAD_DOSE_SCAN(FK) Parent Table Name Parent Column Name
Parents: LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
BODY_PART_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID




Parent Column in RAD_DOSE_SCAN (PK) Child Table Name Child Column Name
Children: RAD_DOSE_SCAN_ID OMF_RAD_DOSE_REPORT_DATA RAD_DOSE_SCAN_ID
RAD_DOSE_SCAN_FACET_R RAD_DOSE_SCAN_ID
RAD_DOSE_SCAN_HIST RAD_DOSE_SCAN_ID
RAD_DOSE_SCAN_ORDER_R RAD_DOSE_SCAN_ID


RAD_DOSE_SCAN_FACET_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose Scan Facet Relation
Definition: Stores the facets that are important for this scan.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_SCAN_FACET_R


Column Name Type Null? Definition
LAST_UPDT_DT_TM DATETIME N The date and time this row was last updated by personnel.
LAST_UPDT_PRSNL_ID DOUBLE N the person that last updated this row.
RAD_DOSE_FACET_MODALITY_ID DOUBLE N Identifies the facet and the modality for this scan.
RAD_DOSE_SCAN_FACET_R_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_SCAN_FACET_R table.
RAD_DOSE_SCAN_ID DOUBLE N Identifies a scan that is related to this facet and modality.
UOM_CD DOUBLE N *** OBSOLETE ****
UOM_ID DOUBLE N The unit of measure for the facet.
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_NBR DOUBLE N The numeric value for the facet.
VALUE_TXT VARCHAR(255) Y The string information related to this facet.



Relationship Detail - RAD_DOSE_SCAN_FACET_R


Child Column in RAD_DOSE_SCAN_FACET_R(FK) Parent Table Name Parent Column Name
Parents: LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
RAD_DOSE_FACET_MODALITY_ID RAD_DOSE_FACET_MODALITY RAD_DOSE_FACET_MODALITY_ID
RAD_DOSE_SCAN_ID RAD_DOSE_SCAN RAD_DOSE_SCAN_ID
UOM_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID




Parent Column in RAD_DOSE_SCAN_FACET_R (PK) Child Table Name Child Column Name
Children: RAD_DOSE_SCAN_FACET_R_ID RAD_DOSE_FACET_R_SET RAD_DOSE_SCAN_FACET_R_ID
RAD_DOSE_SCAN_FACET_R_HIST RAD_DOSE_SCAN_FACET_R_ID


RAD_DOSE_SCAN_FACET_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Dose Scan Facet Relationship History
Definition: Stores the history of facets details for a scan.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_SCAN_FACET_R_HIST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LAST_UPDT_PRSNL_ID DOUBLE N the person that last updated this row.
RAD_DOSE_SCAN_FACET_R_HIST_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_SCAN_FACET_R_HIST table.
RAD_DOSE_SCAN_FACET_R_ID DOUBLE N Unique identifier to the rad_dose_scan_facet_r table. Links to the row on the base table that relates to this history row.
UOM_CD DOUBLE N *** OBSOLETE ****
UOM_ID DOUBLE N The unit of measure for the facet.
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_NBR DOUBLE N The numeric value for the facet.
VALUE_TXT VARCHAR(255) Y Stores the string information related to this facet.



Relationship Detail - RAD_DOSE_SCAN_FACET_R_HIST


Child Column in RAD_DOSE_SCAN_FACET_R_HIST(FK) Parent Table Name Parent Column Name
Parents: LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
RAD_DOSE_SCAN_FACET_R_ID RAD_DOSE_SCAN_FACET_R RAD_DOSE_SCAN_FACET_R_ID
UOM_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID


RAD_DOSE_SCAN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Dose Scan History
Definition: Store the history information for the rows in the rad_dose_scan table for auditing purposes.
Table Type: ACTIVITY





Column Detail - RAD_DOSE_SCAN_HIST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BODY_PART_CD DOUBLE N *** OBSOLETE***
BODY_PART_ID DOUBLE N The body part the conversion factor applies to.
EFFECTIVE_DOSE_AMT DOUBLE N Stores the calculated effective dose for the scan.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
IRRADIATION_EVENT_UID VARCHAR(255) N Stores the irradiation event uid received from DICOM.
LAST_UPDT_PRSNL_ID DOUBLE N the person that last updated this row.
RAD_DOSE_SCAN_HIST_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_SCAN_HIST table.
RAD_DOSE_SCAN_ID DOUBLE N Unique identifier to a single row on the rad_dose_scan table. Identifies the Rad Dose Scan that this row is history for.
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_HIST


Child Column in RAD_DOSE_SCAN_HIST(FK) Parent Table Name Parent Column Name
Parents: LAST_UPDT_PRSNL_ID PRSNL PERSON_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