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 |