Table Detail Report

CDI_WORK_ITEM_ATTRIB_CNFG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cdi Work Item Attribute Configuration
Definition: This table will store work item attribute configuration information.
Table Type: REFERENCE





Column Detail - CDI_WORK_ITEM_ATTRIB_CNFG


Column Name Type Null? Definition
ATTRIBUTE_CD DOUBLE N Defines the type of attribute.
CDI_WORK_ITEM_ATTRIB_CNFG_ID DOUBLE N Unique generated number that identifies a single row on the CDI_WORK_ITEM_ATTRIB_CNFG table.
CDI_WORK_QUEUE_ID DOUBLE N The work queue identifier.
MULTI_SELECT_ENABLE_IND DOUBLE N indicates whether or not this attribute's multi select control is enabled.
REQUIRED_IND DOUBLE N Indicates whether or not this attribute is required.
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.
WARN_IND DOUBLE N Indicates whether or not this attribute is setup to warn if blank.



Relationship Detail - CDI_WORK_ITEM_ATTRIB_CNFG


Child Column in CDI_WORK_ITEM_ATTRIB_CNFG(FK) Parent Table Name Parent Column Name
Parents: CDI_WORK_QUEUE_ID CDI_WORK_QUEUE CDI_WORK_QUEUE_ID


CDI_WORK_ITEM_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Work Item View
Definition: Stores views that can be applied to work queues. A view is a filter. When applied on a work queue, it filters items shown in a work queue based on the attributes selected to be viewable. (These attributes are saved in CDI_RULE and CDI_RULE_CRITERIA tables). Views show different users different work Items in a queue based upon the view they have selected or that is tied to their position.
Table Type: REFERENCE





Column Detail - CDI_WORK_ITEM_VIEW


Column Name Type Null? Definition
CDI_VIEW_NAME VARCHAR(100) N The name of the view.
CDI_VIEW_NAME_KEY VARCHAR(100) N Stores corresponding string values from column CDI_VIEW_NAME for searching in UPPER case, less SPACES or special characters..
CDI_VIEW_NAME_KEY_A_NLS VARCHAR(400) N Stores the corresponding non-English ACCENTED character set values for column CDI_VIEW_NAME_KEY.
CDI_WORK_ITEM_VIEW_ID DOUBLE N Unique generated number that identifies a single row on the CDI_WORK_ITEM_VIEW table.
PRSNL_ID DOUBLE N Foreign key to the PRSNL table. "Views" are basically filters. We have two flavors of them - user created views for their own personal use and views created by an administrator. For the personal views, the PRSNL_ID will be the user who created it and it will only be available to that user. For the views created by an administrator, the PRSNL_ID will be zero and access is based on the CDI_WORK_ITEM_POS_R table.
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 - CDI_WORK_ITEM_VIEW


Child Column in CDI_WORK_ITEM_VIEW(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in CDI_WORK_ITEM_VIEW (PK) Child Table Name Child Column Name
Children: CDI_WORK_ITEM_VIEW_ID CDI_WORK_ITEM_VIEW_POS_R CDI_WORK_ITEM_VIEW_ID


CDI_WORK_ITEM_VIEW_POS_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Work Item View Position Relationship
Definition: Stores the relationship between views and positions to which the view can be applied.
Table Type: REFERENCE





Column Detail - CDI_WORK_ITEM_VIEW_POS_R


Column Name Type Null? Definition
CDI_WORK_ITEM_VIEW_ID DOUBLE N Foreign Key reference to CDI_WORK_ITEM_VIEW table. This is the ID of the view related to the position.
CDI_WORK_ITEM_VIEW_POS_R_ID DOUBLE N Unique generated number that identifies a single row on the CDI_WORK_ITEM_VIEW_POS_R table.
POSITION_CD DOUBLE N The position code to which this view can be applied. Examples of positions are Admin, Patient, Pathologist, etc.
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 - CDI_WORK_ITEM_VIEW_POS_R


Child Column in CDI_WORK_ITEM_VIEW_POS_R(FK) Parent Table Name Parent Column Name
Parents: CDI_WORK_ITEM_VIEW_ID CDI_WORK_ITEM_VIEW CDI_WORK_ITEM_VIEW_ID


CDI_WORK_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Work Queue
Definition: This table represents a CPDI Work Queue.
Table Type: REFERENCE





Column Detail - CDI_WORK_QUEUE


Column Name Type Null? Definition
CDI_WORK_QUEUE_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
DEFAULT_AUTHENTICATED_IND DOUBLE N Specifies if clinical work items in this queue default to authenticated (1) or transcribed (0).
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PAGINATION_IND DOUBLE N The column indicates whether or not the queue will utilize pagination of items within the queue when displayed in Work Queue Monitor. 0 indicates pagination is not active. 1 Indicates pagination is active.
REG_ACTION_KEYS_TXT VARCHAR(2000) Y Contains a list of values from RCA_REG_ACTION.REG_ACTION_KEY_TXT indicating the registration actions that can be performed within the context of this work queue.
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.
WORK_QUEUE_CD DOUBLE N Code value for this work queue (used to associate work queue to other code value via the code_value_group table).
WORK_QUEUE_DESCRIPTION VARCHAR(100) N Description of the work queue.
WORK_QUEUE_NAME VARCHAR(40) N Name of the work queue.
WORK_QUEUE_TYPE_CD DOUBLE N Specifies the type of items that will be routed to this work queue.



Relationship Detail - CDI_WORK_QUEUE


Child Column in CDI_WORK_QUEUE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CDI_WORK_QUEUE (PK) Child Table Name Child Column Name
Children: CDI_WORK_QUEUE_ID CDI_WORK_ITEM_ATTRIB_CNFG CDI_WORK_QUEUE_ID
CDI_WORK_QUEUE_ITEM_RELTN CDI_WORK_QUEUE_ID
CDI_WORK_QUEUE_PRSNL_RELTN CDI_WORK_QUEUE_ID
CDI_WORK_QUEUE_TIME CDI_WORK_QUEUE_ID


CDI_WORK_QUEUE_ITEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Queue Work Item Relationship
Definition: This tables relates work items (CDI_WORK_ITEM table) with their assigned work queues (RX_IMAGE_QUEUE table).
Table Type: ACTIVITY





Column Detail - CDI_WORK_QUEUE_ITEM_RELTN


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CDI_WORK_ITEM_ID DOUBLE N Identifier for the work item.
CDI_WORK_QUEUE_ID DOUBLE N The identifier of the work queue associated to the work item.
CDI_WORK_QUEUE_ITEM_RELTN_ID DOUBLE N The unique primary key of this table. It is an internally assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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.
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 - CDI_WORK_QUEUE_ITEM_RELTN


Child Column in CDI_WORK_QUEUE_ITEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_WORK_ITEM_ID CDI_WORK_ITEM CDI_WORK_ITEM_ID
CDI_WORK_QUEUE_ID CDI_WORK_QUEUE CDI_WORK_QUEUE_ID