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 |