CRITIQUE_CODE_ASSIGNMENTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Critique Code Assignments
Definition: The Critique_Code_Assignments table contains coded information about an exam critique.
Table Type: ACTIVITY





Column Detail - CRITIQUE_CODE_ASSIGNMENTS


Column Name Type Null? Definition
CRITIQUE_INFO_ID DOUBLE N The Critique_Info_Id is a foreign key the exam_critique_info table.
CRITIQUE_PRSNL_ID DOUBLE N The Critique_Prsnl_id contains the id of the Radiologist doing the critique of a Resident, Transcriptionist, or Technologist
CRITIQUE_TYPE_CD DOUBLE N The Critique_Type_Cd contains the codes that identify the specifics about the critique. (ex. too light, too dark, etc.)
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 - CRITIQUE_CODE_ASSIGNMENTS


Child Column in CRITIQUE_CODE_ASSIGNMENTS(FK) Parent Table Name Parent Column Name
Parents: CRITIQUE_PRSNL_ID CRITIQUE_PRSNL CRITIQUE_PRSNL_ID


CRITIQUE_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Critique Prsnl
Definition: The Critique_Prsnl table contains the list of personnel that are being critiqued.
Table Type: ACTIVITY





Column Detail - CRITIQUE_PRSNL


Column Name Type Null? Definition
COMMENTS VARCHAR(255) Y The comments field contains comments about each report that is being critiqued.
CRITIQUED_ID DOUBLE N The Critiqued_Id idendifies the personnel whose work is being critiqued.
CRITIQUE_INFO_ID DOUBLE N The Critique_Info_Id is a foreign key the exam_critique_info table.
CRITIQUE_PRSNL_ID DOUBLE N The critique_prsnl_id is the person doing the critique
CRITIQUE_RELTN_FLAG DOUBLE Y Defines the relationship the person being critiqued has with the procedure.
READ_IND DOUBLE Y Indicator to say if the resident, transcriptionist, or technologist has read this critique.
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 - CRITIQUE_PRSNL


Child Column in CRITIQUE_PRSNL(FK) Parent Table Name Parent Column Name
Parents: CRITIQUE_INFO_ID EXAM_CRITIQUE_INFO CRITIQUE_INFO_ID
CRITIQUED_ID PRSNL PERSON_ID




Parent Column in CRITIQUE_PRSNL (PK) Child Table Name Child Column Name
Children: CRITIQUE_PRSNL_ID CRITIQUE_CODE_ASSIGNMENTS CRITIQUE_PRSNL_ID


ORDER_RADIOLOGY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Radiology
Definition: The Order_Radiology table contains radiology specific order information.
Table Type: ACTIVITY





Column Detail - ORDER_RADIOLOGY


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The Accession field contains the accession number that this order was assigned to at order time.
ACCESSION_ID DOUBLE N The Accession_Id field is a foreign key to the Accession table.
ACC_ADD_ON_IND DOUBLE N This column indicates if the order was a part of an Accession Add-on transaction.
CANCEL_BY_ID DOUBLE N If the order was cancelled the Cancel_By_Id contains the unique Identifier for the person who cancelled the order.
CANCEL_DT_TM DATETIME Y If the order was cancelled the Cancel_Dt_Tm contains the date and time that the order was cancelled.
CANCEL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies which exam was ordered.
COMMENTS VARCHAR(255) Y The Comments field contains any general comments pertaining to the order.
COMPLETE_DT_TM DATETIME Y The Complete_Dt_Tm captures the date and time that the exam was performed.
COMPLETE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXAM_AUTO_REPORT_IND DOUBLE Y Indicates if the exam is auto-reported.
EXAM_STATUS_CD DOUBLE N The Exam_Status_Cd contains the current status of the exam portion of the order.
GROUP_EVENT_ID DOUBLE N The Group_Event_Id is a foreign key to the Clinical_Event table.
GROUP_REFERENCE_NBR VARCHAR(40) Y The Group_Reference_Nbr serves as a secondary tie to the Clinical_Event table.
HIDE_PRELIM_REPORT_IND DOUBLE N Indicates if the preliminary report is to be hidden from viewing outside RADNET.
ORDER_ID DOUBLE N The Order_Id is a foreign key to the Orders table. It is used to uniquely identify an order.
ORDER_PHYSICIAN_ID DOUBLE N The Order_Physician_Id contains the unique id of the physician who ordered the procedure.
ORD_LOC_CD DOUBLE N the Ord_Loc_Cd identifies the Location from which the order was placed.
ORIG_ORDER_DT_TM DATETIME Y The Original order date and time for this order.
PACKET_ROUTING_CD DOUBLE N The Packet_Routing_Cd identifies which packet routing to use for printing of the patient packet. This field is not always filled out.
PARENT_ORDER_ID DOUBLE N The Parent_Order_Id is used during accession linking of a report. It contains the Order_Id of the master. This is only filled out after the report has been at least started.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIORITY_CD DOUBLE N The Priority_Cd identifies the priority of the order.
PROTOCOL_REQ_IND DOUBLE Y Indicates a protocol is required for this exam. Null indicates the order existed prior to protocol functionality being available in Millennium.
PULL_LIST_ID DOUBLE N The Pull_List_Id is a foreign key to the Pull_List table. It identifies which pull list is related to this order.
RAD_PACS_ID DOUBLE N This field is used as a unique identifier for PACS interfaces.
REASON_FOR_EXAM VARCHAR(4000) Y The Reason_For_Exam field contains a textual reason of why the procedure was performed.
REFER_LOC_CD DOUBLE N The Refer_Loc_Cd identifies where the order was referred from.
REMOVED_BY_ID DOUBLE N If the order was removed after completion, the Removed_By_Id contains the Id of the person performing the remove.
REMOVED_CD DOUBLE N *** OBSOLETE ***
REMOVED_DT_TM DATETIME Y If the order was removed after completion, the Removed_Cd Identifies why the exam was removed.
REPLACED_ORDER_ID DOUBLE N This column, when valued, will reference the order that was cancelled as a part of a replace transaction.
REPORTING_PRIORITY_CD DOUBLE N This column contains the code value to allow for either ROUTINE or STAT priority. The STAT priority alerts the radiology tech to focus on first.
REPORT_STATUS_CD DOUBLE N The Report_Status_Cd identifies the current status of the report that a part of this order.
REQUESTED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
REQUEST_DT_TM DATETIME Y The Request_Dt_Tm field contains the date and time that the order was requested to be performed.
RESTORED_IND DOUBLE Y The Restored_Ind indicates whether or not this order was restored from the repository for the purpose of changing the report.
SEQ_EXAM_ID DOUBLE N The Seq_Exam_Id is a foreign key to the Exam_Data table. It serves as a link to the exam info within the exam management area.
START_DT_TM DATETIME Y The Start_Dt_tm contains the date and time that the exam was started. This is used for turnaround times.
START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
TRANS_WORKGROUP_CD DOUBLE N The Trans_Workgroup_Cd identifies the transcription workgroup that the report will be loaded to.
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.
VETTING_DT_TM DATETIME Y This column will contain the date and time that the exam was vetted.
VETTING_PRSNL_ID DOUBLE N This column will contain the id of the personnel that vetted the exam.
VETTING_STATUS_FLAG DOUBLE N This is the vetting status of the exam.Valid values for this column are: 0 - Not Vetted; 1- Accepted; 2- Rejected; 3- Replaced; 4 - In Process
VETTING_TZ DOUBLE Y Time zone associated with the corresponding vetting_dt_tm column.



Relationship Detail - ORDER_RADIOLOGY


Child Column in ORDER_RADIOLOGY(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID
ORDER_ID ORDERS ORDER_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
PARENT_ORDER_ID ORDER_RADIOLOGY ORDER_ID
REPLACED_ORDER_ID ORDER_RADIOLOGY ORDER_ID
PERSON_ID PERSON PERSON_ID
CANCEL_BY_ID PRSNL PERSON_ID
ORDER_PHYSICIAN_ID PRSNL PERSON_ID
REMOVED_BY_ID PRSNL PERSON_ID
VETTING_PRSNL_ID PRSNL PERSON_ID
PULL_LIST_ID PULL_LIST PULL_LIST_ID




Parent Column in ORDER_RADIOLOGY (PK) Child Table Name Child Column Name
Children: ORDER_ID EXAM_CRITIQUE_INFO ORDER_ID
ICLASS_ACC_ORDER_R ORDER_ID
MAMMO_STUDY ORDER_ID
OMF_RADPROC_CLASS_ST ORDER_ID
ORDER_RADIOLOGY PARENT_ORDER_ID
ORDER_RADIOLOGY REPLACED_ORDER_ID
PROC_CLASSIFICATION ORDER_ID
PULL_ORD_SCHED ORDER_ID
RAD_ACR_CODES ORDER_ID
RAD_CRITICAL_RESOLVE ORDER_ID
RAD_DOSE_SCAN_ORDER_R ORDER_ID
RAD_EXAM ORDER_ID
RAD_FILM_ADJUST ORDER_ID
RAD_INIT_READ ORDER_ID
RAD_PACKET ORDER_ID
RAD_PROTOCOL_ACT ORDER_ID
RAD_PROTOCOL_ACT_HIST ORDER_ID
RAD_REPORT ORDER_ID
RAD_RPT_LOCK ORDER_ID
RAD_VETTING_HOLD_DETAIL ORDER_ID


ORD_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Entity Relation
Definition: This table contains the relationships between an order and some other entity. (radiology medication)
Table Type: ACTIVITY





Column Detail - ORD_ENTITY_RELTN


Column Name Type Null? Definition
ORDER_ID DOUBLE N This column is a foreign key to the orders table. It identifies the order that is being associated to the entity.
ORD_ENTITY_RELTN_ID DOUBLE N This column contains a meaningless number that serves as a unique identifier.
PARENT_ENTITY_ID DOUBLE N This column, used in conjunction with the parent_entity_name, identifies the entity that is being associated with the order.
PARENT_ENTITY_NAME VARCHAR(32) N This column, used in conjunction with the parent_entity_id, identifies the entity that is being associated with the order.
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 - ORD_ENTITY_RELTN


Child Column in ORD_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


PROC_CLASSIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Classification
Definition: This table contains the classifications for a specific completed procedure.
Table Type: ACTIVITY





Column Detail - PROC_CLASSIFICATION


Column Name Type Null? Definition
CLASSIFICATION_CD DOUBLE N This column contains the code_value for the specific classification that has been assigned to the completed procedure.
CLASSIFICATION_DT_TM DATETIME Y This is the date time when the classification has been assigned to the completed procedure.
CLASSIFICATION_PRSNL_ID DOUBLE Y This is the personnel who added the classification assigned to the completed procedure.
ORDER_ID DOUBLE N This column is a foreign key to the order_radiology table. It uniquely identifies the order/procedure that the classification is for.
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 - PROC_CLASSIFICATION


Child Column in PROC_CLASSIFICATION(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
CLASSIFICATION_PRSNL_ID PRSNL PERSON_ID