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 |