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 |