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 |