Table Detail Report

RAD_EXPOSURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains data captured for exposure documentation.
Definition: rad_exposure
Table Type: ACTIVITY





Column Detail - RAD_EXPOSURE


Column Name Type Null? Definition
RAD_EXPOSURE_ID DOUBLE N This is a unique meaningless number used only for identification of a row on this table.
SEQUENCE DOUBLE Y The sequence field indicates the order of the series within seq_exam_id.
SEQ_EXAM_ID DOUBLE N The sequential_exam_id field is a foreign key to the exam_data table. It uniquely identifies the exam.
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_EXPOSURE


Child Column in RAD_EXPOSURE(FK) Parent Table Name Parent Column Name
Parents: SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID




Parent Column in RAD_EXPOSURE (PK) Child Table Name Child Column Name
Children: RAD_EXPOSURE_ID RAD_EXPOSURE_DATA RAD_EXPOSURE_ID


RAD_EXPOSURE_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the exposure fields assigned to a specific exam.
Definition: Rad Exposure Data
Table Type: ACTIVITY





Column Detail - RAD_EXPOSURE_DATA


Column Name Type Null? Definition
EXPOSURE_FIELD_CD DOUBLE N This field identifies which field the value corresponds with.
EXP_VALUE_FREETEXT VARCHAR(255) Y This column contains the free text response, if the field is of type free-text.
EXP_VALUE_ID DOUBLE N This column contains the coded value if the field is a codified field.
EXP_VALUE_NBR DOUBLE Y This column contains the numeric entry if this field is of type number.
RAD_EXPOSURE_ID DOUBLE N This column contains a foreign key to the Rad_Exposure table. It uniquely identifies the exposure related to a specific exam.
SEQUENCE DOUBLE Y The sequence field indicates which order the fields should be displayed in.
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_EXPOSURE_DATA


Child Column in RAD_EXPOSURE_DATA(FK) Parent Table Name Parent Column Name
Parents: RAD_EXPOSURE_ID RAD_EXPOSURE RAD_EXPOSURE_ID
EXP_VALUE_ID RAD_EXPOSURE_VALUES EXPOSURE_VALUE_ID


RAD_EXPOSURE_VALUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Exposure Values
Definition: This field stores the user defined values for radiology exposure fields.
Table Type: REFERENCE





Column Detail - RAD_EXPOSURE_VALUES


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
DESCRIPTION VARCHAR(255) Y This is the description of the exposure value.
EXPOSURE_FIELD_CD DOUBLE N This column identifies the exposure field that this value is related to.
EXPOSURE_VALUE_ID DOUBLE N The Exposure Value Id serves as a unique identifier for a given row.
SEQUENCE DOUBLE Y The Sequence field determines which order the values should appear when listed.
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_EXPOSURE_VALUES




Parent Column in RAD_EXPOSURE_VALUES (PK) Child Table Name Child Column Name
Children: EXPOSURE_VALUE_ID RAD_EXPOSURE_DATA EXP_VALUE_ID
SERVICE_DIRECTORY RAD_ORGAN_ID
TECHNIQUE_DEFAULT_VALS EXPOSURE_VALUE_ID