Table Detail Report

RAD_IMAGE_SYS_CONTROLS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Image System Controls
Definition: The Rad_Image_Sys_Controls table contains system
Table Type: REFERENCE





Column Detail - RAD_IMAGE_SYS_CONTROLS


Column Name Type Null? Definition
DEF_EX_RM_LOAN_INTERVAL DOUBLE Y The Def_Ex_Rm_Loan_Interval contains the default number of days that an exam room may keep loaned folders/films.
DEF_FOREIGN_LIB_FLAG DOUBLE Y The Def_Foreign_Lib_Flag indicates whether the foreign library should default from the users profile or from the library group.
DEF_LOAN_INTERVAL DOUBLE Y The Def_Loan_Interval keeps the default number of days that a loan may exist.
DEF_PAT_LOAN_INTERVAL DOUBLE Y The Def_Pat_Loan_Interval indicates the default amount of days that a patient can borrow their folders/films.
FOREIGN_RETURN_INTERVAL DOUBLE Y The Foreign_Return_Interval indicates the maximum amount of time, in days, that foreign folders should be kept.
HIST_DOWNLOAD_IND DOUBLE Y The Hist_Download_Ind indicates whether or not a historical download of information has bee performed.
HIST_LABELS_IND DOUBLE Y The Hist_Labels_Ind indicates whether or not labels from a historical download should print or not.
IEX_UNREAD_FLAG DOUBLE Y The IEX_Unread_Flag indicates if unread exams are to be included, excluded, or handled separately on the incomplete exam report.
LOAN_INTERESTING_CASE_IND DOUBLE Y This column indicates if exams that reside in interesting case files are allowed to be loaned out.
LOAN_MED_LEGAL_IND DOUBLE Y The Loan_Med_Legal_Ind indicates if folders that are marked as medical legal are available to be loaned.
LOAN_UNREAD_FILMS_IND DOUBLE Y The Loan_Unread_Films_Ind indicates if unread exams are available to be loaned.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Library_Group table. It identifies the library group that these system controls are for.
SUSPEND_TAT_UNREAD_IND DOUBLE Y The Suspend_TAT_Unread_Ind indicates if unread exams are to be included on the turnaround time report.
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_PREV_MASTERS_IND DOUBLE N The Updt_Prev_Masters_Ind indicates if previous master folders should have their current location updated, along with the active master, when an exam is completed.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
URS_UNREAD_FLAG DOUBLE Y The URS_Unread_Flag indicates if unread films are to be included, excluded, or handled separately on the unsigned reports listing.



Relationship Detail - RAD_IMAGE_SYS_CONTROLS


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


RAD_INT_CASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Interesting Case
Definition: The Rad_Int_Case table identifies the groups in which interesting cases will be collected.
Table Type: REFERENCE





Column Detail - RAD_INT_CASE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
INT_CASE_DESC VARCHAR(50) Y The Int_Case_Desc is the description of the interesting case.
INT_CASE_ID DOUBLE N The Int_Case_Id uniquely identifies a row in the Rad_Int_Case table. It serves no other purpose other than to uniquely identify the row.
PARENT_INT_CASE_ID DOUBLE N Parent subclass of the current subclass
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIVATE_IND DOUBLE Y The Private_Ind indicates if the interesting case is a shared case or a private case.
SUBCLASS_DISPLAY_SEQ DOUBLE N Identifies the order in which the subclass is to be displayed in interesting case subclass build.
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_INT_CASE


Child Column in RAD_INT_CASE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID
PARENT_INT_CASE_ID RAD_INT_CASE INT_CASE_ID




Parent Column in RAD_INT_CASE (PK) Child Table Name Child Column Name
Children: INT_CASE_ID RAD_INT_CASE PARENT_INT_CASE_ID
RAD_INT_CASE_R INT_CASE_ID


RAD_MED_CATEGORIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Med Categories
Definition: This table contains information about categories that are used to group radiology medications.
Table Type: REFERENCE





Column Detail - RAD_MED_CATEGORIES


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CATEGORY_DESCRIPTION VARCHAR(100) Y This column contains the description of the medication category.
RAD_MED_CATEGORY_ID DOUBLE N This column contains a meaningless number that serves as a unique identifier for a 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.



Relationship Detail - RAD_MED_CATEGORIES




Parent Column in RAD_MED_CATEGORIES (PK) Child Table Name Child Column Name
Children: RAD_MED_CATEGORY_ID RAD_MED_CAT_LIST RAD_MED_CATEGORY_ID


RAD_MED_CAT_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology medication category list
Definition: This table contains the relationships between a radiology medication category and the medications.
Table Type: REFERENCE





Column Detail - RAD_MED_CAT_LIST


Column Name Type Null? Definition
RAD_MED_CATEGORY_ID DOUBLE N This column contains a foreign key to the rad_med_categories table. It identifies the category that is associated with the meds.
SYNONYM_ID DOUBLE N This column contains a foreign key to the order_catalog_synonym table. It identifies the medication that is being associated with a category.
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_MED_CAT_LIST


Child Column in RAD_MED_CAT_LIST(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
RAD_MED_CATEGORY_ID RAD_MED_CATEGORIES RAD_MED_CATEGORY_ID


RAD_MED_FIELDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Med Fields
Definition: This table contains the definition of fields that will be captured as a part of recording medications administered within the Radiology department.
Table Type: REFERENCE





Column Detail - RAD_MED_FIELDS


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
FIELD_DESCRIPTION VARCHAR(60) Y This column contains the description of the field.
FIELD_MEANING VARCHAR(12) Y This column contains the meaning of the field that can used by the application to identify the purpose of the field.
FIELD_TYPE_FLAG DOUBLE Y This column indicates what type of data type is to be captured for a given field. (1 - numeric, 2 - string, 3 - date)
RAD_MED_FIELD_ID DOUBLE N This column contains a meaningless number used only to serve as a unique identifier for the row.
REQUIRED_IND DOUBLE N This column holds an indicator which is used to determine if the medication field is required or not
SEQUENCE DOUBLE Y This column indicates the order in which the fields should appear.
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_MED_FIELDS




Parent Column in RAD_MED_FIELDS (PK) Child Table Name Child Column Name
Children: RAD_MED_FIELD_ID RAD_MED_DETAILS RAD_MED_FIELD_ID