OMF_RADEXAM_ST



Column Section Top of Page


Table-level Detail

Description: OMF RADEXAM ST
Definition: The detail level summary table for radiology management.
Table Type: ACTIVITY





Column Detail - OMF_RADEXAM_ST


Column Name Type Null? Definition
CREDIT_QUANTITY DOUBLE Y Credited quantity.
ORDER_ID DOUBLE N The unique identification number that pertains to the order.
QUANTITY DOUBLE Y The number completed/used (supplies) for this detail record.
RAD_EXAM_ID DOUBLE N Unique identification number for the radiology exam.
RESULT_TYPE_CD DOUBLE N The default result type for the exam.
TASK_ASSAY_CD DOUBLE N The task assay code for the radiology exam.
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.


OMF_RADMGMT_ORDER_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF RADMGMT ORDER ST
Definition: The main summary table for radiology management.
Table Type: ACTIVITY





Column Detail - OMF_RADMGMT_ORDER_ST


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(50) Y The accession number for the order.
ACT_DICTATE_TRANS DOUBLE Y The actual turnaround time from dictate to transcribe.
ACT_EX_COMP_VIEW DOUBLE Y The actual turnaround time from exam complete to view.
ACT_ORDER_SCHED_CONFIRM DOUBLE Y Actual turn around time from order to scheduled confirmed status
ACT_ORD_START DOUBLE Y The actual turnaround time from order to start.
ACT_OVERALL_TAT DOUBLE Y The actual overall turnaround time.
ACT_REQUEST_START DOUBLE Y Actual turnaround time from Request to Start status.
ACT_SCHED_CONFIRM_REQUEST DOUBLE Y Expected Turnaround Time from scheduled confirmed to Request status.
ACT_START_EX_COMP DOUBLE Y Actual turnaround time from start to exam complete.
ACT_TRANS_FINAL DOUBLE Y Actual turnaround time from transcribed to signout.
ACT_VIEW_DICTATE DOUBLE Y Actual turnaround time from view to dictate.
BED_AT_EXAM_CMPLT_CD DOUBLE N Stores the bed the patient was in at the time the exam was completed.
CANCEL_BY_ID DOUBLE N Personnel that cancelled the exam.
CANCEL_DT_NBR DOUBLE N Canceled date number used for calculation of other date related dimensions and filters.
CANCEL_DT_TM DATETIME Y Date the procedure was cancelled.
CANCEL_MIN_NBR DOUBLE N Canceled minute number used for calculation of other time related dimensions and filters.
CANCEL_REASON_CD DOUBLE N Reason the order was cancelled.
CANCEL_TZ DOUBLE N Time Zone associated with the corresponding CANCEL_DT_TM.
CATALOG_CD DOUBLE N The catalog code for the order.
DICTATE_DT_NBR DOUBLE Y Dictate Date Number used to create date related dimensions and filters
DICTATE_DT_TM DATETIME Y The dictate date/time for the order.
DICTATE_MIN_NBR DOUBLE Y Dictate Minute number used to create time related dimensions and filters
DICTATE_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.
ENCNTR_TYPE_AT_EXAM_CMPLT_CD DOUBLE N Stores the patient's encounter type at exam completion.
ENCNTR_TYPE_CD DOUBLE N The encounter type code for the order.
EXAM_COMPLETE_DAY DOUBLE Y The day of week that the exam was completed.
EXAM_COMPLETE_DT_NBR DOUBLE Y Exam complete date number used for calculation of other date related dimensions and filters
EXAM_COMPLETE_DT_TM DATETIME Y The date/time that the exam was completed.
EXAM_COMPLETE_HOUR DOUBLE Y The hour of day that the exam was completed.
EXAM_COMPLETE_MIN_NBR DOUBLE Y Exam Complete minute number used for the calculation of other time related dimensions and filters
EXAM_COMPLETE_MONTH VARCHAR(10) Y The month of year that the exam was completed.
EXAM_COMPLETE_QTY DOUBLE Y The quantity that has been completed.
EXAM_COMPLETE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
EXAM_COMP_CREDIT_QTY DOUBLE Y Determines if applying a credit to the order from AFC or charge services or if being called from radremove then it's set to 1 otherwise 0.
EXAM_ROOM_CD DOUBLE N The service resource code for the exam room.
EXP_DICTATE_TRANS DOUBLE Y The expected turnaround time from dictate to transcribe.
EXP_EX_COMP_VIEW DOUBLE Y The expected exam complete to view turnaround time.
EXP_ORDER_SCHED_CONFIRM DOUBLE Y Expected turnaround time from Order to scheduled confirmed status.
EXP_ORD_START DOUBLE Y Expected ordered to start turnaround time.
EXP_OVERALL_TAT DOUBLE Y Expected overall turnaround time.
EXP_REQUEST_START DOUBLE Y Expected turnaround time from Request to Start status.
EXP_SCHED_CONFIRM_REQUEST DOUBLE Y Expected turnaround time from scheduled confirmed to Request status.
EXP_START_EX_COMP DOUBLE Y Expected start to exam complete turnaround time.
EXP_TRANS_FINAL DOUBLE Y Expected transcribe to signout turnaround time.
EXP_VIEW_DICTATE DOUBLE Y Expected view to dictate turnaround time.
FINAL_DT_NBR DOUBLE Y Final Date Number used for the calculation of other date related dimensions and filters
FINAL_DT_TM DATETIME Y The date/time that the case signout took place.
FINAL_MIN_NBR DOUBLE Y Final minute number used to calculate other time related dimensions and filters
FINAL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LOC_AT_EXAM_CMPLT_CD DOUBLE N Stores the patient's location at exam completion.
NBR_REPORTS DOUBLE Y The number of reports completed for this order (1 per order).
ORDER_DT_NBR DOUBLE Y Order Date Number used to calculate other date related dimensions and filters
ORDER_DT_TM DATETIME Y The date/time that the order took place.
ORDER_ID DOUBLE N The unique identification number for the order.
ORDER_MIN_NBR DOUBLE Y Order minute number used to calculate time related dimensions and filters
ORDER_PHYS_ID DOUBLE N The unique identification number for the ordering physician.
ORDER_PRSNL_ID DOUBLE N Stores the personnel that ordered the procedure.
ORDER_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PATIENT_ID DOUBLE N The identification number of the patient for which the order took place.
PERF_DEPT_CD DOUBLE N The performing department in which the order took place.
PERF_INST_CD DOUBLE N The performing institution in which the order took place.
PRECOMPLETE_CANCEL_IND DOUBLE N Indicates the order was cancelled prior to exam completion.
PRIORITY_CD DOUBLE N The Radnet priority for the order.
PROCEDURE_TYPE_FLAG DOUBLE Y This column indicates if the entry represents an Exam Only procedure, a Read Only procedure or a regular procedure.
RADIOLOGIST_ID DOUBLE N The radiologist associated with this case.
RAD_REPORT_ID DOUBLE N The Radnet report identification number associated with this order.
REQUEST_DT_NBR DOUBLE Y Requested date number of order used to calculate other date related dimensions and filters.
REQUEST_DT_TM DATETIME Y Requested date and time of a order.
REQUEST_MIN_NBR DOUBLE Y Requested minute number used to calculate other time related dimensions and filters.
REQUEST_TZ DOUBLE Y Time zone associated with the requested DT_TM column.
ROOM_AT_EXAM_CMPLT_CD DOUBLE N Stores the room the patient was in at the time the exam was completed.
RULE_ID DOUBLE N The identification number of the rule for which this order qualified.
SCHED_CONFIRM_DT_NBR DOUBLE Y Confirmed Date Number of order used to calculate other date related dimensions and filters.
SCHED_CONFIRM_DT_TM DATETIME Y Confirmed date and time of a order.
SCHED_CONFIRM_MIN_NBR DOUBLE Y Confirmed minute number used to calculate other time related dimensions and filters.
SCHED_CONFIRM_TZ DOUBLE Y Time zone associated with the scheduled and confirmed DT_TM column.
SCHED_DT_NBR DOUBLE N Scheduled date number used for calculation of other date related dimensions and filters.
SCHED_DT_TM DATETIME Y Date the procedure was scheduled.
SCHED_MIN_NBR DOUBLE N Scheduled minute number used for calculation of other time related dimensions and filters.
SCHED_TZ DOUBLE Y Time zone associated with the sched_dt_tm field.
SECTION_CD DOUBLE N The section in which the order was performed.
START_DT_NBR DOUBLE Y Start Date Number used to calculate other date related dimensions and filters
START_DT_TM DATETIME Y The date/time in which the order was started.
START_MIN_NBR DOUBLE Y Start minute number used to calculate other time related dimensions and filters
START_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SUBSECTION_CD DOUBLE N The subsection in which the order was performed.
TAT_QUAL_IND DOUBLE Y Did this record qualify for a rule.
TRANSCRIBE_DT_NBR DOUBLE Y Transcribe Date number used to calculate date related dimensions and filters
TRANSCRIBE_DT_TM DATETIME Y The date/time in which the order was transcribed.
TRANSCRIBE_MIN_NBR DOUBLE Y Transcribe minute number used to create time related dimensions and filters
TRANSCRIBE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
TRANSCRIPTIONIST_ID DOUBLE N The identification number of the transcriptionist.
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.
VETTING_DT_NBR DOUBLE N Vetting date number used for calculation of other date related dimensions and filters.
VETTING_DT_TM DATETIME Y Date the procedure was vetted.
VETTING_MIN_NBR DOUBLE N Vetting minute number used for calculation of other time related dimensions and filters.
VETTING_TZ DOUBLE Y Time zone associated with the vetting_dt_tm field.
VIEW_DT_TM DATETIME Y The date/time in which the xrays were viewed.



Relationship Detail - OMF_RADMGMT_ORDER_ST


Child Column in OMF_RADMGMT_ORDER_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
BED_AT_EXAM_CMPLT_CD LOCATION LOCATION_CD
LOC_AT_EXAM_CMPLT_CD LOCATION LOCATION_CD
ROOM_AT_EXAM_CMPLT_CD LOCATION LOCATION_CD
ORDER_ID ORDERS ORDER_ID
PATIENT_ID PERSON PERSON_ID
CANCEL_BY_ID PRSNL PERSON_ID
ORDER_PHYS_ID PRSNL PERSON_ID
ORDER_PRSNL_ID PRSNL PERSON_ID
RADIOLOGIST_ID PRSNL PERSON_ID
TRANSCRIPTIONIST_ID PRSNL PERSON_ID


OMF_RADPROC_CLASS_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: stores procedure classifications associated with an order_id for omf reporting
Definition: procedure classifications associated with an order_id
Table Type: ACTIVITY





Column Detail - OMF_RADPROC_CLASS_ST


Column Name Type Null? Definition
CLASSIFICATION_CD DOUBLE N procedure classification code
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 Order Id from the orders table
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 - OMF_RADPROC_CLASS_ST


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


OMF_RADREPEAT_ORDER_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF RADREPEAT ORDER ST
Definition: Summary table storing film adjustment information for radiology mgmt.
Table Type: ACTIVITY





Column Detail - OMF_RADREPEAT_ORDER_ST


Column Name Type Null? Definition
FILM_SIZE_CD DOUBLE N The code value for the film size associated with the film adjustment record.
FILM_TYPE_CD DOUBLE N The code value associated with the film type for this film adjustment record.
OMF_RADREPEAT_ORDER_ST_ID DOUBLE N Unique key for the radiology repeat summary table.
ORDER_ID DOUBLE N The identification number associated with this order.
REASON_CD DOUBLE N The repeat reason associated with the film adjustment record.
REPEAT_SEQ DOUBLE N Provides uniqueness to the film adjustment records.
STANDARD_QTY DOUBLE Y The standard amount of film that should be used with this film type.
TECHNOLOGIST_ID DOUBLE N The technologist responsible for the film adjustment.
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.
WASTE_QTY DOUBLE Y The amount of extra film associated associated with this film adjustment.



Relationship Detail - OMF_RADREPEAT_ORDER_ST


Child Column in OMF_RADREPEAT_ORDER_ST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
TECHNOLOGIST_ID PRSNL PERSON_ID


OMF_RADREPORT_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Rad Report Summary Table
Definition: Contains the various date/time fields (transcribed, final) and corresponding personnel associated to report, when its transcribed , addended and final.
Table Type: ACTIVITY





Column Detail - OMF_RADREPORT_ST


Column Name Type Null? Definition
DICTATE_DT_NBR DOUBLE N Contains the "Date number" value, corresponding to the Dictate Dt/Tm
DICTATE_DT_TM DATETIME Y Contains the date and time at which the report was dictated.
DICTATE_MIN_NBR DOUBLE N Contains the "Minute number" value, corresponding to the Dictate Dt/tm
DICTATE_TZ DOUBLE N Contains the time zone value, corresponding the Dictate Dt/tm saved.
FINAL_DT_NBR DOUBLE N Contains the "Date number" value, corresponding to the Final Dt/Tm
FINAL_DT_TM DATETIME Y Contains the date and time at which the report is made final.
FINAL_MIN_NBR DOUBLE N Contains the "Minute number" value, corresponding to the Final Dt/tm
FINAL_TZ DOUBLE N Contains the time zone value, corresponding the Final Dt/tm saved.
OMF_RADREPORT_ST_ID DOUBLE N Unique generated number that identifies a single row on the OMF_RADREPORT_ST table.
ORDER_ID DOUBLE N This is foreign key to the orders table, will contain the order_ID of the selected exam.
PROXY_ID DOUBLE N Contains the personnel ID of the proxy associated to the report of the selected order. This is foreign key to the Prsnl table.
RADIOLOGIST_ID DOUBLE N Contains the personnel ID of the Radiologist associated to the report of the selected order. This is foreign key to the Prsnl table.
RAD_REPORT_ID DOUBLE N Composite key along with order_ID. This is a foreign key to rad_report table, will contain the report_ID of the selected exam.
REPORT_STATUS_FLAG DOUBLE N This denotes if the selected report is in transcribed/modified status or in addended/correction status. If report_ID of the selected row corresponds to transcribed/modified report then this flag will be equal to 0. And if the report of the selected row corresponds to addended/corrected then this flag will be equal to 1.
RESIDENT_ID DOUBLE N Contains the personnel ID of the Resident associated to the report of the selected order. This is foreign key to the Prsnl table.
TRANSCRIBE_DT_NBR DOUBLE N Contains the "Date number" value, corresponding to the transcribed Dt/Tm.
TRANSCRIBE_DT_TM DATETIME Y Contains the date and time at which the report is transcribed..
TRANSCRIBE_MIN_NBR DOUBLE N Contains the "Minute number" value, corresponding to the transcribed Dt/tm.
TRANSCRIBE_TZ DOUBLE N Contains the time zone value, corresponding the transcribed Dt/tm saved.
TRANSCRIPTIONIST_ID DOUBLE N Contains the personnel ID of the user responsible for transcribing the report. This is foreign key to the Prsnl 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 - OMF_RADREPORT_ST


Child Column in OMF_RADREPORT_ST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PROXY_ID PRSNL PERSON_ID
RADIOLOGIST_ID PRSNL PERSON_ID
RESIDENT_ID PRSNL PERSON_ID
TRANSCRIPTIONIST_ID PRSNL PERSON_ID
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID