Table Detail Report

RAD_ACR_CODES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad ACR Codes
Definition: The Rad_ACR_Codes table contains the ACR codes that have been associated with an order.
Table Type: ACTIVITY





Column Detail - RAD_ACR_CODES


Column Name Type Null? Definition
ACR_STRING VARCHAR(15) Y This column is no longer used.
ANATOMY_STR VARCHAR(15) Y This column stores the anatomy piece of the ACR code.
ORDER_ID DOUBLE N The Order_Id field is a foreign key to the Order_Radiology table. It links the ACR code(s) to a specific order.
PARENT_ENTITY_ID DOUBLE N The Parent_entity_id along with the parent_entity_name identifies the exam or order that the acr codes refer to
PARENT_ENTITY_NAME VARCHAR(30) N The parent_entity_name along with the parent_entity_id identifies the exam or order that the acr codes refer to.
PATHOLOGY_STR VARCHAR(15) Y This column contains the Pathology piece of the ACR Code.
PROC_CODE_STR VARCHAR(5) Y This column contains the procedure code piece of the ACR string if one is specified.
SEQUENCE DOUBLE N The sequence column ensures that we have a unique primary key when partnered with the order_id.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - RAD_ACR_CODES


Child Column in RAD_ACR_CODES(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID


RAD_CRITICAL_RESOLVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Criticality Resolution
Definition: Contains the resolution details provided by the physician for exams with normalcy indicators.
Table Type: ACTIVITY





Column Detail - RAD_CRITICAL_RESOLVE


Column Name Type Null? Definition
ORDER_ID DOUBLE N This column is a foreign key to the order_radiology table. It uniquely identifies the order/procedure that the resolution is for.
RAD_CRITICAL_RESOLVE_ID DOUBLE N Unique generated number that identifies a single row on the RAD_CRITICAL_RESOLVE table.
RESOLUTION_CD DOUBLE N
RESOLUTION_COMMENT_TXT VARCHAR(255) Y
RESOLUTION_DT_TM DATETIME Y the date/time stamp when the physician marked procedure's cruciality as resolved.
RESOLUTION_PRSNL_ID DOUBLE N The person_id of the person from personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - RAD_CRITICAL_RESOLVE


Child Column in RAD_CRITICAL_RESOLVE(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
RESOLUTION_PRSNL_ID PRSNL PERSON_ID


RAD_DOSE_CONVERSION_FACTOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Dose Conversion Factor
Definition: Contains the conversion factors needed to calculate effective dose .
Table Type: REFERENCE





Column Detail - RAD_DOSE_CONVERSION_FACTOR


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.
ACTIVITY_SUBTYPE_CD DOUBLE N This field contains a code that identifies the dose template modality used for this scan.
BEGIN_AGE_YEARS DOUBLE N The begin age for the selected body part and activity sub type for which this dose conversion factor is being added.
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.
CONVERSION_FACTOR_AMT DOUBLE N The conversion factor needed to calculate effective dose for the modality and body part.
END_AGE_YEARS DOUBLE N The ending age for the selected body part and activity sub type for which this dose conversion factor is being added.
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.
PREV_CONVERSION_FACTOR_ID DOUBLE N This is the previous rad dose conversion factor id which is used to maintain the history.
RAD_DOSE_CONVERSION_FACTOR_ID DOUBLE N Unique generated number that identifies a single row on the rad_dose_conversion_factor 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_CONVERSION_FACTOR


Child Column in RAD_DOSE_CONVERSION_FACTOR(FK) Parent Table Name Parent Column Name
Parents: PREV_CONVERSION_FACTOR_ID RAD_DOSE_CONVERSION_FACTOR RAD_DOSE_CONVERSION_FACTOR_ID
BODY_PART_ID RAD_DOSE_SNOMED_RT_GLOSSARY RAD_DOSE_SNOMED_RT_GLOSSARY_ID




Parent Column in RAD_DOSE_CONVERSION_FACTOR (PK) Child Table Name Child Column Name
Children: RAD_DOSE_CONVERSION_FACTOR_ID RAD_DOSE_CONVERSION_FACTOR PREV_CONVERSION_FACTOR_ID


RAD_DOSE_FACET_MODALITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Dose Facet Modality Relation
Definition: Stores the relationship between dose facets and modality.
Table Type: REFERENCE





Column Detail - RAD_DOSE_FACET_MODALITY


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.
ACTIVITY_SUBTYPE_CD DOUBLE N This field contains a code that identifies the dose template modality used for this scan.
CONTROL_NAME VARCHAR(255) N The name of the specific database setting.
DATA_TYPE_FLAG DOUBLE N Bitmap indicating the data expected for this facet_cd for the modality.
FACET_CD DOUBLE N The radiation dose facet tied to the modality (activity_subtype_cd)
FACET_SEQ DOUBLE N The order the facet should appear in the application for the given activity subtype.
RAD_DOSE_FACET_MODALITY_ID DOUBLE N Unique generated number that identifies a single row on the RAD_DOSE_FACET_MODALITY table.
RESP_TYPE_FLAG DOUBLE N Indicates if this facet should be displayed in the front end application. 0 - Unchecked (no need to show this facet), 1 - Checked (need to show this facet), 3 - Checked and Disabled (need to show this facet. User cannot modify this setting.)
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_FACET_MODALITY




Parent Column in RAD_DOSE_FACET_MODALITY (PK) Child Table Name Child Column Name
Children: RAD_DOSE_FACET_MODALITY_ID RAD_DOSE_SCAN_FACET_R RAD_DOSE_FACET_MODALITY_ID


RAD_DOSE_FACET_R_SET



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - RAD_DOSE_FACET_R_SET


Column Name Type Null? Definition
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_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_DOSE_FACET_R_SET table.
RAD_DOSE_SCAN_FACET_R_ID DOUBLE N The facet that this value applies to. This is the foreign Key from the table rad_dose_scan_facter_r 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


Child Column in RAD_DOSE_FACET_R_SET(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




Parent Column in RAD_DOSE_FACET_R_SET (PK) Child Table Name Child Column Name
Children: RAD_DOSE_FACET_R_SET_ID RAD_DOSE_FACET_R_SET_HIST RAD_DOSE_FACET_R_SET_ID