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 |