Table Detail Report

RAD_RES_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiologist Resident Information
Definition: The Rad_Res_Info table contains information about a physican or resident specific to radiology.
Table Type: REFERENCE





Column Detail - RAD_RES_INFO


Column Name Type Null? Definition
ALLOW_TO_PROXY_IND DOUBLE Y The Allow_To_Proxy_Ind indicates if others are allowed to proxy reports for this radiologist/resident.
ASSIGNED_RAD_ID DOUBLE N This column contains the id of the radiologist associated with the specified resident.
PASSWORD VARCHAR(20) Y This field is currently not used.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREVENT_PUBLISH_PRELIM_IND DOUBLE N Indicates if resident is prevented from publishing preliminary reports.
PROXY_ALLOWED_IND DOUBLE Y The Proxy_Allowed_Ind indicates if this specific radiologist/resident is allowed to proxy at all.
QUE_LOCK_DT_TM DATETIME Y This is the date and time that the queue was last accessed.
QUE_LOCK_ID DOUBLE N This is the id of the current lock holder of this queue.
REQUIRE_PASS_IND DOUBLE Y If this indicator is true, then the system will re-prompt the user for a password when cases are submitted in case signout.
RES_SIGNOUT_IND DOUBLE Y This column indicates if a resident is able to finalize reports.
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_RES_INFO


Child Column in RAD_RES_INFO(FK) Parent Table Name Parent Column Name
Parents: ASSIGNED_RAD_ID PRSNL PERSON_ID
PERSON_ID PRSNL PERSON_ID
QUE_LOCK_ID PRSNL PERSON_ID




Parent Column in RAD_RES_INFO (PK) Child Table Name Child Column Name
Children: PERSON_ID PROXY_EXEMPTIONS PERSON_ID
PROXY_GROUP PERSON_ID
RES_SIGN_ACT_SUBTYPE PERSON_ID


RAD_SYS_CONTROLS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad System Controls
Definition: The Rad_Sys_Controls table contains system level settings for applications throughout RadNet.
Table Type: REFERENCE





Column Detail - RAD_SYS_CONTROLS


Column Name Type Null? Definition
ACC_LINK_IND DOUBLE Y The Acc_Link_Ind indicates if accessio linking is to be used at this site.
ADDENDUM_POS_FLAG DOUBLE Y The Addendum_Pos_Flag indicates whether the Addendum is displayed below (0) or above (1) the report when the user is adding a new addendum/correction-addendum in RadTranscription. 0 is the default.
ALLOW_CORRECTIONS_IND DOUBLE Y The Allow_Corrections_Ind indicates if corrections are allowed to a signed report, or if addendums must be used for this purpose.
ASSIGN_PRSNL_ROLE_FLAG DOUBLE N Determines if the user is required to enter a role when starting or completing exams.
ASSIGN_TO_READ_FLAG DOUBLE N Determines if the user is required to enter an assigned to personnel at exam complete.
AUTO_ACCEPT_REPLACE_ADDON_IND DOUBLE N Indicates whether exam has to be automatically accepted when replace and add-on is performed. Yes = 0, No = 1.
AUTO_GROUP_VETTBL_ORDER_IND DOUBLE N Indicates whether automatic grouping of vettable orders is applicable. No = 0, Yes = 1.
BATCH_SIGNOUT_IND DOUBLE Y Indicates whether batch signout is used.
BIRADS_EDITION_CHANGE_DT_TM DATETIME Y The date/time the new version of the BIRADS system was implemented. The edition number is stored in BIRADS_EDITION_NBR.
BIRADS_EDITION_NBR DOUBLE Y This column represents the latest ACR BI-RADS edition number that the system will be running on for new radiology mammography studies.
CE_CHUNK_SIZE DOUBLE N This field determines the maximum number of reports that will be queried for at a time from the clinical event server. It is used by rad report search.
CHARACTERS_PER_LINE DOUBLE Y Contains the value that will be used in calculating transcription statistics.
COPY_ACCSN_TO_ORD_FLAG DOUBLE N Determines if the user has the option to copy the accession of the old order to the new order during a replace.
COSIGN_IND DOUBLE Y The Cosign_Ind indicates if cosigners are used at this location.
DEFAULT_EXAM_PRSNL_IND DOUBLE N Indicates if the logged in user needs to be automatically added to the personnel list.
DEFAULT_REPLACE_EXAM_COMM_IND DOUBLE Y Denotes the default communication type for Replace Exam. Verbal = 0, Original = 1
DEFAULT_VERBAL_COMM_IND DOUBLE N This column indicates if the site is using default communication type of verbal or copying it from the original order while doing Accession Addon.
DOC_IMAGE_COPY_ON_REPLACE_FLAG DOUBLE N Indicates if the system will copy document images when an exam is replaced. The values represent the following: 0 - Never, 1 - Prompt, 2 - Always
EXCLUDE_RES_SGNTR_IND DOUBLE N Excludes signing resident's name on signature line if the radiologist finalized the report before resident signed it. 0 = Include, 1 = Exclude
EX_COMP_PROF_CHRG_IND DOUBLE Y This column indicates if the exams completion date and time is to be sent as the service date/time for professional billing instead of the final date/time.
FLOW_DISP_REQUEST_IND DOUBLE N This column indicates if Radiology results in Flowsheet display based on the requested date until exam is completed.
HIDE_PRELIM_REPORT_IND DOUBLE N Indicates if the preliminary report is to be hidden from viewing outside RADNET.
INIT_READ_CREATED_BY_FLAG DOUBLE N Indicates if the Wet Read text should be displayed as a preliminary result if created by certain groups.
MOD_AFTER_VERIFY_IND DOUBLE Y Allows or disallows the modification of order details after the exam has been verified.
MRN_OPTION_FLAG DOUBLE Y This column will display options for patients with multiple active medical record numbers.
PRELIM_INIT_READ_IND DOUBLE N Indicates whether the Wet Read text should be displayed as a preliminary result. 0 = Not Displayed, 1 = Displayed.
PRINT_ADDR_HIST_FORM_IND DOUBLE N Indicates if facility name and mailing address will be printed in mammography patient history sheet.
PROTOCOL_IND DOUBLE N Indicates if the site is using Millennium's solution to providing protocoling (clinical practice guidelines) for radiology orders.
PROTOCOL_REAS_REQ_IND DOUBLE N Indicates if the user must enter a reason when modifying a protocol after an exam is complete.
PUBLISH_RAD_MEDS_ON_EMAR_IND DOUBLE N Setting to determine if medications documented in Radiology should publish to the eMar.
QUICK_PRINT_CUSTOM_TITLE_TXT VARCHAR(40) Y Custom header title used by the quick print report functionality.
RAD_OVERDUE_INTERVAL DOUBLE Y The Rad_Overdue_Interval field contains the number of hours it takes for a report to become overdue while sitting in a radiologists queue. This is used for sorting and reporting purposes.
RELEVANT_PRIOR_DT_TM_FLAG DOUBLE N is the order that was completed or requested prior to the request date and time of the order.Stores the method for determining whether the relevant prior order is determined based on request date time or complete date time.
REPLACE_GRP_ONLY_IND DOUBLE Y This indicates if, when doing a replace, the user should only be allowed to replace from the procedures replacement group rather than with any procedure.
REQ_PRSNL_AUTH_REPLACE_IND DOUBLE N Determines if the user is required to enter the personnel that authorized the replace.
REQ_REMOVE_REAS_IND DOUBLE N If 1, remove reason is a required field.
REQ_REPLACE_REAS_IND DOUBLE N Determines if the user is required to enter a Replace Reason during a replace.
RESIDENTS_IND DOUBLE Y The Residents_Ind indicates if residents exist at this location.
RES_MARKUP_QUEUE_IND DOUBLE N The res_markup_queue_ind indicates if resident final markup queue read functionality is used by Radiology Desktop.
RES_QUEUE_HR_INTERVAL DOUBLE Y The Res_Queue_Hr_Interval indicates the number of hours that reports should be in a residents queue before automatically queueing to the radiologist.
RET_AUTO_NOTE_IND DOUBLE Y This column indicates if the sticky note form should automatically be launched within Radiologist Desktop when a report is returned to resident or transcription.
RET_TO_RES_INTERVAL DOUBLE Y This column indicates the number of hours a report should show in a residents queue before showing up in the radiologists queue after a report has been returned to resident.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Service_Resource table.
SYNC_SIGN_LINE_IND DOUBLE N Determines whether preliminary signature lines are saved synchronously (1) or asynchronously (0). 0 is the default
TECHNIQUE_DOC_IND DOUBLE Y This column indicates if technique documentation is to be used.
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.
VALIDATE_REQ_DATE_IND DOUBLE N The system shall warn the user when attempting to start and complete an exam on a date other than the requested date for that exam. This check shall be performed only once in the start/complete process.
VETTBL_FLTR_BY_ORDER_DT_TM_IND DOUBLE N *** OBSOLETE ***
VETTING_IND DOUBLE N Determines if Vetting is enabled for the system.
VETTING_TAB_NAME VARCHAR(25) Y Name used for the Vetting tab in Rad Online Worklist.
VIEW_CANCELLED_FLOW_IND DOUBLE N This column indicates if cancelled reports should be viewable on the flowsheet.
VIEW_ONHOLD_FLOW_IND DOUBLE N This column indicates if on hold reports should be viewable on the flowsheet.
VIEW_PRELIM_FLOW_FLAG DOUBLE N View Preliminary Flowsheet Flag 0 - Not viewable 1 - Viewable 2 - Viewable but only after images or text have been acquired
VIEW_PRELIM_FLOW_IND DOUBLE N The View_Prelim_flow_Ind indicates if preliminary reports are to be viewable within inquiries in Flowsheet.
VIEW_PRELIM_IND DOUBLE Y The View_Prelim_Ind indicates if preliminary reports are to be viewable within inquiries in RadNet applications.
VIEW_REJECTED_FLOW_IND DOUBLE N This column indicates if rejected reports should be viewable on the flowsheet.
VIEW_REMOVED_FLOW_IND DOUBLE N This column indicates if removed reports should be viewable on the flowsheet.
WITHHOLD_RET_TO_RAD_IND DOUBLE Y This column indicates if a report that was returned to a resident should stay only in the residents queue until the resident re-accepts the report.



Relationship Detail - RAD_SYS_CONTROLS


Child Column in RAD_SYS_CONTROLS(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RAD_VDI_PACS_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Virtual Desktop Integration PACS Configuration
Definition: Information related to a PACS configuration
Table Type: REFERENCE





Column Detail - RAD_VDI_PACS_CONFIG


Column Name Type Null? Definition
ACCESSION_MASK VARCHAR(18) N The format in which accession will be sent to the system. In our example of 0000CT201800000018, the sequence would be 1234AB123456789123. Here CT stands for Modality "Computer tomography",2018 - year in which accession was generated & 18 - accession number created for particular modality in that year. It increments by one for each accession created in particular modality.
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date and time the row is considered to be valid for use. This could correspond to the active date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PACS_MODE_FLAG DOUBLE N The PACS mode of operation. (0 = undefined, 1 = uni-directional, 2 = bi-directional)
PACS_NAME VARCHAR(1000) N The name of the PACS unit. Client entered.
PACS_PARAMETERS_TXT VARCHAR(1000) N Contains PACS parameteres to be passed to the PACS viewer. Command line parameteres needed to launch the third-party PACS. Example: "/cernermode or -cernermode"
PACS_PATH_TXT VARCHAR(1000) N The file path where the respective PACS viewer is present in the machine.
PATIENT_DATA_TYPE_FLAG DOUBLE N The type of identifier being passed.
RAD_VDI_PACS_CONFIG_ID DOUBLE N The unique generated number that identifies a single row on the RAD_VDI_PACS_CONFIG 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 - RAD_VDI_PACS_CONFIG




Parent Column in RAD_VDI_PACS_CONFIG (PK) Child Table Name Child Column Name
Children: RAD_VDI_PACS_CONFIG_ID RAD_VDI_PACS_FACILITY RAD_VDI_PACS_CONFIG_ID


RAD_VDI_PACS_FACILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Virtual Desktop Integration PACS Facility
Definition: Information related to the PACS associated to a facility.
Table Type: REFERENCE





Column Detail - RAD_VDI_PACS_FACILITY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEGIN_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACILITY_CD DOUBLE N The facility where this PACS exists.
RAD_VDI_PACS_CONFIG_ID DOUBLE N The information about the PACS unit that exists in this facility.
RAD_VDI_PACS_FACILITY_ID DOUBLE N Unique generated number that identifies a single row on the RAD_VDI_PACS_FACILITY 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 - RAD_VDI_PACS_FACILITY


Child Column in RAD_VDI_PACS_FACILITY(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
RAD_VDI_PACS_CONFIG_ID RAD_VDI_PACS_CONFIG RAD_VDI_PACS_CONFIG_ID


RAD_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines a description for a radiologists reading worklist.
Definition: Radiology reading worklist
Table Type: REFERENCE





Column Detail - RAD_WORKLIST


Column Name Type Null? Definition
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RAD_WORKLIST_ID DOUBLE N The rad_config_data_id uniquely identifies a row in the Rad_config_data table. It serves no other purpose other than to uniquely identify the row.
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.
WORKLIST_NAME VARCHAR(200) Y The visual display name of the worklist
WORKLIST_TYPE_IND DOUBLE Y *** OBSOLETE *** Indicate if this worklist is shared or private.



Relationship Detail - RAD_WORKLIST


Child Column in RAD_WORKLIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID




Parent Column in RAD_WORKLIST (PK) Child Table Name Child Column Name
Children: RAD_WORKLIST_ID RAD_WORKLIST_FAVORITES RAD_WORKLIST_ID
RAD_WORKLIST_FILTER RAD_WORKLIST_ID
RAD_WORKLIST_SECTION_R RAD_WORKLIST_ID