Table Detail Report

RAD_INT_CASE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the cases that a radiologist has identified as interesting.
Definition: Radiology Interesting Case Relation
Table Type: ACTIVITY





Column Detail - RAD_INT_CASE_R


Column Name Type Null? Definition
DIAGNOSIS VARCHAR(255) Y This column contains the diagnosis entered by the radiologist for this specific interesting case.
INT_CASE_ENTRY_ID DOUBLE N This column is a meaningless number that only exists to uniquely identify a row.
INT_CASE_ID DOUBLE N This column contains a foreign key to the rad_int_case table. It identifies the interesting case subclass that this case resides in.
RADIOLOGIST_ID DOUBLE N This column contains a foreign key to the prsnl table. It uniquely identifies the radiologist associated with the interesting case.
REMINDER_DT_TM DATETIME Y This column contains the reminder date and time for an entry in the reminder file.
REVIEWED_DT_TM DATETIME Y This column contains the date and time that the reminder case what reviewed. This indicates that the reminder has been satisfied.
SEQ_EXAM_ID DOUBLE N This column contains a foreign key to the Exam Data table. It uniquely identifies the completed exam that has been entered into the interesting case file.
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_INT_CASE_R


Child Column in RAD_INT_CASE_R(FK) Parent Table Name Parent Column Name
Parents: SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID
RADIOLOGIST_ID PRSNL PERSON_ID
INT_CASE_ID RAD_INT_CASE INT_CASE_ID


RAD_PROTOCOL_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Protocol Activity
Definition: Stores the protocol information assigned to an individual order.
Table Type: ACTIVITY





Column Detail - RAD_PROTOCOL_ACT


Column Name Type Null? Definition
APPROVED_BY_PRSNL_ID DOUBLE N The person that approved the protocol for this radiology order.
COMMENT_TXT VARCHAR(512) N Protocolling comments entered by the user.
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.
MODIFICATION_REASON_CD DOUBLE N The reason the protocol details were modified for an order.
ORDER_ID DOUBLE N The radiology order that the protocol is for.
PROTOCOL_ID DOUBLE N The protocol that is pertinent for this radiology order.
RAD_PROTOCOL_ACT_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_PROTOCOL_ACT 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_PROTOCOL_ACT


Child Column in RAD_PROTOCOL_ACT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
APPROVED_BY_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
PROTOCOL_ID RAD_PROTOCOL_DEFINITION RAD_PROTOCOL_DEFINITION_ID




Parent Column in RAD_PROTOCOL_ACT (PK) Child Table Name Child Column Name
Children: RAD_PROTOCOL_ACT_ID RAD_PROTOCOL_ACT_HIST RAD_PROTOCOL_ACT_ID


RAD_PROTOCOL_ACT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Protocol Activity History
Definition: Stores the old protocol information about an order. The data on the table is not active.
Table Type: ACTIVITY





Column Detail - RAD_PROTOCOL_ACT_HIST


Column Name Type Null? Definition
APPROVED_BY_PRSNL_ID DOUBLE N The person that approved the protocol for this radiology order.
COMMENT_TXT VARCHAR(512) N Protocolling comments entered by the user.
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.
MODIFICATION_REASON_CD DOUBLE N The reason the protocol details were modified for an order.
ORDER_ID DOUBLE N The radiology order that the protocol is for.
PROTOCOL_ID DOUBLE N The protocol that is pertinent for this radiology order.
RAD_PROTOCOL_ACT_HIST_ID DOUBLE N Unique, generated number that identifies a row in the RAD_PROTOCOL_ACT_HIST table.
RAD_PROTOCOL_ACT_ID DOUBLE N The active Rad Protocol Activity row that this history record is a version of.
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_PROTOCOL_ACT_HIST


Child Column in RAD_PROTOCOL_ACT_HIST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
APPROVED_BY_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
RAD_PROTOCOL_ACT_ID RAD_PROTOCOL_ACT RAD_PROTOCOL_ACT_ID
PROTOCOL_ID RAD_PROTOCOL_DEFINITION RAD_PROTOCOL_DEFINITION_ID


RAD_TECH_CMT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Technical Comment Data
Definition: The Rad_Tech_Cmt_Data table stores technical comment data for a given order in the system.
Table Type: ACTIVITY





Column Detail - RAD_TECH_CMT_DATA


Column Name Type Null? Definition
CHARTABLE_IND DOUBLE Y The chartable_ind indicates if this field was marked as chartable at the time the data was saved.
DATA_CHOICE_IND DOUBLE Y The data_choice_ind indicates if a single or multi choice field should be selected
DATA_DT_TM DATETIME Y The Data_Date field stores date data for a field that is a date type.
DATA_NBR DOUBLE Y The data_nbr field stores numeric data for a field that is a numerical type.
DATA_TEXT VARCHAR(255) Y The data_text field stores text data for a field that is a textual type.
FIELD_ID DOUBLE N The Field_Id is a foreign key to the Rad_Tech_Field table. It is used to identify a Field
MAX_NBR DOUBLE Y The max_nbr field holds a maximum numerical value that was set for this field at the time the data was saved. The max_nbr only applies to fields that are a number type
MIN_NBR DOUBLE Y The min_nbr field holds a minimum numerical value that was set for this field at the time the data was saved. This min_nbr only applies to fields that are a number type
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Orders table. It is used to uniquely identify an order.
PARENT_FIELD_ID DOUBLE N The Parent_Field_Id is a foreign key to the Rad_Tech_Field table. It is used to identify a parent field for the row.
PRSNL_UPDT_DT_TM DATETIME Y The Prsnl_Updt_Dt_Tm identifies the date and time a personnel updated a particular field
PRSNL_UPDT_ID DOUBLE N The Prsnl_Updt_Id identifies the personnel that updated a particular field
REQUIRED_IND DOUBLE Y The required_ind indicates if this field was marked as required at the time the data was saved
SEQUENCE DOUBLE N The sequence identifies a sequence of a list of technical comment fields for a given order
TECH_DATA_ID DOUBLE N The Tech_Data_Id uniquely identifies a row in the Rad_Tech_Cmt_Data table. It serves no other purpose other than to uniquely identify the row
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_TECH_CMT_DATA


Child Column in RAD_TECH_CMT_DATA(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PRSNL_UPDT_ID PRSNL PERSON_ID
FIELD_ID RAD_TECH_FIELD FIELD_ID
PARENT_FIELD_ID RAD_TECH_FIELD FIELD_ID




Parent Column in RAD_TECH_CMT_DATA (PK) Child Table Name Child Column Name
Children: TECH_DATA_ID RAD_TECH_CMT_DATA_HIST TECH_DATA_ID


RAD_TECH_CMT_DATA_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Tech Comment History Data
Definition: The Rad_Tech_Cmt_Data_Hist table stores historical technical comment data for a given order.
Table Type: ACTIVITY





Column Detail - RAD_TECH_CMT_DATA_HIST


Column Name Type Null? Definition
CHARTABLE_IND DOUBLE Y The chartable_ind indicates if this field was marked as chartable at the time the data was saved
DATA_CHOICE_IND DOUBLE Y The data_choice_ind indicates if a single or multi choice field should be selected
DATA_DT_TM DATETIME Y The Data_Date field stores date data for a field that is a date type
DATA_NBR DOUBLE Y The data_nbr field stores numeric data for a field that is a numerical type.
DATA_TEXT VARCHAR(255) Y The data_text field stores text data for a field that is a textual type.
FIELD_ID DOUBLE N The Field_Id is a foreign key to the Rad_Tech_Field table. It is used to identify a Field.
MAX_NBR DOUBLE Y The max_nbr field holds a maximum numerical value that was set for this field at the time the data was saved. The max_nbr only applies to fields that are a number type
MIN_NBR DOUBLE Y The min_nbr field holds a minimum numerical value that was set for this field at the time the data was saved. This min_nbr only applies to fields that are a number type
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Orders table. It is used to uniquely identify an order.
PARENT_FIELD_ID DOUBLE N The Parent_Field_Id is a foreign key to the Rad_Tech_Field table. It is used to identify a parent field for the row.
PRSNL_UPDT_DT_TM DATETIME Y The Prsnl_Updt_Dt_Tm identifies the date and time a personnel updated a particular field
PRSNL_UPDT_ID DOUBLE N The Prsnl_Updt_Id identifies the personnel that updated a particular field.
REQUIRED_IND DOUBLE Y The required_ind indicates if this field was marked as required at the time the data was saved
SEQUENCE DOUBLE N The required_ind indicates if this field was marked as required at the time the data was saved
SERIES_NBR DOUBLE N The series_nbr identifies the order in which field data has changed for a given order.
TECH_DATA_HIST_ID DOUBLE N The Tech_Data_Hist_Id uniquely identifies a row in the Rad_Tech_Cmt_Data_Hist table. It serves no other purpose other than to uniquely identify the row
TECH_DATA_ID DOUBLE N It is used to identify a specific tech comment field with in an order that has been changed.
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_TECH_CMT_DATA_HIST


Child Column in RAD_TECH_CMT_DATA_HIST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PRSNL_UPDT_ID PRSNL PERSON_ID
TECH_DATA_ID RAD_TECH_CMT_DATA TECH_DATA_ID
FIELD_ID RAD_TECH_FIELD FIELD_ID
PARENT_FIELD_ID RAD_TECH_FIELD FIELD_ID