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 |