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 |