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 |