Table Detail Report

RAD_WORKLIST_FAVORITES



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the worklist favorites of a specific user.
Definition: Radiology worklist favorites
Table Type: REFERENCE





Column Detail - RAD_WORKLIST_FAVORITES


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 Attribute that defines what worklist this is.
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_SEQ DOUBLE N *** OBSOLETE *** Defines the order in which the favorites are displayed to the user



Relationship Detail - RAD_WORKLIST_FAVORITES


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


RAD_WORKLIST_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the filter criteria for a given radiology reading worklist.
Definition: Radiology worklist filter
Table Type: REFERENCE





Column Detail - RAD_WORKLIST_FILTER


Column Name Type Null? Definition
INCLUDE_CRITERIA_IND DOUBLE N Indicates if orders criteria should be included in the filter.
PARENT_ENTITY_ID DOUBLE N The primary id of the table that this row is a child of.
PARENT_ENTITY_NAME VARCHAR(255) Y The name of the table that the row on this table is a child of.
RAD_WORKLIST_FILTER_ID DOUBLE N The rad_worklist_filter_id uniquely identifies a row in the Rad_worklist_filter table. It serves no other purpose other than to uniquely identify the row.
RAD_WORKLIST_ID DOUBLE N Attribute that defines what worklist this is.
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_WORKLIST_FILTER


Child Column in RAD_WORKLIST_FILTER(FK) Parent Table Name Parent Column Name
Parents: RAD_WORKLIST_ID RAD_WORKLIST RAD_WORKLIST_ID


RAD_WORKLIST_SECTION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Defines the radiolgy sections that are part of a worklist
Definition: Radioilogy worklist/sections relationship
Table Type: ACTIVITY





Column Detail - RAD_WORKLIST_SECTION_R


Column Name Type Null? Definition
RAD_WORKLIST_ID DOUBLE N Attribute that defines what worklist this is.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd identifies the Exam Room that the detail exam is to be performed within.
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_WORKLIST_SECTION_R


Child Column in RAD_WORKLIST_SECTION_R(FK) Parent Table Name Parent Column Name
Parents: RAD_WORKLIST_ID RAD_WORKLIST RAD_WORKLIST_ID
SERVICE_RESOURCE_CD SECTION SERVICE_RESOURCE_CD


REACT_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: React Entity Relation
Definition: This table contains the relationships between an adverse reaction and some other entity. (radiology medication).
Table Type: ACTIVITY





Column Detail - REACT_ENTITY_RELTN


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N This column, used in conjunction with the parent_entity_name, identifies the entity that is being associated with the reaction.
PARENT_ENTITY_NAME VARCHAR(32) N This column, used in conjunction with the parent_entity_id, identifies the entity that is being associated with the reaction.
REACTION_ID DOUBLE N This column contains a foreign key to the reaction table. It identifies the reaction that is being associated with the entity.
REACT_ENTITY_RELTN_ID DOUBLE N This column contains a meaningless number that serves as a unique identifier for the row.
RECORDED_DT_TM DATETIME Y This column contains the date/time that the relationship was recorded.
RECORDED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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 - REACT_ENTITY_RELTN


Child Column in REACT_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: REACTION_ID REACTION REACTION_ID


REPLACE_GROUPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Replace Grouping
Definition: The Replace_Grouping table provides a mechanism with which to group procedures that can be replaced by one another.
Table Type: REFERENCE





Column Detail - REPLACE_GROUPING


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. It uniquely identifies the orderable procedure that is having a replacement grouping created for.
REPLACE_CATALOG_CD DOUBLE N The Replace_Catalog_Cd is a foreign key to the Order_Catalog table. It identifies an orderable procedure that is a part of the replacement grouping.
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 - REPLACE_GROUPING


Child Column in REPLACE_GROUPING(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD SERVICE_DIRECTORY CATALOG_CD
REPLACE_CATALOG_CD SERVICE_DIRECTORY CATALOG_CD