EXAM_CRITIQUE_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Exam Critique Info
Definition: The Exam_Critique Info table contains information about an exam critique. Info includes who did the critique, when it was done, etc.
Table Type: ACTIVITY





Column Detail - EXAM_CRITIQUE_INFO


Column Name Type Null? Definition
COMMENTS VARCHAR(255) Y The Comments field contains any general comments that the radiologist has about the critique.
CREATED_BY_ID DOUBLE N The Created_By_Id field contains the unique identifier for the radiologist that has performed the critique.
CREATED_DT_TM DATETIME Y The Created_Dt_Tm field captures the date and time that the critique was performed.
CRITIQUE_INFO_ID DOUBLE N The Critique_Info_Id uniquely identifies a row within the Exam_Critique_Info table. It has no other meaning or purpose other than to serve as a unique id.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. This serves as the tie between the order and the critique info.
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 - EXAM_CRITIQUE_INFO


Child Column in EXAM_CRITIQUE_INFO(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
CREATED_BY_ID PRSNL PERSON_ID




Parent Column in EXAM_CRITIQUE_INFO (PK) Child Table Name Child Column Name
Children: CRITIQUE_INFO_ID CRITIQUE_PRSNL CRITIQUE_INFO_ID


EXAM_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Exam Data
Definition: The Exam_Data table contains common information about a radiology exam that was performed.
Table Type: ACTIVITY





Column Detail - EXAM_DATA


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies which exam was performed.
COMPLETE_DT_TM DATETIME Y The Complete_Dt_Tm captures the date and time that the exam was performed.
COMPLETE_LOCN_CD DOUBLE N The Complete_Locn_Cd captures the unique id for the exam room in which the exam was performed.
COMPLETE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
FLUORO_MINS_USED DOUBLE Y This column contains the number of minutes that fluoro was used during the exam.
GROUP_REFERENCE_NBR VARCHAR(40) Y The Group_Reference_Nbr serves as a tie to the corresponding row in the repository.
MEDICAL_LEGAL_IND DOUBLE Y The Medical_Legal_Ind identifies those exam that have medical legal implications.
MED_LEGAL_CMNT VARCHAR(255) Y The Medical_Legal_Cmnt field contains any comments relevant to the exams medical legal status.
ORDER_ID DOUBLE N Order Id from the orders table
OUTSIDE_CASE_IND DOUBLE Y This column indicates if the row on the exam_data table represents an outside case. This is used for interesting cases.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PURGE_IND DOUBLE Y The Purge_Ind indicates whether or not an exam has been marked for purge.
READ_COMPLETE_IND DOUBLE Y The Read_Complete_Ind indicates whether or not the exam has been interpreted by the radiologist/resident.
REPORT_ID DOUBLE N The Report_Id is a foreign key to the Clinical Event table. This serves as the tie between the exam within image management and the report in the repository.
SEQ_EXAM_ID DOUBLE N The Seq_Exam_Id uniquely identifies a row within the Exam_Data table. It has no other meaning or purpose other than to serve as a unique 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 - EXAM_DATA


Child Column in EXAM_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID




Parent Column in EXAM_DATA (PK) Child Table Name Child Column Name
Children: SEQ_EXAM_ID FILM_EXAM SEQ_EXAM_ID
MAMMO_STUDY SEQ_EXAM_ID
MEDIA_EXAM SEQ_EXAM_ID
ORDER_RADIOLOGY SEQ_EXAM_ID
RAD_EXPOSURE SEQ_EXAM_ID
RAD_INT_CASE_R SEQ_EXAM_ID
TEMPORARY_EXAM SEQ_EXAM_ID


RAD_EXAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Exam
Definition: Rad Exam
Table Type: ACTIVITY





Column Detail - RAD_EXAM


Column Name Type Null? Definition
CHARGES_SENT_IND DOUBLE Y This column indicates that technical charges have been sent to the AFC server.
COMPLETE_DT_TM DATETIME Y The Complete_Dt_Tm captures the date and time that the detail exam was performed.
CREDIT_IND DOUBLE Y The Credit_Ind indicates if the row represents bill only procedures that have been credited.
EXAM_SEQUENCE DOUBLE Y The Exam_Sequence defines the order in which the detail exams should appear or be performed.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Order_Radiology table. It identifies the order that the detail exams are a part of.
QUANTITY DOUBLE Y The Quantity field is used to capture the quantity of a specific bill only procedure that was used relative to the order.
RAD_EXAM_ID DOUBLE N The Rad_Exam_Id uniquely identifies a row within the Rad_Exam table. This field serves no purpose other than to uniquely identify the row.
REQUIRED_IND DOUBLE Y The Required_Ind indicates whether or not the detail exam is required to complete.
SCHED_REQ_DT_TM DATETIME Y The Sched_Req_Dt_Tm contains the date that the detail exam was requested/scheduled to be performed on.
SCHED_REQ_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd identifies the Exam Room that the detail exam is to be performed within.
STARTING_DT_TM DATETIME Y The Starting_Dt_Tm captures the date and time that the detail exam was started.
TASK_ASSAY_CD DOUBLE N The Task_Assay_Cd is a foreign key to the Discrete_Task_Assay table. It identifies the detail examthat is to be performed.
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_EXAM


Child Column in RAD_EXAM(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
ORDER_ID ORDER_RADIOLOGY ORDER_ID




Parent Column in RAD_EXAM (PK) Child Table Name Child Column Name
Children: RAD_EXAM_ID RAD_EXAM_PRSNL RAD_EXAM_ID
RAD_EXAM_PRSNL_HIST RAD_EXAM_ID


RAD_EXAM_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Exam Personnel
Definition: The Rad_Exam_Prsnl table contains those personnel that were involved in performing the ordered procedure(s).
Table Type: ACTIVITY





Column Detail - RAD_EXAM_PRSNL


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The Action_Dt_Tm captures the date and time that the person interacted with the detail exam.
ACTION_SEQUENCE DOUBLE N Used to keep exam personnel in a specific sequence (the order in which they were entered)
ACTION_TYPE_CD DOUBLE N The Action_Type_Cd identifies which action the person performed upon the detail exam. (ex. completed, started, etc.)
EXAM_PRSNL_ID DOUBLE N The Exam_Prsnl_Id is a foreign key to the Prsnl table. It identifies the person that interacted with the detail exam.
EXAM_RELATION_CD DOUBLE N The Exam_Relation_Cd identifies the role that the person took when interacting with the detail exam. (ex: tech, nurse, radiologist, etc.)
PRIMARY_PRSNL_IND DOUBLE N Determines if this personnel was designated the primary personnel responsible for this exam. 1 = Primary Personnel, 0 = Secondary Personnel
RAD_EXAM_ID DOUBLE N The Rad_Exam_Id is a foreign key to the Rad_Exam table. It indicates which detail exam the personnel are tied to.
READ_IND DOUBLE N Indicates that this radiologist or resident will be "marked" to be the person to read the x-ray for this exam. This indicator will make this exam show in their desktop application for their own personal worklist of exams assigned to them. 0 = Not assigned; 1 = Assigned to read
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_EXAM_PRSNL


Child Column in RAD_EXAM_PRSNL(FK) Parent Table Name Parent Column Name
Parents: EXAM_PRSNL_ID PRSNL PERSON_ID
RAD_EXAM_ID RAD_EXAM RAD_EXAM_ID


RAD_EXAM_PRSNL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Exam Personnel History
Definition: Contains historical information about the personnel assigned to read the exam.
Table Type: ACTIVITY





Column Detail - RAD_EXAM_PRSNL_HIST


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The Action_Dt_Tm captures the date and time that the person interacted with the detail exam.
ACTION_SEQUENCE DOUBLE N Used to keep exam personnel in a specific sequence (the order in which they were entered)
ACTION_TYPE_CD DOUBLE N The Action_Type_Cd identifies which action the person performed upon the detail exam. (ex. completed, started, etc.)
CREATE_DT_TM DATETIME N The date and time this row was inserted on the table
EXAM_PRSNL_ID DOUBLE N The Exam_Prsnl_Id is a foreign key to the Prsnl table. It identifies the person that interacted with the detail exam.
EXAM_RELATION_CD DOUBLE N The Exam_Relation_Cd identifies the role that the person took when interacting with the detail exam. (ex: tech, nurse, radiologist, etc.)
LAST_ASSIGNED_TO_IND DOUBLE N Indicates that this was the last assigned set of personnel for this exam.
PRIMARY_PRSNL_IND DOUBLE N Determines if this personnel was designated the primary personnel responsible for this exam. 1 = Primary Personnel, 0 = Secondary Personnel
RAD_EXAM_ID DOUBLE N The Rad_Exam_Id is a foreign key to the Rad_Exam table. It indicates which detail exam the personnel are tied to.
RAD_EXAM_PRSNL_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_EXAM_PRSNL_HIST table.
READ_IND DOUBLE N Indicates that this radiologist or resident will be "marked" to be the person to read the x-ray for this exam. This indicator will make this exam show in their desktop application for their own personal worklist of exams assigned to them. 0 = Not assigned; 1 = Assigned to read
SYSTEM_IND DOUBLE N Indicates if the row was created due to a system action such as reporting as opposed to a user-driven assignment update.
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_EXAM_PRSNL_HIST


Child Column in RAD_EXAM_PRSNL_HIST(FK) Parent Table Name Parent Column Name
Parents: EXAM_PRSNL_ID PRSNL PERSON_ID
RAD_EXAM_ID RAD_EXAM RAD_EXAM_ID