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 |